NTSB investigations: Cessna 172P
12 cases on aircraft the registry lists as Cessna 172P, where the defining event was Loss of control in flight. 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
| 2012 | 2 |
|---|---|
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 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 ('2072436')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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 ('2072436')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.NTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.NTSB GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.NTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.NTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.NTSB CEN14CA104Accident · No injuriesData collectionFinal reportCessna 172P · Cotulla, TXThe student pilot did not maintain control of the airplane while landing. The flight instructor's failure to monitor the flight contributed to the accident.NTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.NTSB ERA13CA154Accident · No injuriesData collectionFinal reportCessna 172P · Bardstown, KYThe student pilot’s improper flare during a crosswind landing, which resulted in a hard landing.NTSB WPR13LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maricopa, AZThe pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.NTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.