NTSB investigations: Cessna 170B, 1982
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\") = 1982
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") = 1982
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 LAX83LUG09Accident · No injuriesFinal reportCessna 170B · Big Bear City, CAThe accident occured after touchdown when the pilot temporarily lost control and the aircraft veered off the runway. The wing and propeller collided with a frozen snow bank.NTSB ANC83LA015Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Elim, AKAccording to a witness, the acft lifted off the rwy about midfield, climbed to about 30-50 ft AGL & then began a dive. The witness heard no change in eng sound. The acft's wing first struck a box set on top of other equipment on the ground(about 4 ft 6 in…NTSB FTW82DRG38Accident · No injuriesFinal reportCessna 170B · San Marcos, TXAcft swerved off rwy during takeoff. Ex-military plt retired in 1965, check out in aero club tricycle gear acft on 8/28/82 with subsequent 72 hrs all in tricycle gear acft. Plt stated he had not flown conventional gear acft since the 1950'S. There was no…NTSB ATL82FA261Accident · 1 fatalField investigationFinal reportCessna 170B · Lawrenceville, GADuring the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later…NTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.NTSB ANC82DA053Accident · No injuriesFinal reportCessna 170B · Near Anchorage, AKWhile on a fishing trip, the pilot landed on an abandoned oil exploration roadway. The pilot reported that he did not realize how narrow the roadway was until after he had landed and slowed the aircraft. He reported that he was not aware that the edges of the…NTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.NTSB LAX82DA229Accident · No injuriesFinal reportCessna 170B · Pacoima, CAThe pilot reported that he landed on runway 12 with a slight crosswind from the right. After touchdown, the aircraft veered to the right, the left wingtip and the propeller struck the surface, and the plane nosed over.NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…NTSB ANC82DAA04Accident · No injuriesFinal reportCessna 170 · Chicken, AKThe student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before…NTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…NTSB FTW82FRJ11Accident · Serious injuriesFinal reportCessna 170B · Plain Dealing, LAThe aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while…NTSB DEN82DA060Accident · No injuriesFinal reportCessna 170B · Worden, MTThe pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still…NTSB ANC82DA022Accident · No injuriesFinal reportCessna 170 · Poorman, AKAfter making a low pass over the runway and noting that it was plowed with berms on both sides and that there were bare patches on the runway the pilot elected to land. Shortly after touchdown the left ski encountered a bare spot on the frozen snow and ice…NTSB ANC82DAG15Accident · No injuriesFinal reportCessna 170B · Tuluksak, AKThe pilot reported that on returning to bethel the weather was bad so he landed at Tuluksak. The weather cleared and the pilot attempted to return to bethel. After takeoff the pilot stated that he lost visual contact with the ground during a 180 degree turn…