Police described the attempted robbery as a 'horrific incident'