# NTSB investigations: Aerospatiale AS350BA, 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 WPR10FA085](https://openairdocs.org/ntsb/WPR10FA085.md): Eurocopter AS350BA (FX2) · Hana, Maui, HI · Accident · Serious injuries · Field investigation · Final report · Dec 16, 2009 · N87EW · Substantial damage
  > An uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…
- [NTSB WPR10FA055](https://openairdocs.org/ntsb/WPR10FA055.md): Aerospatiale AS350BA · Doyle, CA · Accident · 3 fatal · Field investigation · Final report · Nov 14, 2009 · N5793P · Substantial damage
  > The pilot became spatially disoriented while maneuvering on a dark night, which resulted in a loss of helicopter control.

## 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.aircraft_model_code IN ('8680817'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8680817&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.
