NTSB investigations: Cessna TR182, 1984
5 cases on aircraft the registry lists as Cessna TR182. 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
| 1979 | 2 |
|---|---|
| 1980 | 6 |
| 1981 | 7 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 10 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 1 |
| 2008 | 7 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 1 |
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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735'))
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 ATL84FA275Accident · Serious injuriesField investigationFinal reportCessna TR182 · Wilmington, NCThe power loss occurred in cruise at 10,000 ft. at 0903 EDT the pilot notified Wilmington approach control that he had a 'rough engine' and requested vectors to Wilmington. Approach control responded with heading information for the back course approach and a…NTSB LAX84FA439Accident · 1 fatalField investigationFinal reportCessna 182RG · Prescott, AZAs the acft proceeded on takeoff down the rwy, it exited the rwy on the left side over a berm into a wide shallow ditch area, then about 122 feet later the acft traveled back over the berm onto the rwy and took off. The nose then pitched up, the acft banked…NTSB LAX84FA299Accident · Serious injuriesField investigationFinal reportCessna TR182 · Big Bear City, CAJust after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…NTSB MIA84LA144Accident · No injuriesLimited investigationFinal reportCessna TR182 · Daytona Beach, FLThe plt was unable to lower the landing gear and made a wheels-up landing. An exam revealed that a rod end, pn S02321-3, on the nose gear door had failed. The failure was in tension bending with no signs of preexisting fatigue or corrosion.NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…