Yep, it's the basis of Outer Wilds, one of the best video games of the last decade, but also others like:

-Sexy Brutale

-Life is Strange

-The Forgotten City (still playing this one)

-Twelve Minutes

There's also Return of the Obra Djinn which is a reverse-mystery thriller, in which you piece together what happened to a ship in reverse murder order.