NTSB investigations: Cessna 182P, 1974
24 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
Latest 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\") = 1974
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") = 1974
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 OAK75DXQ33Accident · No injuriesClosedCessna 182 · Jackpot, NVNTSB NYC75AN061Accident · 1 fatalClosedCessna 182P · Niagara Falls, NYNTSB CHI75FEE28Accident · No injuriesClosedCessna 182P · Chicago, ILNTSB CHI75FEP31Accident · Serious injuriesClosedCessna 182P · Racine, WINTSB MIA75DKT18Accident · No injuriesClosedCessna 182 · Miami, FLNTSB IAD75AI019Accident · 1 fatalClosedCessna 182 · Relief, KYNTSB MIA75FLA17Accident · No injuriesClosedCessna 182P · Pensacola, FLNTSB DEN75FTE30Accident · Minor injuriesClosedCessna 182P · Center, CONTSB OAK75DVG28Accident · No injuriesClosedCessna 182 · Covelo, CANTSB NYC75FHM09Accident · No injuriesClosedCessna 182 · Spring Valley, NYNTSB CHI75FEA09Accident · No injuriesClosedCessna 182 · Franklin, INNTSB SEA75DYA11Accident · Minor injuriesClosedCessna 182P · Rockland, IDNTSB NYC75AN012Accident · 4 fatalClosedPiper PA-28R · Toms River, NJNTSB SEA74AS051Accident · 1 fatalClosedCessna 182P · Zigzag, ORNTSB MIA74FLG30Accident · Serious injuriesClosedCessna 182P · Ridgeway, SCNTSB DEN74FTE78Accident · Serious injuriesClosedCessna 182 · Englewood, CONTSB FTW74DPG57Accident · No injuriesClosedCessna 182 · Jonesboro, ARNTSB CHI74DEI37Accident · No injuriesClosedCessna 182P · Fremont, OHNTSB DEN74DTE60Accident · Minor injuriesClosedCessna 182 · Lake City, CONTSB LAX74AL062Accident · 4 fatalClosedCessna 182P · Ventura, CANTSB CHI74FE134Accident · Minor injuriesClosedCessna 182 · Vickery, OHNTSB LAX74DVW11Accident · No injuriesClosedCessna 182P · Shoshone, CANTSB DEN74AD032Accident · 1 fatalClosedCessna 182P · Ward, CONTSB NYC74FGT14Accident · No injuriesClosedCessna 182 · New Cumberland, PA