# NTSB investigations: Piper PA-18, SD

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 DEN84LA125](https://openairdocs.org/ntsb/DEN84LA125.md): Piper PA-18 · Barnard, SD · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N7594K · Substantial damage
  > During a landing in a soy bean field the acft encountered a soft muddy spot which caused the acft to nose over.
- [NTSB DEN83LA011](https://openairdocs.org/ntsb/DEN83LA011.md): Piper PA-18-125 · Camp Crook, SD · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1982 · N1190A · Destroyed
  > Pilot making low altutude turns found controls jammed and collided left wing low in descent with bales of hay. Fuselage was found to contain spent and live shotgun shells under the floor. Aileron had a firing pin from a shotgun lodged in a pulley. The pilot…
- [NTSB MKC79FA029](https://openairdocs.org/ntsb/MKC79FA029.md): Piper PA-18 · Oelrichs, SD · Accident · 1 fatal · Closed · May 19, 1979 · N240T · Destroyed
- [NTSB MKC78FTK20](https://openairdocs.org/ntsb/MKC78FTK20.md): Piper PA-18 · Naples, SD · Accident · 1 fatal · Closed · Jun 5, 1978 · N2799P · Substantial damage
- [NTSB MKC76FTK19](https://openairdocs.org/ntsb/MKC76FTK19.md): Piper PA-18 · Milbank, SD · Accident · Serious injuries · Closed · Jan 24, 1976 · N6980D · Substantial damage
- [NTSB MKC76AK019](https://openairdocs.org/ntsb/MKC76AK019.md): Piper PA-18 · Hayes, SD · Accident · 2 fatal · Closed · Sep 5, 1975 · N5487H · Destroyed
- [NTSB MKC75DTK12](https://openairdocs.org/ntsb/MKC75DTK12.md): Piper PA-18 · Milbank, SD · Accident · No injuries · Closed · Feb 2, 1975 · N6980D · Substantial damage
- [NTSB MKC75DTK07](https://openairdocs.org/ntsb/MKC75DTK07.md): Piper PA-18 · Cresbard, SD · Accident · No injuries · Closed · Nov 13, 1974 · N1861A · Substantial damage
- [NTSB MKC73DTK15](https://openairdocs.org/ntsb/MKC73DTK15.md): Piper PA-18 · Winner, SD · Accident · Minor injuries · Closed · May 6, 1973 · N3598Z · Substantial damage
- [NTSB MKC73FTK11](https://openairdocs.org/ntsb/MKC73FTK11.md): Piper PA-18 · Mclaughlin, SD · Accident · Serious injuries · Closed · Jan 11, 1973 · N8176D · Substantial damage
- [NTSB DEN73DTC02](https://openairdocs.org/ntsb/DEN73DTC02.md): Piper PA-18 · Belle Frche, SD · Accident · No injuries · Closed · Jul 21, 1972 · N1636A · Substantial damage
- [NTSB MKC71FDQ13](https://openairdocs.org/ntsb/MKC71FDQ13.md): Piper PA-18 · Pierre, SD · Accident · No injuries · Closed · Sep 30, 1970 · N9454D · Substantial damage
- [NTSB MKC71DDQ05](https://openairdocs.org/ntsb/MKC71DDQ05.md): Piper PA-18 · Opal, SD · Accident · No injuries · Closed · Aug 7, 1970 · N7113K · Substantial damage
- [NTSB MKC71DDQ02](https://openairdocs.org/ntsb/MKC71DDQ02.md): Piper PA-18 · Ludlow, SD · Accident · No injuries · Closed · Jul 6, 1970 · N1637A · Substantial damage
- [NTSB MKC70DDQ02](https://openairdocs.org/ntsb/MKC70DDQ02.md): Piper PA-18 · Mobridge, SD · Accident · No injuries · Closed · Jan 15, 1970 · N8176D · Substantial damage
- [NTSB MKC70D0072](https://openairdocs.org/ntsb/MKC70D0072.md): Piper PA-18 · Camp Crook, SD · Accident · No injuries · Closed · Jul 3, 1969 · N1190A · Substantial damage
- [NTSB MKC69D0478](https://openairdocs.org/ntsb/MKC69D0478.md): Piper PA-18 · Onida, SD · Accident · No injuries · Closed · May 30, 1969 · N3475Z · Substantial damage
- [NTSB MKC67F0509](https://openairdocs.org/ntsb/MKC67F0509.md): Piper PA-18 · Watertown, SD · Accident · Minor injuries · Closed · Apr 15, 1967 · N9097D · Substantial damage
- [NTSB MKC67F0179](https://openairdocs.org/ntsb/MKC67F0179.md): Piper PA-18 · Hermosa, SD · Accident · No injuries · Closed · Sep 4, 1966 · N6098D · Substantial damage
- [NTSB MKC66D0432](https://openairdocs.org/ntsb/MKC66D0432.md): Piper PA-18 · Summit, SD · Accident · No injuries · Closed · Feb 18, 1966 · N6980D · Substantial damage

## 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" = 'SD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101802&state=SD

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