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 CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.NTSB ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.NTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.NTSB ANC13FA001Accident · 1 fatalField investigationFinal reportGrumman G-44 · Aleknagik, AKThe pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.NTSB ERA13LA005Accident · No injuriesLimited investigationFinal reportCessna 310I · Burlington, VTThe collapse of the left main landing gear due to a failure of the left main gear bellcrank pin for reasons that could not be determined because the pieces of the fractured bellcrank pin were not located.NTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.NTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.NTSB WPR12LA394Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Healdsburg, CAThe loss of engine power during cruise flight due to the failure of the engine-driven fuel pump as a result of unidentified debris within the vapor return jet.NTSB WPR12LA392Accident · No injuriesLimited investigationFinal reportCessna 210 · Kemmerer, WYThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.NTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12LA503Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Homerville, GAThe loss of engine power due to debris within the engine-driven fuel pump.NTSB WPR12CA284Accident · Minor injuriesData collectionFinal reportCessna 210-5 · West Glacier, MTThe pilot elected to abort the takeoff without sufficient runway available to land and stop the airplane. Contributing to the accident was the illusion created by the rising terrain, which influenced the pilot's decision to abort the takeoff.NTSB CEN12LA373Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Gardner, KSThe pilot's delay in aborting the takeoff when the airplane was not accelerating as expected. Contributing to the accident was a wind shift during takeoff.NTSB ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.NTSB WPR12LA147Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · St. George, UTThe total loss of engine power due to the loose mixture control arm.NTSB ERA12LA217Accident · No injuriesLimited investigationFinal reportCessna 310K · Olive Branch, MSFuel leaking from the left engine fuel strainer onto electrical connections after engine start, which resulted in a fire.NTSB WPR12LA109Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Antioch, CAThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…NTSB CEN12CA165Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lancaster, WIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB CEN12LA110Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Midland, TXThe pilot’s improper fuel management during the flight, which resulted in a total loss of engine power.NTSB WPR12LA047Accident · No injuriesLimited investigationFinal reportCessna 310I · Sedona, AZThe collapse of the right main landing gear after landing for a reason that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and postaccident testing could not be performed due…NTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…NTSB CEN12CA006Accident · No injuriesData collectionFinal reportCessna 210A · Wolfe City, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB ANC11LA084Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKA loss of directional control during landing due to a rock lodged in the main landing gear wheel brake, resulting in a runway excursion and collision with terrain.NTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…NTSB CEN11CA564Accident · No injuriesData collectionFinal reportBeech 35-C33 · Rockwall, TXThe pilot's loss of control while landing with a tailwind due to his misinterpretation of the wind conditions.NTSB ANC11LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe loss of engine power for an undetermined reason, resulting in the ditching and sinking of the airplane in ocean waters.NTSB WPR11FA348Accident · Minor injuriesField investigationFinal reportCessna 210-5(205) · Darby, MTThe fatigue failure of the aluminum air intake duct, which resulted in material being ingested into the engine cylinders and a subsequent loss of engine power during cruise flight.NTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB WPR11CA330Accident · No injuriesData collectionFinal reportCessna 210-5(205) · McKenzie Bridge, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA11FA295Accident · Serious injuriesField investigationFinal reportBeech G33 · Washington, PAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management and preflight inspection. Contributing to the accident was the pilot's failure to comply with the manufacturer's published takeoff and emergency…NTSB WPR11CA215Accident · No injuriesData collectionFinal reportCessna 185A · Bend, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR11FA192Accident · Serious injuriesField investigationFinal reportBeech 35-B33 · Camarillo, CAThe loss of engine power during the landing approach for undetermined reasons.NTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.NTSB CEN11LA207Accident · Serious injuriesLimited investigationFinal reportCessna 310K · Angleton, TXThe pilot's failure to maintain control of the airplane during a night instrument approach.NTSB CEN11CA199Accident · No injuriesData collectionFinal reportCessna 310Q · Romeoville, ILThe pilot's failure to maintain adequate airspeed during the approach/landing to compensate for the ice accumulated on the airframe which resulted in a hard landing.NTSB WPR11FA125Accident · Serious injuriesField investigationFinal reportBeech 95-B55 (T42A) · San Bernardino, CAThe pilot did not recognize the loss of power in the right engine and did not execute the proper procedures for a go-around with one engine inoperative, likely due to increased workload. Contributing to the accident was the pilot's improper in-flight fuel…NTSB WPR11CA123Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · Van Nuys, CAThe pilot's failure to turn off the engine magnetos and properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.NTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.NTSB WPR11LA068Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Madras, ORThe failure of both pilots to see and avoid the other airplane while in the traffic pattern to land, which resulted in a midair collision.NTSB CEN11LA076Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Roanoke, TXA loss of engine power for undetermined reasons.NTSB ERA11FA038Accident · 1 fatalField investigationFinal reportCessna 210A · Aiken, SCThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot’s…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.