# NTSB investigations: Lycoming I0360 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 CHI03LA102](https://openairdocs.org/ntsb/CHI03LA102.md): Cessna 172S · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Apr 11, 2003 · N389SP · Substantial damage
  > The flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…
- [NTSB CHI95LA039](https://openairdocs.org/ntsb/CHI95LA039.md): Piper PA-28R-200 · Rochelle, IL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1994 · N32196 · Substantial damage
  > the student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.
- [NTSB CHI94LA088](https://openairdocs.org/ntsb/CHI94LA088.md): Piper PA-28R-200 · Sandwich, IL · Accident · No injuries · Limited investigation · Final report · Feb 14, 1994 · N76SA · Substantial damage
  > the private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.
- [NTSB CHI83LA194](https://openairdocs.org/ntsb/CHI83LA194.md): Mooney M20E · Springfield, IL · Accident · No injuries · Limited investigation · Final report · May 2, 1983 · N7430V · Substantial damage
  > The acft ran off the left side of the rwy and collided with the VASI after landing. The plt stated he landed on rwy 22 when approach said the wind favored that rwy. He said that 'just as the wheels touched down a gust of wind pushed the nose to the left and…

## 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 ('41515')
    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=41515&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.