NTSB investigations: Cessna 210M, 1985
6 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\") = 1985
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") = 1985
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 MIA86LA030Accident · No injuriesLimited investigationFinal reportCessna 210M · Ft.Lauderdale, FLWhile in cruise flight the pilot attempted to lower the landing gear and the right main landing gear would not extend. During this process the aircraft generator went off the line. The pilot attempted to manually lower the landing gear and extended the nose…NTSB CHI85LA276Accident · No injuriesLimited investigationFinal reportCessna 210MII · Detroit, MIThe acft contacted a tree during a forced landing in a residential area following a loss of pwr. Post accident inspection revealed the right fuel tank contained fuel and the left tank was dry, the left wing fuel vent was installed backwards and the fuel…NTSB NYC85LA147Accident · No injuriesLimited investigationFinal reportCessna 210M · Linden, NJDuring the preflt inspection, the plt visually checked the fuel tanks and determined them to be full. The flt was made with the fuel selector on the left wing tank. During the apch to Linden arpt, the eng stopped operating. The plt attempted to restart the…NTSB NYC85FA120Accident · 2 fatalField investigationFinal reportCessna 210M · Morrisville, NYShortly after t/o the pilot experienced a rough running engine, continued maneuvering at a low altitude and the engine quit due to undetermined cause. The pilot attempted to stretch the glide to an open field and stalled the aircraft, which mushed into the…NTSB MIA85FA105Accident · 1 fatalField investigationFinal reportCessna 210 · Jacksonville, FLThe acft crashed & burned while attempting to return to the arpt after the pilot reported a power loss shortly after takeoff. A post crash exam of the engine did not reveal any evidence to suggest any failure or malfunction prior to impact.NTSB MIA85FA081Accident · No injuriesField investigationFinal reportCessna 210M · Stuart, FLThe acft eng failed in flt & the plt made an emergency landing at night in an open field. The field was on sandy terrain that had been contoured to be an orange grove. While landing on the uneven soft terrain, the acft was damaged. An exam of the eng revealed…