# NTSB investigations: Lycoming IO-540 series, IL: Loss of control - on ground/water

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 CHI06CA103](https://openairdocs.org/ntsb/CHI06CA103.md): Piper PA-32-301 · Grayslake, IL · Accident · No injuries · Data collection · Final report · Apr 2, 2006 · N8290X · Substantial damage
  > The pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.
- [NTSB CHI96LA246](https://openairdocs.org/ntsb/CHI96LA246.md): Elliot Steen Skybolt · Belleville, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1996 · N596E · Substantial damage
  > the inadequate weld on the landing gear by the builder/pilot.
- [NTSB CHI85LA085](https://openairdocs.org/ntsb/CHI85LA085.md): Piper PA-32-301 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Jan 10, 1985 · N83187 · Substantial damage
  > The low time pilot with six POB was ld at dark night light saw showers and icy patches on runway during rollout the acft entered a skid with nose cocked to the left the left main gear failed outboard and the acft exited the left side of the rwy the left wing…

## 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.engine_model_code IN ('41530', '41585')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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