Sometimes it is pilot error, but apparently not in this case. Seems to be a failure in the ferry tank pumps according to comments on avcanada.
For someone in a bad enough situation that they are willing to commit insurance fraud by faking a crash, it probably is a pretty good risk.
See this earlier comment for a link to data on small plane ditching: https://news.ycombinator.com/item?id=8957313
That said, insurance companies aren't stupid. Would they really let the person insure the plane for so much that it is better to lose it for insurance than to simply sell it?
These are not unsurvivable forces we're talking about.
For example, to ship a new Cirrus SR20 to Australia starts at $28,995 and you'll need to wait for factory reassembly and certification. To ferry the same aircraft costs $22,800.