# NTSB investigations: Dehav ENG GIPSY MAJOR: Loss of control - in flight

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 IAD01LA061](https://openairdocs.org/ntsb/IAD01LA061.md): Stampe ET Renard SV-4 · Rhinebeck, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2001 · N25SV · Substantial damage
  > The pilot's failure to maintain climb, and his failure to maintain adequate airspeed.
- [NTSB LAX90LA218](https://openairdocs.org/ntsb/LAX90LA218.md): de Havilland DH-82A · Sonoma, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1990 · N7966 · Destroyed
  > The pilot failed to maintain airspeed causing the airplane to inadvertently enter into a stall/mush condition.
- [NTSB SEA85LA128](https://openairdocs.org/ntsb/SEA85LA128.md): de Havilland DH 82A Tiger Moth · Orland, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1985 · N99108 · Destroyed
  > The plt reported that during a loop, the eng lost power, then the acft entered an inverted spin. He said that he had gotten out of the inverted spin & was recovering from a regular spin when the acft struck the ground. According to a witness, the plt entered…
- [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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('20004')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=20004&occurrence=250

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