I'm told the only "fuck up" that will get you fired on the spot for the first occurrence is sexual harassment.
My experience is fairly consistent with others I know, there are of course a few exceptions. Though please do bear in mind I have a severe observation bias here. I interact with significantly more people that want to work at Netflix than I do those who don't.
The shortest IC tenure I've seen here was the result of being a brilliant jerk (which interviewers did not catch during the interview cycle (and I speak here as one of the people who interviewed this person)). The shortest Manager tenure I've seen here was noticeably shorter than this, and was the result of pissing off your engineers.
I've not seen any IC here screw up on a technical level in such a way as to get fired for a first or even second screwup -- it really takes a pattern. My shortest IC termination was six months from hiring to termination.
Also, would you say your experience matches those of people you know on other teams with other managers?