This sound effect can be found on Freesound.org. It's the same sound effect as WB SIREN - STUKA SIREN HOWL, which is not available on the Warner Bros. Sound Effects Library.
Clean, Full Length and Unedited Link to the Sound Effect
Used In
Image Gallery
Audio Samples