NTSB investigations: Cessna 175, 1971
18 cases on aircraft the registry lists as Cessna 175. 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 | 20 |
|---|---|
| 1965 | 27 |
| 1966 | 26 |
| 1967 | 21 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 9 |
| 1971 | 18 |
| 1972 | 10 |
| 1973 | 14 |
| 1974 | 11 |
| 1975 | 9 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 6 |
| 1979 | 8 |
| 1980 | 7 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 8 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 8 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 5 |
| 1994 | 7 |
| 1995 | 8 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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 MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSNTSB CHI72FET11Accident · Serious injuriesClosedCessna 175 · Auburn, INNTSB MIA72FKQ26Accident · No injuriesClosedCessna 175 · Duck Hill, MSNTSB LAX72FUG36Accident · Minor injuriesClosedN.American P-51D · Chino, CANTSB ANC72AA026Accident · 4 fatalClosedCessna 175 · Willits, CANTSB SEA72DYC23Accident · No injuriesClosedCessna 175 · Condon, ORNTSB SEA72DYA20Accident · No injuriesClosedCessna 175 · Rexburg, IDNTSB CHI72FEI18Accident · No injuriesClosedCessna 175A · Montville, OHNTSB CHI72FEP13Accident · No injuriesClosedCessna 175 · Dodgeville, WINTSB SEA72DYG07Accident · Minor injuriesClosedCessna 175 · Mullan, IDNTSB FTW72DQG15Accident · No injuriesClosedCessna 175 · Seminole, TXNTSB DEN71DTC05Accident · No injuriesClosedCessna 175 · Sheridan, WYNTSB SEA71FYE37Accident · Minor injuriesClosedCessna 175 · Kenmore, WANTSB CHI71FEG28Accident · No injuriesClosedCessna 175 · Hillsboro, OHNTSB CHI71FLQ30Accident · No injuriesClosedCessna 175 · Junction City, KYNTSB IAD71FIA20Accident · Serious injuriesClosedCessna 175 · Hillsboro, VANTSB SEA71DTI30Accident · No injuriesClosedCessna 175 · Havre, MTNTSB SEA71DWG43Accident · No injuriesClosedCessna 175 · Pasco, WA