# NTSB investigations: Cessna 414A: In flight encounter with weather

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 LAX04FA113](https://openairdocs.org/ntsb/LAX04FA113.md): Cessna 414A · Laupahoehoe, HI · Accident · 3 fatal · Field investigation · Final report · Jan 31, 2004 · N5637C · Destroyed
  > the pilot's disregard for an in-flight weather advisory, his likely encounter with marginal VFR or IMC weather conditions, his decision to continue flight into those conditions, and failure to maintain an adequate terrain clearance altitude resulting in an…
- [NTSB ATL89FA058](https://openairdocs.org/ntsb/ATL89FA058.md): Cessna 414 · Bloomville, OH · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1988 · N84UM · Destroyed
- [NTSB DEN84FA122](https://openairdocs.org/ntsb/DEN84FA122.md): Cessna 414A · Douglas, WY · Accident · Serious injuries · Field investigation · Final report · Apr 1, 1984 · N414EM · Substantial damage
  > During an approach for a downwind landing, the acft stalled & impacted the ground 192 ft short of rwy 28. The plane had encountered icing conditions during flt & ice was still adhering to the acft as the plt made an approach for landing. Instrument conditions…
- [NTSB ATL84FA058](https://openairdocs.org/ntsb/ATL84FA058.md): Cessna 414A · Waynesville, NC · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1983 · N6623C · Destroyed
  > After departure at 1417 CST, radar track showed the acft climbing to & maintaining 7,600 ft until about 1733 EST & 28-30 mi north of the knoxville VOR. The acft then descended & crossed the snowbird VOR at about 6,700 ft. there were several up & down altitude…

## 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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