NTSB investigations: Cessna 170B, 1996
17 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\") = 1996
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") = 1996
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 CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.NTSB FTW97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Manvel, TXLoss of aircraft control due to the pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.NTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.NTSB ANC96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's selection of unsuitable terrain for taxiing.NTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.NTSB ANC96LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain directional control during the landing roll.NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.NTSB SEA96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Lewistown, MTthe pilot's inadequate compensation for the changing wind conditions, and his failure to maintain directional control, which resulted in an inadvertent ground swerve. The sudden windshift was a related factor.NTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.NTSB ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.NTSB ANC96LA070Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain control of the airplane during takeoff.NTSB ANC96LA067Accident · No injuriesLimited investigationFinal reportCessna 170 · Dillingham, AKrotation (slippage) of the tire on the rim, and shearing of the valve stem, which allowed the rim to contact the ground and then separate.NTSB ANC96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Togiak, AKfatigue failure of the right main landing gear strut.NTSB ANC96LA052Accident · No injuriesLimited investigationFinal reportCessna 170B · Chicken, AKThe first pilot's failure to maintain clearance with a tree. Factors in the accident were the first pilot's inadequate preflight planning and preparation and soft snow conditions.NTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.