NTSB investigations: Continental E185 series
816 cases on aircraft whose registry engine model is Continental E185 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 ('17014'))
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 ('17014'))
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 SEA03LA164Accident · No injuriesLimited investigationFinal reportBeech A35 · Freeland, WAA partially blocked fuel injector which led to an over temperature condition in the cylinders resulting in a loss of engine power during cruise flight. Sandy terrain conditions for the landing was a factor.NTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB CHI03LA021Accident · Serious injuriesLimited investigationFinal reportBeech D35 · Dodge Center, MNThe loss of engine power due to a fractured engine driven pump shaft pin. The low altitude and unsuitable terrain encountered were contributing factors.NTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.NTSB SEA02LA152Accident · No injuriesLimited investigationFinal reportBeech B35 · Halfway, ORThe pilot's delay in initiating an aborted takeoff and his failure to establish climb out of ground effect. Contributing factors were the high aircraft weight and high density altitude as well as the fence and berm, which the aircraft struck.NTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…NTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.NTSB DEN02LA064Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Cortez, COan inadvertent stall as the pilot attempted to clear a cliff and ravine and avoid power lines, resulting in a collision with the ground. Contributing factors were a loss of engine power for undetermined reasons, a leaking carburetor and fuel pump, and the…NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB CHI02LA158Accident · No injuriesLimited investigationFinal reportBeech B35 · Lakewood, WIThe pilot's failure to maintain control of the aircraft during takeoff when he encountered a stall after failing to maintain airspeed.NTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB LAX02LA117Accident · Serious injuriesLimited investigationFinal reportBeech A35 · Rio Linda, CAthe loss of engine power as a result of fuel starvation due to the pilot's inadequate fuel system management and failure to follow procedures and directives in the Pilot Operating Handbook listed by the manufacturer.NTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.NTSB DEN01LA137Accident · No injuriesLimited investigationFinal reportBeech A35 · Moab, UTthe pilot's failure to lower the landing gear resulting in a wheels up landing.NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.NTSB FTW01LA163Accident · No injuriesLimited investigationFinal reportBeech D35 · Houston, TXthe pilot's failure to maintain aircraft control during the takeoff roll.NTSB DEN01FA088Accident · 1 fatalField investigationFinal reportBeech 35 · Glenwood Sprgs, COthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…NTSB LAX01LA104Accident · No injuriesLimited investigationFinal reportSchneider, Edmund, Pty. Starduster SA300 · Chino Valley, AZThe pilot's inadequate preflight planning and his failure to dissiminate/coordinate the total distance required to successfully operate the airplane.NTSB NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…NTSB FTW00LA271Accident · No injuriesLimited investigationFinal reportTemco Luscombe 11A · Hammond, LAthe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A contributory factor was the fuel cap leak, due to a worn seal.NTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.NTSB CHI00LA222Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Oshkosh, WIthe pilot failed to maintain control of the airplane during flare/touchdown.NTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.NTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.NTSB CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.NTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.NTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB CHI99LA186Accident · No injuriesLimited investigationFinal reportNorth American Navion L-17A · Osceola, WIthe pilot's mismanagement of the fuel system in that he had the fuel selector positioned to a tank which did not contain sufficient fuel for the flight. Factors associated with the accident were the crop and the ditch which the airplane encountered during the…NTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.NTSB NYC99LA027Accident · 1 fatalLimited investigationFinal reportBeech C35 · London, KYThe pilot's inadequate start procedure in which he fail to secure the aircraft from movement during an attempt to handprop the engine.NTSB IAD99LA011Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · East Moriches, NYThe student pilot's failure to maintain adequate airspeed and the certified flight instructor's inadequate supervision.NTSB IAD99LA002Accident · No injuriesLimited investigationFinal reportNavion A · Jaffrey, NHThe pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.NTSB SEA98LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Christmasvalley, ORA jammed nose gear. A corroded cable and the failure of the owner to have an annual inspection performed on the airplane were factors.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.NTSB CHI98LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Gregory, SDthe pilot's not maintaining control of the airplane during landing.NTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.NTSB LAX98FA119Accident · Minor injuriesField investigationFinal reportBeech A35 · Auburn, CAfailure of the engine driven fuel pump drive coupling and the pilot's failure to perform the emergency procedure specified in the Pilot Operating Handbook.NTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…NTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.