Yes. Sometimes only a few minutes, but there is at least one report of a person lasting 8 days.
https://en.wikipedia.org/wiki/Impalement
Wish I hadn’t been morbidly curious enough to read that.