NTSB investigations: Cessna R182, 1987
7 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\") = 1987
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") = 1987
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 DEN88LA029Accident · No injuriesLimited investigationFinal reportCessna 182RG · Boulder, MTWhile on a cross country flt at 6000 ft MSL, the eng lost power. Exam of the acft revealed that the left fuel tank contained 23 gallons while the right was empty. The fuel selector was found on the empty tank. The acft was destroyed during the emergency…NTSB CHI88LA009Accident · No injuriesLimited investigationFinal reportCessna R182RG II · Indianapolis, INAfter take-off, the pilot attempted to retract the landing gear when the hydraulic line on the right main gear actuator failed. The left main landing gear was stuck in the trailing position while the nose gear and right main gear remained down and locked. The…NTSB ATL87LA224Accident · No injuriesLimited investigationFinal reportCessna R182 · Calera, ALThe airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During…NTSB DEN87LA160Accident · No injuriesLimited investigationFinal reportCessna 182RG · Deming, NMDuring the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a…NTSB FTW87LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nowatta, OKDuring takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…NTSB ATL87LA120Accident · No injuriesLimited investigationFinal reportCessna R182 · Owensboro, KYPlt in cruise flt at 5500 ft about 30 min after dep fm paducah when he noted a small amount of black smoke coming from top of panel. The rear seat pax noted flames in the panel at the same time. The plt noted his position in relation to Owensboro and…NTSB BFO87FA024Accident · No injuriesField investigationFinal reportCessna R-182 · Martinsburg, WVThe plt stated that he forgot to make a final before lndg check because he was concentrating on traffic and the short lndg he had been requested to make. Twr personnel violated USAF procedures when they requested that the acft hold short of the east-west rwy…