# NTSB investigations: Lycoming 0-235 series, SC: On ground/water collision with object

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 MIA98LA077](https://openairdocs.org/ntsb/MIA98LA077.md): Cessna 152 · Georgetown, SC · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1998 · N25952 · Destroyed
  > the pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…
- [NTSB ATL95LA148](https://openairdocs.org/ntsb/ATL95LA148.md): Piper PA-12 · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 26, 1995 · N3036M · Substantial damage
  > The improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.
- [NTSB ATL88IA144](https://openairdocs.org/ntsb/ATL88IA144.md): Cessna 152 · York, SC · Incident · No injuries · Incident investigation · Final report · Apr 15, 1988 · N93802 · Minor damage
  > The acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…
- [NTSB ATL83LA296](https://openairdocs.org/ntsb/ATL83LA296.md): Cessna T210N · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N6190C · 2 aircraft · Substantial damage
  > Cessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…

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

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