In my experience, as DM, because the DM is an idiot and he didn't think things through.
The usual time it comes up, for me, is "rolling a large number of dice damage and getting an unexpectedly high total".
As I said, though, it's actually usually a lot of fun to just let unexpected disasters...