NTSB investigations: Cessna P210N, 2021
10 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\") = 2021
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") = 2021
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 WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB GAA22WA029Accident · 1 fatalClass 5 · ForeignCessna P210N · Dornbirn, AustriaNTSB ERA22FA009Accident · 4 fatalClass 3 · FieldFinal reportCessna P210 · Atlanta, GAThe pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…NTSB CEN21LA460Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · El Paso, TXA faulty landing gear pressure switch prematurely deactivated the landing gear motor during extension, which resulted in the landing gear collapsing during rollout.NTSB GAA21WA207AccidentClass 5 · ForeignCessna P210N · Marbach, GermanyNTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB ERA21LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Marianna, FLThe failure of the alternator control unit housing plug connection, which resulted in insufficient battery power to fully extend the landing gear. Contributing to the accident was the pilot’s decision to not use the emergency gear extension handle to secure…NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB ERA21LA146Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Bartow, FLA leaking left main landing gear down lock actuator, which resulted in a loss of hydraulic fluid and a subsequent landing gear collapse during landing.NTSB WPR21LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Moab, UTThe pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.