# NTSB investigations, IL: Training

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 CEN18FA259](https://openairdocs.org/ntsb/CEN18FA259.md): Eurocopter Deutschland EC135 P1 · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Jul 8, 2018 · N312SA · Substantial damage
  > The pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…
- [NTSB DCA18CA001](https://openairdocs.org/ntsb/DCA18CA001.md): Boeing 737 7H4 · Chicago, IL · Accident · No injuries · Data collection · Final report · Oct 2, 2017 · N930WN · Substantial damage
  > the mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.
- [NTSB DCA17FA021](https://openairdocs.org/ntsb/DCA17FA021.md): Boeing 767 · Chicago, IL · Accident · Serious injuries · Class 1 · Field · Final report · Oct 28, 2016 · N345AN · Substantial damage
  > The failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…

## 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" = 'IL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040310'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/040310/cases?state=IL

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