NTSB investigations: Cessna 182R, 1999
5 cases on aircraft the registry lists as Cessna 182R. 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 8 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2018 | 1 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 3 |
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\") = 1999
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072731'))
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") = 1999
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072731'))
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 DEN00LA027Accident · No injuriesLimited investigationFinal reportCessna 182R · Farmington, NMThe pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.NTSB NYC00FA004Accident · 1 fatalField investigationFinal reportCessna 182R · Killingworth, CTThe pilot's failure follow the published instrument approach procedure. A factor in the accident was the low cloud ceiling.NTSB CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.NTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.NTSB MIA99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Sevierville, TNA loss of propeller governor control due to oil contamination.