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 ('1151520')
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 ('1151520')
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 ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.NTSB WPR22LA247Accident · Serious injuriesClass 3 · LimitedFinal reportBeech H35 · LaCrosse, WAThe pilot’s failure to monitor and manage the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB CEN21LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech H35 · Watkins, COThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and a subsequent impact with an obstacle.NTSB WPR21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Santa Ynez, CAThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a total loss of engine power.NTSB WPR19LA223Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Ruidoso, NMThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate…NTSB WPR15LA139Accident · No injuriesLimited investigationFinal reportBeech H35 · Tucson, AZA partial loss of engine power during initial takeoff climb for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical anomaly that would have precluded normal operation.NTSB WPR15LA013Accident · No injuriesLimited investigationFinal reportBeech H35 · Bountiful, UTThe pilot's loss of directional control during a tailwind landing.NTSB CEN14LA273Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Monroe, LAThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.NTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…NTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.NTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN10LA433Accident · No injuriesLimited investigationFinal reportBeech H35 · Green Lake, WIA total loss of engine power during descent due to the overhaul facility’s inadequate maintenance.NTSB ERA09LA512Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Fredericksburg, PAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement of available fuel.NTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.NTSB CHI08CA236Accident · No injuriesData collectionFinal reportBeech H35 · Bay City, MIThe checklist not followed and the inadvertent wheels up landing by the pilot.NTSB NYC08FA056Accident · 1 fatalField investigationFinal reportBeech H35 · Warrenton, VAThe pilot's failure to follow the published instrument approach procedure and his failure to maintain the minimum descent altitude which resulted in collision with trees and terrain. Contributing to the accident were the night, instrument meteorological…NTSB LAX06FA197Accident · 2 fatalField investigationFinal reportBeech H35 · Reno, NVLoss of engine power during takeoff initial climb for undetermined reasons, which resulted in a loss of control and impact with a house. A contributing factor was the lack of suitable terrain for a forced landing.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB SEA05CA142Accident · No injuriesData collectionFinal reportBeech H-35 · Oregon City, ORThe unattended animal on the runway during the landing, which caused the pilot to pull up and land a second time, resulting in an overrun. A factor contributing to the accident was the inability to abort the landing due to obstacles at the end of the runway.NTSB MIA04CA080Accident · Minor injuriesData collectionFinal reportBeech H35 · Fort Pierce, FLThe pilots failure to maintain the proper glide path during the approach which resulted in the airplane undershooting the runway and not attaining the proper touchdown point.NTSB FTW04FA044Accident · 1 fatalField investigationFinal reportBeech H-35 · Mena, ARThe pilot's failure to maintain proper altitude and clearance from terrain. Contributing factors were the mountainous terrain, fog, clouds, and turbulence.NTSB ANC01LA080Accident · No injuriesLimited investigationFinal reportBeech H35 · Chitina, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and a downdraft.NTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA197Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Show Low, AZThe pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB FTW98FA339Accident · 2 fatalField investigationFinal reportBeech H35 · La Veta, COThe pilot's poor judgment by intentionally flying into instrument meteorological conditions without proper certification. Factors were his failure to obtain a weather briefing, and the existing weather conditions that included clouds, rain, and obscuration.NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.NTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.NTSB LAX97LA298Accident · No injuriesLimited investigationFinal reportBeech H35 · Vacaville, CAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.NTSB FTW96LA392Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Boulder, COa loss of engine power due to a plugged fuel tank vent which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.NTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.NTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.NTSB CHI92LA213Accident · No injuriesLimited investigationFinal reportBeech H35 · Baraboo, WIInadequate maintenance service and aircraft preflight by the pilot. A factor contributing to this accident was a partial failure of the brake system.NTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.NTSB LAX90LA178Accident · Serious injuriesLimited investigationFinal reportBeech H35 · San Marcos, CAThe pilot's improper fuel management.NTSB BFO90LA027Accident · No injuriesLimited investigationFinal reportBeech H35 · College Park, MDThe pilot's inadequate compensation for wind conditions. The adverse wind was a related factor.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…NTSB LAX88FA196Accident · 1 fatalField investigationFinal reportBeech H-35 · Phoenix, AZThe plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the…NTSB DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMNTSB FTW88FA032Accident · 3 fatalField investigationFinal reportBeech H35 · Port Mansfield, TXThe plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd…NTSB LAX87LA330Accident · No injuriesLimited investigationFinal reportBeech H35 · Avenal, CADuring a pleasure flight, the pilot noted that the oil pressure was reading low. The pilot decided to make a 180 degree turn to land at a nearby airport. En route the oil pressure continued to drop. During the first landing attempt the pilot stated the…NTSB ANC87LA111Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Nikolai Creek, AKThis pilot stated he did not fully understand crosswind operating procedures. When he encountered a crosswind during takeoff he allowed the aircraft to drift to the left off the runway and groundlooped.NTSB MKC87LA119Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Keokuk, IAThe PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another…NTSB ATL86IA167Incident · No injuriesIncident investigationFinal reportBeech H35 · Birmingham, ALDuring takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway.NTSB FTW86LA048Accident · No injuriesLimited investigationFinal reportBeech H35 · Talihina, OKAcft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power…
Back to Beech H35