Atlantis was hit by tank insulation during launch of STS-27 (1988). While in space, the astronauts inspected the tiles using a camera mounted on the Canadarm. Hoot Gibson says that it "looked like it had been blasted by a shotgun." They were convinced that they were going to die on re-entry, and Gibson had even planned what he'd say to Houston in his final transmission before he died.
They got very, very lucky. There were 700 damaged tiles, but only one missing tile. And the one missing tile just happened to be over an antenna mounting bracket, which made the structure stronger than the rest of the wing. If the foam had hit just a couple of tiles over, then they would've died.
This was the second flight after the Challenger disaster. It might have ended the Shuttle program, right then and there.