Okay, so they are not actually from Hell but from Sweden. They seem to be quite popular in Switzerland, and they are air horns rather than a true siren. The owner of the video lists it as a KTG-10, so perhaps there is more than one model of these things. Has anyone ever heard one in person?
http://www.youtube.com/watch?v=-NIFxgW1yHI