NTSB investigations: Cessna P210N, 2024
4 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\") = 2024
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") = 2024
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 ERA25LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Ball Ground, GAThe pilot and the flight instructor’s failure to maintain control of the airplane during a simulated loss of engine power during takeoff, which resulted in a runway excursion, and collision with a taxiway sign.NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.NTSB WPR24LA157Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Daggett, CAThe pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…NTSB WPR24LA126Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Auburn, WAAn overstress fracture of the left main landing gear actuator, which resulted in the failure of the left main landing gear to fully extend and lock into place.