# NTSB investigations: Rolls-Royce RB-211 series, 2007

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 MIA07CA119](https://openairdocs.org/ntsb/MIA07CA119.md): Boeing 777-232 · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · Jul 12, 2007 · N865DA · No damage
  > The flight attendant's inadvertent misstep on a ladder and falling during pushback resulting in serious injuries.
- [NTSB DCA07WA041](https://openairdocs.org/ntsb/DCA07WA041.md): Boeing 777-200ER · Tel Aviv, Israel · Incident · No injuries · Foreign investigation · May 12, 2007 · N863DA · Minor damage
- [NTSB CHI07LA078](https://openairdocs.org/ntsb/CHI07LA078.md): Boeing 777 · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2007 · N779AN · No damage
  > An in-flight encounter with turbulence during cruise flight.

## 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 year(c."eventDate") = 2007
  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&year=2007

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