first time I heard it was as a kid when it was used to make us aware of the alien presence in "It Came From Outer Space"... which was made in 1953.... bet you remember it from that too... just didn't realise what it was then...
My brother, son and I still, to this day, use that sound when we come across something spooky....
it's such a cool movie...
from what I can remember son telling me... the physicist dude was mucking around with an oscillator in the lab and created the effect.....