NTSB investigations: Turbomeca ARRIEL-1SER
113 cases on aircraft whose registry engine model is Turbomeca ARRIEL-1SER. 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.
Cases, newest first
Query with SQL
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 ('60030'))
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 ('60030'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ANC99LA140Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.NTSB ANC99FA139Accident · Serious injuriesField investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's continued flight into instrument meteorological conditions (IMC), and inadequate altitude/clearance. Factors associated with the accident were flat light and whiteout conditions, snow, and snow-covered terrain. An additional factor was the FAA's…NTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.NTSB ANC99LA036Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Girdwood, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.NTSB ANC98FA061Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-B2 · Juneau, AKThe failure of both command pilots to maintain an adequate lookout to see and avoid each other's aircraft. Factors associated with the accident were the pilot's failure to follow published advisory procedures to monitor/issue position reports on the…NTSB ANC98LA032Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350B · Soldotna, AKThe pilot's inadvertent dynamic rollover while performing a slope landing. Factors associated with the accident are the presence of rough and uneven terrain, and the pilot's improper slope landing technique.NTSB ANC95LA062Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B2 · Skagway, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were the uneven and icy terrain.NTSB FTW94FA224Accident · 2 fatalField investigationFinal reportAerospatiale AS 350B-2 · Granite, COFailure of the pilot to assure main rotor clearance from sloping terrain while in a hover. The terrain condition was a related factor.NTSB LAX94LA134Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350-B · Humuula, HIThe pilot's poor in-flight decision by failing to attain the best rate of climb speed and exceeding the helicopter's hover performance capability. The clouds and downdraft were factors in this accident.NTSB CHI93FA182Accident · 2 fatalField investigationFinal reportAerospatiale AS-350B · Cameron, MOThe loss of engine power due to failure of the second stage turbine labyrinth seal. Factors related to the accident were: the unfavorable wind and tall trees bordering the emergency landing area.NTSB LAX91LA339Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Kahului, HIA non-mechanical loss of engine power due to fuel exhaustion and subsequent hard landing by the pilot. Contributing to the accident was a malfunctioning fuel low level indication system.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB FTW90LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B · Grand Prairie, TXManufacturer's failure to property install the left side components of the dual control system following its removal for additional completion work prior to delivery of the aircraft. Contributing to the accident was the failure of quality control personnel to…