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 ('1151506')
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 ('1151506')
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 CEN26LA077Accident · No injuriesClass 4 · LimitedFinal reportBeech B35 · La Casa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb after takeoff, leading to an aerodynamic stall and impact with trees.NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.NTSB WPR19LA265Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Gresham, ORA total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.NTSB WPR19LA064Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Port Hadlock, WAA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB CEN15FA214Accident · Serious injuriesField investigationFinal reportBeech B35 · Orange, TXThe impact with power lines for reasons that could not be determined based on the available information.NTSB WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.NTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.NTSB CEN09LA170Accident · No injuriesLimited investigationFinal reportBeech B35 · La Luz, NMA loss of engine power due to fuel starvation as a result of a blockage in the right fuel tank vent.NTSB NYC08LA271Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Lockport, NYA partial loss of engine power, as reported by the pilot, for undetermined reasons. Contributing to the accident was the pilot's inadequate preflight planning and the overweight condition of the airplane.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 DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoNTSB SEA02LA152Accident · No injuriesLimited investigationFinal reportBeech B35 · Halfway, ORThe pilot's delay in initiating an aborted takeoff and his failure to establish climb out of ground effect. Contributing factors were the high aircraft weight and high density altitude as well as the fence and berm, which the aircraft struck.NTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.NTSB MIA96LA171Accident · No injuriesLimited investigationFinal reportBeech B35 · Kissimmee, FLthe pilot was operating the airplane at an indicated airspeed that exceeded the design speed for maximum gust intensity (VB), when clear air turbulence was encountered.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 CHI96LA235Accident · No injuriesLimited investigationFinal reportBeech B35 · Chesterfield, MOimproperly balanced ruddervators and improperly installed ruddervator (elevator) trim tabs, due to improper maintenance, which resulted in ruddervator flutter and substantial damage in the area of the aft fuselage. Factors relating to the accident were:…NTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.NTSB SEA94LA229Accident · No injuriesLimited investigationFinal reportBeech E-35 · Everett, WAThe nose gear extension assembly failure.NTSB CHI94LA281Accident · No injuriesLimited investigationFinal reportBeech B-35 · Boyceville, WIThe pilot-in-command's inadequate compensation for the existing wind conditions during the landing flare/touchdown. A factor was the gusty wind conditions.NTSB LAX94LA022Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Indian Springs, NVFailure of the pilot to properly operate the airplane's fuel selector, which resulted in fuel starvation, and his improper emergency procedure for restarting the engine. A factor related to the accident was: the pilot's lack of experience in this make and…NTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.NTSB MKC90LA073Accident · No injuriesLimited investigationFinal reportBeech B35 · Hartington, NEDirectional control not maintained by the pilot in command.NTSB SEA90FA021Accident · 2 fatalField investigationFinal reportBeech B35 · Bremerton, WAThe pilot's improper IFR procedure, his failure to maintain proper alignment on the ILS approach, and his failure to initiate a missed approached after reaching the lateral limits of the ILS system or decision height. Darkness and deteriorating weather were…NTSB CHI90FA019Accident · 1 fatalField investigationFinal reportBeech B35 · Clare, MIImproper preflight by the pilot by not assuring that the fuel selector was properly positioned, which resulted in fuel starvation, and the pilot's failure to maintain airspeed, which resulted in a stall/spin.NTSB LAX89LA282Accident · Serious injuriesLimited investigationFinal reportBeech B35 · San Diego, CALoss of engine power for undetermined reasons. Factors that related to the accident were: unavaliable altitude, remedial action not possible, unsuitable terrain, high vegetation, and the trees.NTSB SEA89LA119Accident · No injuriesLimited investigationFinal reportBeech B35 · Dallesport, WAThe premature rotatiion and liftoff by the pilot, which resulted in an inadvertent stall. A factor related to the accident was: the tailwind.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.NTSB ANC88FA037Accident · 1 fatalField investigationFinal reportBeech B35 · Nome, AKThe aircraft sustained an in-flight breakup during the enroute phase of the flight. The left fitting that secures the front spars of the stabilizers to the fuselage revealed the presence of pre-existing fatigue cracking. The initial separation of the left…NTSB CHI86FEM08Accident · Serious injuriesFinal reportBeech B35 · Paw Paw, MIOn takeoff at approx 100' the engine began to falter. The pilot did a 180 deg turn and landed about 1/2 way down the runway. After bouncing twice and seeing that he would probably run off the end, he performed a go-around. At a point near the end of the…NTSB MKC85LA106Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Harper, KSPlt stated rt wing dropped when acft was 4 to 5 ft AGL after liftoff. When plt corrected for low right wing, the acft over-corrected to the left. Acft was then completely uncontrollable and it veered left off the runway heading and mushedto the ground. After…NTSB LAX85FA100Accident · 4 fatalField investigationFinal reportBeech B-35 · Death Valley, CAThe plt got an extended wx fcst the day prior to departure which indicated bkn to ovc clouds based at about 8,000 ft for the first part of the trip & sct to bkn clouds for the last half. Mountain areas were predicted to be obscured. Plt was encouraged to call…NTSB LAX84FA048Accident · No injuriesField investigationFinal reportBeech B35 · Long Beach, CAThe plt reported that as he raised the landing gear during takeoff, the eng simultaneously lost power. He initiated an emergency landing on the remaining portion of the rwy. Acccording to him, the acft stalled while he was holding it in a nose high attitude &…NTSB CHI84LA023Accident · No injuriesLimited investigationFinal reportBeech B35 · Northfield, OHDuring takeoff, the acft collided with trees. According to the arpt manager, the acft was rotated prematurely during the takeoff & the plt flew the acft on the back side of the power curve until tree impact. Reportedly, there was no preimpact part failure or…NTSB LAX83IA342Incident · No injuriesIncident investigationFinal reportBeech B-35 · Fullerton, CAThe gear collapsed on the landing roll. Gear were found to be dry. Tge pilot had a gear flag but does not remember a green light.NTSB FTW83LA080Accident · No injuriesLimited investigationFinal reportBeech B35 · Canadian, TXThe acft collided with a tree during rollout after a forced landing following engine power loss on final approach. The pilot said he was one and a half miles out on final at 200 ft AGL when the engine quit. He was operating on the right main fuel tank. He…NTSB LAX83FVD03Accident · Serious injuriesFinal reportBeech B35 · Linden, CAThe aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel…NTSB FTW82DA272Accident · No injuriesFinal reportBeech B35 · Ft. Worth, TXThe pilot stated that while he was on final approach, he was carrying a little power since he was a little low. He stated that as the aircraft crossed the threshold, he reduced power and the plane yawed to the right. Subsequently, the aircraft headed toward a…NTSB ATL82FA089Accident · 3 fatalField investigationFinal reportBeech B35 · Louisville, KYThe aircraft crashed on approach during an attempted emergency landing. The aircraft had just departed and was returningbecause of smoke in the cockpit. The smoke was caused by an electrical short and arcing of wiring in the system. The loose wiring and worn…NTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…NTSB LAX82DA091Accident · No injuriesFinal reportBeech B35 · La Jolla, CADuring flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore.NTSB CHI81FEK24Accident · No injuriesClosedBeech B35 · Columbus, OHNTSB NYC81FHD21Accident · No injuriesClosedBeech B-35 · New London, PANTSB ATL81FA055Accident · 1 fatalClosedBeech 35 · Buckhannon, WV
Back to Beech B35