NTSB investigations: Cessna 210D, TX
16 cases on aircraft the registry lists as Cessna 210D. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 4 |
| 1970 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2003 | 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 ('2073414'))
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 ('2073414'))
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 FTW03CA201Accident · No injuriesData collectionFinal reportCessna 210D · San Antonio, TXThe pilot's failure to comply with the checklist resulting in a wheels up landing. Contributing to the accident was self-induced pressure.NTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.NTSB FTW93LA082Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hillsboro, TXThe power loss due to fuel exhaustion for undetermined reasons. Factors were the dark night conditions and the lack of suitable terrain for the ensuing forced landing.NTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…NTSB FTW79DQD06Accident · No injuriesClosedCessna 210 · El Paso, TXNTSB FTW77DQG28Accident · No injuriesClosedCessna 210 · Amarillo, TXNTSB FTW74DQG27Accident · No injuriesClosedCessna 210 · Hereford, TXNTSB FTW70FQD07Accident · Minor injuriesClosedCessna 210D · Ft.Stockton, TXNTSB FTW68F0399Accident · Minor injuriesClosedCessna 210C · Gatesville, TXNTSB FTW68D0343Accident · No injuriesClosedCessna 210 · Austin, TXNTSB FTW68F0259Accident · No injuriesClosedCessna 210D · Corpus Chrsti, TXNTSB FTW67D0549Accident · No injuriesClosedCessna 210D · Alief, TXNTSB FTW67D0180Accident · No injuriesClosedCessna 210 · Midland, TXNTSB FTW67A0006Accident · 4 fatalClosedCessna 210D · Antelope, TXNTSB FTW66D0083Accident · No injuriesClosedCessna 210D · Alief, TXNTSB UNK64X3495Accident · No injuriesClosedCessna 210 · George West, TX