# Fatal NTSB investigations: Cessna P210R

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 ATL94FA056](https://openairdocs.org/ntsb/ATL94FA056.md): Cessna P210R · Bay Minette, AL · Accident · 4 fatal · Field investigation · Final report · Mar 1, 1994 · N55MM · Destroyed
  > The pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…
- [NTSB DEN90FA159](https://openairdocs.org/ntsb/DEN90FA159.md): Cessna P210R · Ogden, UT · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1990 · N6203A · Destroyed
  > Failure of the #1 piston due to pre-ignition/detonation in the #1 cylinder, and inadequate visual lookout by the pilot (his failure to see-and-avoid the obstruction). The obstruction (power line) was a related factor.
- [NTSB FTW87MA133](https://openairdocs.org/ntsb/FTW87MA133.md): Cessna P210R · Arnett, OK · Accident · 1 fatal · Major investigation · Final report · Jun 3, 1987 · N5488A · Destroyed
  > The flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…
- [NTSB NYC87FA109](https://openairdocs.org/ntsb/NYC87FA109.md): Cessna P210R · Block Island, RI · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1987 · N6434A · Destroyed
  > The aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,…

## 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 c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073455'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=2073455

---
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.