VIDEOS:
Dunkirk
Used at multiple points in the film Dunkirk, crescendoing to a horrific screech and providing an excellent example of Hell Is That Noise. The very first teaser trailer relied entirely on it, featuring a pier jammed solid with Tommies... then you hear the rising Stuka scream and they all look up in fear. It's also Justified since the noise is being made by actual Stukas on bombing runs over the beach.
Example of:
Stuka Scream