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 ('1151512')
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 ('1151512')
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 ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.NTSB WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…NTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB ERA10LA014Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Mount Morris, NYThe pilot’s improper decision to take off from unsuitable terrain with a quartering tailwind.NTSB CEN09CA080Accident · No injuriesData collectionFinal reportBeech E35 · Bloomington, INA partial loss of engine power due to a failure of the number one cylinder exhaust valve, and the associated secondary damage to the intake valve and piston.NTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB SEA01LA115Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Eastsound, WAFailure of the engine driven fuel pump due to a worn snap ring which resulted in a loss of engine power during initial climb. Failure to comply with Service Bulletin inspection instructions, and collision with trees were factors.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB FTW98LA390Accident · No injuriesLimited investigationFinal reportBeech E35 · Fort Worth, TXThe pilot's failure to maintain aircraft control during takeoff initial climb. A factor was the pilot lifting off the aircraft prematurely.NTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…NTSB FTW96LA169Accident · No injuriesLimited investigationFinal reportBeech E35 · Albuquerque, NMa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff.NTSB NYC95LA159Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Pottsville, PAimproper installation of a fuel line fitting by the pilot/owner which resulted in fuel blockage and subsequent loss of engine power due to fuel starvation.NTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.NTSB FTW93LA013Accident · Minor injuriesLimited investigationFinal reportBeech V35E · Laguna, NMFailure of the pilot to select the proper fuel tank and resultant fuel starvation power loss. A factor was the unsuitable terrain.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.NTSB SEA86LA088Accident · Minor injuriesLimited investigationFinal reportBeech E-35 · Couger, WAWhile at cruise, the pilot intentionally ran one fuel tank dry. When the pilot attempted a restart by use of the wobble pump, the aircraft's engine would not start. The pilot made a forced landing into trees for lack of a more suitable landing site. The…NTSB NYC81FNE16Accident · No injuriesClosedPiper PA-28 · Gardner, MANTSB FTW81FA074Accident · 4 fatalClosedBeech E35 · Fay, OKNTSB ATL81FKW04Accident · Minor injuriesClosedBeech E35 · Chattanooga, TNNTSB SEA79FYM68Accident · No injuriesClosedCessna 172N · Clatskanie, ORNTSB LAX79IA055Incident · No injuriesClosedCessna 402 · Long Beach, CANTSB CHI79FEE49Accident · No injuriesClosedBeech E-35 · Deer Grove, ILNTSB MIA79FA048Accident · 1 fatalClosedBeech E35 · Brunswick, GANTSB DEN79FTE13Accident · No injuriesClosedBeech 35 · Greeley, CONTSB MKC78FCG13Accident · Minor injuriesClosedBeech E35 · Kirksville, MONTSB MKC78FA052Accident · 3 fatalClosedBeech E35 · Potosi, MONTSB OAK78FA005Accident · 4 fatalClosedBeech E35 · Willows, CANTSB OAK77DVA31Accident · No injuriesClosedBeech E35 · Turlock, CANTSB MIA77DLA22Accident · No injuriesClosedBeech 35 · Ft.Pierce, FLNTSB OAK76FVG79Accident · No injuriesClosedBeech E35 · Jackson, CANTSB MIA76FLA34Accident · No injuriesClosedBeech E35 · Live Oak, FLNTSB OAK75FXQ34Accident · Serious injuriesClosedBeech E35 · Truckee, CANTSB CHI75AC049Accident · 1 fatalClosedBeech E35 · Westland, MINTSB SEA75DYC19Accident · Minor injuriesClosedBeech E35 · Lagrande, ORNTSB OAK75FXQ15Accident · No injuriesClosedBeech E35 · Reno, NVNTSB MIA74DKJ60Accident · No injuriesClosedBeech E35 · Lacey Springs, ALNTSB MIA74DLD89Accident · No injuriesClosedBeech E35 · Lakeland, FLNTSB FTW74DRG86Accident · No injuriesClosedBeech E35 · Henly, TXNTSB MKC74AK006Accident · 3 fatalClosedBeech E35 · Alta, IANTSB IAD73DKM45Accident · No injuriesClosedBeech E35 · Spruce Pine, NCNTSB FTW73FPD38Accident · No injuriesClosedBeech E35 · Smithfield, TXNTSB CHI73FEM56Accident · No injuriesClosedBeech E35 · Iron River, MINTSB MKC73AK061Accident · 1 fatalClosedBeech E35 · Junction Cty, KSNTSB CHI73AC079Accident · 2 fatalClosedBeech E35 · Hanover, MINTSB NYC73AN113Accident · 4 fatalClosedBeech E35 · Marion, NC
Back to Beech E35