NTSB investigations: Cessna 182C, 1967
19 cases on aircraft the registry lists as Cessna 182C. 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 | 25 |
|---|---|
| 1965 | 16 |
| 1966 | 15 |
| 1967 | 19 |
| 1968 | 9 |
| 1969 | 11 |
| 1970 | 8 |
| 1971 | 7 |
| 1972 | 4 |
| 1973 | 4 |
| 1974 | 7 |
| 1975 | 8 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 9 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 9 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 4 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 2 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 5 |
| 2013 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 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\") = 1967
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708'))
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") = 1967
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708'))
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 LAX68D0267Accident · No injuriesClosedCessna 182C · Big Bear City, CANTSB SEA68F0233Accident · No injuriesClosedCessna 182C · Springfield, ORNTSB FTW68D0199Accident · No injuriesClosedCessna 182C · Skiatook, OKNTSB SEA68D0129Accident · No injuriesClosedCessna 182 · Bridge, IDNTSB DEN68D0064Accident · No injuriesClosedCessna 182 · Riverton, WYNTSB MKC68D0143Accident · No injuriesClosedCessna 182 · Newton, IANTSB MKC68D0038Accident · No injuriesClosedCessna 182C · Valentine, NENTSB LAX68F0060Accident · Serious injuriesClosedCessna 182 · Phoenix, AZNTSB LAX68F0287Accident · No injuriesClosedCessna 182C · Bakersfield, CANTSB DEN67F0277Accident · No injuriesClosedCessna 182 · Salt Lake City, UTNTSB LAX67A0107Accident · 2 fatalClosedCessna 182C · Hawthorne, CANTSB DIA67F0085Accident · No injuriesClosedCessna 182 · Raleigh, NCNTSB MKC67D0547Accident · No injuriesClosedCessna 182 · Stockton, MONTSB DEN67D0248Accident · No injuriesClosedCessna 182C · Lander, WYNTSB DEN67A0047Accident · 2 fatalClosedCessna 182C · Plymouth, UTNTSB OAK68D0151Accident · No injuriesClosedCessna 182 · Carmel, CANTSB FTW67D0546Accident · Minor injuriesClosedCessna 182 · San Felipe, MexicoNTSB FTW67D0438Accident · No injuriesClosedCessna 182 · Little Rock, ARNTSB CHI67F0469Accident · No injuriesClosedCessna 182 · Rising Sun, IN