The last transmission by a pilot killed in a light aircraft crash last month contained the words “going to end up in a field,” investigators have established.