NTSB investigations: Cessna 170A, 1974
19 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
Latest 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\") = 1974
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") = 1974
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 NYC75DHA28Accident · No injuriesClosedCessna 170A · Pittstown, NJNTSB NYC75FHD25Accident · Minor injuriesClosedCessna 170 · Marlton, NJNTSB MKC75DTK02Accident · No injuriesClosedCessna 170 · Vermillion, SDNTSB DEN75AD005Accident · 2 fatalClosedCessna 170A · Bernardo, NMNTSB OAK74DVG69Accident · No injuriesClosedCessna 170A · Redding, CANTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MONTSB CHI74FER05Accident · No injuriesClosedCessna 170A · Horse Creek, WINTSB DEN74AD058Accident · 2 fatalClosedCessna 170A · Dubois, WYNTSB MIA74DKT84Accident · No injuriesClosedCessna 170A · Naples, FLNTSB NYC74FHM28Accident · No injuriesClosedCessna 170A · Fairfield, NJNTSB ANC74FAA35Accident · Serious injuriesClosedCessna 170 · Mckinley Prk, AKNTSB ANC74FAA34Accident · No injuriesClosedCessna 170A · North Pole, AKNTSB IAD74AI058Accident · 2 fatalClosedCessna 170A · Newport News, VANTSB CHI74DEP43Accident · No injuriesClosedCessna 170A · Gratiot, WINTSB ANC74DAG98Accident · No injuriesClosedCessna 170A · Mt.Village, AKNTSB MKC74FCG28Accident · No injuriesClosedCessna 170A · Bonner Sprgs, KSNTSB NYC74DFJ26Accident · No injuriesClosedCessna 170A · Batavia, NYNTSB MKC74DTK08Accident · No injuriesClosedCessna 170A · Bemis, SDNTSB LAX74DVA40Accident · No injuriesClosedCessna 170A · Kennedy Mds, CA