NTSB investigations: Cessna 170A, 1988
5 cases on aircraft the registry lists as Cessna 170A. 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 | 22 |
|---|---|
| 1965 | 18 |
| 1966 | 20 |
| 1967 | 28 |
| 1968 | 22 |
| 1969 | 21 |
| 1970 | 18 |
| 1971 | 15 |
| 1972 | 13 |
| 1973 | 17 |
| 1974 | 19 |
| 1975 | 15 |
| 1976 | 6 |
| 1977 | 13 |
| 1978 | 13 |
| 1979 | 11 |
| 1980 | 7 |
| 1981 | 8 |
| 1982 | 6 |
| 1983 | 8 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 7 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 7 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 7 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 1 |
| 2020 | 3 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 2 |
| 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304'))
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 MKC89LA030Accident · No injuriesLimited investigationFinal reportCessna 170A · Mccrory, ARThe student pilot and passenger said after about 10 minutes of local flight, they experienced a partial power loss. An emergency ldg was attempted on a near by rural strip, but the plt said he had excess airspeed and was unable to land successfully. The…NTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…NTSB FTW88FA160Accident · 4 fatalField investigationFinal reportCessna 170A · El Paso, TXPilot's impairment due to the influence of alcohol.NTSB FTW88LA098Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Sour Lake, TXThe acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles…NTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…