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 DEN99LA043Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Leadville, COThe pilot's in-flight decision to turn into rising terrain, and his decision to fly into and out of the airport in a heavy weight condition after the local flight instructor/FAA accident prevention counselor recommended that he should not. Factors were the…NTSB LAX99FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Coalinga, CAthe pilot's inadvertant visual flight into instrument meteorological conditions.NTSB MIA99LA068Accident · No injuriesLimited investigationFinal reportCessna 310N · Clearwater, FLa ground fire in the left wing due to an undetermined ignition source.NTSB FTW99LA050Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Mesquite, TXThe student pilot's failure to maintain directional control during a simulated engine failure during takeoff maneuver and the instructor's inadequate supervision. Factors were; the student's lack of total flight time in multiengine airplanes, and the soft…NTSB DEN99LA007Accident · No injuriesLimited investigationFinal reportCessna 210A · Provo, UTThe pilot's abrupt throttle control movement that caused the engine to flood, and his failure to follow emergency procedures contained in the Airplane Flight Manual. Factors were increasing the mixture control to full rich and switching the fuel pump to high…NTSB CHI98LA366Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Point Lookout, MOThe pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.NTSB ANC98LA138Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to maintain clearance with terrain. Contributing factors were the pilot's delayed remedial action (course reversal), low ceilings, rain, fog, and mountainous terrain.NTSB ANC98LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot's failure to maintain directional control.NTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.NTSB LAX98LA229Accident · No injuriesLimited investigationFinal reportCessna 310K · Calexico, CAThe pilot's continued operation of the aircraft with known deficiencies in the landing gear indicating system. A contributing factor to the accident was the pilot's expectation that the gear would be extended and locked irrespective of the indicator lights…NTSB MIA98LA192Accident · No injuriesLimited investigationFinal reportCessna 310K · Opa-Locka, FLThe fuel leak due to improper installation of the left auxiliary fuel tank by maintenance personnel. Also, inadequate annual inspection of the airplane by maintenance personnel for failure to identify the missing screw from the adel clamp resulting in chafing…NTSB CHI98LA174Accident · No injuriesLimited investigationFinal reportCessna 310L · Wheeling, ILthe collapse of the left main landing gear for undetermined reasons.NTSB LAX98FA153Accident · 1 fatalField investigationFinal reportBeech G33 · Crestline, CAthe pilot's intentional flight into known instrument weather conditions while operating VFR.NTSB FTW98LA226Accident · No injuriesLimited investigationFinal reportCessna 210A · Weatherford, TXThe restricted movement of the elevator control system by a bolt.NTSB SEA98LA059Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORThe flight instructor's inadequate supervision and the dual student's premature lift off which resulted in inadequate airspeed, a stall, and collision with the ground.NTSB CHI98LA112Accident · No injuriesLimited investigationFinal reportCessna 310J · Hutchinson, KSthe flight instructor's inadequate supervision by failing to ensure that the right throttle had been retarded before re-advancing the right mixture control, which resulted in a loss of directional control, an encounter with soft terrain, and damage to the…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.NTSB LAX98LA101Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot's improper use of the mixture controls.NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB IAD98LA028Accident · No injuriesLimited investigationFinal reportBeech 55B · Buffalo, NYImproper use of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB FTW98LA120Accident · No injuriesLimited investigationFinal reportCessna 210A · Morgan, UTfailure of the pilot to maintain control of the aircraft, which resulted in an inadvertent ground swerve. A related factor was the lack of experience in the make and model of aircraft.NTSB LAX98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Compton, CAThe failure of maintenance personnel to adequately inspect the aircraft during an annual inspection to detect a chafed and leaking engine fuel supply line.NTSB CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.NTSB FTW98FA056Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Royse City, TXThe pilot's impairment due to drugs, and his ensuing failure to maintain minimum required airspeed for flight, which resulted in a stall/spin. A factors was the loss of power to both engines due to fuel starvation as a result of the pilot's improper use of…NTSB CHI98LA041Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Burlington, KSan undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…NTSB FTW98LA045Accident · No injuriesLimited investigationFinal reportBeech J35 · Provo, UTthe pilot's failure to properly position the fuel tank selector to a tank with adequate fuel, which resulted in fuel starvation, and a subsequent forced landing due to lack of engine power. His failure (or inability) to extent the gear for landing was a…NTSB ANC97LA144Accident · No injuriesLimited investigationFinal reportCessna 185 · Kotzebue, AKThe collapse/deflation of the right main tire when the tire slipped on the tire wheel rim which resulted in the collapse of the right main landing gear due to overload.NTSB ATL97LA130Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Murfreesboro, TNThe pilot's excessive airspeed, and improper touch down point during landing, that resulted in the runway end overun. Factors were the wet runway surface, and the embankment at the end of the runway.NTSB NYC97GA177Accident · No injuriesFinal reportNavion G · Brooklyn, NYthe pilot's inadequate preflight by failing to ensure the fuel selector was properly positioned for takeoff, which resulted in fuel starvation, loss of engine power, and a forced landing after takeoff.NTSB LAX97LA277Accident · No injuriesLimited investigationFinal reportCessna 310 · Mesa, AZinadequate maintenance inspection of the landing gear system, following a prior incident, due to the mechanic's failure to follow the service manual instructions.NTSB ATL97LA112Accident · No injuriesLimited investigationFinal reportCessna 310K · Bainbridge, GAThe pilot's failure to properly perform the soft landing procedure, leading to a hard landing.NTSB NYC97LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Springfield, KYthe pilot's misjudgment of distance and speed, and his delay in aborting the landing. Factors relating to the accident were: the pilot's failure to attain a proper touchdown point for landing, and proximity of the fence to the runway.NTSB ATL97LA100Accident · No injuriesLimited investigationFinal reportBeech 55 · Murfreesboro, TNThe failure of the aircraft braking system due to low brake pressure resulting from the undetermined loss of brake fluid from the brake reservoir.NTSB FTW97LA258Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Dallas, TXThe pilot-in-command's failure to follow emergency procedures to reduce drag and maintain best climb airspeed. Factors were the partial loss of engine power due to the cracks in the #1 and #4 cylinders as the result of an unapproved modification of their…NTSB LAX97LA230Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Beaumont, CAthe pilot's inadvertent movement of the propeller controls, instead of the throttle levers, which resulted in an inadvertent dual engine shutdown. Factors relating to the accident were: the pilot's failure to properly secure the door during preflight, and his…NTSB FTW97LA239Accident · No injuriesLimited investigationFinal reportCessna 210 · Peyton, COFailure of both pilots to assure the landing gear was down and locked.NTSB SEA97LA144Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORthe pilot's failure to ensure the landing gear was down and locked for landing. The unlatched passenger door, the uphill (unidirectional) landing area, and trees off the departure end of the landing runway were related factors.NTSB CHI97LA151Accident · No injuriesLimited investigationFinal reportBeech 35 · Liberty, MOretraction of the nose gear for undetermined reason(s).NTSB ATL97LA069Accident · No injuriesLimited investigationFinal reportBeech 33 · Carrollton, GAThe inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.NTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.NTSB FTW97LA071Accident · No injuriesLimited investigationFinal reportCessna 210A · Peyton, COthe pilot's improper fuel management by failing to avoid a prolong uncoordinated turn or slip, which resulted in fuel starvation. Factors relating to the accident were: darkness, and the lack of (activated) runway lights.NTSB LAX97FA046Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Goleta, CAfailure of the pilot to maintain control of the aircraft during an instrument approach, due to spatial disorientation, and/or his failure to maintain proper altitude. Factors relating to the accident were: the pilot's delay (or failure) to initiate a missed…NTSB LAX97LA042Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Apple Valley, CAfuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.NTSB LAX97LA012Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Truckee, CAthe pilot's inadequate preflight planning/preparation and fuel consumption calculations resulting in fuel exhaustion. The pilot's failure to switch the fuel tanks to the auxiliary position and feather both propellers were factors.NTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA334Accident · No injuriesLimited investigationFinal reportCessna 210 · Pueblo, COimproper routing of the nose landing gear hydraulic line by unknown maintenance personnel, allowing it to chafe on the nose wheel and develop a leak, which resulted in an inability to obtain a down-and-locked condition of the landing gear.NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.