Fatal NTSB investigations: Cessna 210-5

16 cases on aircraft the registry lists as Cessna 210-5. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Fatal NTSB investigations: Cessna 210-5 per year, 1964–2026: 16 cases
1964	4
1965	1
1966	1
1967	1
1968	1
1971	1
1973	1
1974	1
1982	1
1983	1
1985	1
2017	1
2018	1

Where

Open the map

Latest cases

Query with SQL

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 ('2073404')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073404'))
  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 ('2073404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…Oct 1, 2018 · N8388Z · Substantial damage NTSB ANC18FA003Accident · 1 fatalField investigationFinal reportCessna 210 · Russian Mission, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Oct 16, 2017 · N8347Z · Destroyed NTSB SEA85FA120Accident · 3 fatalField investigationFinal reportCessna 205 · Chewelah, WAThe acft was observed flying up a canyon at low altitude while climbing at an angle equivalent to the surrounding terrain slope. Shortly thereafter the acft encountered steeply upsloping terrain and began impacting trees in a left wing high and nose up…May 20, 1985 · N125ZL · Destroyed NTSB FTW83FA142Accident · 1 fatalField investigationFinal reportCessna 210-5 · Orange Grove, TXThe plt was believed to have departed hebbronville muni arpt at about 0500 CST. When the acft failed to arrive at its destination, a search was initiated. The wreckage was found where it crashed in an area of mesquite trees & brush, about halfway between the…Mar 4, 1983 · N8270Z · Destroyed NTSB ATL82FA104Accident · 4 fatalField investigationFinal reportCessna 210-5 · Hendersonville, NCThe aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound…Apr 16, 1982 · N8113Z · Destroyed NTSB LAX75AL018Accident · 1 fatalClosedCessna 210-5 · Altadena, CAOct 7, 1974 · N1803Z · Destroyed NTSB LAX74AL047Accident · 5 fatalClosedCessna 210-5 · Hesperia, CADec 28, 1973 · N8263Z · Destroyed NTSB FTW71DRH25Accident · 2 fatalClosedCessna 210-5 · Rosarito Bch, MexicoMay 12, 1971 · N8172Z · Destroyed NTSB DEN69A0005Accident · 6 fatalClosedBeech K35 · Rock River, WYAug 1, 1968 · N3069C · 2 aircraft · Destroyed NTSB MKC67A0042Accident · 2 fatalClosedCessna 205 · Dighton, KSJan 1, 1967 · N1881Z · Destroyed NTSB NYC67A0075Accident · 3 fatalClosedCessna 205A · East Nassau, NYNov 6, 1966 · N4816U · Destroyed NTSB FTW65A0076Accident · 1 fatalClosedCessna 205 · Laredo, TXJan 24, 1965 · N8159Z · Destroyed NTSB UNK65X0230Accident · 6 fatalClosedCessna 210-5 · Plantation, FLOct 11, 1964 · N1877Z · Destroyed NTSB UNK64X2671Accident · 2 fatalClosedCessna 205 · Riverside, CAJul 5, 1964 · N8281Z · Destroyed NTSB UNK64X0476Accident · 4 fatalClosedCessna 210 · Pinon, NMFeb 6, 1964 · N1895Z · Destroyed NTSB UNK64X0202Accident · 6 fatalClosedCessna 205 · Vanderbilt, MIJan 10, 1964 · N1849Z · Destroyed