OpenAirDocs.org

NTSB investigations: Turbomeca ARRIEL-1SER

9 cases on aircraft whose registry engine model is Turbomeca ARRIEL-1SER, where the first occurrence was “In flight collision with object”. 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

20012026

Where

Open the map

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60030')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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.

NTSB ANC06LA100Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350B2 · Skagway, AKThe pilot's failure to maintain adequate clearance from trees while hovering, which resulted in a main rotor strike with trees, an uncontrolled descent, and a collision with terrain.Jul 27, 2006 · N301TH · Substantial damageNTSB ANC06LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Haines, AKThe pilot's failure to maintain adequate clearance from an object while landing a helicopter at a remote site, which resulted in the main rotor blades striking a tree.Apr 6, 2006 · N209CH · Substantial damageNTSB ATL06CA026Accident · Serious injuriesData collectionFinal reportEurocopter France AS-350-B2 · Jasper, ALThe pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.Dec 22, 2005 · N350ET · Substantial damageNTSB DEN04LA033Accident · No injuriesLimited investigationFinal reportAerospatiale AS 365 N-2 · Santa Fe, NMthe pilot's failure to maintain lateral clearance from the hangar. A contributing factor was the gusty crosswind.Dec 27, 2003 · N291LL · DestroyedNTSB FTW03LA178Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Ship Shoal 80The pilot's failure to maintain clearance with the safety fence while landing on an off-shore helipad.Jul 7, 2003 · N147BH · Substantial damageNTSB LAX03LA027Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350B · Kingman, AZthe pilot's inadequate visual lookout and failure to maintain adequate clearance from transmission wires while performing low altitude operations.Nov 10, 2002 · N909WA · Substantial damageNTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…Aug 31, 2002 · N15460 · Substantial damageNTSB MIA02LA040Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Swanee, GAThe pilot's improper visual lookout while hovering the helicopter, which resulted in the helicopter's main rotor blades colliding with a light post.Nov 16, 2001 · N6101U · Substantial damageNTSB LAX01LA304Accident · 1 fatalLimited investigationFinal reportAerospatiale AS350BA · Chico, CAthe pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…Sep 23, 2001 · N911NT · Destroyed