# NTSB investigations, IL: Complete 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 CHI86FA235](https://openairdocs.org/ntsb/CHI86FA235.md): Fairchild SA-266TC · Galesburg, IL · Accident · No injuries · Field investigation · Final report · Sep 25, 1986 · N327BA · Substantial damage
  > All landing gear on the aircraft prematurely retracted during takoff rotation. The captain aborted the takeoff and the aircraft slid to a stop on the runway. Subsequent gear retraction tests revealed no mechanical malfunctions within the landing gear system.…
- [NTSB CHI83LA182](https://openairdocs.org/ntsb/CHI83LA182.md): Piper PA-24 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N9254P · Substantial damage
  > The acft was landed with the gear up. Investigation revealed during a retraction test, that no malfunction of the landing gear system prevented normal operation. Electrical system showed that the warning the horn did not operate. When the cockpit was checked…
- [NTSB CHI82DA250](https://openairdocs.org/ntsb/CHI82DA250.md): Piper PA-30-160 · Salem, IL · Accident · No injuries · Final report · Jul 15, 1982 · N7047Y · Substantial damage
  > Pilot stated he had 3 green gear lights. During touchdown and roll the landing gear collapsed. The landing gear control switch collar was defective and if the pilot did not hold the gear selector in the down position it may have returned to off before the…

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

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