NTSB investigations: Turbomeca ARRIUS-2B series
5 cases on aircraft whose registry engine model is Turbomeca ARRIUS-2B series. 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 per year
| 2003 | 2 |
|---|---|
| 2008 | 1 |
| 2012 | 1 |
| 2020 | 1 |
Where
Open the mapLatest cases
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 ('60013'))
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 ('60013'))
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 ANC20LA089Accident · No injuriesClass 3 · LimitedFinal reportEurocopter AS 350 · Fort Greely, AKFailure of the door lock due to interference between the door and a cargo box.NTSB WPR12TA120Accident · No injuriesFinal reportEurocopter AS 350 B3 · Napa, CAThe flight instructor’s improper use of the collective control during a practice hovering autorotation, which resulted in a hard landing.NTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…NTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.NTSB LAX03GA145Accident · No injuriesFinal reportEurocopter France AS350B3 · Napa, CAthe pilot under instruction's inadvertent activation of the collective manual fuel slide lock, which led to engine and main rotor overspeeds due to excessive fuel flow during power application. This resulted in failures of the gas generator turbine (N1)…