NTSB investigations: Cessna P210N, 1985
7 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\") = 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 ('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") = 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 ('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 MKC86FA026Accident · 4 fatalField investigationFinal reportCessna P210N · Wichita, KSThe acdt occurred during an IFR, non-precision approach to the uncontrolled jabara airport. When the flt was one mile from the faf, ATC told the flt that in the event of a missedapproach N3864P should enter controlled airspace heading 360 deg. The controller…NTSB CHI86FA006Accident · No injuriesField investigationFinal reportCessna P210N · Grayslake, ILDuring descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks…NTSB NYC85LA158Accident · No injuriesLimited investigationFinal reportCessna P210 · White Plains, NYA gear up landing was made following a loss of oil during takeoff. The acft was serviced with oil at skyport aviation prior to the attempted takeoff. The plt reported that after the oil was added he checked the oil level with the dip stick. Shortly after…NTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…NTSB LAX85LA196Accident · 1 fatalLimited investigationFinal reportCessna P210N · Santa Barbara, CAAfter receiving a special VFR clearance to depart the control zone to the northeast the non-instrument rated plt took off on a southeasterly heading over the water under low ceilings and in low visibility. A controller observed the acft start a right turn…NTSB LAX85LA182Accident · 2 fatalLimited investigationFinal reportCessna P210N · Mountain Pass, CAThe non-instrument rated plt departed into a weather front. VFR flt was not recommended. Flt precautions existed for icing, turbulence & mt obscuration. The radar chart showed light to moderate rain with isolated thunderstorms. The acft was issued a clearance…NTSB SEA85LA058Accident · No injuriesLimited investigationFinal reportCessna P210 · Las Vegas, NVThe hydraulic power pack reservoir was depleted from a leak in the hand pump suction line, which had been chafed through by interference with the right rudder cable. Apparently, there was sufficient back pressure remaining to lower and lock the nose gear, but…