# NTSB investigations: Lycoming 0-235 series, SC: 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 ATL95LA104](https://openairdocs.org/ntsb/ATL95LA104.md): American AA-1 · Rock Hill, SC · Accident · No injuries · Limited investigation · Final report · Jun 1, 1995 · N6214L · Substantial damage
  > An inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.
- [NTSB ATL94LA040](https://openairdocs.org/ntsb/ATL94LA040.md): Cessna 152 · Pelion, SC · Accident · No injuries · Limited investigation · Final report · Jan 16, 1994 · N69046 · Substantial damage
  > Inadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.
- [NTSB ATL88LA176](https://openairdocs.org/ntsb/ATL88LA176.md): Cessna 152 · Florence, SC · Accident · No injuries · Limited investigation · Final report · May 18, 1988 · N757VH · Substantial damage
  > The accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…
- [NTSB ATL88LA023](https://openairdocs.org/ntsb/ATL88LA023.md): Cessna 152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Oct 21, 1987 · N94126 · Substantial damage
  > The student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with 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" = 'SC' 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 ('41505')
    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=41505&occurrence=260&state=SC

---
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.