The expression, scared stiff, can be explained by the feeling when you visit graveyards.
It may also explain the expression scared stiff (in the sense of tumescent, not in the sense of immobilized by drunken overindulgence in a gift bottle of bourbon that one never received).