NTSB investigations: Cessna 210A, 1965
12 cases on aircraft the registry lists as Cessna 210A. 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
| 1964 | 12 |
|---|---|
| 1965 | 12 |
| 1966 | 10 |
| 1967 | 11 |
| 1968 | 4 |
| 1969 | 5 |
| 1970 | 7 |
| 1971 | 3 |
| 1972 | 1 |
| 1973 | 6 |
| 1974 | 5 |
| 1975 | 5 |
| 1977 | 1 |
| 1978 | 5 |
| 1979 | 1 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1996 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2025 | 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 year(c.\"eventDate\") = 1965
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073408'))
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") = 1965
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073408'))
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 FTW66A0045Accident · 2 fatalClosedCessna 210 · Ft Stockton, TXNTSB OAK66D0106Accident · No injuriesClosedCessna 210 · Nut Tree, CANTSB MKC66D0172Accident · Minor injuriesClosedCessna 210 · Ottawa, KSNTSB FTW66A0016Accident · 1 fatalClosedPiper PA-24 · Amarillo, TXNTSB CHI66A0003Accident · 2 fatalClosedCessna 210 · Meppen, ILNTSB MIA66D0057Accident · No injuriesClosedCessna 210 · Faison, NCNTSB MKC65F0144Accident · No injuriesClosedCessna 210A · Pratt, KSNTSB DEN65D0052Accident · Serious injuriesClosedCessna 210 · Orem, UTNTSB DEN65D0039Accident · No injuriesClosedCessna 210 · Cortez, CONTSB FTW66F0257Accident · No injuriesClosedCessna 210 · Ft Worth, TXNTSB MIA65F0008Accident · No injuriesClosedCessna 210 · Tampa, FLNTSB UNK65X1353Accident · No injuriesClosedCessna 210 · Silver City, NM