I forget what the name of of the waterslide was, if it even had a name, but it was at Wild Waves in WA. I went 2 times this summer, and the first I was scared of it badly, but the second time I went on it and loved it.
BTW it's basically a black tube then a nearly strait down slide... it gives a good rush.