NTSB investigations: Cessna 172S, CA

7 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Ground collision. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

20092026
NTSB investigations: Cessna 172S, CA per year, 2009–2026: 7 cases
20091
20132
20161
20181
20231
20251

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…Nov 9, 2025 · N5199J · Substantial damageNTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.Aug 1, 2023 · N46393 · 2 aircraft · Minor damageNTSB GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.Jun 3, 2018 · N786SA · 2 aircraft · Substantial damageNTSB WPR16LA063Accident · No injuriesLimited investigationFinal reportCessna 172S · San Diego, CAThe failure of the flight instructor of the other airplane to maintain awareness while parked on the ramp with the engine operating, which resulted in impact with the parked airplane.Feb 3, 2016 · N499DR · 2 aircraft · Minor damageNTSB WPR14LA025Accident · No injuriesLimited investigationFinal reportAviat S2 · Livermore, CAFailure of the pilots of the Pitts airplane to maneuver the airplane as necessary to observe the taxi route and avoid the Cessna airplane ahead. Contributing to the accident was the local controller's failure to provide the required warning of traffic ahead…Oct 20, 2013 · N15TA · 2 aircraft · Substantial damageNTSB WPR13LA286Accident · No injuriesLimited investigationFinal reportCessna 182T · San Diego, CABoth pilots’ failure to maintain a proper visual lookout while taxiing during nighttime conditions, which resulted in an on-ground collision.Jun 24, 2013 · N411CP · 2 aircraft · Substantial damageNTSB WPR09CA461Accident · No injuriesData collectionFinal reportCessna 172S · San Carlos, CAThe student pilot's failure to maintain clearance with a fence post during taxi.Sep 21, 2009 · N21591 · Substantial damage