# NTSB investigations: Lycoming 0-320 series, 1983, ND

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 DEN83LA213](https://openairdocs.org/ntsb/DEN83LA213.md): Piper PA-28B-150 · Watford City, ND · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N5821W · Substantial damage
  > The acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he…
- [NTSB DEN83LA139](https://openairdocs.org/ntsb/DEN83LA139.md): Piper PA-23 · Jamestown, ND · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N2054P · Destroyed
  > The acft landed wheels-up with one engine feathered and nosed over during the slide-out. The pilot had intentionally feathered the left engine to 'try out' the acft. The left engine has the only engine driven hydraulic pump. This pump isnecessary to lower…
- [NTSB DEN83LA093](https://openairdocs.org/ntsb/DEN83LA093.md): Piper PA-18-150 · Powers Lake, ND · Accident · No injuries · Limited investigation · Final report · Apr 2, 1983 · N3944Z · Substantial damage
  > According to the plt, he was landing on a road near a friend's house when the left wing hit a steelpost and caused the acft to veer off the road and into a ditch. The acft then nosed over in the ditch.

## 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" = 'ND' 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=ND&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.