My guess is that they took something like an air raid siren and reversed it, fiddled about with it in some audio editing software and Robert's your mother's brother.
Here's an example I made. I took a generic air raid siren recording, selected a chunk, reversed it, added reverb. I think it's pretty close.
It's attached as a zip because the forum won't accept mp3s directly.