NTSB investigations: Cessna 182D, TX
18 cases on aircraft the registry lists as Cessna 182D. 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
| 1964 | 4 |
|---|---|
| 1965 | 2 |
| 1966 | 3 |
| 1967 | 3 |
| 1978 | 1 |
| 1981 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2008 | 1 |
| 2010 | 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 ('2072710'))
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 ('2072710'))
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 CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.NTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.NTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.NTSB FTW88LA137Accident · No injuriesLimited investigationFinal reportCessna 182D · Gilmer, TXThe pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and…NTSB FTW82DPD03Accident · No injuriesClosedCessna 182 · Ranger, TXNTSB FTW78DQG20Accident · No injuriesClosedCessna 182 · Olton, TXNTSB FTW68F0389Accident · Minor injuriesClosedCessna 182D · Ft.Stockton, TXNTSB FTW68A0058Accident · 3 fatalClosedCessna 182 · Orange, TXNTSB FTW67F0494Accident · No injuriesClosedCessna 182D · Ranger, TXNTSB FTW67F0311Accident · No injuriesClosedCessna 182 · Ort Worth, TXNTSB FTW67F0292Accident · No injuriesClosedCessna 182D · Crystal City, TXNTSB FTW66D0569Accident · Minor injuriesClosedCessna 182 · Zapata, TXNTSB FTW66D0230Accident · No injuriesClosedCessna 182 · Coyanosa, TXNTSB UNK65X1460Accident · No injuriesClosedCessna 182D · Austin, TXNTSB UNK65X1113Accident · No injuriesClosedCessna 182 · Mason, TXNTSB UNK64X3047Accident · Minor injuriesClosedCessna 182 · Denison, TXNTSB UNK64X2548Accident · No injuriesClosedCessna 182 · Aubrey, TXNTSB UNK64X0831Accident · No injuriesClosedCessna 182D · Teague, TX