NTSB investigations: Cessna TR182, 1988
6 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\") = 1988
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") = 1988
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 DEN89LA048Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lamar, COThe pilot was making a VFR approach for landing. The landing gear was lowered and full flaps were deployed. The pilot said he allowed the airspeed to get too low and the aircraft stalled. The nose and left wing dropped and the pilot added full power. The nose…NTSB LAX89FA021Accident · 1 fatalField investigationFinal reportCessna TR-182 · Paso Robles, CAThe pilot failed to maintain the proper altitude while executing the published instrument approach procedure.NTSB ATL89LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lexington, NCDuring final approach to rwy 26 a crosswind shifted to a tailwind. The plt rprtd a full flap/carb heat touchdown was made despite 14 knots airspeed. Insufficient rwy remained and full throttle was applied for go-around. Flaps and carb heat were not…NTSB ANC88DAG07Accident · No injuriesFinal reportCessna T182RG · Kenai, AKThe pilot was taxiing the Cessna to the ramp area when the airplane wing struck a light pole near the terminal building. The pilot stated that he did not see the light pole before impact and that it blended in with the natural surroundings.NTSB LAX88LA244Accident · No injuriesLimited investigationFinal reportCessna TR182 · Niland, CADuring the takeoff ground run on a dirt road, witnesses stated that the pilot had lifted the nose of the airplane so high that the tail dragged on the ground. The airplane became entangled in weeds near the road, the pilot lost control and the airplane…NTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CA