NTSB investigations: Cessna TR182, TX
10 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2015 | 2 |
| 2020 | 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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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 CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB CEN15LA404Accident · 1 fatalLimited investigationFinal reportCessna TR182 · Midland, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN15LA243Accident · No injuriesLimited investigationFinal reportCessna TR182 · Tulia, TXThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB DFW08LA065Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Antonio, TXSeparation of the turbocharger exhaust stack, which resulted in a loss of engine power.NTSB DFW05CA206Accident · No injuriesData collectionFinal reportCessna 182T · Houston, TXThe gear-up landing as result of the separation of the hydraulic line in the landing gear extension system.NTSB FTW02LA119Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cypress, TXthe total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA344Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Port Isabel, TXpilot impairment of judgment and performance due to alcohol and drugs, and failure of the pilot(s) to maintain obstacle clearance, during an intentional low altitude flight manueuver (low pass under a bridge).NTSB FTW90FA018Accident · 2 fatalField investigationFinal reportCessna TR182 · Crane, TXThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his loss of aircraft control, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument…NTSB FTW82FRG33Accident · 4 fatalFinal reportCessna R182 · Bergheim, TXAt 0010 the plt contacted san antonio tower approximately 10 mi north of san antonio intl arpt. He stated he was at 3100 ft in the clouds. The controller instructed the plt to turn left heading 030, maintain 3,000, & asked the plt if hewanted an IFR…NTSB FTW80FQD09Accident · No injuriesClosedCessna TR182 · El Paso, TX