NTSB investigations: Cessna 172L
13 cases on aircraft the registry lists as Cessna 172L, 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 per year
| 2013 | 3 |
|---|---|
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432')
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.
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 ('2072432')
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…NTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.NTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.NTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA15CA106Accident · No injuriesData collectionFinal reportCessna 172L · New Castle, PAPilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.NTSB CEN13CA202Accident · No injuriesData collectionFinal reportCessna 172L · Pontiac, MIThe pilot's failure to maintain airplane control after an unexplained increase in engine power while taxiing.NTSB CEN13LA167Accident · No injuriesLimited investigationFinal reportCessna 172L · Idabel, OKThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion.