# NTSB investigations: Turbomeca ARRIEL-1D1, 2009

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 ERA09LA378](https://openairdocs.org/ntsb/ERA09LA378.md): Eurocopter AS 350 B2 · Loris, SC · Accident · No injuries · Limited investigation · Final report · Jul 3, 2009 · N53963 · Substantial damage
  > The crew's failure to see and avoid a steel pole during a nighttime approach to the helipad.
- [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…

## 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 year(c."eventDate") = 2009
  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&year=2009

---
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.
