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 ('1151532')
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 ('1151532')
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 WPR26LA236Accident · No injuriesClass 3 · LimitedPreliminary reportBeech S35 · Dome, AZOn June 25, 2026, about 1125 mountain standard time, a Beech S35, N6040F, sustained substantial damage when it was involved in an accident near Dome, Arizona. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA016Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Olympia, WAThe pilot’s inadvertent retraction of the landing gear after landing.NTSB CEN25LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Lowell, MIThe pilot’s failure to extend the landing gear before landing.NTSB WPR24LA317Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Watsonville, CAThe Yak-50 pilot’s failure to maintain clearance from another airplane while taxiing and maneuvering. Contributing to the accident was the pilot’s inattention due to a distraction inside the cockpit.NTSB CEN23LA379Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Houston, TXAn in-flight collision with a bird.NTSB ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA22FA001Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Andrews, NCThe pilot’s decision to fly toward rapidly rising, obscured mountainous terrain after departing under visual flight rules at night.NTSB WPR21FA353Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Billings, MTThe pilot’s improper flare, which led to a hard landing, subsequent loss of control, and collision with trees.NTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.NTSB GAA19CA358Accident · No injuriesData collectionFinal reportBeech 35 · Bowie, MDThe pilot's failure to extend the landing gear before landing.NTSB WPR19LA128Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sedona, AZThe partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.NTSB ERA19LA083Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Lexington, KYThe pilot's improper slip maneuver on final approach, which resulted in a total loss of engine power.NTSB ERA16LA003Accident · Serious injuriesClass 2 · LimitedFinal reportBeech S35 · Knoxville, TNThe pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.NTSB CEN15FA424Accident · 2 fatalField investigationFinal reportBeech S35 · Pagosa Springs, COImproper engine assembly by unknown maintenance personnel, which resulted in the failure of the No. 6 connecting rod due to oil starvation from the shifting of the crankshaft's No. 4 main bearing.NTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.NTSB ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.NTSB CEN14LA002Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Brownwood, TXA loss of engine power due to fuel starvation, which resulted from a foreign material in the fuel system blocking the fuel flow to the engine.NTSB WPR13CA422Accident · No injuriesData collectionFinal reportBeech 35 - Undesignat · Seattle, WAThe pilot's distracted attention and failure to extend the landing gear, which resulted in a gear up landing.NTSB CEN13LA072Accident · Serious injuriesLimited investigationFinal reportBeech S35 · DeRidder, LAA total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…NTSB CEN12FA271Accident · 2 fatalField investigationFinal reportBeech S35 · Lake in the Hills, ILThe pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.NTSB WPR12LA116Accident · No injuriesLimited investigationFinal reportBeech S35 · Dixie Valley, NVThe airplane’s encounter with forecast low-level windshear conditions during takeoff, which resulted in a loss of lift.NTSB CEN12LA074Accident · No injuriesLimited investigationFinal reportBeech S35 · Elkhart Lake, WIThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11FA090Accident · 2 fatalField investigationFinal reportBeech S35 · Chester, CAThe pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.NTSB WPR09CA438Accident · No injuriesData collectionFinal reportBeech S35 · Fallon, NVThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB CEN09LA446Accident · No injuriesLimited investigationFinal reportBeech S35 · Tuscola, ILThe pilot failure to maintain proper speed and distance during approach to land which resulted in landing long and subsequent runway excursion.NTSB CEN09CA342Accident · No injuriesData collectionFinal reportBeech S35 · Decatur, TXBoth pilots' inadequate preflight inspection and failure to identify the presence of dirt and insect larvae in the pitot tube, and the owner-pilot's attempt to turn off the runway and onto the taxiway at an excessive speed during the aborted takeoff.NTSB MIA08CA120Accident · Minor injuriesData collectionFinal reportBeech S35 · Creola, ALThe pilot's inadequate fuel calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB CHI07LA127Accident · No injuriesLimited investigationFinal reportBeech S35 · Brookfield, MOImproper maintenance by maintenance personnel by not properly torquing cylinder thru-bolts. The loose stud nuts which resulted in the separation of the cylinder and the crop and ditch were factors.NTSB NYC06FA230Accident · 1 fatalField investigationFinal reportBeech S35 · Lake City, FLA loss of control during an unintentional takeoff for an undetermined reason.NTSB DEN05LA088Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe flight instructor and pilot's improper decision to continue the attempted high altitude takeoff when Vy airspeed was not obtained, and failure to abort the takeoff which resulted in an off-field landing and subsequent impact with terrain. A contributing…NTSB DEN05LA086Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Broomfield, COthe pilot's failure to maintain adequate airspeed which resulted in a stall, and his failure to abort the takeoff. The loss of power for undetermined reasons is a contributing factor.NTSB CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB MIA03WA142Accident · 3 fatalForeign investigationBeech S-35 · San Vito Java, Costa RicaNTSB LAX03LA210Accident · No injuriesLimited investigationFinal reportBeech S35 · Weed, CAthe pilot's failure to maintain an adequate terrain/object clearance altitude.NTSB DEN03LA107Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe pilot's inadequate in-flight planning/decision in which he mismanaged his fuel supply by failing to switch tanks resulting in fuel starvation and the loss of engine power. A contributing factor was the pilot's diverted attention.NTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.NTSB IAD02FA075Accident · 1 fatalField investigationFinal reportBeech S-35 · Clear Spring, MDThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising terrain. Factors included dense fog and mountainous terrain.NTSB CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.NTSB LAX02LA233Accident · No injuriesLimited investigationFinal reportBeech S35 · St. Johns, AZThe pilot's failure to maintain airplane control following an encounter with a wind gust.NTSB LAX02FA212Accident · 3 fatalField investigationFinal reportBeech S35 · Ojai, CAthe pilot's inadequate in-flight planning and failure to maintain an adequate terrain clearance altitude within the canyon.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.NTSB DEN00FA175Accident · 2 fatalField investigationFinal reportBeech S35 · Longmont, COThe pilot/passenger's failure to maintain aircraft control, and the pilot in command's inadequate supervision of the flight. A factor was the pilot/passenger's lack of experience in aircraft type.NTSB NYC00FA039Accident · 3 fatalField investigationFinal reportBeech S35 · Newark, NJThe pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.NTSB FTW99LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Waxahachie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC98FA034Accident · 2 fatalField investigationFinal reportBeech BE-S35 · Chatham, MAThe pilot's failure to maintain adequate airspeed during initial climb which resulted in an inadvertent stall and subsequent impact into trees. Related factors were high wind and turbulence.NTSB FTW97LA025Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Jefferson, TXThe pilot's failure to attain the proper touchdown point, and his failure to maintain clearance from the fence. A factor was the fence post.NTSB LAX97LA020Accident · No injuriesLimited investigationFinal reportBeech S35 · Palo Alto, CAfuel starvation, due to the pilot's improper positioning of the fuel tank selector to an empty tank. Swampy terrain in the emergency landing area was a related factor.
Back to Beech S35