Fatal NTSB investigations: Cessna 210K
10 cases on aircraft the registry lists as Cessna 210K. 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 |
|---|---|
| 1978 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2011 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073446'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073446'))
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 CEN11WA695Accident · 6 fatalClass 5 · ForeignCessna 210K · (Atlantic Ocean)NTSB DFW07FA073Accident · 1 fatalField investigationFinal reportCessna 210K · Lago Vista, TXThe pilot's failure to maintain clearance from terrain. A factor was the pilot's diverted attention with a reported autopilot malfunction.NTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…NTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.NTSB LAX97FA210Accident · 1 fatalField investigationFinal reportCessna 210K · Topanga, CAThe pilot's failure to maintain proper VFR altitude over mountainous terrain obscured by clouds, and his intentional descent into instrument meteorological weather conditions.NTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.NTSB MIA85LA176Accident · 1 fatalLimited investigationFinal reportCessna 210K · Missing AcftThe Acft departed miami, FL, at about 0700 EDT on a flt to port-au-prince, haiti. It did not arrive at its destination or return to miami. The Acft was not found & was presumed to have been destroyed. Also, the plt was not found & was presumed to have been…NTSB SEA84FA217Accident · 4 fatalField investigationFinal reportCessna 210K · Mccall, IDTwo acft departed in trail intending to follow a river through the mountainous terrain in their climb above the ridge line. The first acft proceeded as planned along the river and turned toward the dest at a safe alt. About 1/4 of a mile behind, the second…NTSB NYC78FA022Accident · 2 fatalClosedCessna 210K · Ithaca, NYNTSB FTW71AF063Accident · 1 fatalClosedCessna 210K · Roganville, TX