NTSB investigations: Cessna P210N, 2018
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\") = 2018
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") = 2018
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 ERA19LA061Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Myerstown, PAA total loss of engine power due to fuel starvation.NTSB CEN18LA363Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Crete, NEThe stuck turbocharger wastegate in the closed position for reasons that could not be determined based on the available information. Also causal was the pilot's failure to reduce the throttle during takeoff when the manifold pressure and fuel flow exceeded…NTSB WPR18FA245Accident · 1 fatalClass 2 · FieldFinal reportCessna P210 · Prescott, AZThe pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.NTSB CEN18LA351Accident · No injuriesLimited investigationFinal reportCessna P210 · Delaware, OHThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s distraction of the formation flight.NTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…NTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.NTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.