NTSB investigations: Cessna R182, 2001
4 cases on aircraft the registry lists as Cessna R182. 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 | 2 |
|---|---|
| 1976 | 1 |
| 1978 | 7 |
| 1979 | 9 |
| 1980 | 11 |
| 1981 | 14 |
| 1982 | 10 |
| 1983 | 11 |
| 1984 | 11 |
| 1985 | 12 |
| 1986 | 2 |
| 1987 | 7 |
| 1988 | 12 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 4 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 4 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 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\") = 2001
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072734'))
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") = 2001
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072734'))
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 LAX02LA050Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Maria, CAInadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.NTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.NTSB CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.NTSB SEA01LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Renton, WAThe worn condition of the hydraulic pump gears which resulted in a continuous running pump, subsequent pump motor overheat and eventually the tripping of the pump motor circuit breaker. An additional cause was the pilot's failure to verify that the landing…