NTSB investigations: Cessna 170A, 1985
7 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
Latest 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 ('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") = 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 ('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 CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…NTSB NYC85LA253Accident · No injuriesLimited investigationFinal reportCessna C-170A · Marathon, NYDuring an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…NTSB DEN85LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalispell, MTThe plt was returning from a local pleasure flt, it was a hot day. The plt said that he inadvertently leveled the acft aprx 10 ft high. He said the acft stalled causing a hard landing. The impact caused substantial damage to the acft.NTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…NTSB LAX85LA260Accident · No injuriesLimited investigationFinal reportCessna 170A · Bakersfield, CAThe plt placed the ignition key on the acft's dashboard & then proceeded to turn over the prop by hand. Acft was not tied down or chocked & the eng started. The plt attempted to restrain the runaway acft. After being dragged for several yds, the plt let…NTSB NYC85LA078Accident · No injuriesLimited investigationFinal reportCessna 170A · Perkasie, PAThe pilot stated that the aircraft ground looped to the right after touchdown. The left gear collapsed and the aircraft spun to the left.NTSB SEA85FA049Accident · 3 fatalField investigationFinal reportCessna 170A · Lopez, WAShortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,…