Most of those stories are urban myths. There are the stray cases of people walking off a cliff or doing something else very stupid while on acid, but these same people face similar dangers with alcohol or any other hallucinogen. Besides, that sort of thing would require you to take a LOT of acid.