NTSB investigations: Turbomeca ARRIEL-2B1, 2010
3 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\") = 2010
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") = 2010
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 WPR10LA481Accident · No injuriesLimited investigationFinal reportEurocopter EC130 · Meadview, AZThe pilot's distraction with another departing helicopter while maneuvering in a hover for departure, which resulted in his failure to maintain clearance between the tail rotor and an umbrella.NTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…NTSB WPR10CA164Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Parker, AZThe mechanics' failure to account for all the tools following a maintenance procedure and the pilot's failure to perform a preflight check before a maintenance test flight.