# NTSB investigations, IL: Oversight

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 CEN23LA111](https://openairdocs.org/ntsb/CEN23LA111.md): Cessna 172K · Moline, IL · Accident · No injuries · Class 4 · Limited · Final report · Feb 19, 2023 · N84688 · Substantial damage
  > The student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.
- [NTSB CEN11IA369](https://openairdocs.org/ntsb/CEN11IA369.md): Embraer EMB-145 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 3, 2011 · N607AE · No damage
  > The overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…
- [NTSB OPS10IA155](https://openairdocs.org/ntsb/OPS10IA155.md): Embraer EMB-135KL · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Apr 22, 2010 · N806AE · 2 aircraft · No damage
  > The air traffic controller's issuance of an improper takeoff clearance to the pilot of the Embraer. Contributing to the incident was the instructor’s inadequate monitoring of the trainee local controller.
- [NTSB CEN10LA142](https://openairdocs.org/ntsb/CEN10LA142.md): Bombardier BD-100-1A10 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Feb 24, 2010 · N515FX · Substantial damage
  > The deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.

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

This list as a web page: https://openairdocs.org/ntsb-findings/040320/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.