NTSB investigations: Turbomeca ARRIEL-2B1, 2017
5 cases on aircraft whose registry engine model is Turbomeca ARRIEL-2B1. 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 | 1 |
|---|---|
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 5 |
| 2008 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60056'))
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 year(c."eventDate") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60056'))
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 GAA18CA070Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Santa Rosa, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ANC17CA041Accident · No injuriesData collectionFinal reportAirbus AS350 · Delta Junction, AKThe pilot’s failure to maintain clearance from a steel frame attached to a tracked drilling unit. Contributing to the accident was the pilot’s failure to visually identify the steel frame during the reconnaissance process.NTSB WPR17LA133Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVA loss of engine power due to the failure of the manufacturer to reinstall the oil filter after it was removed for inspection, which led to coke pollution that obstructed the oil jet and resulted in the subsequent oil starvation of the axial compressor rear…NTSB GAA17CA344Accident · No injuriesData collectionFinal reportEurocopter EC130 · Peach Springs, AZThe ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.NTSB GAA17CA167Accident · No injuriesData collectionFinal reportEurocopter EC130 · Las Vegas, NVThe pilot's abrupt cyclic/pitch attitude control movement, which resulted in a Fenestron ground strike.