# NTSB investigations: Turbomeca ASTAZOU series, 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 ERA13LA242](https://openairdocs.org/ntsb/ERA13LA242.md): Sud SA 318C · South Bay, FL · Accident · No injuries · Limited investigation · Final report · May 8, 2013 · N318DB · Substantial damage
  > The pilot’s failure to maintain proper rotor rpm while hovering in sideways flight.
- [NTSB MIA02TA082](https://openairdocs.org/ntsb/MIA02TA082.md): Aerospatiale SA319B Alouette III · Altoona, FL · Accident · Serious injuries · Final report · Apr 9, 2002 · N2UH · Substantial damage
  > The intentional operation of the helicopter with known deficiencies in equipment (inoperative normal brakes), and the pilot's improper use of the cyclic flight controls after the helicopter started rolling following touchdown.
- [NTSB MIA85FA191](https://openairdocs.org/ntsb/MIA85FA191.md): Aerospatiale SA316B · Silver Springs, FL · Accident · No injuries · Field investigation · Final report · Jun 13, 1985 · N49550 · Substantial damage
  > The plt of the helicopter on an on demand air taxi medevac flt encountered deteriorating wx conditions and attmepted to maintain VFR flt in IMC conditions. He descended and struck a tree causing substantial damage. He then made a forced landing and 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."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 ('60020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=60020&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.