# NTSB investigations: S N I A S AS350D ASTAR: In flight collision with object

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 LAX94FA100](https://openairdocs.org/ntsb/LAX94FA100.md): Aerospatiale AS-350D · Lebec, CA · Accident · 2 fatal · Field investigation · Final report · Jan 20, 1994 · N5795X · Destroyed
  > The pilot-in-command's inadequate in-flight planning and inadequate visual lookout. Factors in the accident were mountainous terrain which masked the presence of the wires and the pilot-in-command's lack of familiarity with the geographic area.
- [NTSB FTW90LA143](https://openairdocs.org/ntsb/FTW90LA143.md): Aerospatiale AS-350D · Berwick, LA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1990 · N3598F · Substantial damage
  > Pilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.
- [NTSB FTW85FA300](https://openairdocs.org/ntsb/FTW85FA300.md): S.N.I.A.S. AS350D Astar · Houma, LA · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1985 · N3607C · Destroyed
  > The plt landed at a microwave antenna tower and did not shut down the eng or deplane. An employee at the tower retrievedcargo from the helicopter (a small box of parts) and went back inside the tower building. Shortly thereafter, the plt apparently initiated…
- [NTSB DEN82IA150](https://openairdocs.org/ntsb/DEN82IA150.md): Aerospatiale 350D · Near Winter Par, CO · Incident · No injuries · Incident investigation · Final report · Jul 31, 1982 · N49556 · Minor damage
  > Witnesses who were aboard the aircraft stated that the aircrafts rotor struck a tree during a "straffing run" on a railroad trestle just below the Continental divide. The pilot stated that the engine flamed out as he passed over the trestle. The aircraft was…

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

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

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