# NTSB investigations: Airbus A320-232, IL

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 DCA26LA047](https://openairdocs.org/ntsb/DCA26LA047.md): Embraer S A ERJ 170-200 LR · Chicago, IL · Accident · No injuries · Class 4 · Limited · Final report · Nov 29, 2025 · N317TB · 2 aircraft · Substantial damage
  > United Airlines flight crew’s failure to maintain adequate clearance from the parked Envoy Airlines airplane while taxiing in winter weather conditions.
- [NTSB OPS06IA007](https://openairdocs.org/ntsb/OPS06IA007.md): Boeing 737-300 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 23, 2006 · N309UA · 2 aircraft · No damage
  > The probable cause of this incident was the ORD tower local controller's failure to provide sufficient separation between two aircraft departing intersecting runways. Contributing to the incident was the ORD local monitor's failure to monitor the situating…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940004', '3940304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3940004&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.