NTSB investigations: Cessna 210L, 1984
4 cases on aircraft the registry lists as Cessna 210L. 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1974 | 10 |
| 1975 | 11 |
| 1976 | 17 |
| 1977 | 13 |
| 1978 | 10 |
| 1979 | 9 |
| 1980 | 8 |
| 1981 | 10 |
| 1982 | 12 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 8 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 10 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 4 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2024 | 1 |
| 2025 | 2 |
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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073448'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073448'))
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 MKC85FPG02Accident · Minor injuriesFinal reportCessna 210L · Newport, ARThe acft collided with trees during an emergency landing following a loss of pwr en route. The eng and prop separated during the accident and were submerged in water which prevented an examination to determine cause of the pwr loss.NTSB ATL84LA259Accident · No injuriesLimited investigationFinal reportCessna 210L · Conway, SCThe acft crashed into trees and after a loss of power during final apch. Plt reported the acft had 70 gallons of avgas onboard at departure from Conway, SC, at 0900 EDT. The proposed flt from Conway to florence, SC, and back to Conway was a distance of 72 NM.…NTSB LAX84LA436Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Chinle, AZAt about 1400 MST, the plt took off. He climbed & leveled off at 8500 ft. he was using fuel from the right tank which ran dry, then he switched to the left tank. At that time, he thought he had 30 mins of fuel remaining. He decided to land at Chinle, AZ, &…NTSB CHI84LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Middleton, WIPwr loss experienced during normal cruise flt. Plt received vector to nearest airport. There was no evidence of attempt to regain power. On approach to airport, plt extended lndg gear. Resultant drag factor increased glide angle to extent plt felt clearance…