NTSB investigations: Cessna 210L, MT

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

19742026

NTSB investigations: Cessna 210L, MT per year, 1974–2026: 6 cases
1974	1
1976	1
1978	1
1988	1
1995	1
2002	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" = 'MT' 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 ('2073448')) 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\" = 'MT' 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 ('2073448'))
  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" = 'MT' 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 ('2073448'))
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 SEA02LA025Accident · No injuriesLimited investigationFinal reportCessna 210L · Great Falls, MTThe pilot's intentional continuation of a visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the terrain. Factors include low ceilings, snow, mountainous/hilly terrain, and trees.Jan 9, 2002 · N1713X · Substantial damage NTSB SEA96LA011Accident · No injuriesLimited investigationFinal reportCessna 210L · Lincoln, MTThe failure of the pilot to follow the landing checklist and assure that the landing gear was extended. Factors relating to the accident were: the pilot's diverted attention, and an inoperative landing gear warning system.Oct 24, 1995 · N1752X · Substantial damage NTSB DEN88IA083Incident · No injuriesIncident investigationFinal reportCessna 210 · Billings, MTMar 17, 1988 · N2180S · Minor damage NTSB SEA78FA041Accident · 2 fatalClosedCessna 210L · Belgrade, MTJun 30, 1978 · N22195 · Destroyed NTSB SEA76DTI24Accident · No injuriesClosedCessna 210 · Stevensville, MTApr 17, 1976 · N59130 · Substantial damage NTSB SEA74FTA20Accident · No injuriesClosedCessna 210 · Glendive, MTApr 5, 1974 · N35498 · Substantial damage