# NTSB investigations: Boeing 737-222, 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 CHI99LA145](https://openairdocs.org/ntsb/CHI99LA145.md): Boeing 737-222 · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · May 6, 1999 · N208AU · No damage
  > the flight attendants did not follow the cockpit crews instructions to be seated because of expected turbulence. A factor associated with the accident was the turbulence encountered.
- [NTSB CHI97IA117](https://openairdocs.org/ntsb/CHI97IA117.md): Boeing 737-200 · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Apr 28, 1997 · N9063U · Minor damage
  > inadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…
- [NTSB CHI86FA119](https://openairdocs.org/ntsb/CHI86FA119.md): Boeing 737-222 · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Apr 8, 1986 · N9054U · Substantial damage
  > The left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and…
- [NTSB DCA73A0003](https://openairdocs.org/ntsb/DCA73A0003.md): Boeing 737 · Chicago, IL · Accident · 43 fatal · Closed · Dec 8, 1972 · N9031U · Destroyed

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

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