# NTSB investigations: CFM International CFM56-7B27E series, 2017

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 DCA18IA026](https://openairdocs.org/ntsb/DCA18IA026.md): Boeing 737-932ER · Atlanta, GA · Incident · No injuries · Class 3 · Incident · Final report · Nov 29, 2017 · N852DN · No damage
  > The flight crewmembers’ failure to properly monitor the airplane’s flightpath, which caused the approach to become unstabilized and resulted in the airplane’s descent below the decision altitude while misaligned with the localizer course. Contributing to the…
- [NTSB DCA17CA217](https://openairdocs.org/ntsb/DCA17CA217.md): Boeing 737-8H4 · Sioux City, IA · Accident · Serious injuries · Data collection · Final report · Sep 25, 2017 · N500WR · No damage
  > the flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.
- [NTSB DCA17CA195](https://openairdocs.org/ntsb/DCA17CA195.md): Boeing 737-924ER · Los Angeles, CA · Accident · No injuries · Data collection · Final report · Sep 12, 2017 · N69813 · 2 aircraft · Minor damage
  > the B737 flight crew's misjudgment of the clearance between their wingtip and the B767 horizontal stabilizer.

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

This list as a web page: https://openairdocs.org/ntsb?engine=13078&year=2017

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