Special constable left red-faced after being unable to deploy police stinger