When should you drop collision insurance on a car?

When it no longer has a good book value and you can afford to fix your car yourself. Usually about 7–8 year old vehicles stop having the resale value but use Kelly Blue Book or similar website to look up values.