# NTSB investigations: Bellanca 14-19-3, 1986

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 CHI87FA054](https://openairdocs.org/ntsb/CHI87FA054.md): Bellanca 14-19-3A · West Chicago, IL · Accident · 4 fatal · Field investigation · Final report · Dec 22, 1986 · N1253R · Destroyed
  > At 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx…
- [NTSB ATL86FA220](https://openairdocs.org/ntsb/ATL86FA220.md): Bellanca 14-19-3A · Toccoa, GA · Accident · Serious injuries · Field investigation · Final report · Aug 13, 1986 · N1297R · Destroyed
  > The plt checked on the acft the day prior to this flt and stated that he did not want it refueled. On the day of the flt he was observed draining fuel from the acft. He air filed an IFR flt plan and stated that he had 3 hrs and 45 mins of fuel and his en…

## 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 year(c."eventDate") = 1986
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080106', '1250012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3080106&year=1986

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