# NTSB investigations: Lycoming I0360 series, 1983, SC

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 ATL83LA367](https://openairdocs.org/ntsb/ATL83LA367.md): Rockwell AC-112A · Batesburg, SC · Accident · No injuries · Limited investigation · Final report · Sep 13, 1983 · N1423J · Substantial damage
  > The acft experienced a gear collapse during landing rollout. The pilot stated that the gear green lights were on prior to landing. The landing and rollout were uneventful until a right turn of 180 degrees was made. During the turn the left main gear folded…
- [NTSB ATL83LA098](https://openairdocs.org/ntsb/ATL83LA098.md): Piper PA-30 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 6, 1983 · N1810M · Substantial damage
  > The plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…

## 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 year(c."eventDate") = 1983
  AND 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 ('41515'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41515&state=SC&year=1983

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