I don’t remember what happened to Scotty after the TNG episode where they found him preserved in a transporter buffer on a ship left on the outside of a dyson sphere.

O’Brien when this episode concluded: “Back into the transporter buffer you go, Mr. Scott!”