Fatal NTSB investigations: Cessna 172C
28 cases on aircraft the registry lists as Cessna 172C. 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
| 1964 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2007 | 1 |
| 2013 | 1 |
| 2016 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072408'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072408'))
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 ERA16FA161Accident · 2 fatalField investigationFinal reportCessna 172 · Westmoreland, NYThe pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…NTSB ANC14FA002Accident · 1 fatalField investigationFinal reportCessna 172C · Fairbanks, AKThe pilot’s failure to ensure that adequate fuel was on board the airplane, which resulted in fuel exhaustion and a subsequent collision with terrain.NTSB CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.NTSB MIA05LA158Accident · 2 fatalLimited investigationFinal reportCessna 172C · Saint Cloud, FLThe pilot's failure to maintain the airspeed while maneuvering following loss of engine power resulting in a stall/mush, an uncontrolled descent, and collision with trees and the ground.NTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.NTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…NTSB CHI82FA160Accident · 1 fatalField investigationFinal reportCessna 172C · Sunburg, MNThe pilot received several weather briefings and was advised of a severe cold front and thunderstorms in an area on his route. Prior to takeoff, he was advised that VFR flight was not recommended. While en route, the pilot reported that he was "totally…NTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTNTSB OAK72AP028Accident · 1 fatalClosedCessna 172 · Strawberry, CANTSB SEA71OS003Accident · 4 fatalClosedCessna 172C · Mission, CanadaNTSB NYC71AN067Accident · 6 fatalClosedCessna 172 · Missing AircraftNTSB MKC70A0019Accident · 2 fatalClosedCessna 172C · Washington, MONTSB FTW70A0027Accident · 3 fatalClosedCessna 172C · Allison, ARNTSB IAD70A0008Accident · 3 fatalClosedCessna 172 · Amherstdale, WVNTSB DIA69A0010Accident · 2 fatalClosedCessna 172C · Rock Hall, MDNTSB MIA68A0077Accident · 3 fatalClosedCessna 172C · St.Augustine, FLNTSB DEN68A0033Accident · 3 fatalClosedCessna 172 · Watkins, CONTSB DEN67A0046Accident · 2 fatalClosedCessna 172C · Bluff, UTNTSB OAK67F0185Accident · 1 fatalClosedCessna 172 · Wailau, HINTSB NYC66A0130Accident · 4 fatalClosedCessna 172 · E.Syracuse, NYNTSB LAX66A0048Accident · 1 fatalClosedCessna 172C · Montello, NVNTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CONTSB MKC66A0023Accident · 3 fatalClosedCessna 172C · Fulton, MONTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LA