I have read about a guy who got a piece of rebar through his brain, survived, functioned, and even improved his outlook on life through such an event ... And while looking him up, I found that it's a surprisingly common thing (I mean, compared to what I expected).

The top result on DDG was this person, of whom I had not previously been aware: https://en.wikipedia.org/wiki/Phineas_Gage