# NTSB investigations: Cessna 414A: In flight collision with object

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 LAX87LA144](https://openairdocs.org/ntsb/LAX87LA144.md): Cessna 414A · Chinle, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1987 · N26864 · Substantial damage
  > The plt rprtd the rwy lights on one side of the rwy were inop & that he made an apch to the wrong side of the lights. When he realized the acft was not aligned with the rwy, he initiated a go-around. However, as he started to go-around, the acft hit a fence…
- [NTSB MKC84FA077](https://openairdocs.org/ntsb/MKC84FA077.md): Cessna 414A · Mena, AR · Accident · 2 fatal · Field investigation · Final report · Feb 15, 1984 · N6815Z · Substantial damage
  > Acft cleared for Mena NDB apch and to maintain 5000 ft MSL until established on the apch. Acft descended to 4800 ft MSL on aprx grnd track of 040 to 030 deg after NDB passage. Acft then turned to a ground track of 116 deg. After 12 seconds the acft turned to…
- [NTSB ATL83FA337](https://openairdocs.org/ntsb/ATL83FA337.md): Cessna 414A · Marion, NC · Accident · Minor injuries · Field investigation · Final report · Aug 23, 1983 · N5ER · Destroyed
  > During the takeoff run, at 85 KTS, the acft hit a bump & the plt stated his forward vision was obstructed by water on the windshield. He instinctively pulled back on the controls & become airborne. He lost sight of the right side set of rwy lights & was…
- [NTSB DCA82AA008](https://openairdocs.org/ntsb/DCA82AA008.md): Cessna 414A · Ashland, VA · Accident · 8 fatal · Final report · Jan 3, 1982 · N2620L · Destroyed
  > The plt received 2 wx briefings, one on the evening bfr the flt, another at 1009 EST, within 3 hrs of the tkof time. IFR conditions were forcasted at the uncontrolled, destination arpt. The plt filed an IFR flt plan, but did not list an alternate arpt. The…

## 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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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