Fatal NTSB investigations: Turbomeca ARRIEL-1SER, AZ
5 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
| 2001 | 1 |
|---|---|
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2012 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…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 LAX05FA053Accident · 1 fatalField investigationFinal reportEurocopter AS-350-B3 · Apache Junction, AZA loss of control during the final approach to land for undetermined reasons.NTSB LAX03MA292Accident · 7 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · GrandCanyonWest, AZThe pilot's disregard of safe flying procedures and misjudgment of the helicopter's proximity to terrain, which resulted in an in-flight collision with a canyon wall. Contributing to the accident was the failure of Sundance Helicopters and the Federal…NTSB LAX01MA272Accident · 6 fatalMajor investigationFinal reportEurocopter AS350-B2 · Meadview, AZThe pilot’s loss of control of the helicopter for undetermined reasons.