# NTSB investigations: Lycoming 0-290 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 CHI02LA159](https://openairdocs.org/ntsb/CHI02LA159.md): Galbraith Piel Emeraude · Hot Springs, SD · Accident · 1 fatal · Limited investigation · Final report · Jun 11, 2002 · N71PE · Substantial damage
  > The loss of engine power due to the connecting rod fatigue failure during takeoff climb.
- [NTSB CHI96LA229](https://openairdocs.org/ntsb/CHI96LA229.md): Hewitt Cassutt 3M · Vermillion, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1996 · N290E · Substantial damage
  > the failure of the unapproved fuel pump.
- [NTSB DEN84FTK01](https://openairdocs.org/ntsb/DEN84FTK01.md): Baking Duce · Rapid City, SD · Accident · No injuries · Final report · Oct 29, 1983 · N6769 · Substantial damage
  > The acft ran off the left side of the rwy during landing and the left main landing gear collapsed. When the plt attempted to bring the acft back onto the rwy the gear hit the edge of the rwy. There was a 7 to 10 kt crosswind on rwy 14 at the time of the…
- [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 MKC78DTK34](https://openairdocs.org/ntsb/MKC78DTK34.md): Piper PA-18 · Milbank, SD · Accident · No injuries · Closed · Aug 23, 1978 · N3353A · 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 DEN73DTC08](https://openairdocs.org/ntsb/DEN73DTC08.md): Piper PA-18 · Bell Fourch, SD · Accident · No injuries · Closed · Sep 1, 1972 · N8254C · 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 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 MKC70DDQ12](https://openairdocs.org/ntsb/MKC70DDQ12.md): Piper PA-18 · Altamont, SD · Accident · No injuries · Closed · Jan 25, 1970 · N1256A · Substantial damage
- [NTSB MKC70F0274](https://openairdocs.org/ntsb/MKC70F0274.md): Piper PA-22 · Oglala, SD · Accident · No injuries · Closed · Dec 6, 1969 · N8687C · 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 MKC69F0459](https://openairdocs.org/ntsb/MKC69F0459.md): Piper PA-20 · Spearfish, SD · Accident · No injuries · Closed · Jun 3, 1969 · N7099K · Substantial damage
- [NTSB MKC69D0036](https://openairdocs.org/ntsb/MKC69D0036.md): Piper PA-22 · Lemmon, SD · Accident · Minor injuries · Closed · Jun 16, 1968 · N1489C · Substantial damage
- [NTSB MKC68F0545](https://openairdocs.org/ntsb/MKC68F0545.md): Piper J3L-65 · Northville, SD · Accident · No injuries · Closed · May 14, 1968 · N24686 · Substantial damage
- [NTSB MKC68D0115](https://openairdocs.org/ntsb/MKC68D0115.md): Piper PA-18 · Gettysburg, SD · Accident · No injuries · Closed · Jun 17, 1967 · N8082C · Substantial damage
- [NTSB MKC67D0347](https://openairdocs.org/ntsb/MKC67D0347.md): Piper PA-20 · Philip, SD · Accident · No injuries · Closed · Dec 8, 1966 · N1510A · Substantial damage
- [NTSB MKC66D0504](https://openairdocs.org/ntsb/MKC66D0504.md): Piper PA-20 · Mitchell, SD · Accident · No injuries · Closed · Mar 19, 1966 · N1591A · Substantial damage
- [NTSB MKC66F0104](https://openairdocs.org/ntsb/MKC66F0104.md): Piper PA-18 · Tulare, SD · Accident · Minor injuries · Closed · Jun 8, 1965 · N1011A · Destroyed
- [NTSB UNK64X4113](https://openairdocs.org/ntsb/UNK64X4113.md): Piper PA22 · Watertown, SD · Accident · No injuries · Closed · Sep 23, 1964 · N2464A · Substantial damage
- [NTSB UNK64X3790](https://openairdocs.org/ntsb/UNK64X3790.md): Stits SA3B · Mobridge, SD · Accident · Minor injuries · Closed · Sep 5, 1964 · N4985E · Destroyed

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

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