NTSB investigations: Cessna T210F, 1972

10 cases on aircraft the registry lists as Cessna T210F. 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

19662026

NTSB investigations: Cessna T210F, 1972 per year, 1966–2026: 91 cases
1966	6
1967	13
1968	4
1969	4
1970	3
1971	2
1972	10
1973	7
1974	3
1975	1
1976	3
1977	4
1978	1
1980	2
1981	3
1983	2
1985	1
1986	1
1987	1
1988	3
1989	1
1990	1
1993	2
1995	2
1999	3
2001	1
2002	1
2013	1
2017	1
2018	1
2021	1
2022	1
2023	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 year(c."eventDate") = 1972 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073422')) 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 year(c.\"eventDate\") = 1972
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073422'))
  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 year(c."eventDate") = 1972
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073422'))
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 DEN73FTC11Accident · Minor injuriesClosedCessna T210F · Cheyenne, WYOct 13, 1972 · N6185R · Destroyed NTSB NYC73FFA11Incident · No injuriesClosedCessna 210 · Hudson, NYAug 23, 1972 · N6176R · Minor damage NTSB OAK73FXQ11Accident · Minor injuriesClosedCessna T210 · Reno, NVAug 19, 1972 · N6734R · Substantial damage NTSB MIA73DKJ08Accident · No injuriesClosedCessna 210F · Montgomery, ALAug 4, 1972 · N6148R · Substantial damage NTSB MIA72DKW31Accident · No injuriesClosedCessna 210 · Elizabethton, TNJun 26, 1972 · N6198R · Substantial damage NTSB FTW72DRG64Accident · No injuriesClosedCessna 210T · Cabo San Lucs, MexicoApr 8, 1972 · N6763R · Substantial damage NTSB OAK72AP035Accident · 1 fatalClosedCessna 210K · Sacramento, CAMar 22, 1972 · N6725R · Destroyed NTSB MIA72AM094Accident · 1 fatalClosedCessna T210F · Jasper, GAMar 21, 1972 · N6117R · Destroyed NTSB DEN72AD034Accident · 1 fatalClosedCessna T210F · Lehi, UTFeb 1, 1972 · N6762R · Destroyed NTSB DEN72AD033Accident · 1 fatalClosedCessna T210F · Wagon Mound, NMJan 26, 1972 · N6152R · Destroyed