# Fatal NTSB investigations: Dehav ENG GIPSY MAJOR

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 SEA90LA054](https://openairdocs.org/ntsb/SEA90LA054.md): de Havilland DH 82A · White City, OR · Accident · 1 fatal · Limited investigation · Final report · Mar 20, 1990 · N353FG · Substantial damage
  > Pilot's delay in taking remedial action to prevent an undershoot. His misjudgement of distance and altitude on final approach were related factors.
- [NTSB BFO85FA004](https://openairdocs.org/ntsb/BFO85FA004.md): de Havilland DH 82 Tiger Moth · Keyser'S Ridge, MD · Accident · 2 fatal · Field investigation · Final report · Oct 29, 1984 · N172VF · Destroyed
  > The flt was the final leg of a flt from winchester, VA that had been discontinued the day before due to adverse weather conditions. Two weather briefings were obtained on the day of the accident, both of which included the statement that VFR flight was not…
- [NTSB FTW84FA218](https://openairdocs.org/ntsb/FTW84FA218.md): de Havilland Tiger Moth DH 82A · San Antonio, TX · Accident · 2 fatal · Field investigation · Final report · May 3, 1984 · N82DS · Destroyed
  > The acft crashed in an open pasture with trees on the western perimeter. The acft attitude at impact was nose down at a 30 to 50 degree angle in a right spiral. The main fuel tank mounted on the top wing over and behind the engine broke from its mount on…
- [NTSB LAX80FA137](https://openairdocs.org/ntsb/LAX80FA137.md): Dehavilland DH82A · Oak View, CA · Accident · 2 fatal · Closed · Aug 31, 1980 · N87677 · Destroyed
- [NTSB FTW73AF004](https://openairdocs.org/ntsb/FTW73AF004.md): Dehavilland DH82A · Jenks, OK · Accident · 1 fatal · Closed · Jul 23, 1972 · N3549 · Destroyed
- [NTSB CHI67A0001](https://openairdocs.org/ntsb/CHI67A0001.md): Dehavilland DHC-1B · La Porte, IN · Accident · 2 fatal · Closed · Jul 1, 1966 · N1147 · 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 ('20004'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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