A game that causes several crashes rapidly after another causing the console to break. tch tch... unheard of 
Heard of, even PC is known not to work if it shuts down from an error and you wanna turn it on right away, instead of leaving it to cool down and then turn it on. Sometimes it might not even want to turn on for soem time. Another thing that can break the thing is if you had it in a backpack outside of the house and you turn it on right away without leaving it to reach the temperature close of the room's (such as when it's very cold outside, you need to let the console get a bit warmer or something migth snap).
On another note, ps3 is generally a very unstable console and is known to shut down on it's own and even break completely for no reason whatsoever, not just with Skyrim. I had this myself with games such as MGS4, Resistance, FF13, Dead Space, AC etc etc. It's probably the fact that Skyrim is a heavy burden for the console because of it's bad optimisation that makes this happen sooner, especially if your console is old.