# NTSB investigations: Aerospatiale SA316B ALOUETTE III, CA

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 LAX98TA278](https://openairdocs.org/ntsb/LAX98TA278.md): Aerospatiale SA316B · Porterville, CA · Accident · No injuries · Final report · Aug 27, 1998 · N605RA · Substantial damage
  > The pilot's failure to maintain adequate in-flight clearance between the bucket and trees resulting in the entanglement/separation of the long line and subsequent impact with and separation of the tail rotor assembly. A factor was the trees.
- [NTSB LAX92FA054](https://openairdocs.org/ntsb/LAX92FA054.md): Aerospatiale SA 316B · Bridgeport, CA · Accident · 4 fatal · Field investigation · Final report · Nov 28, 1991 · N146RM · Destroyed
  > Failure of the helicopter's tail rotor drive shaft and drive shaft bearing due to undetermined reason(s).
- [NTSB LAX85FA126](https://openairdocs.org/ntsb/LAX85FA126.md): Aerospatiale SA316B · Galt, CA · Accident · Serious injuries · Field investigation · Final report · Jan 30, 1985 · N67081 · Substantial damage
  > While in cruise the plt lost tail rotor control and elected to execute an emergency landing in an open field. The tail rotor gearbox was found 45 ft from the main wreckage. The tail rotor guard was found 60 ft from the main wreckage. It did not exhibit any…
- [NTSB LAX81DVA22](https://openairdocs.org/ntsb/LAX81DVA22.md): Aerospatle S316B · Dinky Creek, CA · Accident · Minor injuries · Closed · Feb 13, 1981 · N48184 · Substantial damage

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

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

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