Along those lines, one time a few years back, I took a BOS-LGA shuttle. I was sitting on the right side of the plane. For some reason (never seen that again, and I've been in many, many, many, shuttle flights) for final approach the plane flew southbound over the east river from the Bronx, made a right towards NJ at the base of Battery Park, turned right and northwards over the Hudson, and then made a final right across Manhattan over Columbia University. Since I was on the window right side, I got an incredible aerial tour of Manhattan.