NTSB investigations: Cessna 172C
11 cases on aircraft the registry lists as Cessna 172C, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2006 | 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 ('2072408')
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\" = 353))
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 ('2072408')
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" = 353))
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 MIA07CA002Accident · Minor injuriesData collectionFinal reportCessna 172C · Jay, FLThe pilot's improper in-flight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB LAX97LA007Accident · No injuriesLimited investigationFinal reportCessna 172C · Mesa, AZthe pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB MIA95LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLThe inadequate preflight planning by the pilot-in-command to assure that adequate fuel was on-board the airplane to complete the flight, which resulted in a loss of engine power, forced landing and the collision with a tree on touchdown.NTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.NTSB CHI93LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · West Chicago, ILthe pilot's improper use of carburetor heat. Conditions conducive to the formation of carburetor ice was a factor.NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.NTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…NTSB LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…NTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…