# Final NTSB investigations: BMW Rolls BR-700 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 DCA23FA339](https://openairdocs.org/ntsb/DCA23FA339.md): Boeing 717-200 · Charlotte, NC · Accident · No injuries · Class 3 · Field · Final report · Jun 28, 2023 · N955AT · Substantial damage
  > A fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.
- [NTSB DCA22LA191](https://openairdocs.org/ntsb/DCA22LA191.md): Boeing 717-200 · Detroit, MI · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 29, 2022 · N946AT · No damage
  > An encounter with moderate turbulence during descent.
- [NTSB DCA17CA096](https://openairdocs.org/ntsb/DCA17CA096.md): Boeing 717 200 · Hopewell, VA · Accident · Serious injuries · Data collection · Final report · Nov 21, 2016 · N930AT · No damage
  > the flight attendant's inadvertent bump into a retractable galley tray.
- [NTSB ERA10LA041](https://openairdocs.org/ntsb/ERA10LA041.md): Boeing 717-200 · Pleasant Grove, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2009 · N935AT · No damage
  > The captain's excessive maneuver in response to a traffic alert and collision avoidance system (TCAS) alert, which resulted in a serious injury to a flight attendant. Contributing to the accident was the operator's inadequate TCAS training and guidance.
- [NTSB ATL07LA016](https://openairdocs.org/ntsb/ATL07LA016.md): Boeing 717-200 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Nov 11, 2006 · N956AT · Substantial damage
  > The captain's inadequate visual look out during taxi.
- [NTSB NYC03FA067](https://openairdocs.org/ntsb/NYC03FA067.md): Boeing 717-200 · Flushing, NY · Accident · Serious injuries · Field investigation · Final report · Mar 27, 2003 · N957AT · Minor damage
  > A failure of the left power control distribution unit (PCDU).

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09500'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=09500&status=final

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