# Fatal NTSB investigations: Wright C14AB AC BA

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 DEN02GA074](https://openairdocs.org/ntsb/DEN02GA074.md): Consolidated-Vultee P4Y-2 · Estes Park, CO · Accident · 2 fatal · Final report · Jul 19, 2002 · N7620C · Destroyed
  > the inflight failure of the left wing due to fatigue cracking in the left wing's forward spar and wing skin. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.
- [NTSB SEA85FA182](https://openairdocs.org/ntsb/SEA85FA182.md): Consolidated-Vultee PBY-6A · Northport, WA · Accident · 2 fatal · Field investigation · Final report · Jul 29, 1985 · N2886D · Destroyed
  > Water bomber acft landed on lake with dump doors partially open during landing phase of water pickup run. Mechanically operated dump door locks were applied before dump doors were closed. Plt controlled dump doors from pilots control wheel, co-pilot operated…
- [NTSB ANC77FA024](https://openairdocs.org/ntsb/ANC77FA024.md): Chase YC122C · Anchorage, AK · Accident · 1 fatal · Closed · Jan 31, 1977 · N5904V · Destroyed
- [NTSB MIA75FKG77](https://openairdocs.org/ntsb/MIA75FKG77.md): N.American B-25H · Dawsonville, GA · Accident · 2 fatal · Closed · Jun 3, 1975 · N96GC · Destroyed
- [NTSB ANC67A0069](https://openairdocs.org/ntsb/ANC67A0069.md): N.American B-25N · Rampart, AK · Accident · 2 fatal · Closed · Jun 27, 1967 · N9937Z · Destroyed
- [NTSB NYC67A0172](https://openairdocs.org/ntsb/NYC67A0172.md): Grumman TBM-3E · Tuckerton, NJ · Accident · 1 fatal · Closed · Jun 2, 1967 · N9595C · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67030'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=67030&fatal=1

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