I haven't had any big mishaps myself, but I worked in a wafer fab and apparently the person who came in to replace me after I quit, dropped a whole box of wafers like a month into the job. Shit worth like $1M.
That said, massive fault on the company for a lack of better procedures handling those, and afaik the person didn't even lose the job as it was an honest accident.