# NTSB investigations: Cessna P210N, 2017

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR18LA022](https://openairdocs.org/ntsb/WPR18LA022.md): Cessna P210N · Mount Vernon, WA · Accident · No injuries · Limited investigation · Final report · Oct 28, 2017 · N6582P · Substantial damage
  > The failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.
- [NTSB CEN17LA247](https://openairdocs.org/ntsb/CEN17LA247.md): Cessna P210N · Eagle, CO · Accident · No injuries · Limited investigation · Final report · Jun 30, 2017 · N210HG · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17WA195](https://openairdocs.org/ntsb/CEN17WA195.md): Cessna P210N · San Vicente Tancoayalab, Mexico · Accident · Serious injuries · Foreign investigation · May 9, 2017 · N116DC · Destroyed
  > On May 9, 2017, about 1430 universal coordinated time, a Cessna P210N airplane, N116DC, impacted trees and terrain during an emergency descent near San Vicente Tancoayalab, Mexico, following lightning strikes during cruise. The pilot was seriously injured and…
- [NTSB GAA17CA221](https://openairdocs.org/ntsb/GAA17CA221.md): Cessna P210 · Granby, CO · Accident · No injuries · Data collection · Final report · Apr 6, 2017 · N829BA · Substantial damage
  > The pilot's failure to extend the landing gear before landing.
- [NTSB ERA17LA098](https://openairdocs.org/ntsb/ERA17LA098.md): Cessna P210 · Pottsville, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2017 · N4796P · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2017
  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
```

This list as a web page: https://openairdocs.org/ntsb?model=2073454&year=2017

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.