# Fatal NTSB investigations: Wright C9HD series

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 MKC86FA179](https://openairdocs.org/ntsb/MKC86FA179.md): Lockheed 18-56 (Howard 250) · Texarkana, AR · Accident · 2 fatal · Field investigation · Final report · Aug 28, 1986 · N252K · Destroyed
  > While apchg for a lndg, the acft pitched up, rolled inverted & impacted the terrain to the left of the rwy. No preimpactpart failure/malfunction was fnd; however, an inv revealed the acft had been loaded with the center-of-gravity (CG) wellbehind the aft…
- [NTSB NYC84FA110](https://openairdocs.org/ntsb/NYC84FA110.md): Lockheed 18-56 · Oneonta, NY · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1984 · N77777 · Destroyed
  > At aprx 2330 EST, witnesses near the crash site heard an acft, & shortly thereafter, they saw a flash. One of them, who was driving a car, went back to the area the next day & found the acft wreckage. The acft had crashed & burned about 1 mi from the apch end…
- [NTSB ATL83FA237](https://openairdocs.org/ntsb/ATL83FA237.md): Lockheed L-18 · Millhaven, GA · Accident · 2 fatal · Field investigation · Final report · Jun 23, 1983 · N333FB · Destroyed
  > The acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around…
- [NTSB ATL83FA021](https://openairdocs.org/ntsb/ATL83FA021.md): Lockheed 18 · Kosciusko, MS · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1982 · N1040G · Destroyed
  > The acft was observed without lights making repeated low altitude passes over a pipeline right-of-way at night. The acftwas equipped with an internal aux fuel tank, non-standard internal plumbing, a large lever-operated petroleum products pump, an inflatable…
- [NTSB LAX67A0095](https://openairdocs.org/ntsb/LAX67A0095.md): Lockheed 18 · Aguila, AZ · Accident · 2 fatal · Closed · Apr 11, 1967 · N699C · 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 ('67028'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=67028&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.