# Major NTSB investigations: Rolls-Royce RB-211 series

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 DCA23LA125](https://openairdocs.org/ntsb/DCA23LA125.md): Boeing 737-900ER · Queens, NY · Incident · No injuries · Class 1 · Limited · Final report · Jan 14, 2023 · N914DU · 2 aircraft · No damage
  > The American Airlines flight 106 (AAL106) crew’s surface navigation error due to distractions caused by their performance of concurrent operational tasks during taxi, which resulted in a loss of situational awareness. Contributing to the incident was the air…
- [NTSB DCA11IA015](https://openairdocs.org/ntsb/DCA11IA015.md): Boeing 757-223 · Jackson Hole, WY · Incident · No injuries · Class 1 · Incident · Final report · Dec 29, 2010 · N668AA · No damage
  > a manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…
- [NTSB DCA04MA061](https://openairdocs.org/ntsb/DCA04MA061.md): Boeing 777 · Miami, FL · Accident · Serious injuries · Major investigation · Final report · Jul 25, 2004 · N797AN · No damage
  > the in-flight encounter with unforecasted clear air turbulence.
- [NTSB DCA01MA064](https://openairdocs.org/ntsb/DCA01MA064.md): Boeing 757-200 · Arlington, VA · Accident · 64 fatal · Major investigation · Final report · Sep 11, 2001 · N644AA · Destroyed
  > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54555'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=54555&major=1

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