NTSB investigations: Cessna TR182
9 cases on aircraft the registry lists as Cessna TR182, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072735')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB SEA01LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Boise, IDThe pilot's failure to adequately compensate for wind conditions. Wind gusts were a factor.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB DEN90LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sioux Falls, SDThe pilot's loss of directional control during landing roll.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, CANTSB 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 DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…NTSB LAX82DA059Accident · No injuriesFinal reportCessna TR182 · Las Vegas, NVThe pilot stated that on landing after the second bounce the plane veered left and ran off the runway on to the desert and flipped over.