# NTSB investigations: Cessna 210A: 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 ERA19FA266](https://openairdocs.org/ntsb/ERA19FA266.md): Cessna 210 · Marathon, FL · Accident · 2 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N9436X · Substantial damage
  > The pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.
- [NTSB WPR14CA261](https://openairdocs.org/ntsb/WPR14CA261.md): Cessna 210A · Port Angeles, WA · Accident · No injuries · Data collection · Final report · Jun 22, 2014 · N9457X · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a ground-loop.
- [NTSB WPR13LA078](https://openairdocs.org/ntsb/WPR13LA078.md): Cessna 210A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Dec 31, 2012 · N9507X · Substantial damage
  > A loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA11FA038](https://openairdocs.org/ntsb/ERA11FA038.md): Cessna 210A · Aiken, SC · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2010 · N6655X · Substantial damage
  > The pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot’s…
- [NTSB WPR10LA251](https://openairdocs.org/ntsb/WPR10LA251.md): Cessna 210A · Benson, AZ · Accident · Minor injuries · Limited investigation · Final report · May 21, 2010 · N6630X · Substantial damage
  > A loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.

## 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 ('2073408')
    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=2073408

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