NTSB investigations: Cessna 210E, CA

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

19652026

NTSB investigations: Cessna 210E, CA per year, 1965–2026: 16 cases
1965	1
1966	1
1967	3
1968	1
1969	2
1971	1
1975	1
1976	1
1979	1
1983	1
1996	1
1997	1
2014	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."eventStateOrRegion" = 'CA' 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 ('2073416')) 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.\"eventStateOrRegion\" = 'CA' 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 ('2073416'))
  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" = 'CA' 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 ('2073416'))
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 WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.Apr 27, 2014 · N4962U · 2 aircraft · Destroyed NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.Aug 22, 1997 · N1808F · Destroyed NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.Aug 17, 1996 · N4931U · Destroyed NTSB LAX84LA109Accident · No injuriesLimited investigationFinal reportCessna 210E · El Monte, CAA relatively inexperienced plt made a hard landing and reported that the 'front' tire blew upon landing. He pulled up & the acft ballooned and landed very hard on the nose wheel. Control tower personnel stated that the acft flew into the rwy in a nose low…Oct 26, 1983 · N2353F · Substantial damage NTSB OAK79DVG14Accident · Serious injuriesClosedCessna 210 · Rio Linda, CAFeb 18, 1979 · N2368F · Substantial damage NTSB OAK77DVG04Accident · No injuriesClosedCessna 210 · Davis, CAOct 16, 1976 · N4987U · Substantial damage NTSB LAX76DUG22Accident · No injuriesClosedCessna 210E · 29 Palms, CADec 4, 1975 · N4908U · Destroyed NTSB OAK71DVG50Accident · Minor injuriesClosedCessna 210 · Lower Lake, CAJan 22, 1971 · N2368F · Destroyed NTSB LAX70D0174Accident · No injuriesClosedCessna 210 · Bakersfield, CAOct 31, 1969 · N4902U · Substantial damage NTSB LAX69D0308Accident · No injuriesClosedCessna 210 · Yucca Valley, CAApr 4, 1969 · N2362F · Substantial damage NTSB OAK69D0057Accident · Serious injuriesClosedCessna 210 · Alturas, CAMay 20, 1968 · N4962U · Destroyed NTSB OAK68D0022Accident · No injuriesClosedCessna 210 · Concord, CAJun 11, 1967 · N2383Y · Substantial damage NTSB OAK67F0314Accident · Minor injuriesClosedCessna 210 · Lee Vining, CAMay 6, 1967 · N2393F · Substantial damage NTSB LAX67D0350Accident · No injuriesClosedCessna 210 · Palm Desert, CAFeb 26, 1967 · N194CF · Substantial damage NTSB LAX67F0190Accident · No injuriesClosedCessna 210 · Needles, CANov 14, 1966 · N2352F · Substantial damage NTSB OAK66D0157Accident · No injuriesClosedCessna 210 · Mammoth Lakes, CANov 29, 1965 · N2393F · Substantial damage