Man dies after his lorry crashed and left major road