# NTSB investigations: Allison 250 SER 317HP, 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 LAX90LA283](https://openairdocs.org/ntsb/LAX90LA283.md): Bell 206B II · San Francisco, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1990 · N2917W · Destroyed
  > The pilot's failure to maintain directional control of the helicopter. Contributing to the accident was the pilot's decision to operate the helicopter in a flight regime conducive to unanticipated right yaw.
- [NTSB LAX85LA045](https://openairdocs.org/ntsb/LAX85LA045.md): Bell 206B · Inverness, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N2917W · Substantial damage
  > An autorotation was initiated at about 300 ft as eng and rotor RPM began to decrease. Touchdown occurred in soft sand with some forward motion. Full aft cyclic was applied causing the main rotor to contact the tailboom. Exam of the acft fuel system revealed…
- [NTSB LAX83FA287](https://openairdocs.org/ntsb/LAX83FA287.md): Bell 206B · Temecula, CA · Accident · Minor injuries · Field investigation · Final report · Jun 14, 1983 · N5754M · Substantial damage
  > The plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…
- [NTSB LAX79FUQ39](https://openairdocs.org/ntsb/LAX79FUQ39.md): Hiller Acft FH1100 · Oxnard, CA · Accident · No injuries · Closed · Jul 19, 1979 · N5064F · Destroyed

## 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.engine_model_code IN ('03011'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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