Often, yes (though usually not to the point of actually dying). Overcoming survival fears is behind every act of physical courage, e.g., saving a friend or stranger, or exploring any new zone that will normally kill you (mountaineering, undersea, space, etc.).

You have got to suppress your naive survival instinct (or remain massively ignorant) to climb on top of a rocket with thousands of tons of explosive material...