# NTSB investigations: Cessna 210E: Collision with terr/obj (non-CFIT)

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 CEN14GA135](https://openairdocs.org/ntsb/CEN14GA135.md): Cessna 210E · Oden, AR · Accident · 1 fatal · Final report · Jan 31, 2014 · N4957U · Substantial damage
  > The pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.
- [NTSB CEN14CA092](https://openairdocs.org/ntsb/CEN14CA092.md): Cessna 210E · Guymon, OK · Accident · Minor injuries · Data collection · Final report · Dec 20, 2013 · N2382F · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.
- [NTSB ERA13FA209](https://openairdocs.org/ntsb/ERA13FA209.md): Cessna 210E · Williamsburg, VA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2013 · N111BK · Substantial damage
  > The pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.
- [NTSB ERA12LA157](https://openairdocs.org/ntsb/ERA12LA157.md): Cessna 210E · Port Orange, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2012 · N7130U · Substantial damage
  > The total loss of engine power for reasons that could not be conclusively determined during postaccident examination.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073416')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?model=2073416

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