Visionary

S3, E17: O'Brien is exposed to a small amount of radiation that allows him to shift through time several hours into the future, where he witnesses the station's destruction and his own death.