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 ('1151504')
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 ('1151504')
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 CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR24LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Maricopa, AZThe pilot’s failure to properly configure the landing gear and verify its position before landing, which resulted in a gear-up landing.NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB ERA22LA146Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Waco, GAThe failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.NTSB CEN21LA405Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A35 · Morrilton, ARThe total loss of engine power for reasons that could not be determined based on available information.NTSB WPR20LA131Accident · 3 fatalClass 3 · LimitedFinal reportBeech 35 · Currie, NVThe pilot’s failure to maintain airplane control during a forced landing which resulted in a hard landing for reasons that could not be determined based on available evidence.NTSB WPR15FA212Accident · 2 fatalField investigationFinal reportBeech A35 · Mazama, WAThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance from mountainous terrain.NTSB WPR15CA033Accident · No injuriesData collectionFinal reportBeech A35 · Havasu City, AZLoss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.NTSB WPR11LA004Accident · 1 fatalLimited investigationFinal reportBeech A35 · Blue Diamond, NVThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.NTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.NTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.NTSB ATL05LA042Accident · 1 fatalLimited investigationFinal reportBeech 35 · Knoxville, TNThe pilot's failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with trees. A factor was dark night.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 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 DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.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 DEN01LA137Accident · No injuriesLimited investigationFinal reportBeech A35 · Moab, UTthe pilot's failure to lower the landing gear resulting in a wheels up landing.NTSB LAX01FA234Accident · No injuriesField investigationFinal reportBeech 35A · Linden, CAThe engine lost power for undetermined reasons.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 NYC99LA109Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Phillipsburg, OHFuel starvation to the engine due to the pilot's failure to switch fuel tanks.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 ANC98LA084Accident · Minor injuriesLimited investigationFinal reportBeech A-35 · Skagway, AKThe pilot's inadequate in-flight planning/decision to ensure the rudder pedals were locked in an operable position.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 FTW96LA196Accident · No injuriesLimited investigationFinal reportBeech A35 · Siloam Springs, ARthe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB FTW96FA048Accident · 1 fatalField investigationFinal reportBeech A35 · Hudson, COThe pilot's failure to maintain clearance. A factor was improper in-flight planning.NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.NTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB MIA94LA135Accident · No injuriesLimited investigationFinal reportBeech A35 · St. Petersburg, FLFailure of the pilot-in-command to maintain airspeed and proper glidepath resulting in the in-flight collision with trees short of the airport property.NTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.NTSB LAX93FA097Accident · 2 fatalField investigationFinal reportBeech A35 · Tulare, CAThe installation of an unapproved wing tip fuel tank system; an inadequate annual inspection which did not note, or correct, the unapproved fuel system addition; a wing tank fuel selector valve installation without adequate placards to show position or…NTSB SEA93LA019Accident · No injuriesLimited investigationFinal reportBeech A35 · Vancouver, WADesign stress limits of the aircraft were exceeded.NTSB BFO91DIA01Accident · Serious injuriesFinal reportHagaman Pitts Pitts S · Warrenton, VAThe pilot misjuded altitude and clearance above the terrain. Contributing to the accident was aerobatic maneuver performed at low altitude.NTSB LAX91LA150Accident · No injuriesLimited investigationFinal reportBeech A35 · Hilt, CAThe application of a sealant instead of a lubricant to the internal 'o' rings seals in the fuel selector by maintenance personnel. Factors contributing to the accident were the pilot's inability to select a fuel source and fuel starvation that resulted in an…NTSB LAX90LA247Accident · No injuriesLimited investigationFinal reportBeech A-35 · Santa Ynez, CAAn engine failure due to fuel leakage from a ruptured diaphram in the carburetor; failure of the aircraft owner to comply with the manufacturer's recommended component overhaul intervals.NTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…NTSB LAX89LA255Accident · No injuriesLimited investigationFinal reportBeech A35 · Hemet, CALoss of engine power for undetermined reasons.NTSB NYC89FA033Accident · 3 fatalField investigationFinal reportBeech A35 · Shirley, NYLoss of control during takeoff, due to the failure (separation) of the right rudder control cable. Contributing to the accident was improper inspection and maintenance of the cable.NTSB LAX88FA252Accident · 1 fatalField investigationFinal reportBeech A35 · Lompoc, CAPilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…NTSB CHI88DET02Accident · No injuriesFinal reportBeech A35 · Wheeler, INThe acft was being operated iaw a ferry permit to obtain an annual inspn. The prev annual inspn was on 3/13/85. Drg flt abt 1.3 hrs after takeoff, the eng lost pwr. The plt noted the fuel pres was zero. He said he turned on the aux fuel pump & insured the…NTSB LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…NTSB CHI88FA001Accident · No injuriesField investigationFinal reportBeech A35 · Grand Ledge, MIAfter rtrng fm a x-country flt, the plt was about to turn downwind to land when the eng began to lose power. He moved the fuel selector from the left main to the rgt main psn & pumped the wobble pump svrl times, but the eng did not restart. He then moved the…NTSB LAX87LA252Accident · No injuriesLimited investigationFinal reportBeech A35 · Santa Rosa, CAThe plt was participating in a cafe-400 (comparative acft flt efficiency) contest over a 400 mi, round robin course. While dscndg fm 7000' at the end of the flt, the plt slowed the acft to 140 mph to observe traffic. When clear, he increased the speed to 160…
Back to Beech A35