NTSB investigations: Dehav ENG GIPSY MAJOR, CA

6 cases on aircraft whose registry engine model is Dehav ENG GIPSY MAJOR. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

NTSB investigations: Dehav ENG GIPSY MAJOR, CA per year, 1971–2026: 6 cases
1971	1
1973	1
1980	1
1985	1
1990	2

Where

Open the map

Latest cases

Query with 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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

duckdb -csv -c "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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX90LA299Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Petaluma, CAThe pilot's failure to maintain directional control.Aug 24, 1990 · N82KF · Substantial damage NTSB LAX90LA218Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Sonoma, CAThe pilot failed to maintain airspeed causing the airplane to inadvertently enter into a stall/mush condition.Jun 29, 1990 · N7966 · Destroyed NTSB SEA85LA128Accident · Serious injuriesLimited investigationFinal reportde Havilland DH 82A Tiger Moth · Orland, CAThe 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…Jun 5, 1985 · N99108 · Destroyed NTSB LAX80FA137Accident · 2 fatalClosedDehavilland DH82A · Oak View, CAAug 31, 1980 · N87677 · Destroyed NTSB LAX73DUQ04Accident · No injuriesClosedDehavilland DH82A · Santa Susan, CAJul 29, 1973 · N522R · Substantial damage NTSB LAX72DUQ49Accident · Minor injuriesClosedDehavilland DH 82A · Santa Paula, CASep 6, 1971 · N5444 · Substantial damage