NTSB investigations: Cessna P210N, 1984
6 cases on aircraft the registry lists as Cessna P210N. 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 | 4 |
|---|---|
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 9 |
| 1982 | 10 |
| 1983 | 3 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 7 |
| 1995 | 7 |
| 1996 | 8 |
| 1997 | 8 |
| 1998 | 1 |
| 1999 | 8 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 2 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 7 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 5 |
| 2018 | 9 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 5 |
| 2026 | 4 |
Where
Latest 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 ('2073454', '2073462'))
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 ('2073454', '2073462'))
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 LAX85LA058Accident · No injuriesLimited investigationFinal reportCessna P210N · Lancaster, CAPlt elected to make a precautionary landing at Lancaster due to a low fuel state. Eng quit while on downwind in traffic pattern. Unable to make it to the rwy, an off arpt landing was made during which the acft was damaged.NTSB ANC84LA177Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Point Hope, AKThe acft crashed during an attempted night takeoff with the plt controlled rwy lights turned off. The plt stated he had consumed a couple of alchoholic beverages earlier in the evening; and although approached by several people to fly, he stated he refused…NTSB LAX84LA298Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Ramona, CAAs part of an experimental test flt in the turbine powered acft, intentional spins were performed. The planned one turn spin evolved into a flat spin. Recovery procedures were ineffective and the plt elected to deploy the anti-spin parachute. Despite repeated…NTSB MIA84LA107Accident · No injuriesLimited investigationFinal reportCessna 210N · Lacrosse, FLThe plt reported that the right fuel tank went dry when the fuel gage indicated it had 6 gal remaining. He switched fuel tanks, & shortly thereafter, the left tank emptied when the gage indicated it had 13 gal remaining. He tried to land in a pasture, but was…NTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…NTSB ATL84FA088Accident · 2 fatalField investigationFinal reportCessna P210N · Greensboro, NCDuring arrival, the plt was advised that the arpt wx had just changed to IFR. He was assigned an alt (2900 ft MSL) & provided a vector for an ILS apch. Shortly thereafter, the plt advised that he was 'having motor difficulty & needed to come straight-in.' He…