NTSB investigations: Cessna 180H, 1971
18 cases on aircraft the registry lists as Cessna 180H. 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 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 10 |
| 1967 | 8 |
| 1968 | 13 |
| 1969 | 10 |
| 1970 | 13 |
| 1971 | 18 |
| 1972 | 12 |
| 1973 | 13 |
| 1974 | 10 |
| 1975 | 14 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 10 |
| 1979 | 10 |
| 1980 | 5 |
| 1981 | 10 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 9 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 1 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 2 |
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 ('2072618'))
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 ('2072618'))
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 ANC72AA029Accident · No injuriesClosedCessna 180 · Iliamna, AKNTSB ANC72AA021Accident · No injuriesClosedCessna 180H · Gulkana, AKNTSB MIA72FKG51Accident · Serious injuriesClosedCessna 180H · Hartwell, GANTSB FTW72FRD14Accident · Minor injuriesClosedCessna 180 · Paincourtville, LANTSB ANC72DAG45Accident · No injuriesClosedCessna 180H · Glenallen, AKNTSB MKC72FTG10Accident · No injuriesClosedCessna 180 · Minot, NDNTSB ANC72DAG18Accident · No injuriesClosedCessna 180H · Kodiak, AKNTSB FTW72AF005Accident · 2 fatalClosedPiper PA-18 · Houma, LANTSB ANC72FFAA2Accident · No injuriesClosedCessna 180H · Healey, AKNTSB FTW71AF086Accident · No injuriesClosedCessna 180H · Palmetto, LANTSB ANC71FAA30Accident · No injuriesClosedCessna 180 · Galena, AKNTSB FTW71FRA55Accident · Minor injuriesClosedCessna 170B · Angleton, TXNTSB ANC71AA054Accident · No injuriesClosedCessna 180H · Aniak, AKNTSB ANC71AA046Accident · No injuriesClosedCessna 180H · Bethel, AKNTSB FTW71AF061Accident · No injuriesClosedCessna 180H · Delacroix, LANTSB FTW71AF059Accident · Minor injuriesClosedCessna 180 · Intrcoastl Cty, LANTSB ANC71AA038Accident · No injuriesClosedCessna 180 · Seward, AKNTSB ANC71AA036Accident · No injuriesClosedCessna 180 · Bethel, AK