Skip to content

NTSB investigations: Continental O-470 series, SD

44 cases on aircraft whose registry engine model is Continental O-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

NTSB investigations: Continental O-470 series, SD per year, 1964–2026: 44 cases
1964	1
1965	2
1966	2
1967	2
1968	1
1969	1
1970	3
1971	1
1972	2
1973	3
1974	2
1975	4
1978	1
1979	1
1980	2
1981	1
1983	1
1987	1
1988	1
1993	1
1995	1
1998	1
2002	1
2003	1
2004	2
2007	1
2015	1
2018	1
2020	1
2022	1

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 ('17026')) 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 ('17026'))
  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 ('17026'))
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 CEN22LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305 · Sioux Falls, SDThe pilot’s failure to maintain directional control after an attempted go-around, which resulted in a runway excursion and impact with terrain.Jun 10, 2022 · N201FM · Substantial damage NTSB CEN21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Spearfish, SDThe snowplow driver’s failure to see the airplane which resulted in a collision with the airplane.Oct 18, 2020 · N97875 · Substantial damage NTSB GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.Mar 20, 2018 · N3024Y · Substantial damage NTSB GAA16CA022Accident · No injuriesData collectionFinal reportCessna 180H · Sioux Falls, SDThe pilot's decision to land with a 20 knot direct cross wind, which resulted in a loss of directional control and the right wing impacting terrain and a subsequent ground loop.Oct 19, 2015 · N9780G · Substantial damage NTSB CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.Jul 15, 2007 · N3306D · Substantial damage NTSB CHI05CA040Accident · Minor injuriesData collectionFinal reportCessna 182P · Belle Fourche, SDThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were the gusting crosswind, the pilot's lack of night flying of experience, the inoperative instrument lights, and the night…Dec 4, 2004 · N21213 · Substantial damage NTSB CHI04CA091Accident · No injuriesData collectionFinal reportCessna C-180 · Aberdeen, SDThe pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…Mar 28, 2004 · N2916C · Substantial damage NTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.Jun 3, 2003 · N630SW · Destroyed NTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.Jun 15, 2002 · N4833N · Substantial damage NTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…Mar 28, 1998 · N9140C · Substantial damage NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.Oct 20, 1995 · N5466E · Substantial damage NTSB CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.Aug 7, 1993 · N4724K · Substantial damage NTSB DEN88LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Gettysburg, SDThe commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right…Jun 2, 1988 · N2123Z · Substantial damage NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…Apr 21, 1987 · N9069T · Substantial damage NTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…Oct 20, 1983 · N3375U · Destroyed NTSB DEN81DTK06Accident · No injuriesClosedCessna 180 · Gettysburg, SDMar 14, 1981 · N5095E · Substantial damage NTSB MKC80FTK09Accident · No injuriesClosedCessna 182 · Spearfish, SDMar 2, 1980 · N5161D · Substantial damage NTSB MKC80FTK08Accident · No injuriesClosedCessna 182M · Pukwana, SDFeb 24, 1980 · N71317 · Substantial damage NTSB MKC79DTK07Accident · No injuriesClosedCessna 180 · Bullhead, SDFeb 19, 1979 · N2698Y · Substantial damage NTSB MKC78DTK13Accident · No injuriesClosedCessna 180 · Desmet, SDMar 25, 1978 · N9184C · Substantial damage NTSB MKC76DTK12Accident · No injuriesClosedCessna 180 · Chelsea, SDOct 20, 1975 · N101A · Substantial damage NTSB MKC76FTK08Accident · No injuriesClosedCessna 182A · Spearfish, SDOct 4, 1975 · N4826D · Substantial damage NTSB MKC76FTK07Accident · No injuriesClosedCessna 180 · Rapid City, SDSep 23, 1975 · N4707B · Substantial damage NTSB MKC76DTK01Accident · No injuriesClosedCessna 180 · Buffalo, SDJul 23, 1975 · N6453X · Substantial damage NTSB MKC75DTK03Accident · No injuriesClosedCessna 180 · Rapid City, SDSep 21, 1974 · N4644A · Substantial damage NTSB MKC74DTK0DAccident · No injuriesClosedCessna 182 · Gettysburg, SDFeb 17, 1974 · N71045 · Substantial damage NTSB MKC74DTK04Accident · No injuriesClosedCessna 182 · Onida, SDSep 2, 1973 · N92823 · Substantial damage NTSB MKC74DTK01Accident · No injuriesClosedCessna 305A · Spearfish, SDJul 8, 1973 · N5283G · Substantial damage NTSB MKC73FTG10Accident · No injuriesClosedCessna 305A · Bismarck, SDApr 4, 1973 · N5210G · Substantial damage NTSB MKC73FTK02Accident · Minor injuriesClosedCessna 180 · Watertown, SDAug 6, 1972 · N9033C · Substantial damage NTSB MKC72DTK16Accident · No injuriesClosedCessna 182F · Marion, SDJan 3, 1972 · N3523U · Substantial damage NTSB MKC72DTK05Accident · No injuriesClosedCessna 188 · Wagner, SDAug 11, 1971 · N8045V · Substantial damage NTSB MKC71DDQ18Accident · No injuriesClosedCessna 310 · Mission, SDOct 28, 1970 · N5292A · Substantial damage NTSB MKC70DDQ11Accident · No injuriesClosedCessna 182 · Willow Lake, SDJun 19, 1970 · N2426R · Substantial damage NTSB MKC70DDQ06Accident · No injuriesClosedCessna 180 · Watertown, SDApr 25, 1970 · N9033C · Substantial damage NTSB MKC69D0447Accident · No injuriesClosedCessna 182B · Highmore, SDMay 18, 1969 · N2791G · Substantial damage NTSB MKC68D0576Accident · No injuriesClosedCessna 182 · Mitchell, SDMay 10, 1968 · N461VY · Substantial damage NTSB MKC68D0193Accident · No injuriesClosedCessna 182K · Clark, SDJul 2, 1967 · N2713Q · Substantial damage NTSB MKC67F0427Accident · No injuriesClosedCessna 180 · Newell, SDJan 24, 1967 · N3141D · Substantial damage NTSB MKC67F0009Accident · Minor injuriesClosedCessna 182 · Rapid City, SDMay 28, 1966 · N6381B · Substantial damage NTSB MKC66F0434Accident · No injuriesClosedBellanca 14-19 · Huron, SDFeb 13, 1966 · N7666B · Substantial damage NTSB MKC66F0162Accident · No injuriesClosedBellanca 14-19 · Bison, SDJul 30, 1965 · N7676B · Substantial damage NTSB MKC65D0103Accident · No injuriesClosedCessna 182 · Huron, SDApr 15, 1965 · N9333X · Substantial damage NTSB UNK64X2753Accident · No injuriesClosedCessna 182 · Chamberlain, SDJul 10, 1964 · N3698U · Substantial damage