NTSB investigations: Cessna 172H
19 cases on aircraft the registry lists as Cessna 172H, 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 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1992 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 4 |
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 ('2072424')
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 ('2072424')
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 CHI03LA223Accident · No injuriesLimited investigationFinal reportCessna 172H · Red Wing, MNThe pilot's failure to follow the checklist resulting in fuel starvation and subsequent loss of engine power.NTSB NYC03LA127Accident · Minor injuriesLimited investigationFinal reportCessna 172H · East Vincent, PAThe pilot's inadequate in-flight planning/preparation which resulted in fuel exhaustion during cruise flight. The pilot's inadequate preflight preparation in which he failed to refuel the airplane is a contributing factor.NTSB SEA03LA097Accident · No injuriesLimited investigationFinal reportCessna 172H · Glasgow, MTA loss of engine power due to carburetor icing. Contributing factors were carburetor icing conditions and the muddy, wet terrain at the landing site.NTSB CHI03LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Holt, MOThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident were the trees.NTSB IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.NTSB LAX98LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mariposa, CAFuel exhaustion due to the pilot's inadequate preflight planning, and improper in-flight decision not to make a precautionary landing for additional fuel.NTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.NTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.NTSB BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.NTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.NTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…NTSB BFO86FA020Accident · No injuriesField investigationFinal reportCessna 172H · Upper Marlboro, MDSince the fuel gages in the acft were known not to be accurate, the plt measured the amount of fuel in each tank with a dipstick before departing. He determined that he had 18 gallons for the 2 hours of flying he planned to do and based on a fuel consumption…NTSB CHI85LA264Accident · No injuriesLimited investigationFinal reportCessna 172H · Coleman, WIThe pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe.NTSB ATL83LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Birmingham, ALPilot made a hard off airport landing after loss of power. He had used a prolonged slip to lose altitude and the engine stopped. Then he could not reach the runway. The fuel selector was found on left tank. Left tank had less than two gallons of fuel.NTSB NYC83LA022Accident · No injuriesLimited investigationFinal reportCessna 172H · Clarion, PAAfter engine quit pilot tried to return to airport but crashed off airport in a turn collapsing the nose gear and damaging the right wing. The fuel aboard was one gallon in left tank and about two gallons in right tank. The gauges indicated empty for left and…NTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…