# NTSB investigations: Turbomeca ARRIEL-1SER, FL

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 MIA06FA022](https://openairdocs.org/ntsb/MIA06FA022.md): Aerospatiale AS350B · Homestead, FL · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2005 · N264BH · 2 aircraft · Substantial damage
  > The failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…
- [NTSB MIA02FA161](https://openairdocs.org/ntsb/MIA02FA161.md): Sikorsky S76A+ · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Aug 31, 2002 · N15460 · Substantial damage
  > The flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…

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

This list as a web page: https://openairdocs.org/ntsb?engine=60030&state=FL

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