# NTSB investigations: Rolls-Royce RB-211-22 series, MO

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 CHI97IA134](https://openairdocs.org/ntsb/CHI97IA134.md): Lockheed L-1011-385-1 · Saint Louis, MO · Incident · No injuries · Incident investigation · Final report · May 15, 1997 · N11003 · Minor damage
  > failure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.
- [NTSB MKC85IA131](https://openairdocs.org/ntsb/MKC85IA131.md): Lockheed L-1011 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jun 11, 1985 · N31013 · Minor damage
  > While on an IFR approach to land at stl and the plt initiated flaps. The no.3 outboard flap vane separated from its mounting and fell to the ground. Upon separation the flap vane struck the leading edge of the trailing edge flap knocking a hole in the skin.…
- [NTSB MKC83IA115](https://openairdocs.org/ntsb/MKC83IA115.md): Lockheed L-1011-385-1 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · May 25, 1983 · N31013 · Minor damage
  > While taxiing to the gate the number 1 engine struck a baggage cart in an area normally occupied by aircraft. The pilotsundivided attention was to the signalman.

## 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" = 'MO' 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 ('54554'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=54554&state=MO

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