Analysis of information sources in references of the Wikipedia article "Junkers Ju 87" in English language version.
There are historical recordings of Stukas that date before the war and that sound has been recycled over the generations for movies and TV shows. It's often used as the classic dive bomber sound, or plane crashing sound, or for an anvil dropping on Wile E. Coyote's head.