NTSB investigations: Cessna 210M, 2004
2 cases on aircraft the registry lists as Cessna 210M. 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
| 1978 | 5 |
|---|---|
| 1979 | 4 |
| 1980 | 6 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2018 | 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\") = 2004
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073450'))
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") = 2004
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073450'))
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 DEN05LA008Accident · No injuriesLimited investigationFinal reportCessna 210M · Salida, COThe pilot's inadequate preflight planning which failed to determine the fuel supply was inadequate resulting in fuel exhaustion and the loss of engine power.NTSB NYC04LA167Accident · No injuriesLimited investigationFinal reportCessna 210M · Quarryville, PAImproper maintenance performed on the airplane, which resulted in a total electrical failure during cruise flight in IMC, and a subsequent precautionary landing. A factor in the accident was the low ceiling.