Skip to content

NTSB investigations: Continental C85 series, SD

24 cases on aircraft whose registry engine model is Continental C85 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 ('17008')) 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 ('17008'))
  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 ('17008'))
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 CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…Sep 8, 2019 · N73000 · Substantial damage NTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.Mar 12, 2018 · N2011N · Substantial damage NTSB GAA17CA374Accident · No injuriesData collectionFinal reportChampion 7BCM · Watertown, SDThe pilot’s failure to maintain directional control during the landing roll.Jun 26, 2017 · N3195C · Substantial damage NTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.Aug 11, 1996 · N4053G · Substantial damage NTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.Aug 24, 1991 · N16098 · 2 aircraft · Substantial damage NTSB DEN84LA131Accident · No injuriesLimited investigationFinal reportCessna 140 · Miller, SDThe acft ground-looped during the plt's first solo landing & the right main landing gear sheared off. The CFI said the student had made between 30 to 40 landings prior to the solo flt.Apr 19, 1984 · N89740 · Substantial damage NTSB MKC79FA039Accident · 1 fatalClosedCessna 120 · Madison, SDJul 6, 1979 · N2777N · Destroyed NTSB MKC79FTK11Accident · No injuriesClosedCessna 140 · Redowl, SDApr 22, 1979 · N77191 · Substantial damage NTSB MKC78DTK36Accident · Minor injuriesClosedCessna 140 · Webster, SDSep 3, 1978 · N76114 · Substantial damage NTSB MKC78FTK32Accident · Serious injuriesClosedDavis DA2A · Custer, SDAug 7, 1978 · N3489 · Substantial damage NTSB MKC77FTK31Accident · Minor injuriesClosedPiper J5A · Rapid City, SDJul 13, 1977 · N38427 · Destroyed NTSB MKC77DTK09Accident · No injuriesClosedCessna 140 · Philip, SDMar 6, 1977 · N1962N · Substantial damage NTSB MKC77FTK04Accident · No injuriesClosedPiper PA-11 · Lake Preston, SDDec 16, 1976 · N4528M · Substantial damage NTSB MKC72DTK17Accident · No injuriesClosedAeronca 7BCM · Huron, SDJan 6, 1972 · N4256E · Substantial damage NTSB MKC72DTK14Accident · No injuriesClosedAeronca 7AC · De Smet, SDDec 28, 1971 · N3731E · Substantial damage NTSB MKC72DTK13Accident · No injuriesClosedPiper PA-11 · Miller, SDDec 24, 1971 · N78636 · Substantial damage NTSB MKC71DTK28Accident · No injuriesClosedCessna 120 · Tea, SDMay 3, 1971 · N1966N · Substantial damage NTSB MKC71DDQ12Accident · No injuriesClosedCessna 120 · Harrold, SDSep 19, 1970 · N3141N · Substantial damage NTSB MKC69F0131Accident · Minor injuriesClosedLuscombe 8E · Wagner, SDAug 12, 1968 · N2745K · Substantial damage NTSB MKC68D0498Accident · No injuriesClosedAeronca 11AC · Pollock, SDFeb 29, 1968 · N9779E · Substantial damage NTSB MKC67F0038Accident · Minor injuriesClosedPiper J3C · Parkston, SDJun 14, 1966 · N6318H · Destroyed NTSB MKC66F0454Accident · Serious injuriesClosedPiper PA-11 · Tolstoy, SDJan 25, 1966 · N78820 · Substantial damage NTSB MKC66F0067Accident · No injuriesClosedCessna 140 · Columbia, SDJun 10, 1965 · N2341N · Substantial damage NTSB UNK64X1508Accident · No injuriesClosedPiper PA12 · Sioux Falls, SDApr 29, 1964 · N3356N · Substantial damage