NTSB investigations: Cessna 182N, TX
12 cases on aircraft the registry lists as Cessna 182N. 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
| 1971 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 2 |
| 1976 | 2 |
| 1985 | 1 |
| 1990 | 1 |
| 2008 | 2 |
| 2017 | 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 ('2072730'))
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 ('2072730'))
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 GAA17CA129Accident · No injuriesData collectionFinal reportCessna 182 · Midland, TXThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.NTSB DEN08CA075Accident · No injuriesData collectionFinal reportCessna 182N · Amarillo, TXThe pilot's failure to maintain aircraft control during the landing. Contributing to the accident were the crosswind, gusty wind conditions and the pilot's inadequate compensation for the wind conditions.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB FTW86LA003Accident · No injuriesLimited investigationFinal reportCessna 182N · Odessa, TXDuring touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left…NTSB FTW76FQD27Accident · Serious injuriesClosedCessna 182N · Salt Flat, TXNTSB FTW76DRA44Accident · No injuriesClosedCessna 182 · Houston, TXNTSB FTW74FQG05Accident · No injuriesClosedCessna 182N · Lubbock, TXNTSB FTW73DRG57Accident · No injuriesClosedCessna 182 · Brownsville, TXNTSB FTW73DQG47Accident · No injuriesClosedCessna 182 · Amarillo, TXNTSB FTW72AF085Accident · 5 fatalClosedCessna 182N · Smiley, TXNTSB FTW71FPD57Accident · No injuriesClosedCessna 182 · Stephenville, TX