NTSB investigations: Turbomeca ARRIEL-1SER, 2007
4 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 per year
| 1989 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 8 |
| 2002 | 11 |
| 2003 | 9 |
| 2004 | 11 |
| 2005 | 7 |
| 2006 | 4 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 8 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 7 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2024 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 2007
AND 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 year(c."eventDate") = 2007
AND 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 ANC08FA025Accident · 4 fatalField investigationFinal reportEurocopter Deutschland BK117C1 · Whittier, AKThe pilot's decision to continue VFR flight into night instrument meteorological conditions. Contributing to the accident were the operator's failure to adhere to an FAA-approved and mandated safety risk management program, the FAA's failure to provide…NTSB LAX07MA231Accident · 4 fatalClass 1 · MajorFinal reportEurocopter AS350-B2 · Phoenix, AZBoth pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…NTSB LAX07IA115Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 BA · Kahului, HIThe loss of tail rotor control due to wear damage to the pitch control input rod that resulted ultimately in the fatigue failure of the upper support yoke arm. Contributing factors were the improper maintenance inspection of the expansion pin assembly and the…NTSB NYC07MA073Accident · 4 fatalMajor investigationFinal reportAerospatiale AS350BA · Princeville, HIThe failure of maintenance personnel to properly tighten (torque) the flight control servo lower attachment clevis, and reinstall a functioning lock washer, which resulted in a flight control disconnect and a complete loss of helicopter control. Contributing…