Yes. It is possible.
I have played at least two missions where failure was possible.
Off the top of my head , I just thought of 3 ways to make it happen.
If you do it though, Expect to get downrated by a lot of people.

Folks don't like their heroes losing.