He went missing in the Carbon Crater, and subsequently Ruby asked the player to find him. He is found dead in the crater, and the player can bring his corpse back to her. He was the last cat known to be alive in America.
Interactions with the player
Mr. Pussy is dead during the time player finds him, so he appears in-game as the item "dead cat". Finding him is the goal of the quest Find Ruby's Cat.