# NTSB investigations: Turbomeca ARRIUS-2F, CA

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 WPR23LA068](https://openairdocs.org/ntsb/WPR23LA068.md): Eurocopter EC120B · Rancho Cordova, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 11, 2022 · N255SD · Substantial damage
  > The pilot receiving instruction’s loss of helicopter control during landing with a crosswind, and the flight instructor’s delayed remedial action.
- [NTSB LAX05GA231](https://openairdocs.org/ntsb/LAX05GA231.md): Eurocopter France EC120B · Fair Oaks, CA · Accident · 2 fatal · Final report · Jul 14, 2005 · N266SD · Destroyed
  > The failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…

## 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" = 'CA' 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 ('60010'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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