# NTSB investigations: Rolls-Royce RB-211 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 ENG08IA001](https://openairdocs.org/ntsb/ENG08IA001.md): Boeing 757-225 · Charlotte, NC · Incident · Incident investigation · Final report · Oct 28, 2007 · N919UW · Minor damage
  > The truck beam fracture initiated by fatigue and stress corrosion cracking from pits that were present on the ID surface of the truck beam, under the protective finishes. Crack propagation occurred by alternating modes of stress corrosion cracking and fatigue…
- [NTSB MIA03IA168](https://openairdocs.org/ntsb/MIA03IA168.md): Boeing 757-223 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Aug 24, 2003 · N609AA · Minor damage
  > The failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…
- [NTSB LAX99FA315](https://openairdocs.org/ntsb/LAX99FA315.md): Boeing 757-2S7 · Agua Caliente, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 20, 1999 · N904AW · No damage
  > the systemic failure of the airline's maintenance department to identify and correct the long standing history of intermittent faults, nuisance warnings, and erratic behavior in this airplane's GPWS system. Also causal is the airline's failure to perform the…
- [NTSB LAX97FA276](https://openairdocs.org/ntsb/LAX97FA276.md): Lockheed L-1011-385-1-15 · Honolulu, HI · Accident · Serious injuries · Field investigation · Final report · Aug 8, 1997 · N740DA · Minor damage
  > the cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…

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