NTSB investigations: Cessna 172
10 cases on aircraft the registry lists as Cessna 172, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2005 | 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 ('2072402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 ('2072402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 DFW05CA090Accident · Minor injuriesData collectionFinal reportCessna 172 · Nachogdoches, TXThe pilot's improper in-flight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.NTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.NTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.NTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.NTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.NTSB MIA90LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The engine seized from oil starvation (lack of oil or oil pressure), which resulted in the aircraft being ditched at sea.NTSB LAX86LA334Accident · No injuriesLimited investigationFinal reportCessna 172 · Oroville, CAThe pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They…NTSB FTW82DA374Accident · Minor injuriesFinal reportCessna 172 · Vain, OKThe pilot and his passenger took off on a local flight and flew over a runway that they were constructing in their pasture. The pilot stated that he was in slow flight over the runway. Both occupants received concussions in the accident and could not recall…