Skip to content

NTSB investigations: Continental I0-470 series, IA

38 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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CEN20LA145Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sidney, IAA loss of engine power for reasons that could not be determined.Apr 10, 2020 · N1258Z · Substantial damage NTSB CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.Dec 2, 2012 · N1566Z · Substantial damage NTSB CEN11FA040Accident · 1 fatalField investigationFinal reportBeech 95-B55 (T42A) · Clarion, IAThe pilot's failure to maintain control of the airplane. Contributing to the accident was the loss of left engine power for undetermined reasons.Oct 21, 2010 · N784CB · Destroyed NTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.Jul 21, 2001 · N6062E · Destroyed NTSB CHI98LA103Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Council Bluffs, IAthe pilot's failure to maintain proper runway alignment during the landing. The dark night was a factor.Mar 16, 1998 · N1521T · Substantial damage NTSB CHI94LA045Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Dubuque, IAFlight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.Dec 6, 1993 · N9684X · Substantial damage NTSB MKC86LA041Accident · No injuriesLimited investigationFinal reportBeech M35 · Council Bluffs, IAThe acft made a gear-up forced lndg off the arpt after a loss of power during a business flt. The acft had only been airborne for about 15 minutes. Post accident investigation discovered that the acft fuel was contaminated with water.Dec 27, 1985 · N9730R · Substantial damage NTSB MKC83LA183Accident · No injuriesLimited investigationFinal reportBeech M35 · Sioux City, IAThe plt stated that the landing gear switch was down when he started tha takeoff roll. When the acft had accelerated to aprx 50 mph during the takeoff roll, the landing gear retracted/collapsed, nose wheel first, followed by the main gear. The plt stated that…Aug 8, 1983 · N555M · Substantial damage NTSB MKC83FA128Accident · 4 fatalField investigationFinal reportBeech J35 · Knoxville, IAThe acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…Jun 12, 1983 · N3054C · Destroyed NTSB MKC83FA061Accident · Serious injuriesField investigationFinal reportBeech M35 · Cedar Rapids, IAThe acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through…Jan 31, 1983 · N9708R · No damage NTSB MKC82DA122Accident · Minor injuriesFinal reportBeech 95-A55 · Laurens, IAThe pilot had no current medical certificate or FAA pilot license. He stated that most of the time, he had a pilot in the company, but on this day, he was unable to obtain a pilot and conducted the flight himself. He stated that during his landing approach at…Jul 13, 1982 · N1456G · Substantial damage NTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…May 2, 1982 · N313Z · Substantial damage NTSB MKC79DCD14Accident · No injuriesClosedBeech 35 · Grinnell, IAMar 14, 1979 · N906B · Substantial damage NTSB MKC76FCD17Accident · Serious injuriesClosedCessna 210A · Council Bluffs, IAOct 28, 1975 · N9424X · Substantial damage NTSB MKC73FCD48Accident · No injuriesClosedCessna 310D · Des Moines, IAJan 17, 1973 · N6999T · Substantial damage NTSB MKC72DCD67Accident · No injuriesClosedCessna 185 · Council Blfs, IAApr 17, 1972 · N4010Y · Destroyed NTSB MKC71DCD87Accident · No injuriesClosedBeech 35-C33 · Centerville, IAJun 11, 1971 · N5454U · Substantial damage NTSB MKC71FCD66Accident · No injuriesClosedBeech K35 · Mason City, IAMar 28, 1971 · N6089E · Substantial damage NTSB MKC71AK044Accident · 1 fatalClosedCessna 172G · Marshalltown, IAFeb 6, 1971 · N4678L · 2 aircraft · Destroyed NTSB MKC71DCD46Accident · No injuriesClosedBeech 95-B55 · Mason City, IADec 31, 1970 · N291BP · Substantial damage NTSB MKC71FCJ28Accident · No injuriesClosedCessna 205 · Harlan, IAOct 25, 1970 · N8212Z · Substantial damage NTSB MKC71DCD09Accident · No injuriesClosedCessna 210A · Winterset, IAJul 20, 1970 · N6654X · Substantial damage NTSB MKC70DCD10Accident · No injuriesClosedBeech K35 · Spirit Lake, IAFeb 4, 1970 · N646Q · Substantial damage NTSB MKC70D0142Accident · No injuriesClosedBeech 35-B33 · Grinnell, IAAug 11, 1969 · N9703Y · Substantial damage NTSB MKC69F0417Accident · No injuriesClosedCessna 210 · Des Moines, IAMay 1, 1969 · N9699T · Substantial damage NTSB MKC68A0042Accident · No injuriesClosedCessna 210 · Ute, IADec 28, 1967 · N3672Y · Substantial damage NTSB MKC68D0227Accident · No injuriesClosedBeech P35 · Spencer, IASep 24, 1967 · N8625M · Substantial damage NTSB MKC68D0136Accident · No injuriesClosedCessna 210 · Sioux City, IAAug 9, 1967 · N9496X · Substantial damage NTSB MKC66D0236Accident · No injuriesClosedCessna 210 · Mapleton, IASep 9, 1965 · N9454T · Substantial damage NTSB MKC66D0168Accident · No injuriesClosedBeechcraft P-35 · Okoboji, IAAug 17, 1965 · N8625M · Substantial damage NTSB MKC66D0029Accident · No injuriesClosedBeechcraft P-35 · Spencer, IAMay 28, 1965 · N1538S · Substantial damage NTSB MKC66D0077Accident · No injuriesClosedCessna 210 · Davenport, IAMay 1, 1965 · N740B · Substantial damage NTSB MKC65F0102Accident · No injuriesClosedNavion G-1 · Sioux City, IAMar 28, 1965 · N2467T · Substantial damage NTSB UNK65X1011Accident · No injuriesClosedBeechraft N35 · Centerville, IADec 14, 1964 · N545T · Substantial damage NTSB UNK65X0656Accident · No injuriesClosedCessna 210 · Knoxville, IANov 11, 1964 · N9657T · Substantial damage NTSB UNK64X3987Accident · No injuriesClosedCessna 205 · Red Oak, IASep 14, 1964 · N8257Z · Substantial damage NTSB UNK64X2289Accident · No injuriesClosedCessna 210 · Dubuque, IAJun 14, 1964 · N9440T · Substantial damage NTSB UNK64X1666Accident · No injuriesClosedBeechcraft 35J · Okoboji, IAMay 8, 1964 · N3057C · Substantial damage