I don't think I've ever been next to these tracks when a train's gone down. I've sometimes seen it from the other side of the river, though. You can read a bit about the nearby disused station here; this used to be a passenger line, but it's freight-only now.
GPS Coordinates:
51.44812, -2.62562
Location: Hotwells