NTSB investigations: Cessna 170B, 1986
15 cases on aircraft the registry lists as Cessna 170B. 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 | 77 |
|---|---|
| 1965 | 67 |
| 1966 | 61 |
| 1967 | 46 |
| 1968 | 48 |
| 1969 | 31 |
| 1970 | 36 |
| 1971 | 44 |
| 1972 | 35 |
| 1973 | 32 |
| 1974 | 35 |
| 1975 | 35 |
| 1976 | 27 |
| 1977 | 22 |
| 1978 | 28 |
| 1979 | 22 |
| 1980 | 12 |
| 1981 | 16 |
| 1982 | 15 |
| 1983 | 13 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 15 |
| 1987 | 17 |
| 1988 | 11 |
| 1989 | 11 |
| 1990 | 10 |
| 1991 | 12 |
| 1992 | 7 |
| 1993 | 13 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 17 |
| 1997 | 15 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 10 |
| 2001 | 9 |
| 2002 | 11 |
| 2003 | 10 |
| 2004 | 12 |
| 2005 | 9 |
| 2006 | 14 |
| 2007 | 5 |
| 2008 | 3 |
| 2009 | 13 |
| 2010 | 9 |
| 2011 | 4 |
| 2012 | 6 |
| 2013 | 12 |
| 2014 | 11 |
| 2015 | 9 |
| 2016 | 3 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 7 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 8 |
| 2025 | 8 |
| 2026 | 6 |
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072306', '2072307'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072306', '2072307'))
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 ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…NTSB ATL87FA039Accident · 1 fatalField investigationFinal reportCessna 170B · Madison, GAAlthough there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near…NTSB MKC87LA014Accident · No injuriesLimited investigationFinal reportCessna 170B · Hyannis, NEThe pilot stated that he was servicing customers while on this business trip. On his next call, the pilot further stated, he was to land in a hay field that he had previously used but, due to water in the area, he elected to land on higher grounds. Upon…NTSB NYC86LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Danbury, CTThe aircraft bounced on touchdown, but then settled back to the runway with the tail swinging to the left. Hard left brake was applied but the pilot could not maintain direction control and the aircraft ran off the runway into the turf striking the left wing…NTSB DEN86LA240Accident · No injuriesLimited investigationFinal reportCessna 170B · Greeley, COPlt was ferrying acft from glenwood springs, CO to troy, MO. Acft was out of annual (3-84) and a special airworthiness certificate was issued. Plt likewise had not flown for 2 years. Plt accomplished the mandatory biennial flight review the day before the…NTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…NTSB ANC86LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Blackburn, AKAcft undershot apch and crashed into a river while executing a low circling apch to land at a nearby gravel bar. Plt stated that he had been on duty for about 18 hrs, had flown 8.4 hrs that day hauling fish and that he was tired and 'playing around'. Acft…NTSB ANC86LA103Accident · No injuriesLimited investigationFinal reportCessna 170B · Tekanika River, AKThe acft nosed over during the forced landing which followed a total loss of pwr. The plt reported he noted a decrease in oil pressure during cruise flt just prior to the pwr loss. Examination of the acft eng revealed that the #6 cylinder push rod had failed.NTSB ANC86LA096Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Alexander Creek, AKWhile landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over.NTSB FTW86LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Witchita Falls, TXDuring the ground run portion of the takeoff, the pilot lost directional control of his taildragger aircraft. As the aircraft was spinning around the right gear struck a small ditch and broke the landing gear off, causing the aircraft to come to rest on its…NTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…NTSB DEN86LA111Accident · No injuriesLimited investigationFinal reportCessna 170B · St George, UTThe plt stated the acft encountered a crosswind and ground looped during the landing touchdown.NTSB ATL86FEI03Accident · Minor injuriesFinal reportCessna 170B · Columbia Stat., OHThe acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft.NTSB ANC86LA040Accident · No injuriesLimited investigationFinal reportCessna 170-B · Whittier, AKThe pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back.NTSB MKC86LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Alliance, NEThe plt had just completed a biennial flight review in Alliance, Nebraska and was returning to land on his ranch property south of Alliance. Wind rpts fm the Alliance airport, and the FAA flight service station in scottsbluff, indicated winds generally fm the…