# NTSB investigations: Boeing 727-23, 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 CHI85IA212](https://openairdocs.org/ntsb/CHI85IA212.md): Boeing 727-023 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 28, 1985 · N1984 · Minor damage
  > American airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all…
- [NTSB CHI83IA418](https://openairdocs.org/ntsb/CHI83IA418.md): Boeing 727-200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 7, 1983 · N1984 · Minor damage
  > The acft experienced a left walking beam failure when the landing gear was extended during approach, the acft log was noted 'during gear extension at 230 KTS tremendous bang occurred which dropped panels at rows 15-7 02 masks at row 18. Three green normal…

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

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