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 ERA09CA117Accident · No injuriesData collectionFinal reportBeech G35 · Chattanooga, TNThe pilot's failure to see and avoid the marked helicopter dolly. Contributing to the accident were the dark night conditions.NTSB CEN09CA080Accident · No injuriesData collectionFinal reportBeech E35 · Bloomington, INA partial loss of engine power due to a failure of the number one cylinder exhaust valve, and the associated secondary damage to the intake valve and piston.NTSB NYC08LA306Accident · No injuriesLimited investigationFinal reportBeech G35 · Knoxville, TNThe pilot's improper fuel consumption calculations which resulted in total loss of engine power due to fuel exhaustion.NTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.NTSB NYC08LA164Accident · No injuriesLimited investigationFinal reportBeech G35 · New Smyrna Beach, FLThe pilot's inadvertent encounter with turbulence that was not forcast.NTSB SEA08LA012Accident · No injuriesLimited investigationFinal reportBeech F35 · San Carlos, CAA total loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB NYC08CA006Accident · No injuriesData collectionFinal reportBeech G35 · Lexington, SCThe pilot's inadequate fuel management.NTSB CHI07LA312Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Waterloo, IAThe pilot's failure to maintain adequate clearance from the trees and terrain during a night visual approach for landing. Contributing to the accident were the pilot's lack of recent night flying experience, the night conditions, and the trees.NTSB DFW07LA191Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Borger, TXA loss of engine power while on approach due to fuel starvation. Contributing to the accident were a corroded carburetor fuel needle valve, inlet fuel screen and no suitable terrain for the forced landing.NTSB CHI07FA182Accident · 2 fatalField investigationFinal reportNorth American Navion · Colona, ILThe non-instrument rated pilot's continued flight into instrument meteorological conditions.NTSB DEN07CA085Accident · No injuriesData collectionFinal reportBeech F-35 · Wheatland, WYThe pilot's inadequate soft field takeoff procedures and the low airspeed resulting in the airplane settling back to the ground.NTSB LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…NTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoNTSB LAX06CA139Accident · No injuriesData collectionFinal reportBeech G35 · Flagstaff, AZthe pilot's failure to maintain an adequate clearance with obstructions while taxiing.NTSB ATL06WA036Accident · 2 fatalForeign investigationBeech D35 · Tierra Blanca, Costa RicaNTSB SEA06LA004Accident · No injuriesLimited investigationFinal reportBeech G35 · Longview, WARuddervator flutter which resulted in the buckling of the empennage. The reason for the ruddervator flutter was undetermined.NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.NTSB SEA05LA103Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Emmett, IDThe partial loss of engine power during cruise flight as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a hardened and brittle fuel selector valve O-ring. Factors include no suitable landing area within the…NTSB IAD05LA030Accident · No injuriesLimited investigationFinal reportBeech G35 · Falmouth, MAThe pilot's failure to maintain control of the airplane during taxi. A factor was the snow-covered taxiway.NTSB DEN05FA012Accident · 2 fatalField investigationFinal reportBeech F35 · Chester, ARthe pilot's inadequate planning/decision which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were the pilot's failure to follow the briefing recommendation, fog, mist, and observation.NTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB MIA04FA023Accident · 3 fatalField investigationFinal reportBeech G35 · Okolona, MSThe pilot's intentional low altitude maneuver and buzzing resulting in collision with trees, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the pilot's ostentatious display.NTSB LAX03LA268Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Gerlach, NVa loss of engine power for undetermined reasons.NTSB NYC03FA148Accident · 2 fatalField investigationFinal reportBeech F-35 · Middlesboro, KYThe pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.NTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.NTSB CHI03LA067Accident · No injuriesLimited investigationFinal reportBeech BE-G35 · Urbana, ILThe partial failure of the left stabilizer in overload.NTSB LAX03LA082Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Middletown, CAThe pilot's failure to attain an adequate takeoff airspeed and failure to abort the takeoff when the lack of acceleration was apparent.NTSB FTW03FA067Accident · 1 fatalField investigationFinal reportBeech F-35 · Addison, TXThe pilot's mismanagement of the fuel supply by his failure to switch fuel tank positions which resulted in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA031Accident · No injuriesLimited investigationFinal reportBeech F-35 · Hollywood, FLThe pilot exceeded the design limits of the airplane which resulted in an in flight structural failure.NTSB LAX03LA024Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Santa Ana, CAThe pilot's encounter with wake turbulence resulting in a loss of control. A related factor was insufficient separation by air traffic control.NTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.NTSB SEA02LA116Accident · No injuriesLimited investigationFinal reportBeech G35 · Yakima, WAEmpennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.NTSB CHI02LA160Accident · Minor injuriesLimited investigationFinal reportNavion Navion A · Forest Lake, MNThe pilot not performing an aborted takeoff. The soft turf runway and power lines were contributing factors.NTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.NTSB NYC02LA093Accident · No injuriesLimited investigationFinal reportD'Apuzzo D-260 · Andover, NJThe pilot's failure to obtain proper runway alignment while landing, which resulted in a gear collapse.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB LAX02FA134Accident · 2 fatalField investigationFinal reportBeech G35 · Willows, CAthe pilot's entry into an abrupt maneuver at an excessive airspeed beyond Va, which resulted in exceeding the aircraft's design stress limits.NTSB FTW02LA129Accident · No injuriesLimited investigationFinal reportBeech F35 · Amarillo, TXFlutter due to the improper balance of the ruddervator, which resulted in structural damage to the aft fuselage.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB MIA01FA192Accident · 1 fatalField investigationFinal reportBeech BE-35-F35 · Bamberg, SCthe failure of the pilot to maintain airspeed, while attempting a forced landing following a loss of engine power for undetermined reasons, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain. A factor in this accident was…NTSB LAX01FA234Accident · No injuriesField investigationFinal reportBeech 35A · Linden, CAThe engine lost power for undetermined reasons.NTSB SEA01LA115Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Eastsound, WAFailure of the engine driven fuel pump due to a worn snap ring which resulted in a loss of engine power during initial climb. Failure to comply with Service Bulletin inspection instructions, and collision with trees were factors.NTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.NTSB CHI00LA238Accident · No injuriesLimited investigationFinal reportBeech BE-A35 · Poplar Bluff, MOthe pilot exceeded the VNE speed restriction of 144 MPH. Factors included the ruddervator flutter and the out of balance ruddervators.NTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.NTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.NTSB FTW00LA044Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Elk City, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.