NTSB investigations: Cessna 172H, 1992
10 cases on aircraft the registry lists as Cessna 172H. 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
| 1966 | 11 |
|---|---|
| 1967 | 59 |
| 1968 | 48 |
| 1969 | 32 |
| 1970 | 24 |
| 1971 | 28 |
| 1972 | 32 |
| 1973 | 22 |
| 1974 | 12 |
| 1975 | 16 |
| 1976 | 18 |
| 1977 | 18 |
| 1978 | 13 |
| 1979 | 15 |
| 1980 | 8 |
| 1981 | 6 |
| 1982 | 5 |
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 12 |
| 2002 | 6 |
| 2003 | 14 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 5 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 2 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
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 year(c."eventDate") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
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 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 SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB CHI92FA228Accident · 3 fatalField investigationFinal reportCessna 172H · Grayling, MIThe pilot's failure to maintain aircraft control.NTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.NTSB LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.NTSB MIA92FA127Accident · 1 fatalField investigationFinal reportCessna 172-H · Clewiston, FLThe failure of the pilot-in-command (student pilot) to maintain an airspeed above stall, and his inadvertent stall and spin.NTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…NTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.