NTSB investigations: Cessna 182K, TX
17 cases on aircraft the registry lists as Cessna 182K. 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1974 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 3 |
| 1983 | 1 |
| 1991 | 1 |
| 2001 | 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 ('2072724'))
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 ('2072724'))
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 CEN11CA037Accident · No injuriesData collectionFinal reportCessna 182K · Henderson, TXThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in a hard landing.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.NTSB FTW83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Weston, TXThe plt was on a flt to obtain aerial photographs. He elected to land in a pasture to discuss a survey problem with personnel on the ground. He had previously checked the area by driving across it with a vehicle and felt it was satisfactory. After making a…NTSB FTW81DPA03Accident · No injuriesClosedCessna 182 · Waco, TXNTSB FTW81DPD45Accident · No injuriesClosedCessna 182 · Bangs, TXNTSB FTW80DPD24Accident · No injuriesClosedCessna 182K · Graham, TXNTSB FTW80FRA07Accident · Serious injuriesClosedCessna 182 · Houston, TXNTSB FTW78FPA18Accident · No injuriesClosedCessna 182K · Waxahachie, TXNTSB FTW75DQD10Accident · No injuriesClosedCessna 182 · Alpine, TXNTSB FTW75FRG01Accident · No injuriesClosedCessna 182 · Port Lavaca, TXNTSB FTW73AFO18Accident · 1 fatalClosedCessna 182K · Eliasville, TXNTSB FTW71FPD29Accident · No injuriesClosedCessna 182 · Fort Worth, TXNTSB FTW70FRA09Accident · No injuriesClosedCessna 182K · Houston, TXNTSB FTW69D0450Accident · No injuriesClosedCessna 182 · Lubbock, TXNTSB FTW69D0293Accident · No injuriesClosedCessna 182 · Liberty, TXNTSB FTW68D0171Accident · No injuriesClosedCessna 182 · Fabens, TX