NTSB investigations: Cessna 172P
14 cases on aircraft the registry lists as Cessna 172P, where the sequence of events included Loss of engine power (total). 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
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 3 |
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' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '341' 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 ('2072436')
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" = '341' 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 ERA26LA073Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Browns Corner, VAOn December 20, 2025, at 1415 eastern standard time, a Cessna 172P airplane, N54576, was substantially damaged when it was involved in an accident near Quinton, Virginia. The private pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA063Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · DeLand, FLThe flight instructor’s inadequate fuel quantity inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA300Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Gainesville, TXOn August 1, 2025, about 0802 central daylight time, a Cessna 172P airplane, N62296, was substantially damaged during an accident near Gainesville, Texas. The flight instructor and pilot-receiving-instruction were not injured. The airplane was operated as a…NTSB WPR24LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Goodyear, AZBearing degradation that increased clearances between the bearing and crankshaft journal surfaces, resulting in fatigue cracks and the subsequent failure of the No. 3 connecting rod and a total loss of engine power. Contributing to the accident was the…NTSB ERA23LA049Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Greenville, SCThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.NTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.NTSB WPR20LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Tucson, AZThe pilot improper fuel management, which resulted in running the left fuel tank empty and a subsequent total loss of engine power due to fuel starvation.NTSB WPR19LA035Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172P · Santa RitaA total loss of engine power for undetermined reasons.NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB ERA16FA329Accident · 1 fatalField investigationFinal reportCessna 172 · Laytonsville, MDThe pilot/mechanic's failure to maintain airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the pilot/mechanic's failure to service the engine…NTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.NTSB WPR14LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · InarajanA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.