NTSB investigations: Cessna 172K, 1994
12 cases on aircraft the registry lists as Cessna 172K. 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
| 1967 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 29 |
| 1970 | 48 |
| 1971 | 66 |
| 1972 | 52 |
| 1973 | 43 |
| 1974 | 40 |
| 1975 | 21 |
| 1976 | 30 |
| 1977 | 29 |
| 1978 | 25 |
| 1979 | 15 |
| 1980 | 12 |
| 1981 | 13 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 12 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 7 |
| 1991 | 11 |
| 1992 | 4 |
| 1993 | 7 |
| 1994 | 12 |
| 1995 | 6 |
| 1996 | 12 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 5 |
| 2002 | 8 |
| 2003 | 10 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 7 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 8 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 1994
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430'))
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") = 1994
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430'))
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 LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.NTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB CHI94LA326Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brookfield, WIthe commercial pilot's poor planning/decision making. A related factor is the wet, grass runway selected for landing.NTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.NTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.NTSB MIA94LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Culebra, PRThe failure of the pilot-in-command(CFI) to initiate a go-around after encountering severe turbulence during landing flare and his decision to raise the flaps and reduce engine power to idle after directional control was lost resulting in the aircraft…NTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.