# NTSB investigations: GE CF34 series, MI

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 CEN11IA264](https://openairdocs.org/ntsb/CEN11IA264.md): Bombardier CL-600-2B19 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Mar 30, 2011 · N8505Q · No damage
  > The mechanic's incomplete securing of all the wheel well bin's fasteners, which resulted in separation of the bin from the airplane.
- [NTSB DCA07FA037](https://openairdocs.org/ntsb/DCA07FA037.md): Bombardier CL-600-2B19 · Traverse City, MI · Accident · No injuries · Class 1 · Field · Final report · Apr 12, 2007 · N8905F · Substantial damage
  > The pilots' decision to land at Cherry Capital Airport (TVC), Traverse City, Michigan, without performing a landing distance assessment, which was required by company policy because of runway contamination initially reported by TVC ground operations personnel…
- [NTSB CHI07FA107](https://openairdocs.org/ntsb/CHI07FA107.md): Canadair CL-600-2B19 · Lake Michigan, MI · Accident · No injuries · Field investigation · Final report · Apr 8, 2007 · N77181 · Substantial damage
  > In-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…
- [NTSB CHI01IA073](https://openairdocs.org/ntsb/CHI01IA073.md): Canadair CL-600-2B19 · Grand Rapids, MI · Incident · No injuries · Incident investigation · Final report · Jan 25, 2001 · N785CA · Minor damage
  > The uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.
- [NTSB CHI01LA066](https://openairdocs.org/ntsb/CHI01LA066.md): Bombardier CL-600-2B19 · Detroit, MI · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 2001 · N784CA · Substantial damage
  > The vehicle driver's inadvertent failure to place the column shifter into the parking gear. A factor to the accident was the vehicle.

## 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" = 'MI' 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=MI

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