NTSB investigations: Cessna 172M

61 cases on aircraft the registry lists as Cessna 172M, where the sequence of events included Loss of control on ground. 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, newest first

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418')
      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\" = '230' 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 WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.Dec 6, 2009 · N20186 · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.Oct 15, 2008 · N20745 · Substantial damageNTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.Oct 3, 2008 · N20921 · Substantial damageNTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.Aug 3, 2008 · N73594 · Substantial damageNTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.Jun 24, 2008 · N9629V · Substantial damageNTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.Jun 9, 2008 · N9328H · Substantial damageNTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.May 22, 2008 · N74WC · Substantial damageNTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.May 18, 2008 · N1281U · Substantial damageNTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.Mar 11, 2008 · N80318 · Substantial damageNTSB DEN08LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Pine Bluffs, WYThe pilot's failure to maintain control of the airplane. Contributing factors in this accident were the unfavorable wind and the snow bank.Jan 12, 2008 · N12606 · Substantial damage