Cody Dobbs tragically died in hospital days after the bike he was riding on was involved in a horror crash