# NTSB investigations: Eurocopter AS 350 B3, 2002

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 LAX02TA299](https://openairdocs.org/ntsb/LAX02TA299.md): Eurocopter AS350-B3 · Bishop, CA · Accident · No injuries · Final report · Sep 29, 2002 · N352SA · Substantial damage
  > the disengagement of the collective locking mechanism due to component wear.
- [NTSB FTW02LA247](https://openairdocs.org/ntsb/FTW02LA247.md): Eurocopter AS350B3 · Eagle Pass, TX · Accident · No injuries · Limited investigation · Final report · Sep 2, 2002 · N747R · Substantial damage
  > The insufficient length of the stepper motor rack inside the HMU, which caused the red "GOV" light to illuminate and the fuel metering valve to freeze causing the engine to automatically engage the manual mode.

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

This list as a web page: https://openairdocs.org/ntsb?model=8680954&year=2002

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