If you don't mind, I will be stealing that for a Call of Cthulhu module.
Feel free! I already used it for a D&D adventure I ran about a month later.
Most people get scared by their nightmares, I basically recycle them into RW fiction or adventures.
The only nightmare I've had that scared the bechupus out of me was one involving a car wreck.
One day, I got in an accident in which I was the middle car of a multiple-car hit & run collision on a freeway. Due to some funny angles of impact, my Volvo actually got airborn for a second or 2 before landing in the trunk of the car in front of me.
My passenger and I were fine (Volvos ROCK!), and the police dropped me off at the Courthouse downtown (I had been headed there to file some papers for a client). However, on the way there, we had to go over an interchange from I-35 to US-75, which is one of those that arches high into the air while going from N-S to E-W... At its peak you actually look down on some fairly tall buildings.
And I hate heights.*
That night, and every night thereafter for at least a month, I had a nightmare about
that accident occurring at the peak of
that high, curving arch...and going over the side.
That meant that for at least a month, at some point in the night, I was going to wake up in a cold sweat with my pulse racing...
*Its not quite a phobia- of that I'm sure- but its not far from it. My fear of heights has actually caused at least one blackout.