If I wanted to be optimistic, I'd propose that there are failure-actuated safety protocols on TNG ships -- for example, that it takes power to prevent emergency doors from slamming down to seal off jeopardized sections of the ship or to prevent similar mechanisms from locking down windows.
Unfortunately, although sensible, we saw way too many times that TNG engineering is directly opposed to failure-actuated safeties at nearly every turn, because while they're sound engineering, they make for poor drama. (Or DO they?)
"Now I did a job -- and got nothin' but trouble since I did it, not to mention more than a few unkind words as regard to my character, so let me make this abundantly clear: I do the job... and then I get paid. Go run your little world."