It's mentioned that time travel using the gravitational slingshot effect is highly dangerous, but typically reckless Kirk uses it successfully at least four times (including twice with a captured non-Federation ship). It also looks like Picard is likely to attempt time travel this way as well.
Do we know of any cases where the slingshot effect failed? By failed, I mean either that the ship at least failed to travel through time or was destroyed in the attempt. Clearly this never happened to Kirk, but did it happen to anyone else, human or not? For example, have Romulans lost a few warbirds trying to slingshot themselves back to the time of exodus from Vulcan? Have Klingons tried to slingshot back to the time of Kahless and ended up as a clump of mixed organic and non-organic debris?
To be clear, I'm looking for specific evidence of specific ships and/or people who attempted but failed to accomplish slingshot time travel. Names are not required but I am looking for specifically identifiable ships or people rather than general discussion of how dangerous this is. For example, the following would do:
Captain's log, stardate.... We are en route to Deep Space 3 to drop off the survivors of an Orion ship that crashed on an asteroid in Sector 843. Scans indicate that they tried to slingshot themselves back in time but their warp core exploded instead. Being so close to the Romulan Neutral Zone makes me nervous, let's hope everything goes as planned so I can get that vacation on Risa....
Answers from any timeline are acceptable (e.g. Prime universe, Abramsverse, Mirror universe, etc.). Canon answers are best but I will also accept extended universe sources (e.g. novels). Unauthorized stories, fanfics, or headcanons do not count.
Instances of failed time travel using means other than the slingshot effect (for example, wormholes, trying to bribe the Q, or drinking level 6 quantum unobtanium elixir) do not count.