NTSB investigations: Cessna P210N, 1986
9 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
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\") = 1986
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") = 1986
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 LAX87LA064Accident · No injuriesLimited investigationFinal reportCessna P210N · Chandler, AZWhile the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On…NTSB SEA86LA249Accident · No injuriesLimited investigationFinal reportCessna P-210 · Pasco, WAWhile in cruise at 14,000 feet MSL, a catastrophic engine failure with a flash fire at the turbocharger occurred. A turn to reverse direction for a forced landing was initiated while making a rapid descent. An undershoot to the runway occurred with the…NTSB LAX86LA331Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Salton City, CAA total loss of power was experienced during a descent from 17,500' MSL to 10,000' MSL. Attempts to restart the engine failed and the acft was landed gear-up in a rocky field. Post accident inspection disclosed a track of internal electrical arcing in the…NTSB FTW86LA148Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Altus, OKThe engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…NTSB FTW86LA124Accident · Minor injuriesLimited investigationFinal reportCessna P-210N · Zachery, LAThe plt experienced a total loss of power due to fuel exhaustion during cruise flight. Approach control vectored him to a closer airport but the aircraft was beyond gliding distance and it collided with a house which was under construction. Inspection of the…NTSB ATL86FA182Accident · Minor injuriesField investigationFinal reportCessna P210N · Lawrenceville, GAThe acft was damaged during a forced lndg on a hiway after the engine quit. The flt was nearing its destination on a VFR x-country when the engine lost power. The acft fuel tank selector was on the rt tank for 2 hrs before and during the emergency. After the…NTSB LAX86LA156Accident · No injuriesLimited investigationFinal reportCessna 210P · Ontario, CAA Cessna 210P collided with the runway surface after a total loss of engine power. Examination of the aircraft revealed that the right fuel tank was empty. The pilot indicated that he had a total of 60 gallons of 100LL on departure and he had selected the…NTSB DEN86FA077Accident · 3 fatalField investigationFinal reportCessna P210N · Dulce, NMThe plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the…NTSB DCA86AA017Accident · 2 fatalFinal reportCessna P210N · Keflavik, IcelandAt 1146 gmt, N4906K deptd on a 5 hr flt to narssarssuaq, greenland with an estd 7 hrs of fuel. When the plt rprtd 60 mi sw of greenland, the destn vis was below IFR min & the ceiling at the altn arpt was below the mda. The plt elected to cont to reykjavik,…