NTSB investigations: Cessna 170A, 1983
8 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
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\") = 1983
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") = 1983
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 LAX83LA392Accident · No injuriesLimited investigationFinal reportCessna 17OA · Ramona, CAThe plt was practicing touch-and-go landings in winds that were variable at 5 gusting 10 KTS. On his 4th landing, he touched down using the 'full stall technique.' He reported that after touching down, he turned off the carburetor heat & raised the flaps,…NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…NTSB MKC83LA173Accident · No injuriesLimited investigationFinal reportCessna 170A · Syracuse, KSWhile the plt was making his second landing, the acft began to rock back & forth during the roll-out. He added power to correct the oscillation, but said the power had the opposite effect. He lost directional control & the acft swerved off the left side of…NTSB LAX83LA306Accident · Serious injuriesLimited investigationFinal reportCessna C170A · Cajon Pass, CAThe plt was flying about 40 ft AGL in marginal weather when the acft contacted a power line and crashed. No flt plan wasfiled and there is no record of a weather briefing for the plt. The plt stated he was following a highway up a Pass whenhe encountered…NTSB NYC83LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Chatham, MAThe acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…NTSB FTW83LA233Accident · No injuriesLimited investigationFinal reportCessna 170A · Prague, OKWhile turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…NTSB DEN83LA098Accident · No injuriesLimited investigationFinal reportCessna 170A · Plentywood, MTPilot was practicing touch and go landings on runway 30. Pilot stated that on landing roll as he closed the carburetor heat control preparing for another takeoff a gust caught the right wing lifting it up. The pilot corrected by using right aileron and left…NTSB FTW83LA081Accident · No injuriesLimited investigationFinal reportCessna 170A · Temple, TXThe student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed.