# NTSB investigations: S N I A S AS350D ASTAR: Loss of control - in flight

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 LAX86LA143](https://openairdocs.org/ntsb/LAX86LA143.md): Aerospatiale AS-350D · Tahoe Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 1986 · N88GT · Destroyed
  > The helicopter collided with trees and crashed in rough mountainous terrain during takeoff. The acft was shuttling skiers from a landing area located at approximately 8,300 ft mls to a ridgeline at 11,000 ft MSL. The plt reported the EGT (T-4) was at 790 deg…
- [NTSB LAX85FA402](https://openairdocs.org/ntsb/LAX85FA402.md): Aerospatiale AS350D · Kula, HI · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1985 · N4268V · Substantial damage
  > The helicopter collided with terrain while on a sightseeing tour. The plt stated that the helicopter lost alt as he attempted to cross power lines. Directional control was lost during the ensuing down wind emergency landing. The helicopter contacted the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680803')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8680803&occurrence=250

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