# NTSB investigations: Allison 250-C20B: 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 MIA07LA148](https://openairdocs.org/ntsb/MIA07LA148.md): Bell 206B3 · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Sep 5, 2007 · N267MW · Substantial damage
  > The failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…
- [NTSB MIA06LA126](https://openairdocs.org/ntsb/MIA06LA126.md): Fairchild Hiller FH-1100 · Navarre, FL · Accident · No injuries · Limited investigation · Final report · Jun 8, 2006 · N4035G · Substantial damage
  > The inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.

## 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 ('03081')
    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=03081&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.