NTSB investigations: Cessna 170B, 1988
11 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\") = 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 ('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") = 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 ('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 ANC89LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt rprtd that drg an apch to land, a x-wind caused the acft to drift to the left. Subsequently, the left wing struck trees along the edge of the rwy & the acft crashed. The plt rprtd the wind was from 120 deg at 6 gusting 10 KTS.NTSB ANC88LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Willow, AKAfter the student did a touch and go, during the initial climb out, the airplane stalled and crashed into a row of trees at the end of the runway. The student pilot reportedly startled by turbulence, pulled rapidly back on the control yoke, and the aircraft…NTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.NTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.NTSB ANC88LA084Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot of a Cessna 170 lost directional control and ground looped while taxiing for take off. The FAA control tower had instructed the pilot to taxi behind a taxiing B-727, and issued caution: wake turbulence. The idle power of the B-727 caused the Cessna…NTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILNTSB MKC88LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Bayard, NEThe pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop…NTSB BFO88LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Goldsboro, MDThe plt said he unsuccessfully tried to climb in ground-effect after the acft lifted off before adequate flying speed was obtained. The acft drifted right of the rwy and touched down in a plowed field where it nosed over.NTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…NTSB ANC88LA031Accident · No injuriesLimited investigationFinal reportCessna 170 · Healy, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the plane to strike a small tree next to a snow covered taxiway.NTSB FTW88LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Crowley, TXThe engine stopped as a result of fuel starvation, due to a large amount of contamination throughout the fuel system. The source of the contamination and the length of time it had been in the system was not determined. The pilot was not in gliding distance of…