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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('1151502')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1151502')
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 CEN25LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35 · Cedarcreek, MOThe student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…NTSB CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Wauchula, FLThe pilot’s failure to maintain directional control after landing. A contributing factor was a degraded left main landing gear wheel assembly.NTSB CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.NTSB CEN21LA167Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Bridgeport, TXThe pilots’ failure to maintain adequate airspeed during a simulated power-off approach in gusting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and loss of control.NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.NTSB ERA17LA347Accident · No injuriesLimited investigationFinal reportBeech 35 · Marathon, FLA total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.NTSB CEN15LA183Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Gordonville, TXThe pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…NTSB CEN12CA625Accident · No injuriesData collectionFinal reportBeech 35 · Geary, OKThe student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…NTSB CEN12FA196Accident · 3 fatalField investigationFinal reportBeech 35 · Glencoe, MNThe non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.NTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.NTSB CEN10CA231Accident · No injuriesData collectionFinal reportBeech 35 · Boulder, COThe pilot's failure to maintain directional control while landing in a crosswind.NTSB CEN09LA501Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Oklahoma City, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB WPR09CA387Accident · No injuriesData collectionFinal reportBeech 35 · St. Johns, AZThe pilot’s inadequate compensation for the crosswind gust and failure to maintain directional control of the airplane during the takeoff. Contributing to the accident was the gusty crosswind weather conditions.NTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…NTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.NTSB DEN03FA157Accident · 1 fatalField investigationFinal reportBeech 35 · Belen, NMThe pilot's failure to maintain aircraft control immediately after takeoff due to spatial disorientation. A factor was the dark night light conditions.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 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 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 FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.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 CHI00LA222Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Oshkosh, WIthe pilot failed to maintain control of the airplane during flare/touchdown.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 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 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 IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.NTSB LAX98LA243Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Temecula, CAA partial loss of engine power due to a disconnected throttle linkage, which was the result of an inadequate maintenance installation/inspection.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 IAD97LA099Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Wadsworth, OHThe pilot's failure to retard the engine throttle to idle during the landing roll. A related factor was the diverted attention.NTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.NTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB CHI96LA274Accident · No injuriesLimited investigationFinal reportBeech 35 · Yankton, SDan improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…NTSB SEA96LA181Accident · No injuriesLimited investigationFinal reportBeech 35 · Spokane, WAfailure (cracking) of the aft fuselage bulkhead for undetermined reason(s).NTSB SEA96LA058Accident · No injuriesLimited investigationFinal reportBeech 35 · Laurel, MTthe pilot's failure to extend the landing gear. Factors related to the accident were: an inoperative gear warning system, the dark night, and the pilot's failure to follow the checklist.NTSB FTW96FA119Accident · 2 fatalField investigationFinal reportBeech 35 · Allenspark, COAircraft control not maintained by the pilot in command for reasons undetermined.NTSB BFO95LA077Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Paintersville, OHThe pilot's continued VFR flight into instrument meteorological conditions. Factors related to the accident were: the pilot's failure to obtain a weather briefing, and the weather conditions.NTSB SEA95LA092Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bliss, IDThe pilot's continued VFR flight into instrument meteorological conditions. Factors include low ceiling, rain and fog.NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.NTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB FTW94LA189Accident · No injuriesLimited investigationFinal reportBeech 35 · Mckinney, TXThe ailerons being locked by a foreign object.NTSB FTW94LA056Accident · No injuriesLimited investigationFinal reportBeech 35 · Crystal Beach, TXWas a total loss of engine power for undetermined reasons. Factors were a passenger door inadvertently opening in flight due to inadequate preflight by the pilot, unsuitable terrain for the forced landing, and carburetor icing conditions.NTSB MIA93FA190Accident · Serious injuriesField investigationFinal reportBeech 35 · Frisco, NCThe pilot's failure to maintain airspeed (vso) resulting in a stall/mush. Contributing to the accident was the near total loss of engine power due to separation of one of the two counterweights for undetermined reasons.NTSB NYC93FA005Accident · 3 fatalField investigationFinal reportBeech 35 · New Manchester, WVThe pilot's failure to obtain adequate airspeed and abort the takeoff. The pilot's premature rotation, upsloping runway, and a tailwind are contributing factors.NTSB LAX92FA188Accident · 3 fatalField investigationFinal reportBeech 35 · Reno, NVThe pilot's poorly planned approach to compensate for the existing wind conditions, and his failure to maintain adequate airspeed.NTSB DEN92FA028Accident · No injuriesField investigationFinal reportBeech 35 · Nucla, COImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB SEA92LA027Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Klamath Falls, ORPilot factor in that he failed to follow IFR procedures. Factors to the accident were generator failure, operation with known deficiencies with equipment, and poor inflight planning.
Back to Beech 35