# Fatal, Final NTSB investigations: Bellanca 14-19

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 LAX06FA233](https://openairdocs.org/ntsb/LAX06FA233.md): Bellanca 14-19 · Arcata, CA · Accident · 1 fatal · Field investigation · Final report · Jul 17, 2006 · N522A · Destroyed
  > The pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…
- [NTSB LAX01FA160](https://openairdocs.org/ntsb/LAX01FA160.md): Bellanca 14-19 · Casa Grande, AZ · Accident · 1 fatal · Field investigation · Final report · May 1, 2001 · N521A · Destroyed
  > A fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…
- [NTSB LAX73AL062](https://openairdocs.org/ntsb/LAX73AL062.md): Bellanca 14-19 · Parker, AZ · Accident · 3 fatal · Closed · Jun 7, 1973 · N6581N · Destroyed
- [NTSB LAX72FUQ87](https://openairdocs.org/ntsb/LAX72FUQ87.md): Bellanca 14-19 · Prt Hueneme, CA · Accident · 1 fatal · Closed · May 7, 1972 · N527A · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=3080102&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
