# NTSB investigations: Cessna 414: In flight collision with terrain/water

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 ATL03FA077](https://openairdocs.org/ntsb/ATL03FA077.md): Cessna 414 · Waleska, GA · Accident · 1 fatal · Field investigation · Final report · Apr 10, 2003 · N822DB · Destroyed
  > The pilot's failure to maintain clearance from terrain.
- [NTSB CHI01LA109](https://openairdocs.org/ntsb/CHI01LA109.md): Cessna 414 · Minneapolis, MN · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2001 · N8247Q · Substantial damage
  > The pilot not maintaining the proper airspeed during the circling approach, the inadvertent stall and the subsequent loss of control. Factors were the pilot's decision to continue the approach in weather conditions below the approach/landing minimums, the…
- [NTSB FTW00LA075](https://openairdocs.org/ntsb/FTW00LA075.md): Cessna 414 · Oklahoma City, OK · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2000 · N7VS · Substantial damage
  > The failure of the pilot to deice the airplane prior to departure.
- [NTSB ANC90FA158](https://openairdocs.org/ntsb/ANC90FA158.md): Cessna 414 · Sitka, AK · Accident · 2 fatal · Field investigation · Final report · Aug 28, 1990 · N8180K · Destroyed
  > Improper planning/decision by the pilot, and his failure to follow IFR procedures and maintain clearance from mountainous terrain.
- [NTSB LAX89FA081](https://openairdocs.org/ntsb/LAX89FA081.md): Cessna 414 · Pleasanton, CA · Accident · 1 fatal · Field investigation · Final report · Jan 9, 1989 · N1672T · Destroyed
  > Failure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.
- [NTSB NYC85FA057](https://openairdocs.org/ntsb/NYC85FA057.md): Cessna 414 · Sadsburyville, PA · Accident · 4 fatal · Field investigation · Final report · Jan 31, 1985 · N1994G · Destroyed
  > Acft was on its rwy 29 apch when it collided with gnd 1 mile from the arpt. A witness saw he acft fly over the arpt to the west between 500 to 1500 ft. witnesses near the accident site saw the acft making abrupt maneuvers at low altitude prior to the…
- [NTSB NYC84FA294](https://openairdocs.org/ntsb/NYC84FA294.md): Cessna 414 · Wallingford, VT · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1984 · N18SM · Destroyed
  > The plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…

## 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 ('2075908')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2075908&occurrence=230

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