I actually set fire to a 7900GT once. Seriously. My machine was powercycling, so I took the side off to check that the fan was spinning, and saw one of the RAM chips flare and burst into flames.
I suspect that had more to do with me having a duff PSU than a monster overclock though....
Tom