I opened up the ceiling and cut out the damaged piece - you can see the hole in the joist just to the left of the cut off pipe. Can you say 'bullseye'?