A man was found unconscious and shoot after he crashed into a stop sign and later died