There was a man, Elpenor, the youngest in our ranks,
none too brave in battle, none too sound in mind.
He’d strayed from his mates in Circe’s magic halls
and keen for the cool night air,
sodden with wine he’d bedded down on her roofs.
But roused by the shouts and tread of marching men,
he leapt up with a start at dawn but still so dazed
he forgot to climb back down again by the long ladder –
headfirst from the roof he plunged, his neck snapped
from the backbone, his soul flew down to Death.
– Homer
The Odyssey, Book 10, lines 608-617. This passage tells of the ignominious drunken death of his youngest comrade Elpenor, who is described as "none too brave in battle." He fell to his death from one of Circe’s roofs where he slept after imbibing too much wine. This is about as far as you can get from the heroic, honorable deaths in battle preferred by soldiers in Homer’s epic poetry.