Is the last person in a car pile-up at fault for the whole accident?

generally no , however each party that is hit by your vehicle can and most likely will file a claim against you. usually the person you hit files agaist you, the person they hit files against them and so on.