# NTSB investigations: Allison 250-C28 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 NYC01LA088](https://openairdocs.org/ntsb/NYC01LA088.md): Bell 206 L-1 · Seneca Falls, NY · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2001 · N2138Y · Substantial damage
  > the loss of a bolt in a Thomas coupling on the tail rotor drive shaft, for undetermined reasons, during climb, while operating over unsuitable terrain.
- [NTSB FTW87LA195](https://openairdocs.org/ntsb/FTW87LA195.md): Bell 206L-1 · New Iberia, LA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1987 · N2764F · Substantial damage
  > Crew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…
- [NTSB FTW82DA144](https://openairdocs.org/ntsb/FTW82DA144.md): Bell 206L-1 · Cameron, LA · Accident · No injuries · Final report · Apr 22, 1982 · N2138Y · Substantial damage
  > N2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.…

## 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 ('03022', '03021')
    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=03022&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.