NTSB investigations: Continental E225 series
513 cases on aircraft whose registry engine model is Continental E225 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 ('17015'))
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 ('17015'))
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 FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.NTSB DEN99LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Salida, COAn inadvertent stall during an aborted landing. A factor was the pilot's selection of the wrong runway for landing.NTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB FTW99LA093Accident · No injuriesLimited investigationFinal reportBeech G35 · Ennis, TXFlutter of the empennage for an undetermined reason, which resulted in damage to the aft fuselage.NTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.NTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.NTSB FTW98LA390Accident · No injuriesLimited investigationFinal reportBeech E35 · Fort Worth, TXThe pilot's failure to maintain aircraft control during takeoff initial climb. A factor was the pilot lifting off the aircraft prematurely.NTSB LAX98LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Rio Linda, CAthe pilot's inadequate fuel management which led to fuel exhaustion.NTSB MIA98FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech G35 · Missingundetermined.NTSB CHI98FA017Accident · No injuriesField investigationFinal reportBeech G35 · Poplar Grove, ILflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB FTW97FA292Accident · 2 fatalField investigationFinal reportBeech F35 · Richards, MOThe pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.NTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB MIA97LA134Accident · No injuriesLimited investigationFinal reportNavion A · Quincy, FLchafing of an electrical cable that was routed through the firewall, which resulted in electrical arching and an in-flight fire.NTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.NTSB FTW97LA118Accident · No injuriesLimited investigationFinal reportRyan Navion A · Hudson, COA total power loss due to fuel starvation as a result of the pilot's inadequate preflight inspection of the airplane and its fuel system. Factors include: the pilot's failure to refuel the airplane, the improper fuel tank selector position that would not…NTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…NTSB FTW96LA284Accident · No injuriesLimited investigationFinal reportBeech B35 · Portales, NMfailure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.NTSB CHI96LA219Accident · No injuriesLimited investigationFinal reportNavion NA1 · Evansville, INthe pilot did not maintain control of the aircraft during landing roll.NTSB SEA96LA121Accident · No injuriesLimited investigationFinal reportBeech 35 · Aurora, ORfailure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.NTSB IAD96LA047Accident · No injuriesLimited investigationFinal reportBeech F35 · Mt. Sterling, KYa loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.NTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…NTSB ATL95FA142Accident · 2 fatalField investigationFinal reportBeech 35F · Mt Dora, FLthe pilot's inadequate preflight planning/preparation by allowing the airplane's weight and balance to be exceeded, and his failure to maintain control of the airplane, while turning after takeoff, which resulted in an inadvertent stall.NTSB LAX95LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Tucson, AZthe pilot's failure to maintain adequate clearance from a taxiway sign while taxiing clear of the runway.NTSB NYC95FA049Accident · 1 fatalField investigationFinal reportBeech G35 · West Palm Beach, FLImproper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…NTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.NTSB SEA93LA217Accident · No injuriesLimited investigationFinal reportBeech G35 · Arlington, WAFracture of the left stabilizer spar.NTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.NTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.NTSB BFO93LA096Accident · No injuriesLimited investigationFinal reportRyan Navion · Cumberland, RILoss of engine power due to undetermined reasons. A factor related to the accident was rough and uneven terrain.NTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.NTSB LAX93LA191Accident · No injuriesLimited investigationFinal reportBeech F35 · Sandy Valley, NVThe pilot's failure to perform a preflight inspection of the airplane, and to assure that an adequate supply of fuel was on board the aircraft. This subsequently led to an inadequate fuel supply in the left tank, and fuel starvation. A factor related to the…NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB FTW92LA211Accident · No injuriesLimited investigationFinal reportBeech G35 · La Porte, TXThe loss of engine power for undetermined reasons. Factors were the dark night and the lack of suitable terrain available for the forced landing.NTSB MIA92LA021Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Okeechobee, FLOperation by the owner/pilot-in-command with known deficiencies in equipment and fuel starvation due to a blocked fuel line.NTSB FTW92LA012Accident · No injuriesLimited investigationFinal reportNorth American Navion · Denison, TXThe exceeding of the airplane's takeoff performance capability by the pilot's inadequate preflight preparation..NTSB SEA92FA001Accident · 1 fatalField investigationFinal reportNorth American Navion · Ola, IDAn incapacitating heart attack while in flight.NTSB CHI91FA090Accident · 1 fatalField investigationFinal reportBeech F.35 · Sidney, OHThe pilot's intentional VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's disregard for directives and overconfidence in his ability.NTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.NTSB SEA89LA151Accident · Minor injuriesLimited investigationFinal reportNavion A · Ely, NVImproper planning/decision by the pilot, which resulted in failure to obtain/maintain adequate airspeed to remain airborne after lift-off, and an inadvertent stall. Factors related to the accident were: the pilot's attempt to fly the aircraft with excessive…NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.NTSB NYC89FA029Accident · 3 fatalField investigationFinal reportRyan Navion A · Franklin, PADue to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the…NTSB MKC87FA163Accident · Serious injuriesField investigationFinal reportBeech 35 · Excelsior Spgs, MOAccording to witnesses, the pilot declared an emergency over the radio stating that the eng was losing power and that she was attempting an emerg lndg at Excelsior springs arpt. The pilot stated that she initiated a go-around, after the rwy was assured, due…NTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…NTSB FTW87LA023Accident · 2 fatalLimited investigationFinal reportNorth American Navion A · Springtown, TXThe pilot told rescue personnel that he had taken off with empty tanks selected. The engine quit, and the aircraft impacted the ground before he could restart. Initial reports of serious injury only, but both occupants expired two weeks later.NTSB ATL86LLT09Accident · No injuriesFinal reportBeech 35A · Nashville, TNThe student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his…NTSB NYC86LA245Accident · No injuriesLimited investigationFinal reportRyan-Navion A · Lakeport, NYThe rocker box cover on the #6 cylinder had the top and bottom screws loose and the center screw missing, causing oil to leak from the bottom of the rocker box cover.NTSB ATL86LA233Accident · No injuriesLimited investigationFinal reportBeech C35 · Akron, OHThe plt stated that one to two minutes after the fuel selector was changed from the right to left tank, the eng quit. The aux pump was turned on and fuel selector changed back to the right tank. Then to aux tank then back to left tank. The engine would not…