I was on the first pitch of a climb called Johnny Vegas in Red Rocks, NV. I don't have a guide handy so I can't tell you too much about it, but I think it's a 5.8.
That was my first climb of a weekend trip my partner and I took, and the first time I'd climbed outside of Washington. The approach was (to me) long and shitty. The area was pretty isolated, but there was another party a pitch ahead of us. I had brand new rock shoes and neither my partner nor myself thought to keep em untied or off while belaying. My partner was not visible when he reached the next belay point, and verbal communication was nearly impossible with wind and echoes. My feet were cramping really badly from the shoes, and I had a hard time even getting started. The whole climb felt like dental work and about 2/3 of the way up the pitch, I suddenly got The Fear. No muscle exhaustion, no fall, no slip. I just suddenly, inexplicably, got very scared. At first there was no real tangible threat, I wasn't exactly afraid *of falling*, I was just afraid. And once I was scared, it all built on itself, I knew that I put everyone in danger by panicking, and that made me panic. My amazingly capable partner managed to get me to the belay point, and ordered me to get a grip. I managed to rappel down, and as I looked at the rock, it wasn't a hard climb.
I shook and cried and swore I'd never climb again. We spent the night playing blackjack and drinking, and the next morning it was me that dragged my partner back to the rock. We spent that day, however, on sport climbs next to the road, and I was fine.
I got The Fear inexplicably again at Peshastin in April. No real trigger, except maybe frustration.
My earlier post was inaccurate. I don't have to get high to climb, but I do occaisionally have a day where it's a boost.
In response to the other questions SL posed, I think that people can be stupid without chemicals, and I think some people get especially stupid with them. I think it's a pretty situational thing. My partner has usually toked in the past, but doesn't with me, explaining that climbing with me has made him more careful (probably since I'm a girl.) Conversely, it was actually him that suggested it might be the thing to get me back up off the ground. I know there's people that climb drunk, however, and that to me seems like a death wish.
P.S. I realize this post is off topic - I'm not sure of the etiquette on this board when responding to questions. If I should have created a new subject, I apologize.