NTSB investigations: Cessna R182, TX
16 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 3 |
| 1985 | 2 |
| 1988 | 1 |
| 2005 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 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 ('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 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 ('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 GAA17CA289Accident · No injuriesData collectionFinal reportCessna R182 · Llano, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN13CA458Accident · Minor injuriesData collectionFinal reportCessna R182 · Lago Vista, TXThe pilot’s inadequate recovery from a bounced landing in crosswind conditions, and an inadvertent aerodynamic stall during the subsequent go-around attempt.NTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB CEN09CA245Accident · No injuriesData collectionFinal reportCessna R182 · Granger, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.NTSB DFW05LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Roanoke, TXThe pilot's misjudgment of distance needed to land to a full stop resulting in an overrun. Contributing factors were the prevailing rain and the encounter with hydroplaning conditions.NTSB FTW88LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bonham, TXOne airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in…NTSB FTW85LA319Accident · No injuriesLimited investigationFinal reportCessna R182 · Lubbock, TXThe plt made a hard landing at the town and country arpt at Lubbock, TX, and a collapse of the nose gear resulted.NTSB FTW85LA277Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Midland, TXThe plt stated that on a pass over the pvt strip the wind sock as indicating the wind out of the north. In actuality, Midland regional arpt was reporting the winds from 110 degs at 13 KTS. Touchdown was made at a higher than normal airspeed. The acft landed…NTSB FTW84LA062Accident · No injuriesLimited investigationFinal reportCessna R182 · Houston, TXThe acft nosed down during a crosswind landing. The rwy is 100/280 degrees and the wind was 360 degrees at 19 KTS. Shortly after the landing touchdown the acft nose gear separated from the acft.NTSB FTW83LA151Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sheffield, TXAfter takeoff from a ranch strip, the eng lost power during a turn, then started again after the plt leveled the wings. He maneuver over the strip & the eng cut out two more times. The acft descend into grassy terrain, but hit a rock & damaged the nose gear.…NTSB FTW83LA113Accident · No injuriesLimited investigationFinal reportCessna R182 · George West, TXThe plt reported that after he touched down on a wet grass runway, he was unable to stop, so he elected to go around. During the go-around, the gear collided with a fence, and subsequently, the acft crashed into trees and a building.NTSB FTW81FA108Accident · No injuriesClosedCessna R182 · Abilene, TXNTSB FTW80DQG14Accident · No injuriesClosedCessna R182 · Vega, TXNTSB FTW80FA007Accident · 4 fatalClosedCessna 182 · Sonora, TXNTSB FTW78DRA42Accident · No injuriesClosedCessna 182RG · Midway, TX