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 FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.NTSB CHI96LA144Accident · No injuriesLimited investigationFinal reportBeech B55B · Manhattan, KSthe pilot's failure to properly extend the landing gear. A factor was his failure to follow checklist procedures.NTSB MIA96LA121Accident · No injuriesLimited investigationFinal reportCessna 310D · Palmetto, GAFailure of the pilot-in-command to maintain the proper descent rate resulting in a hard landing and collapse of the right main landing gear.NTSB ANC96LA040Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's inadequate compensation for gusty crosswind conditions. The strong, gusty crosswind was a factor.NTSB FTW96LA129Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Brownwood, TXthe pilot's failure to follow manufacturer's procedures and premature gear retraction.NTSB MIA96FA082Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Morganton, NCthe pilot's delay in initiating a go-around (aborted landing), which resulted in his failure to obtain/maintain sufficient altitude or clearance from trees beyond the end of the runway. Factors relating to the accident were: the pilot's failure to ensure…NTSB FTW96LA093Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Houston, TXa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA051Accident · Minor injuriesLimited investigationFinal reportCessna 310J · Englewood, COfailure of the pilot to feather the propeller on the inoperative engine in accordance with the emergency procedure. Factors relating to the accident were: loss of power in the left engine for undetermined reason(s), and rough/uneven terrain in the emergency…NTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…NTSB FTW96LA047Accident · No injuriesLimited investigationFinal reportCessna 210B · Loveland, COFailure of the pilot to extend the landing gear.NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB BFO96LA018Accident · No injuriesLimited investigationFinal reportBeech 35 · Phillipsburg, OHThe flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…NTSB LAX96LA034Accident · No injuriesLimited investigationFinal reportCessna 310C · Boulder City, NVthe pilot's improper aircraft handling during touchdown which resulted in the right wing and horizontal stabilizer dragging on the runway. The poorly planned landing approach was a factor.NTSB BFO96LA002Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Annapolis, MDthe pilot's improper planning/decision, and/or failure to go around while there sufficient airspeed and runway remaining during the approach/landing. Factors relating to the accident were: standing water on the runway, and resultant hydroplaning conditions.NTSB BFO95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Columbiana, OHThe improper maintenance installation and the subsequent separation of the torque links on the left main landing gear during the landing roll.NTSB SEA95LA186Accident · No injuriesLimited investigationFinal reportBeech P-35 · Bend, ORseizure of the #4 connecting rod bearing due to overtemperature resulting in the separation of the connecting rod and total loss of engine power. A factor contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.NTSB CHI95LA254Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Delavan, WIThe pilot misjudged the flare and improper recovery from a bounced landing. Lack of experience in the make and model aircraft was a factor.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.NTSB NYC95LA125Accident · 1 fatalLimited investigationFinal reportCessna 310Q · Atlantic Ocean (Atlantic Ocean)the pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and subsequent ditching at sea. Darkness and the high sea condition (rough water) were related factors.NTSB LAX95FA148Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Toms Place, CAthe pilot's decisions to initially attempt and then continue flight into known forecast and observed adverse weather. Factors in the accident were: the pilot's inadequate preflight planning and his use of a drug.NTSB LAX95WA165Accident · 2 fatalForeign investigationBeech BE-55 · Laurieton, AustraliaNTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.NTSB ATL95FA031Accident · 2 fatalField investigationFinal reportCessna 310Q · St. Augustine, FLThe non-instrument rated pilot's attempted flight into known instrument meteorological conditions which resulted in spatial disorientation and loss of control.NTSB NYC95LA023Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Coventry, RIimproper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.NTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.NTSB SEA94LA229Accident · No injuriesLimited investigationFinal reportBeech E-35 · Everett, WAThe nose gear extension assembly failure.NTSB FTW94FA233Accident · 2 fatalField investigationFinal reportCessna 310Q · Greenville, TXThe cfi's failure to maintain airspeed above VMC, resulting in a loss of control during the single engine G0-around. Factors were not attaining runway alignment and the cfi's failure to retract the landing gear for the go-around procedure.NTSB LAX94LA276Accident · No injuriesLimited investigationFinal reportCessna 310J · Elko, NVthe collapse of the landing gear due to a gear strut bolt shearing in two.NTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.NTSB LAX94LA264Accident · No injuriesLimited investigationFinal reportCessna 210A · Mesquite, NVExhaustion of the brake system hydraulic fluid due to an inadequate annual inspection.NTSB ATL94LA120Accident · No injuriesLimited investigationFinal reportBeech P35 · Bluffton, SCA loss of engine power due to oil starvation. This resulted from an undertorqued condition of the oil filter adapter, and the subsequent fretting of the adapter threads.NTSB BFO94FA096Accident · 2 fatalField investigationFinal reportCessna 210B · Culpepper, VAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control of the aircraft. Contributing factors were the low ceilings and clouds.NTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…NTSB ANC94LA053Accident · No injuriesLimited investigationFinal reportBeech 35 · Gustavus, AKThe pilot-in-command's delay in selecting the main fuel tank position. The lack of suitable terrain for a forced landing was a factor.NTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.NTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.NTSB MIA94LA107Accident · No injuriesLimited investigationFinal reportCessna 310Q · West Palm Beach, FLThe pilot-in-command's inadvertent landing with the brakes on, resulting in a bounced landing and his failure to maintain airspeed after a bounced landing which resulted in the aircraft stalling and landing hard.NTSB FTW94FA104Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Battlement Mesa, COImpaired judgement and performance of the pilot by flying while under the influence of alcohol that resulted in his failure to maintain clearance (or altitude) from terrain, while flying at night.NTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.NTSB FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.NTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.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.