NTSB investigations: Cessna 182B, 1975
9 cases on aircraft the registry lists as Cessna 182B. 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 | 19 |
|---|---|
| 1965 | 27 |
| 1966 | 21 |
| 1967 | 24 |
| 1968 | 13 |
| 1969 | 13 |
| 1970 | 12 |
| 1971 | 12 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 8 |
| 1975 | 9 |
| 1976 | 7 |
| 1977 | 8 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 6 |
| 1982 | 6 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 7 |
| 1992 | 7 |
| 1994 | 7 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 5 |
| 2025 | 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\") = 1975
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072706'))
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") = 1975
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072706'))
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 MIA76DKJ05Accident · Minor injuriesClosedCessna 182 · Elberta, ALNTSB LAX76DUJ07Accident · No injuriesClosedCessna 195 · Tucson, AZNTSB FTW76FPJ02Accident · Minor injuriesClosedCessna 182B · Norman, OKNTSB OAK75FVM29Accident · No injuriesClosedCessna 182B · San Jose, CANTSB FTW75FPD37Accident · No injuriesClosedCessna 182 · Richland Hills, TXNTSB DEN75DQG08Accident · No injuriesClosedCessna 182B · Clovis, NMNTSB MIA75AM062Accident · 1 fatalClosedCessna 182B · Zephyrhills, FLNTSB FTW75FPA18Accident · No injuriesClosedCessna 182B · Plano, TXNTSB DEN75FTC13Accident · No injuriesClosedCessna 182 · Casper, WY