NTSB investigations: Turbomeca ARTOUSTEIIIB

7 cases on aircraft whose registry engine model is Turbomeca ARTOUSTEIIIB, where the first occurrence was “Airframe/component/system failure/malfunction”. 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

19822026

NTSB investigations: Turbomeca ARTOUSTEIIIB per year, 1982–2026: 7 cases
1982	2
1987	1
1993	2
2001	1
2002	1

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60003') 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" = 130)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60003')
      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\" = 130))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60003')
    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" = 130))
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 ATL02LA067Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS315B · Hortense, GAFailure of the engine to main transmission drive shaft due to improper installation by company maintenance personnel. A factor were the trees.Mar 28, 2002 · N49525 · Substantial damage NTSB DEN01LA125Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Cody, WYthe failure of the turbine assembly due to an over temperature condition. A contributing factor was the lack of suitable terrain for a forced landing.Jul 17, 2001 · N2128Z · Substantial damage NTSB LAX94LA017Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315 · Beckwourth, CAwas the worn collective servo causing a hydraulic lock and not allowing the pilot to lower the collective. This condition caused the main rotor blades rpm to decay.Oct 18, 1993 · N49511 · Substantial damage NTSB DEN93FA038Accident · 3 fatalField investigationFinal reportAerospatiale SA316B · Aspen, COFailure of the flight control lower mixing unit due to fatigue, which resulted in the loss of control.Apr 1, 1993 · N3153R · Destroyed NTSB SEA87LA092Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315-D Lama · Siletz, ORDuring external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the…May 13, 1987 · N47256 · Destroyed NTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…Apr 15, 1982 · N48089 · Substantial damage NTSB LAX82FA117Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Near Brideport, CAAfter taking off in a mountainous area, the pilot began climbing in up-currents on the side of a canyon. While following a ridge at about 100 ft AGL (11,000 ft MSL), he heard a loud noise that was followed by a shudder and vibrations. The helicopter began…Mar 22, 1982 · N9829C · Destroyed