StoneSoup

Hand Weapons
o - the +8 lance "Wyrmbane" (weapon) {slay drac, rPois rF+ rC+ AC+3}
(You found it in an ice cave)

Was so happy when i got this one but soon after things went south pretty fast.

21652 Lorum the Impaler (level 12, -1/168 HPs)
Began as a Minotaur Berserker on Feb 26, 2017.
Was the Champion of Trog.
Killed by divine providence
... invoked by an orc priest
(9 damage)
... on level 1 of the Orcish Mines.
The game lasted 00:33:59 (12885 turns).

Stair dance ? nah
Use Healing Potion ? nah

oh well next try

Had a character who fell into a pit trap...

and died...

Shiren the Wanderer DS:

1. Got killed by an enemy that was flung by a trap. I don't remember the death message, but it was unique and unfortunately there wasn't an achievement (or rather, this game's equivalent for it).

2. Common one: Being turned into a riceball (which makes you completely defenseless) and being attacked, which can easily kill you. (A less common death, which I believe did have an achievement, is to hit the trap that makes riceballs rotten while in riceball form.)

3. Not a death, but a major loss that happened to me once. On Old Cedar Road (first area of the game), I was playing around with meat (which transforms you into a monster), and turned into the highest level form of Walrus. While in that form, I was attacked, I split (because this monster has that capability), and the clone stole my shield+99 and disappeared. (Unlike with lower tiers, this monster actually disappears completely when it steals instead of just warping to another part on the same floor.)

Does Dwarf Fortress count? 'cause I have a few ones.

Had a nice fortress in DF2012. Nothing fancy, and maybe light on the military side (only a half trained, poorly equiped squad), but home to 100+ dwarves, and it felt like home, ya know?
Main entrance of my walled courtyard was heavily defended, but I had a "back door" closed by an iron door. You had to access it from a traped tunnel in the dry moat. In case of big emergencies, I could always abandon the courtyard, retreat to the underground fortress and cut down a bridge behind me.

Comes a goblin raiding party, juste 2 squads of bowmen and lashers. No airborne beast, no troll to bash down my doors, so no problem. the bowmen may snipe my guards if they man the wall, though. So I just tell my civilians to retreat to the courtyard to continue their usual activities, lock the doors, and keep the guards underground so that they won't go on the walls and pick a fight with the bowgoblins. Worse case, they'll ambush a foreign merchant caravan or two before they decide to leave. Best case, caravan guards will slaughter them an I loot the bodies.

"Err, a combat report saying I just lost a dog? Was a hunter locked out in the wilderness? The courtyard guard dog?! Why is there a goblin in my courtyard? Why are the raider squads running toward the door? WHY IS THE DOOR OPEN?!?"

So, stupid way to die in DF n°#186752 : Forget that the invisible goblin thieves that sometime try to get into your fortress to kidnap children CAN unlock doors. And even if they are not really a threat by themselves (a simple dog can dispell their invisibility, and they run once discovered), the doors they unlocked can be used by the raiders that have been camping on the map for a few weeks...

Note : Stupid way to die in DF n°#186753 : Try to stop a firebreathing dragon with a wooden gate. That one didn't work out too well either... ^^

EDIT : Stupid way to die in DF n° 186754 : Build a castle at the foot of a cliff (with great doors doors in the cliff leading inside the mountain). It looked impressive, very dwarven. Until enemy bowmen took position on top of the cliff and started raining death on everyone in the courtyard and on the walls, civilians and soldiers alike.
I survived this one, but with half the guarison dead and the other half going crazy (because of the stress) and going on a killing spree inside my great hall, I was playing "Dwarf Graveyard with a few shellshocked survivors" once the dust settled.

So, your cause of death was hubris? :) Honestly, that could be said to be the more general cause of at least 75% of my deaths in Stone Soup (especially as Berserkers and Fighters). I rarely even try to teleport until I'm already screwed so badly that I won't be able to survive long enough for the teleport to actually kick in.

In Spelunky, (more of a "roguelike" than a Rogue-like, but given the OP's examples, it's close enough), on the other hand, my general cause of death is usually that I was running when/where I should've been walking. That, and poor risk/reward calculations on my part. ("I only have three health: I have to try to rescue that precariously placed damsel." [Proceeds to lose two health to an arrow trap getting to the damsel (who will give him one); just for spice, maybe the Ghost comes just after, making him rush to the exit, perhaps throwing the damsel to try to kill a bat or something that in the way, with the damsel landing on spikes and dying])

And even though it's not a roguelike in any sense (though events and item placement are somewhat randomized, and characters die permanently, though you control a group), I seem almost incapable of surviving any sort of combat in This War of Mine. Even with the ex-soldier character, even if I'm able to more-or-less sneak up on someone, I always end up getting killed when I try to fight. It's a shame, because I'm pretty good at surviving otherwise.

The reason I gave up on Nethack :

I had an insanely powerful Ranger going about 12 levels down. I can't remember how exactly, but for some reason I had teleportites at the time, perhaps from having eaten a leprechaun earlier in a fit of hunger. But it didn't matter too much that every now and then I randomly teleported to somewhere on the level, because I was powerful enough to deal with who or whatever I suddenly startled half to death.Well, that is until Is stepped on a polymorph trap.
Of all of the awesome things I could've turn into like a bear, or something like a minotaur, the gods saw fit to turn me into, wait for it... a god damn rat ):-\ It might've turned out alright though if I could just have waited it out, but as luck would have it I then had another sudden bout of teleportites. In the blink of an eye the wide and empty corridor that was before me turned into a life sized air elemental who took great personal offence at this sudden and uninvited invasion of his personal space.
And so Ragard the mighty ranger met his end: as a small rat being pummeled to death inside a whirlwind (as is the 'body' of all air elementals) grabbing desperately at all the scrolls and wands that flew about him, items he had accumulated over several days to use in a time of great need. Great need as it where, Ragnar's newly acquired tiny squeaky voice was unable to incant the magic contained within the 2 or 3 scrolls his tiny bruised claws managed to grab in the final moments of his life.

One other cause of death, this time in Nethack:

I was playing wizard mode (basically, Nethack's version of a debug mode, which lets you cheat in various ways), and one of the things it lets you do is keep your save files when loading. Well, I decided to do so, but it turns out that the game's code isn't designed to handle this case gracefully. Therefore, after a while the dungeon collapsed, ending my game with no option to refuse the death. (Normally, wizard mode (and explore mode) allows you to choose not to die when you otherwise would; however, a dungeon collapse is triggered by the game being unable to function correctly (for example, if a level file is corrupt or missing), and therefore there is no way the game could have continued if I had chosen not to die.)

Not really a true 'YASD', but I fell asleep playing ToME with my hand resting on the down key of my laptop.

When I woke up my character had walked all the way south into the sea and drowned.

In this game its always hubris :)
Funny thing in ever other tactical RPG like BaldursGate/ID/Planescape/DragonAge/Blackguards
i usually go like "ok Cone of Frost there buff him, taunt this enemy, heal him" and so on and so on.
But StoneSoup that is something complete different, there my World of Warcraft Warrior behavior
kicks in and i go like "oh there is an Enemy..CHARGE"

Well, if you're playing a berserker, that just means you're roleplaying! =)

FTL: ADVANCED EDITION

I let my greed overrule my self preservation. I was winning, but then I choose to board the ship just to be able to get some more stuff. But they were strong and had one of those healing rooms.

Torneko: The Last Hope. (Yes, this game counts as a roguelike.)

I was in the Lost Forest. The gimmick of this particular dungeon (which comes before what I consider to be the main dungeon) is that, outside of shops, the only item you will find is money. To compensate, shops are very common in this dungeon, which is a good thing as you will need to rely on them for items. You can take 2 items with you into this dungeon, which will most likely be a weapon and a shield. (Note that this dungeon comes before you can upgrade and combine equipment to create powerful weapons and armor.)

In any case, on this attempt, the game refused to spawn any shops for the first few floors, so all I had was my weapon and shield. I then got surrounded in a corridor, and with no items that would help me get out of that situation, I was screwed.

When the game refuses to provide some important resources (in my case, shops, but food is another resources that you can be starved of in roguelikes), there's really nothing you can do.

My life is a roguelike, one chance, hard as nails, no saves/savescumming and permadeath (haven't experienced that one yet)

Another Torneko death.

Entered a special dungeon known as The Well. This dungeon is a single floor dungeon, which can either be a dark maze or a monster house, and you can (and are expected to) bring in up to 5 items with you. I have made multiple attempts and only finished it once. You can set the difficulty, but I only have Level 1 available to me currently.

In any case, one run ended very quickly. I entered the dungeon, it was a dark maze, and very quickly run into a Mimic that kills me in one hit before I can do anything. Do you think that's fair?

Also, while not a death (and in a different dungeon), I see a scroll, hit the ground nearby (to make sure there isn't a mine trap that will destroy the scroll), noticed that there is a mine trap, and then I *step on the mine trap*, destroying the scroll. This time, I only have myself to blame; after checking for a trap I should pause for a moment to see if there is a trap before continuing. (Remember, as this game is a roguelike, time will not pass in-game if you don't do anything.)