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 ('1151604')
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 ('1151604')
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 ATL95FA046Accident · 1 fatalField investigationFinal reportBeech A36 · Chamblee, GAThe pilot's failure to maintain aircraft control after becoming spatially disoriented. Factors relating to the accident were: the pilot's lack of proficiency (recent experience) in instrument flying, and improper approach control service by vectoring the…NTSB FTW95FA101Accident · 1 fatalField investigationFinal reportBeech A36 · Wallisville, TXFuel starvation due to improper positioning of the fuel tank selector, which resulted in loss of engine power. Factors related to the accident were: darkness and a lack of suitable terrain for the forced landing.NTSB BFO95LA019Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Montrose, PATotal loss of engine power for undetermined reasons.NTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.NTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.NTSB BFO94LA150Accident · No injuriesLimited investigationFinal reportBeech 36 · Georgetown, DEThe issuance of a NOTAM with inadequate information. Factors related to the accident were: the pilot's failure to attain the proper touchdown point, and the lack of visual cues concerning the construction barrier.NTSB LAX94LA338Accident · No injuriesLimited investigationFinal reportBeech A36 · So. Lake Tahoe, CAthe pilot's delayed decision to abort the takeoff when the performance deficiency first became apparent.NTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.NTSB LAX94FA232Accident · 2 fatalField investigationFinal reportBeech A-36 · Fullerton, CAthe pilot's lack of familiarity with the performance change of the airplane, and the lack of proper training/transition in the modified airplane. Contributing to the accident was inadequate substantiation process and insufficient review by the FAA; the…NTSB ATL94FA102Accident · 1 fatalField investigationFinal reportBeech A36 · Statesville, NCA LOSS OF CONTROL FOR UNDETERMINED REASON(s).NTSB CHI94FA089Accident · 5 fatalField investigationFinal reportBeech A36 · Grain Valley, MOThe instrument rated private pilot's inadvertent stall while circling to land. The weather was a factor.NTSB MIA94LA013Accident · 3 fatalLimited investigationFinal reportBeech A36 · Ormond Beach, FLPoor judgement of the pilot, due to consumption of alcohol and use of drugs, and his failure (or inability) to maintain altitude (or clearance) above water at night. Darkness was a related factor.NTSB FTW94LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Tomball, TXWas the pilot's disregard for and continued descent below mda and his delay in executing a go around.NTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.NTSB FTW93LA266Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe fuel leak which resulted from the mechanic's improper installation of the fuel line. A factor was the lead mechanic's inadequate post run up inspection.NTSB LAX93LA370Accident · No injuriesLimited investigationFinal reportBeech A-36 · Firebaugh, CAthe CFI's inadequate supervision of the flight and his delay in taking remedial action; the dual student's premature liftoff and improper use of the flight controls. The high vegetation and soft terrain were factors in this accident.NTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.NTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…NTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.NTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.NTSB DEN93FA032Accident · 2 fatalField investigationFinal reportBeech A36 · Englewood, COPower loss due to fuel exhaustion as a result of failing to refuel en route. Factors were: inaccurate fuel consumption calculations, lack of suitable terrain for a forced landing, lack of total experience in the type of aircraft being flown, and becoming lost…NTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingNTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.NTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.NTSB CHI93LA062Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Milwaukee, WIFailure of the pilot to perform an aborted landing and failure to select a proper touchdown point on the runway.NTSB MIA93LA034Accident · No injuriesLimited investigationFinal reportBeech A36 · Miami, FLThe pilot in command's inadvertent activation of the landing gear switch while attempting to raise wing flaps during landing rollout, resulting in collapse of the landing gear. Contributing to the accident was the pilot in command's diverted attention to the…NTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB MIA93LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Port St. Lucie, FLTotal loss of engine power due to fuel exhaustion caused by poor preflight planning preparation by the pilot in command.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.NTSB DEN92FA083Accident · 1 fatalField investigationFinal reportBeech A36 · Camden, ARAn inflight breakup of the aircraft when the pilot flew into a level three thunderstorm.NTSB LAX92LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Brawley, CAFuel starvation due to the pilot's; 1) failure to refuel the aircraft, 2) improper use of the fuel system, and 3) his delayed positioning of the fuel selector valve to a tank containing fuel. A factor in the accident was the pilot's failure to adhere to the…NTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…NTSB LAX92LA386Accident · 1 fatalLimited investigationFinal reportBeech A36 · Avalon, CAA loss of control due to pilot incapacitation for an undetermined reason(s).NTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.NTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.NTSB NYC92FA050Accident · 3 fatalField investigationFinal reportBeech A36 · Wilmington, OHThe failure of the pilots to maintain adequate terrain clearance. Factors which contributed to the accident were: the night conditions, reduced visibility due to fog, and the likelihood that the pilots diverted their attention to the operation of the loran…NTSB FTW92FA014Accident · 2 fatalField investigationFinal reportBeech A36 · Marble Falls, TXThe pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB CHI92FA009Accident · 2 fatalField investigationFinal reportBeech A36 · Lakeville, MNThe pilot-in-command's decision to continue flight into known adverse weather. Contributing to the accident was the encounter with weather conditions favorable for formation of airframe icing.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB FTW91FA088Accident · 4 fatalField investigationFinal reportBeech A36 · Lakeview, ARThe pilot's improper visual approach, and his failure to maintain an adequate visual lookout for obstructions. Factors were the unmarked power linesNTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB FTW91FA078Accident · 2 fatalField investigationFinal reportBeech A36 · Caldwell, TXThe pilot-in-command's failure to properly position the fuel selector handle resulting in a fuel starvation power loss. A factor was the inadvertent stall.NTSB FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.NTSB CHI91LA106Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ogallala, NEImproper planning/decision by the pilot and the lack of sufficient airspeed to maneuver (circle to land) in unfavorable wind conditions with structural ice on the aircraft. The adverse weather conditions and structural (wing) ice were related factors.
Back to Beech A36