So.....pit with instadeath spikes/instadrown water/instasizzle electricity....is that considered bottomless since there's no way you hit the bottom and survive?
If we mention psychonauts, I remember being rather miffed at the meat circus, I believe it's one of the games where I wish there were more bottomless pits. At least with a bottomless/instadeath pit you die and if you're not out of lives, respawn a bit back, whereas if you have a non-bottomless pit (like Metroid style games), you fall down and then have half an hour's trek to get back where you were... I'd prefer death and respawn, or the Sands of TIme dagger to rewind and retry.
How about Abe's oddysee? Is that a bottomless pit? I mean, you fall down, you hear a scream, but then you also hear a thump and a screen shaking effect before you respawn. There must be a bottom to it right? ;-)
We could be talking more about it as a lazy game design choice? "There's a pit here. You fall you fail... no I don't know what it is that kills you but you sure die, so don't fall"
As for non-bottomless pit games (From memory) there's the likes of Yo! Joe! which I believe has no bottomless pit, just frustration at climbing back up.
Qwak and BubbleBobble and Parasol Stars and that kind of single screen platformers usually just put you at the top.
A Valley Without Wind doesn't seem to have any, but I got stuck in a cave I couldn't climb out of, so not exactly non-lethal drop.
Don't think the old Secret Agent Man games had bottomless pits either.
And I'd like to nominate Flashback as "Bottomless pit...or is it" for ending level 1 wherein you throw yourself into a pit which seems bottomless unless you get the anti-grav device first. But there are other bottomless pits later.