Skip to content

NTSB investigations: Continental I0-470 series, MN

31 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN25FA364Accident · 1 fatalClass 3 · FieldPreliminary reportBeech K35 · Cambridge, MNOn September 4, 2025, about 1105 central daylight time, a Beech K35 airplane, N6021E, sustained substantial damage when it was involved in an accident near Cambridge, Minnesota. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code…Sep 4, 2025 · N6021E · Substantial damage NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.Jul 9, 2004 · N80HL · Substantial damage NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…Dec 22, 2003 · N221Q · Substantial damage NTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.Sep 1, 2003 · N7445E · Substantial damage NTSB CHI02LA235Accident · Minor injuriesLimited investigationFinal reportCessna 185B · Brainerd, MNThe pilot's evasive maneuver to avoid obstacle clearance, resulting in a premature lift off with inadequate airspeed followed by a stall. The presence of the boat was a factor.Aug 4, 2002 · N11LP · Substantial damage NTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…Feb 24, 2000 · N7736R · Destroyed NTSB CHI99LA265Accident · No injuriesLimited investigationFinal reportCessna 310N · Eden Prairie, MNmaintenance personnel installed washers which were not large enough in diameter to prevent the retraction/extension scissors links from separating from each other.Jul 31, 1999 · N310DE · Substantial damage NTSB CHI91LA107Accident · No injuriesLimited investigationFinal reportBeech 55 · Forest Lake, MNAn aborted landing not performed by the pilot. Factors related to the accident were a runway that was wet and ice covered.Mar 5, 1991 · N29SF · Substantial damage NTSB CHI87DER09Accident · 1 fatalFinal reportGreat Lakes Adams 2T-1 · Bethel/Msp, MNThe amateur built aircraft impacted in an open farm field. Although witnesses did not agree on the altitude the aircraft was flying at, they all stated that the Great lakes 2T-1 was spinning before it collided with the ground. One witness indicated that the…Jul 10, 1987 · N23JA · Substantial damage NTSB CHI85FA314Accident · 4 fatalField investigationFinal reportBeech J35 · Eden Prairie, MNThe plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left…Jul 26, 1985 · N687B · Destroyed NTSB CHI83LA140Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Princton, MNThe pilot said that at 6000 feet MSL the engine began to miss and got worse. He tried to correct the situation but could not. He requested and was given vectors to the princeton arpt. The arpt was closed at the time due to snow covered ruts on the rnwy and…Mar 16, 1983 · N10HR · Substantial damage NTSB CHI81FER67Accident · No injuriesClosedBeech P35 · Stephen, MNSep 5, 1981 · N1501S · Substantial damage NTSB MKC78FA041Accident · 4 fatalClosedBeech 35-B33 · Harris, MNMay 29, 1978 · N1320Z · Destroyed NTSB MKC78FER22Accident · No injuriesClosedCessna 310C · Blaine, MNJan 4, 1978 · N1780H · Substantial damage NTSB MKC78FER03Accident · No injuriesClosedCessna 310 · Eden Prairie, MNOct 12, 1977 · N8917Z · Substantial damage NTSB MKC76FER41Accident · No injuriesClosedBeech 35J · Rochester, MNNov 22, 1975 · N8397D · Substantial damage NTSB MKC75DER60Accident · No injuriesClosedCessna 310 · Minneapolis, MNMar 18, 1975 · N650R · Substantial damage NTSB MKC75FER28Accident · No injuriesClosedBeech 95-55 · Minneapolis, MNNov 7, 1974 · N1233Z · Substantial damage NTSB MKC74DER62Accident · No injuriesClosedBeech N35 · Trimont, MNJun 25, 1974 · N1289Z · Substantial damage NTSB MKC74FER03Accident · No injuriesClosedCessna 310J · Owatonna, MNAug 1, 1973 · N3165L · Substantial damage NTSB MKC73FER21Accident · No injuriesClosedBeech 95-B55 · Detroit Lks, MNSep 7, 1972 · N7958K · Substantial damage NTSB MKC70F0311Accident · No injuriesClosedBeech K35 · St Paul, MNDec 19, 1969 · N803R · Substantial damage NTSB MKC69D0346Accident · No injuriesClosedBeech J35 · Austin, MNFeb 16, 1969 · N644T · Substantial damage NTSB MKC68F0286Accident · No injuriesClosedBellanca 14-19 · Lake Elmo, MNOct 1, 1967 · N8511R · Substantial damage NTSB MKC68F0253Accident · No injuriesClosedBellanca 14-19 · Rothsay, MNAug 5, 1967 · N1282R · Substantial damage NTSB MKC67D0423Accident · No injuriesClosedBeech J35 · Benson, MNJan 2, 1967 · N7263B · Substantial damage NTSB MKC67F0137Accident · No injuriesClosedDowner 14-19 · Pequot Lakes, MNJul 26, 1966 · N8527R · Substantial damage NTSB MKC66F0391Accident · Minor injuriesClosedBeech N35 · Madison, MNNov 3, 1965 · N1504Z · Substantial damage NTSB MKC66F0065Accident · No injuriesClosedCessna 205 · Roseau, MNMay 29, 1965 · N8126Z · Substantial damage NTSB UNK65X0441Accident · 1 fatalClosedBeechcraft N-35 · Brainerd, MNOct 25, 1964 · N9977R · Substantial damage NTSB UNK64X2888Accident · Serious injuriesClosedBeechcraft 35A33 · Int L Falls, MNJul 17, 1964 · N494T · Substantial damage