Skip to content

NTSB investigations: Continental 0-300 series, SD

27 cases on aircraft whose registry engine model is Continental 0-300 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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 ('17022')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('17022'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.Jul 20, 2025 · N3443C · Substantial damage NTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.Jul 11, 2021 · N5340R · Substantial damage NTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · Destroyed NTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.Aug 30, 2017 · N2982U · Substantial damage NTSB CHI02LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Redfield, SDthe failure of the pilot to maintain directional control while taxing to takeoff in high and gusty wind conditions.May 3, 2002 · N6422E · Substantial damage NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.Dec 17, 1995 · N12010 · Substantial damage NTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.Apr 24, 1991 · N5720C · Substantial damage NTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…Jul 26, 1987 · N2346U · Substantial damage NTSB DEN81DTK03Accident · No injuriesClosedCessna 172 · Timber Lake, SDDec 21, 1981 · N8831Z · Substantial damage NTSB DEN81FTK18Accident · No injuriesClosedCessna 172 · Presho, SDAug 2, 1981 · N5752R · Substantial damage NTSB DEN80FTK20Accident · Minor injuriesClosedCessna 172 · Kyle, SDAug 28, 1980 · N7976U · Substantial damage NTSB MKC79FTK12Accident · No injuriesClosedCessna 172 · Howard, SDApr 22, 1979 · N5602T · Substantial damage NTSB MKC77DKT29Accident · No injuriesClosedCessna 172 · Camp Crook, SDJun 27, 1977 · N2763U · Substantial damage NTSB MKC77DTK22Accident · No injuriesClosedCessna 172 · Ethan, SDMay 29, 1977 · N4144F · Substantial damage NTSB MKC77PTK12Accident · Minor injuriesClosedCessna 172 · Chamberlain, SDMar 17, 1977 · N8237X · Substantial damage NTSB MKC76DTK22Accident · No injuriesClosedCessna 172E · Sioux Falls, SDApr 16, 1976 · N3883S · Substantial damage NTSB MKC74DTK03Accident · No injuriesClosedCessna 172G · Monroe, SDAug 18, 1973 · N4444L · Substantial damage NTSB MKC71FDQ23Accident · Minor injuriesClosedCessna 172 · Sioux Falls, SDJan 13, 1971 · N4444L · Substantial damage NTSB MKC69D0014Accident · No injuriesClosedCessna 172 · Grenville, SDMay 25, 1968 · N7606X · Substantial damage NTSB MKC68D0215Accident · No injuriesClosedCessna 172G · Ladner, SDSep 11, 1967 · N6074R · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB MKC66F0591Accident · No injuriesClosedCessna 172 · Pierre, SDMay 28, 1966 · N8239X · Substantial damage NTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damage NTSB MKC66D0198Accident · No injuriesClosedCessna 172 · Kaylor, SDAug 22, 1965 · N7499X · Substantial damage NTSB MKC65F0110Accident · No injuriesClosedCessna 172 · Sioux Falls, SDMay 2, 1965 · N3898S · Substantial damage NTSB UNK65X1106Accident · No injuriesClosedMaule M4 · Rosholt, SDDec 23, 1964 · N4734T · Substantial damage NTSB UNK65X0836Accident · No injuriesClosedCessna 170 · Freeman, SDNov 25, 1964 · N3947V · Destroyed