NTSB investigations: Cessna 172P
27 cases on aircraft the registry lists as Cessna 172P, 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 | 4 |
| 1984 | 3 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2003 | 2 |
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_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 ('2072436')
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 MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.NTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.NTSB LAX02LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Creston, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the dark night conditions.NTSB ATL97LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Rockhill, SCThe pilot's failure to plan and have adequate fuel for the flight.NTSB LAX96LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Raymond, CAThe pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.NTSB MIA95LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Placid, FLTotal failure of the fuel vent system resulting in the total loss of engine power during cruise flight. Contributing to the accident was the inadequate inspection of the airplane during the last annual inspection for failure of the mechanic to identify that…NTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.NTSB MIA93LA118Accident · No injuriesLimited investigationFinal reportCessna 172P · Mims, FLTotal loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the pilot to lean the fuel/air mixture during cruise flight which increased the fuel consumption for the flight.NTSB ATL93LA010Accident · No injuriesLimited investigationFinal reportCessna 172P · Buford, GAFuel exhaustion due to the pilot's inadequate inflight planning.NTSB FTW91LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · El Paso, TXThe power loss due to carburetor icing and the pilot's failure to use carburetor heat. Factors were the icing conditions, lack of suitable terrain for the forced landing, and the gusty tail wind.NTSB DEN91LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Steamboat Sprin, COThe CFI used poor judgement in giving a simulated engine failure by turning off the fuel selector valve.NTSB SEA90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bremerton, WAFuel exhaustion and inadequate preflight planning.NTSB LAX88FAMS3Accident · 3 fatalMissing aircraftFinal reportCessna 172P · Kauai, HIThe pilot departed for honolulu, HI after flying for 3 hours, 45 minutes without refueling. The flight to honolulu takes 1 hour. The airplane has a full fuel endurance of four hours. It disappeared from navy radar 25 miles southeast of Kauai. Acft wreckage…NTSB CHI88LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Sauk Center, MNWhile enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…NTSB NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB MIA86LA214Accident · No injuriesLimited investigationFinal reportCessna 172P · Whiting, FLThe private pilot of a rented Cessna 172P experienced an engine failure after flying 4.7 hours on a cross country flight. During the landing roll the nose gear failed in rough terrain. No fuel was found in the aircraft fuel tanks or lines during recovery and…NTSB FTW86FRA09Accident · Serious injuriesFinal reportCessna 172P · Lake Jackson, TXThe acft crashed during forced landing after a power loss. The acft eng quit, after a 4 hr x-country, during the lndg approach. The acft had been flown locally over an hour by another plt (crew). This made a cumulative flt time on the acft of over 5 hrs since…NTSB CHI85FA054Accident · No injuriesField investigationFinal reportCessna 172P · Waukegan, ILThe acft collided with the terrain during a forced landing following a loss of power during takeoff. Investigation revealed that two days previously a loss of power had occured during a test flt which was virtually identical to the power loss experienced…NTSB MIA85LA018Accident · No injuriesLimited investigationFinal reportCessna 172P · Titusville, FLThe acft landed in a field after experiencing an eng failure in cruise flt. Investigation revealed the accident occurredon the return leg of a x-country flt. The plt stated he visually checked the acft fuel tanks prior to departure and estimated ample fuel…NTSB DEN84LA291Accident · No injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe plt was making a low pass over a strip he wanted certified. During an attempted go-around the eng would not respond so the plt landed. The acft ran off the end of the wet sod airstrip and nosed over. The plt said after the accident that the carburetor…NTSB ATL84LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Jackson, MSThe acft ditched in a reservoir at night after a power loss. The plt was descending to land, in preparation for the landing the plt switched fuel tanks on the selector valve to what he thought was both tanks position. Shortly after thisthe engine quit. The…NTSB CHI84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft landed in a plowed field during an off arpt forced landing after power loss in the traffic pattern for landing. The arpt manager reported that when he reached the acft the carburetor heat was off. The pilot said she thought she usedit but was not…NTSB NYC83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Redding, CTThe flight originated at ramapo, NY. During a preflight check, the plt noted that the fuel gauges indicated full. When he visually checked the fuel tanks, he estimated that the fuel level in each tank was about 1 inch from being full. The fuel capacity of…NTSB CHI83FA224Accident · Minor injuriesField investigationFinal reportCessna 172P · Joliet, ILThe acft made a hard landing and nosed over during a forced landing after engine failure on the base leg. The flt was onthe base leg with power at idle and carburetor heat on when the engine lost power. The pilot was unable to restart the engine. The pilot…NTSB NYC82DA122Accident · No injuriesFinal reportCessna 172 · Monongahela, PAThe pilot was on a flight from rostraver, PA to deerfield, oh and return. Before taking off from rostraver, he estimated there was 25 gal of fuel on board. At deerfield, he estimated there was 15 gallons remaining (12 gal usable). But that he would need only…