Police have named the man who died following a crash involving a Toyota Land Cruiser and a cement truck in Yorkshire.