# NTSB investigations: GE CF34 series, OH

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 DCA23LA005](https://openairdocs.org/ntsb/DCA23LA005.md): Bombardier CL-600-2B19 · Dayton, OH · Incident · No injuries · Class 3 · Limited · Final report · Oct 5, 2022 · N447AW · Minor damage
  > The airplane’s right turn, which developed during the landing rollout and persisted until the airplane came to rest, for reasons that could not be determined based on the available evidence. Contributing to the incident was the pilot’s reliance primarily on…
- [NTSB ENG21LA023](https://openairdocs.org/ntsb/ENG21LA023.md): Bombardier CL-600-2C10 · North Canton, OH · Incident · Class 3 · Limited · Final report · Mar 26, 2021 · N709PS · Minor damage
  > Moisture ingression thru the window humpseal coming into contact with the terminal block braid wires.
- [NTSB DCA16CA208](https://openairdocs.org/ntsb/DCA16CA208.md): Embraer ERJ 170 100 SE · Cleveland, OH · Accident · Serious injuries · Data collection · Final report · Jul 26, 2016 · N655RW · No damage
  > an inadvertent encounter with turbulence.
- [NTSB DCA07MA072](https://openairdocs.org/ntsb/DCA07MA072.md): Embraer ERJ-170 · Cleveland, OH · Accident · No injuries · Class 1 · Major · Final report · Feb 18, 2007 · N862RW · Substantial damage
  > the failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…

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

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

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