On a facetious note: On my BOC, we used to joke that the black line on which we signed our enrolment papers was actually micro-text that read: "I, being of sound mind and fully understanding the consequences of my action, hereby forfeit my life to Her Majesty the Queen of Canada".
But, more seriously, I believe the original question was:
iæfai said:
As a naval officer, what situations exist where you may be given an order which would result in your death?
I will admit a bias for mine warfare in view of my involvement in it but, it seems to me that the question applies directly to the officers serving onboard mine countermeasure vessels. We are the only type of ship that is wilfully and purposefully put into a known mine field, no matter what. Everybody else is diverted out. Moreover, the design and protective measures built into mine countermeasure vessels means that they have little to no capacity to defend themselves against any other threat, yet are required by the circumstances to expose themselves fully to these threats.
A good example of this is Operation Neptune, just before the landings, when the minesweepers had to clear ten channels all the way to the beaches with no protection against air, surface or shore-based threats and a time frame so short that even minesweeping had to be done at greater than speeds consistent with good self-protection practices.
Here is a sample of the orders given to the sweeping formation:
Task to be carried out:
'(a) The clearance of Channel 9 is to be continued to the Lowering position regardless of enemy interference and casualties.'
'(b) In the event of enemy attack the sweeping formation MUST be preserved and the attack fought off with the best available means.'
'(c) No ship must be allowed to sink in the swept channel.'
Anyone familiar with the difficulty of managing the course and speed of a minesweeper, with gear streamed, after its been blown up by a mine, will know that the last order, don't sink in the swept channel, is basically a death warrant on the engine room personnel and likely a good deal of the boatswain.
In all 43 minesweepers out of 255 were lost in Operation Neptune. No other class of ships in that operation, not even the landing crafts, suffered losses in such proportion.
A good historical read on this can be found at the following US site:
http://www.halcyon-class.co.uk/D%20Day/neptune%20minesweeping.htm