NTSB investigations: Continental I0-470 series
2,580 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 ATL89LA031Accident · No injuriesLimited investigationFinal reportCessna 310J · Carrollton, OHThe pilot had landed at Carrollton, OH for refuelling and breakfast. After refuelling he taxied out for departure from runway 25 for a flight back to his home base. The runup was reportedly normal. After application of maximum power, he started his takeoff…NTSB LAX89LA029Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Saint Johns, AZJust after takeoff, the pilot noted cylinder head temp and manifold pressure above red line and a loss of engine power. Mixture had been leaned for tkof. The engine quit when the plt closed the turbocharger wastegate. A forced landing was made upslope on…NTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.NTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…NTSB NYC88LA251Accident · No injuriesLimited investigationFinal reportCessna 210 · Kirkwood, NYThe plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up…NTSB ANC88LA141Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcclaren River, AKAccording to the pilot, the landing gear struck either a depression or an object on the riverbed/runway during takeoff roll and veered left. He corrected the deviation and continued taking off. However, when the airplane reached the end of the airstrip, he…NTSB MIA88FA267Accident · 4 fatalField investigationFinal reportBeech K35 · Morriston, FLThe student pilot was about 47 miles from home and nearing completion of a x-c flt with his wife, father, and mother. The plt had reqsted VFR flight following & had been cruising at 6500 ft. the plt advised ATC they were down to 6250 ft & needed to descend…NTSB SEA88LA151Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Fallon, NVEng lost power on practice missed approach. Forced landing made in rough terrain. Investigation revealed right fuel tank empty, left tank contained about 25 gals. Fuel selector had no positive stop at 'off' position, no detent for right tank position. Left…NTSB SEA88LA145Accident · No injuriesLimited investigationFinal reportBeech K-35 · Halley, IDEngine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left…NTSB SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.NTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CANTSB SEA88LA102Accident · No injuriesLimited investigationFinal reportBeech B55 · Reno, NVThe pilot was attempting to land on runway 25 with winds from 290 degrees at 17 knots. Just prior to flare, the aircraft encountered a gust of wind. The pilot lost control of the aircraft and landed hard on the right main gear. The right strut, wheel and…NTSB MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…NTSB ATL88FA162Accident · No injuriesField investigationFinal reportBeech 55 · Atlanta, GANTSB SEA88FA083Accident · 1 fatalField investigationFinal reportCessna 310G · Las Vegas, NVDuring initial climb at 100 ft after takeoff, the pilot announced he had lost an engine. Witnesses observed the aircraft enter a nose high attitude, roll to the right and descend in a vertical nose down attitude until impact with the ground. The aircraft…NTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…NTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.NTSB ANC88LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mekoryuk, AKThe pilot stated that during the touchdown the aircraft struck a snowbank on the approach end of the runway. The aircraft exited the right side of the runway approximately 500 feet from the approach end.NTSB LAX88DVM01Accident · No injuriesFinal reportBeech M35 · San Jose, CADuring a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…NTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…NTSB MIA88LA054Accident · No injuriesLimited investigationFinal reportCessna 310F · Opa Locka, FLThe plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod…NTSB MIA88FA049Accident · 1 fatalField investigationFinal reportBeech K-35 · Crescent City, FLThe pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel…NTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…NTSB FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…NTSB LAX88LA062Accident · No injuriesLimited investigationFinal reportBeech P35 · Maricopa, CADuring a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10…NTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…NTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…NTSB LAX88LA039Accident · No injuriesLimited investigationFinal reportCessna 210A · San Luis Obispo, CAWhile approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…NTSB ANC88FA012Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe relatively inexperienced seaplane pilot-in-command made one go around when he experienced difficulty in identifying the surface of the glassy water. On the second landing attempt he flew the airplane into the water at a negative angle of attack. The…NTSB MIA88FA003Accident · 4 fatalField investigationFinal reportCessna 310K · Inverness, FLWitnesses stated that the plt initiated a go around at the runway 19 threshold, broke off to the right & went behind a tree line in a 60 degree right bank. On the other side of the tree line the acft was observed to strike the trees with the left wing and…NTSB ANC87LA157Accident · No injuriesLimited investigationFinal reportCessna 185 · Little Delta Rv, AKThe pilot stated that approximately 1000 feet after commencing the take off the airplane climbed to just above tree top level and then began to settle into the trees. The pilot also stated he believes the airplane stalled.NTSB NYC87LA256Accident · No injuriesLimited investigationFinal reportCessna 310N · Williamsport, PAAfter landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut…NTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…NTSB FTW87LA201Accident · No injuriesLimited investigationFinal reportCessna 185 · San Marcos, TXThe pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence.NTSB LAX87LA307Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Page, AZAfter arriving at the arpt, the plt entered traffic to land on rwy 15 with a gusty x-wind from the right. He reported that just before touchdown, the aircraft entered a sudden left roll. Subsequently, the left wing contacted the runway and the plane nosed…NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…NTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…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…NTSB ATL87FA168Accident · 4 fatalField investigationFinal reportCessna 205C · Bowling Green, KYShortly after takeoff from Bowling Green, the pilot reported a problem. He did not report the details of the problem, but witnesses heard the aircraft backfiring as it descended. The aircraft had taken on fuel at Bowling Green. The investigation failed to…NTSB NYC87FA170Accident · 2 fatalField investigationFinal reportCessna 310Q · Montgomery, NYN5527K crashed about 2 miles south of the orange cnty airport shortly after a night tkof fm runway 21. Departure instructions for the IFR flt included a right turn of 130 degrees, to 340 degrees magnetic to intercept V-58 and climb to 5000 ft. the plt…NTSB ATL87DKG03Accident · No injuriesFinal reportCessna 310D · Athens, GAThe acft was reportedly stalled about 30 ft above the rwy and a hard ldg was made. The multi-eng rated plt was practicing short-field ldgs under the instruction of a CFI in preparation for obtaining commercial certificate. The acft wings and fuselage…NTSB SEA87LA087Accident · No injuriesLimited investigationFinal reportCessna 310L · Chiloquin, ORThe aircraft departed the end of the runway during landing roll. The aircraft then went down an embankment and through a fence. The right main gear collapsed with the aircraft turning 90 degrees before coming to rest. A tailwind was present during landing.…NTSB LAX87LA191Accident · Serious injuriesLimited investigationFinal reportBeech 95-55 · Monterey, CAJust after take-off, the cabin door opened in flight. The plt attempted to reland but was unsuccessful due to weather conditions. The plt was vectored to another arpt, however, the plt never climbed to the assigned alt and was never in radar contact. The plt…NTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…NTSB LAX87LA186Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lower Lake, CAA Cessna 310Q overran rwy 30 and collided with terrain off the departure end. A witness stated the acft landed at aprx mid-field on the 2,485 ft by 50 ft asphalt rwy and was unable to stop. Based on the witnesses' statement aprx 1,240 ft would be available…NTSB BFO87LA029Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Midland, VAThe plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,…NTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.NTSB MIA87LA121Accident · No injuriesLimited investigationFinal reportCessna 310L · Venice, FLThe left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown.NTSB MIA87LA120Accident · No injuriesLimited investigationFinal reportCessna 210C · Ponch, PRThe acft was found abandoned in a sugar beet field with the landing gear collapsed. Information pertaining to the occupant(s), history of flt, and facts pertaining to the accident could not be determined. Injury index presumed.NTSB BFO87LA021Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moundsville, WVOn touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley.