NTSB investigations: Cessna 172E, 1985
5 cases on aircraft the registry lists as Cessna 172E. 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 | 52 |
|---|---|
| 1965 | 50 |
| 1966 | 32 |
| 1967 | 28 |
| 1968 | 25 |
| 1969 | 19 |
| 1970 | 24 |
| 1971 | 18 |
| 1972 | 14 |
| 1973 | 7 |
| 1974 | 9 |
| 1975 | 5 |
| 1976 | 10 |
| 1977 | 8 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 7 |
| 1981 | 5 |
| 1982 | 7 |
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 8 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 3 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 6 |
| 2006 | 3 |
| 2007 | 4 |
| 2009 | 4 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 5 |
| 2021 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412'))
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 NYC86LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · East Moriches, NYThe acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice.NTSB MIA85LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe plt experienced an electrical failure while on a night flt & was unable to activate the rwy lights by keying his radio. He elected to land on the unlighted rwy without any landing lights rather than divert to another arpt. The plt stated that during the…NTSB ATL85LA107Accident · No injuriesLimited investigationFinal reportCessna 172E · Campbellsville, KYThe acft was positioned with its tail into the wind & it was blown over. The wind was from 240 deg at 18 KTS with gusts to 28 KTS.NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB LAX85LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · San Carlos, AZThe student plt over rotated the acft while practicing a soft field takeoff. In an attempt to gain airspeed the acft stalled and impacted the rwy.