Not having data to show what happened after losing signal can be a problem, but in this case the data does have the clues to tell what happened.Not to pressure on anyone but my care refresh expires on the 17th . Anything in the flight log to win or lose a flyaway claim ?
It turns out that you've been searching in the wrong place and RTH height you had set wouldn't have caused any problem.
You flew east, then west and then north until losing signal at 10:04.9 with the drone some distance away to the north.
At the time, the drone was 64 metres higher than the launch point.
There was a 38 metre high point between the drone's last known position and the home point.
RTH Height was set at 100 metres.
There were no obstacles that should have blocked the RTH path for the drone.
On losing signal, your drone would have followed the Loss of Signal option you had set in the app settings.
Checking the data, shows that you had changed the Failsafe Action from the default value of RTH, to Hover.
This explains why the drone didn't come home.
Rather than returning home, it would have hovered until the battery reached Critical Low Voltage and then descended where it was.
The last known location was 51.91717 -8.40165.
This should have put the drone close to the river, but not in it.
Unfortunately, it is on the edge of a well used carpark and probably not a good spot for a drone to have landed.