# NTSB investigations: Lycoming 0-320 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 ATL83LA255](https://openairdocs.org/ntsb/ATL83LA255.md): Cessna 172P · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N52471 · Substantial damage
  > The acft nosed over during a forced landing after a stall during a low pass. The plt said he was flying around an islandat 500 ft AGL taking pictures when the acft began to settle. He added power and applied elevator back pressure. Then carburetor heat was…
- [NTSB ATL83FA093](https://openairdocs.org/ntsb/ATL83FA093.md): Piper PA-28-140 · Johns Island, SC · Accident · Minor injuries · Field investigation · Final report · Jan 30, 1983 · N4548R · Substantial damage
  > The acft crash landed in a swamp as the pilot tried to return to the arpt during a forced landing. The engine lost powerduring takeoff climb at about 300 ft AGL. Witnesses said the acft was trailing black smoke as it departed. During the last annual…

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

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