# NTSB investigations: Allison 250-C30 series: Airframe/component/system failure/malfunction

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 FTW00LA137](https://openairdocs.org/ntsb/FTW00LA137.md): Bell 206L3 · Salt Marsh · Accident · No injuries · Limited investigation · Final report · Apr 29, 2000 · N17237 · Substantial damage
  > The company mechanic's failure to replace the bolt's cotter key properly and the subsequent loss of the nut, which then resulted in the tail rotor control disconnection and the pilot's inability to maintain aircraft control.
- [NTSB CHI97FA149](https://openairdocs.org/ntsb/CHI97FA149.md): Bell 206L3 · Boise, ID · Accident · No injuries · Field investigation · Final report · May 27, 1997 · N35CH · Substantial damage
  > the improper torque meter installation by maintenance personnel, attempting flight with known discrepancies by the pilot-in-command and the check airman, and an improper autorotation by the pilot-in-command with improper oversight of the autorotation maneuver…
- [NTSB LAX83LA117](https://openairdocs.org/ntsb/LAX83LA117.md): Bell BH 206-L111 · Peach Springs, AZ · Accident · No injuries · Limited investigation · Final report · Feb 24, 1983 · N3898Y · Substantial damage
  > After the rotorcraft took off to a hover the pilot did a pedal turn for a down canyon departure. After the hover turn the pilot slid to the right to clear some obstacles and when the rotorcraft moved laterally about 25 feet the pilot heard a bang. The left…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=03015&occurrence=130

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