# NTSB investigations: Aerospatiale AS 355 F ECUREUIL, LA

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 FTW84LA265](https://openairdocs.org/ntsb/FTW84LA265.md): Aerospatiale AS 355 F Ecureuil · Venice, LA · Accident · No injuries · Limited investigation · Final report · May 30, 1984 · N5777J · Substantial damage
  > The plt landed to secure a seat belt flapping on the outside of the fuselage. The area chosen for landing was soft and the acft began to settle into the mud. The plt initiated takeoff and when the acft freed itself from the mud it started spinning. The plt…
- [NTSB FTW84FA107](https://openairdocs.org/ntsb/FTW84FA107.md): Aerospatiale AS-355F · Morgan City, LA · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1984 · N5792X · Destroyed
  > The plts in a helicopter encountered foggy weather during a positioning flt and crashed into a lake about 4 mi from the departure point, a fisherman who witnessed the accident said the acft descended into the water in a nose low attitude. The acft skipped and…

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

This list as a web page: https://openairdocs.org/ntsb?model=8680806&state=LA

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