NTSB investigations: Cessna 172F
21 cases on aircraft the registry lists as Cessna 172F, 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 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 2 |
| 2001 | 2 |
| 2002 | 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 ('2072414')
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 ('2072414')
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 DFW05FA082Accident · 1 fatalField investigationFinal reportCessna 172F · Hot Springs, ARA loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.NTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.NTSB DEN01LA055Accident · No injuriesLimited investigationFinal reportCessna 172F · Larkspur, COthe flight instructor inadvertently stalling the airplane during a forced landing. Contributing factors were fuel exhaustion due to inadvertent opening of the fuel drain, lack of familiarity with the airplane, inadequate supervision of the flight, and the…NTSB ANC99LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Galena, AKThe pilot's failure to refuel, and the resulting fuel exhaustion. A factor was the dark night which hampered location of a nearby closed, and unlit, airstrip.NTSB ATL99LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Buchanan, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice during glide and cruise, and rough and uneven terrain.NTSB MIA97FA010Accident · Minor injuriesField investigationFinal reportCessna 172F · Venice, FLinadequate maintenance servicing of the airplane during an oil change by the owner/pilot for his failure to secure the oil temperature probe securing nut. Also, inadequate maintenance of the airplane by the owner/pilot for his failure to operate the engine…NTSB LAX95LA295Accident · No injuriesLimited investigationFinal reportCessna 172F · Bradley, CAfuel exhaustion due to the pilot's failure to refuel prior to takeoff and his delayed decision to proceed to his alternate airport. The night light conditions and the lack of a suitable emergency landing area were factors.NTSB BFO93LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Normalville, PAThe presence of carburetor icing conditions, which caused a total loss of engine power. A factor related to the accident was the pilot's delayed use of carburetor heat and rough terrain.NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.NTSB FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.NTSB CHI90LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Huntington, INThe student pilot's improper preflight planning ensuring sufficient fuel for the intended flight.NTSB DEN89LA105Accident · No injuriesLimited investigationFinal reportCessna 172F · Morgan, UTInadequate servicing of the aircraft by the pilot, partial blockage of the fuel line and fuel filter, and fuel starvation. Contributing factors were: the downward sloping runway and a fence.NTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…NTSB DEN86LA089Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ephraim, UTAccording to the plt, upon his arrival at the dest arpt, he could not activate the rwy lghts by radio, so he proceeded to the nearest arpt. He stated he could not find his alternate arpt beacon light, so he reversed direction and headed once more to his…NTSB FTW86LRA03Accident · No injuriesFinal reportCessna 172F · Saratoga, TXPilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were…NTSB ATL86LA022Accident · No injuriesLimited investigationFinal reportCessna 172F · Hazelhurst, MSDuring cruise flight the engine experienced a loss of power and the pilot applied carb heat. The engine operated normally with the carb heat on and when it was turned off the engine again ran rough. The pilot again turned on the carb heat and the engine ran…NTSB CHI85FEI02Accident · Serious injuriesFinal reportCessna 172F · Akron, OHThe acft contacted trees during a night forced landing following a loss of pwr. State patrol personnel reported there was no sign of fuel on board the acft at the accident site. The eng was test run after the accident, during which time it functioned normally.NTSB MKC84LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Chariton, IAThe acft lost power during takeoff and was forced to land in a muddy field. The CFI said he examined the fuel in a sightglass after refueling the acft and did not notice any water in the fuel. Later examination of the acft by FAA showed water in the fuel…NTSB FTW82DA379Accident · Minor injuriesFinal reportCessna 172 · Corpus Christi, TXAircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity.