Skip to content

NTSB investigations: Continental I0-470 series, SD

20 cases on aircraft whose registry engine model is Continental I0-470 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 ('17027')) 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 ('17027'))
  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 ('17027'))
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 CEN25LA368Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 35-C33 · Brookings, SDOn September 6, 2025, about 0859 central daylight time, a Beech 35-C33 airplane, N1310A, was destroyed when it was involved in an accident near Brookings, South Dakota. The pilot and two passengers sustained minor injuries. The airplane was operated as a…Sep 6, 2025 · N1310A · Destroyed NTSB CEN17FA132Accident · 1 fatalField investigationFinal reportCessna 210B · Opal, SDThe pilot's loss of airplane control for reasons that could not be determined due to a lack of evidence.Mar 16, 2017 · N9581X · Destroyed NTSB CEN16LA275Accident · Minor injuriesClass 3 · LimitedFinal reportMeyers 200 · Huron, SDThe partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.Jul 20, 2016 · N229RS · Substantial damage NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.Sep 22, 2006 · N4JV · Substantial damage NTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…Aug 10, 2005 · N9408T · Substantial damage NTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.Feb 19, 2001 · N9927S · Destroyed NTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.Feb 7, 2001 · N10ET · Substantial damage NTSB MKC80FTK04Accident · No injuriesClosedCessna 210 · Dixon, SDOct 11, 1979 · N9544T · Substantial damage NTSB MKC78FTK17Accident · Serious injuriesClosedCessna 210 · Martin, SDMay 27, 1978 · N9689T · Substantial damage NTSB MKC76DTK17Accident · No injuriesClosedCessna 185 · Hot Springs, SDNov 12, 1975 · N9832X · Substantial damage NTSB MKC72DTK23Accident · No injuriesClosedCessna 310 · Winner, SDFeb 13, 1972 · N3253X · Substantial damage NTSB MKC69D0275Accident · No injuriesClosedCessna 210 · Watertown, SDDec 4, 1968 · N9684X · Substantial damage NTSB MKC68F0527Accident · No injuriesClosedBeech 95-A55 · Sioux Falls, SDApr 11, 1968 · N717T · Substantial damage NTSB MKC38D0375Accident · No injuriesClosedBeech K35 · Huron, SDDec 7, 1967 · N646Q · Substantial damage NTSB MKC68F0173Accident · No injuriesClosedBeech J35 · White River, SDAug 19, 1967 · N8257D · Substantial damage NTSB MKC67D0101Accident · No injuriesClosedBeech 95-B55 · Yankton, SDJul 30, 1966 · N192Q · Substantial damage NTSB MKC66F0554Accident · No injuriesClosedBeech P35 · Brookings, SDMay 25, 1966 · N9773Y · Substantial damage NTSB MKC66F0036Accident · No injuriesClosedCessna 210 · Sioux Falls, SDJun 16, 1965 · N9599T · Substantial damage NTSB UNK64X2241Accident · Minor injuriesClosedCessna 210 · Sioux Falls, SDJun 12, 1964 · N9428T · Substantial damage NTSB UNK64X1506Accident · No injuriesClosedBeechcraft P35 · Sioux Falls, SDApr 29, 1964 · N8906M · Substantial damage