# NTSB investigations, IL: Nose gear collapsed

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 CHI93IA110](https://openairdocs.org/ntsb/CHI93IA110.md): Fokker 100 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 13, 1993 · N895US · Minor damage
  > Failure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…
- [NTSB CHI88LA196](https://openairdocs.org/ntsb/CHI88LA196.md): Cessna 320E · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N222L · Substantial damage
  > Drg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…
- [NTSB CHI85LA270](https://openairdocs.org/ntsb/CHI85LA270.md): Cessna 310D · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N1729K · Substantial damage
  > The acft was landing at dest arpt after a two hr xcountry flt. At gear ext no green light. Pilot recycled gear but still no light. Emergency ext used and three green indicated. On ld roll nose gear collapsed. Uplock arm tube was broken on the nose gear.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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