NTSB investigations: Cessna 182G, 1966
18 cases on aircraft the registry lists as Cessna 182G. 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 | 15 |
|---|---|
| 1965 | 19 |
| 1966 | 18 |
| 1967 | 20 |
| 1968 | 13 |
| 1969 | 7 |
| 1970 | 11 |
| 1971 | 10 |
| 1972 | 4 |
| 1973 | 9 |
| 1974 | 7 |
| 1975 | 9 |
| 1976 | 5 |
| 1977 | 5 |
| 1978 | 2 |
| 1979 | 4 |
| 1980 | 10 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 3 |
| 2007 | 3 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2017 | 1 |
| 2018 | 3 |
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2025 | 1 |
| 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\") = 1966
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072716'))
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") = 1966
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072716'))
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 FTW67F0353Accident · No injuriesClosedCessna 182G · Spring Branch, TXNTSB DEN67A0032Accident · 1 fatalClosedCessna 182 · Lamar, CONTSB OAK67F0086Accident · No injuriesClosedCessna 182G · Sacramento, CANTSB OAK67A0027Accident · 4 fatalClosedCessna 182G · Tahoe Pardise, CANTSB SEA67D0124Accident · No injuriesClosedCessna 182 · Tacoma, WANTSB OAK67F0046Accident · No injuriesClosedCessna 182S · Woodland, CANTSB DEN67D0040Accident · No injuriesClosedCessna 182 · Colorado Sprg, CONTSB SEA67D0036Accident · No injuriesClosedCessna 182 · Riggins, IDNTSB MIA67D0012Accident · No injuriesClosedCessna 182G · Cleveland, TNNTSB MKC67D0089Accident · No injuriesClosedCessna 182 · Larned, KSNTSB DEN66F0357Accident · No injuriesClosedCessna 182G · Albuquerque, NMNTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoNTSB FTW66F0614Accident · Minor injuriesClosedCessna 182 · Donna, TXNTSB SEA66D0251Accident · No injuriesClosedCessna 182G · Port Angeles, WANTSB MIA66D0523Accident · No injuriesClosedCessna 182 · Huntsville, ALNTSB CHI66D0616Accident · No injuriesClosedCessna 182 · Columbus, OHNTSB DEN66D0248Accident · No injuriesClosedCessna 182 · Pubeblo, CONTSB SEA66F0225Accident · No injuriesClosedCessna 182G · Springfield, OR