# NTSB investigations: Continental A&C75 series, 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 CEN10CA244](https://openairdocs.org/ntsb/CEN10CA244.md): Piper J3L · Kyle, SD · Accident · No injuries · Data collection · Final report · May 8, 2010 · N24502 · Substantial damage
  > The pilot's improper touchdown on a soft landing area, resulting in a nose over.
- [NTSB DEN86LA124](https://openairdocs.org/ntsb/DEN86LA124.md): Piper J-3 · Britton, SD · Accident · Minor injuries · Limited investigation · Final report · May 2, 1986 · N92283 · Substantial damage
  > The acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…
- [NTSB DEN83LA187](https://openairdocs.org/ntsb/DEN83LA187.md): Piper PA-11 · Wagner, SD · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N4573M · Substantial damage
  > The plt reported that the eng began loosing power as he approached his destination. He elected to make an emergency landing on a road to investigate the problem. He stated that he made a stalled landing that caused the tailwheel to unlock & allowed the acft…
- [NTSB MKC80FTK01](https://openairdocs.org/ntsb/MKC80FTK01.md): Erco 415-C · Sturgis, SD · Accident · Serious injuries · Closed · Oct 14, 1979 · N2200H · Substantial damage
- [NTSB MKC75DTK20](https://openairdocs.org/ntsb/MKC75DTK20.md): Piper J3C-65 · Scenic, SD · Accident · No injuries · Closed · Jun 6, 1975 · N3400N · Substantial damage
- [NTSB MKC68D0023](https://openairdocs.org/ntsb/MKC68D0023-113882.md): Luscombe 8D · South Shore, SD · Accident · No injuries · Closed · Aug 22, 1967 · N72060 · Substantial damage
- [NTSB MKC67F0609](https://openairdocs.org/ntsb/MKC67F0609.md): Erco 415-C · Hot Springs, SD · Accident · No injuries · Closed · May 15, 1967 · N3130H · 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.engine_model_code IN ('17005'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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