My worst DELETE fail however was:
DELETE * FROM table WHERE [long condition that resolves to true for all records]
It's not my personal habit but some folks I know turn off auto commit and BEGIN a transaction every time they enter an interactive SQL sessions. They then default to ROLLBACK at least once before COMMITing them.
That and having a user with read-only permissions or a read replica