# NTSB investigations: Turbomeca ARRIEL-1D1, AZ

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR09LA125](https://openairdocs.org/ntsb/WPR09LA125.md): Eurocopter AS 350 B2 · Cave Creek, AZ · Accident · No injuries · Limited investigation · Final report · Feb 23, 2009 · N353P · Substantial damage
  > The pilot's misjudged landing flare. Contributing to the accident was the brownout condition created by the dust cloud that interfered with the pilot's perception of proximity to the ground, and the glare interference from the parked fire vehicles headlights…
- [NTSB LAX07MA231](https://openairdocs.org/ntsb/LAX07MA231.md): Eurocopter AS350-B2 · Phoenix, AZ · Accident · 4 fatal · Class 1 · Major · Final report · Jul 27, 2007 · N613TV · 2 aircraft · Destroyed
  > Both 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('60053'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=60053&state=AZ

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.