# NTSB investigations: Cessna 414A: 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 WPR19FA079](https://openairdocs.org/ntsb/WPR19FA079.md): Cessna 414 · Yorba Linda, CA · Accident · 5 fatal · Class 3 · Field · Final report · Feb 3, 2019 · N414RS · Destroyed
  > The pilot’s failure to maintain airplane control after entering instrument meteorological conditions (IMC) while climbing due to spatial disorientation, which resulted in the exceedance of the airplane’s design stress limits and subsequent in-flight break-up.…
- [NTSB ERA16FA279](https://openairdocs.org/ntsb/ERA16FA279.md): Cessna 414 · Destin, FL · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2016 · N2735A · Destroyed
  > The pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.
- [NTSB CEN12FA161](https://openairdocs.org/ntsb/CEN12FA161.md): Cessna 414A · Hayden, CO · Accident · 2 fatal · Field investigation · Final report · Feb 19, 2012 · N4772A · Substantial damage
  > The pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.
- [NTSB CEN11LA273](https://openairdocs.org/ntsb/CEN11LA273.md): Cessna 414A · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Mar 23, 2011 · N4057C · Substantial damage
  > The pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.

## 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 ('2075907', '2075910')
    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=2075907

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