NTSB investigations: Cessna T210F, 1983
2 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.
Cases per year
| 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 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\") = 1983
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") = 1983
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" 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 ATL84FA005Accident · Serious injuriesField investigationFinal reportCessna T210F · Glasgow, VAThe acft crashed during an attempted go-around after a hard landing on a 1200 ft private strip in mountainous terrain. The two pilots had landed at this arpt in landings described as fast. Then two passengers were invited to ride along one more landing was…NTSB LAX83FUG22Accident · No injuriesFinal reportCessna T210F · Mecca, CAThe stolen acft, operated by persons unknown, landed on a road and turned over on its back.