NTSB investigations: Cessna 182P, 1981
19 cases on aircraft the registry lists as Cessna 182P. 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
| 1972 | 13 |
|---|---|
| 1973 | 23 |
| 1974 | 24 |
| 1975 | 29 |
| 1976 | 40 |
| 1977 | 36 |
| 1978 | 42 |
| 1979 | 31 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 25 |
| 1983 | 22 |
| 1984 | 13 |
| 1985 | 17 |
| 1986 | 14 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 13 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 11 |
| 1994 | 20 |
| 1995 | 8 |
| 1996 | 15 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 13 |
| 2002 | 7 |
| 2003 | 8 |
| 2004 | 13 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 13 |
| 2008 | 3 |
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 2 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 5 |
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\") = 1981
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075816'))
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") = 1981
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075816'))
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 MKC82FA007Accident · 5 fatalClosedCessna 182P · Wauneta, NENTSB MKC82FCG11Accident · Serious injuriesClosedCessna 182P · Olathe, KSNTSB MKC82FA003Accident · 2 fatalClosedCessna 182P · Essex, IANTSB ATL82DLQ02Accident · Minor injuriesClosedCessna 182P · Hazard, KYNTSB DEN82FTE04Accident · No injuriesClosedCessna 182P · Steamboat Spgs, CONTSB ATL82FA107Accident · 2 fatalClosedCessna 182 · Berryville, VANTSB LAX81DUJ79Accident · No injuriesClosedCessna 182P · Glendale, AZNTSB ATL81FKG33Accident · No injuriesClosedCessna 182 · Abbeville, GANTSB MKC81DCA18Accident · No injuriesClosedCessna 182P · Kahoka, MONTSB DEN81DTI16Accident · No injuriesClosedCessna 182 · Great Falls, MTNTSB NYC81DA065Accident · No injuriesClosedCessna 182 · Pittstown, NJNTSB SEA81FA042Accident · 3 fatalClosedPiper PA-28 · Bliss, IDNTSB FTW81FPJ29Accident · Minor injuriesClosedCessna 182 · Lawton, OKNTSB DEN81DTM23Accident · No injuriesClosedCessna 182P · Monument Vly, UTNTSB MKC81DCG26Accident · No injuriesClosedCessna 182P · Graham, MONTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCNTSB SEA81FA020Accident · 2 fatalClosedCessna 182P · Everett, WANTSB LAX81DVA25Accident · Minor injuriesClosedCessna 182P · Lost Hills, CANTSB CHI81DEE17Accident · Minor injuriesClosedCessna 182 · Roselle, IL