# NTSB investigations: Boeing 777-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 CHI08FA050](https://openairdocs.org/ntsb/CHI08FA050.md): Boeing 777-222 · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Dec 14, 2007 · N220UA · Minor damage
  > Emergency evacuation due to dense smoke in the cabin and the possibility of an on-board fire, which resulted in a serious injury to one of the 264 passengers and crew. An additional cause was the failure of an engine bearing, allowing oil to migrate into the…
- [NTSB CHI07FA184](https://openairdocs.org/ntsb/CHI07FA184.md): Boeing 777-222 · Chicago, IL · Accident · No injuries · Field investigation · Final report · Jun 27, 2007 · N213UA · 2 aircraft · Minor damage
  > The 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…
- [NTSB CHI03LA237](https://openairdocs.org/ntsb/CHI03LA237.md): Boeing B777-222 · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2003 · N779UA · No damage
  > The turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.

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

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