Police said he came off the motorbike and died at the scene despite medical assistance from police and paramedics