NTSB investigations: Cessna 170B, 1997
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\") = 1997
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") = 1997
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 LAX98LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Fernley, NVthe pilot's failure to maintain terrain clearance during a delayed go-around after an improper decision to continue an approach to an unlighted runway without adequate visual references. Ground fog was a factor in this accident.NTSB ANC97LA154Accident · No injuriesLimited investigationFinal reportCessna 170B · Lime Village, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB ANC97LA139Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Paxson, AKThe pilot's improper use of carburetor heat during a takeoff in carburetor icing conditions. Factors associated with the accident were the pilot's decision to operate the airplane with known deficiencies (a disabled stall warning horn), an inadvertent stall,…NTSB IAD97LA110Accident · No injuriesLimited investigationFinal reportCessna 170B · Jamestown, NYThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB ANC97LA114Accident · No injuriesLimited investigationFinal reportCessna 170B · Juneau, AKThe pilot's selection of an unsuitable off-airport site for takeoff, and his premature lift-off.NTSB SEA97LA160Accident · No injuriesLimited investigationFinal reportCessna 170B · Jackson, WYThe pilot's inadequate compensation for wind conditions. Gusting wind conditions was a factor.NTSB SEA97LA161Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Bend, ORthe pilot's failure to attain a proper climb rate. High density altitude and the pilot's failure to use all of the available runway were factors.NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.NTSB ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB ANC97LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKthe flight instructor's inadequate preflight by failing to ensure his seat was properly latched, and his resultant failure (or inability) to recover from the student pilot's bounced landing. A factor associated with the accident was: the student pilot's…NTSB LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.NTSB ANC97LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Manley Hot Sprn, AKThe pilot's selection of an unsuitable landing area. A factor was the soft snow.NTSB ANC97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.