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 ('1151526')
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 ('1151526')
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 WPR25FA256Accident · 2 fatalClass 3 · FieldPreliminary reportBeech M35 · Des Moines, NMOn August 13, 2025, about 2300 mountain daylight time, a Beech M35, N951T, was destroyed when it was involved in an accident near Des Moines, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.NTSB CEN23FA074Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fayetteville, ARThe pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.NTSB WPR22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Henderson, NVThe flight instructor’s failure to verify the fuel quantity and improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.NTSB CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.NTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…NTSB WPR16FA065Accident · 3 fatalField investigationFinal reportBeech M35 · San Pedro, CAThe failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.NTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.NTSB CHI03LA288Accident · No injuriesLimited investigationFinal reportBeech M35 · Avon, ILThe pilot's inadequate fuel managemant leading to fuel starvation during cruise flight and the unsuitable terrain she encountered during the forced landing. A factor was her lack of total time in the airplane make and model.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB DEN02FA050Accident · 1 fatalField investigationFinal reportBeech M35 · Briggsdale, COcontrolled descent into terrain for reasons undetermined.NTSB FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX01FA186Accident · 1 fatalField investigationFinal reportBeech M35 · North Las Vegas, NVThe pilot/owner's failure to correctly install the oil filter, which resulted in oil exhaustion and a loss of engine power. Also causal was his attempt to modify the design of the oil filter element adapter by breaking the bond between the base and the…NTSB DEN00LA117Accident · No injuriesLimited investigationFinal reportBeech M35 · Los Alamos, NMThe pilot's misjudgment of distance/speed resulting in an overrun and subsequent collision with a blast fence. Contributing factors were high density altitude, a tailwind, and the blast fence.NTSB FTW00FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech M35 · Gulf Of Mexicothe pilot's continued flight of the airplane into known adverse weather conditions resulting in the pilot's loss of control of the aircraft. Contributing factors were the severe turbulence and windshear.NTSB DEN00LA048Accident · Serious injuriesLimited investigationFinal reportBeech M35 · Albuquerque, NMThe pilot inadvertently allowing the airplane to stall. Factors were the missing alternator belt and the resultant total electrical system failure, and the pilot's attention being diverted.NTSB FTW99LA003Accident · No injuriesLimited investigationFinal reportBeech M35 · Carter, OKFuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…NTSB LAX98LA136Accident · Minor injuriesLimited investigationFinal reportBeech M35 · North Las Vegas, NVfuel starvation due to the pilot's improper fuel management and his failure to select the fullest tank for landing.NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.NTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.NTSB CHI93LA360Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Marshfield, MOfuel exhaustion due to the failure of the fuel tank selector valve handle which prohibited the pilot from switching to a tank containing fuel.NTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.NTSB FTW90LA103Accident · No injuriesLimited investigationFinal reportBeech BE-35M · Tomball, TXAn engine failure due to detonation and subsequent piston overtemperature and erosion. A factor related to the accident was the lack of suitable terrain.NTSB CHI90FA108Accident · 1 fatalField investigationFinal reportBeech M35 · Romeo, MIA loss of control due to physical incapacitation (heart attack).NTSB LAX88LA207Accident · No injuriesLimited investigationFinal reportBeech M35 · Scottsdale, AZDuring the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke.NTSB LAX88DVM01Accident · No injuriesFinal reportBeech M35 · San Jose, CADuring a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…NTSB LAX86FA247Accident · Serious injuriesField investigationFinal reportBeech M35 · Swall Meadows, CAThe civil air patrol (cap) organized & provided instructors to teach cap mission plts techniques of 'high altitude' search flying during a 2-DAY course. The curriculum included making a landing approach to a 6080 ft elevation airstrip. The approach was to be…NTSB FTW86FA035Accident · 3 fatalField investigationFinal reportBeech M-35 · Valley View, TXThe non-instrument rated pvt plt received a wx briefing that called for marginal VFR to IFR conditions throughout his route of flt. Destination wx was briefed as 700' ovc, vis 2 miles in haze and fog and the en route wx was considerably worse. Several…NTSB MKC86LA041Accident · No injuriesLimited investigationFinal reportBeech M35 · Council Bluffs, IAThe acft made a gear-up forced lndg off the arpt after a loss of power during a business flt. The acft had only been airborne for about 15 minutes. Post accident investigation discovered that the acft fuel was contaminated with water.NTSB ATL84FA172Accident · 2 fatalField investigationFinal reportBeech 35 · Chesapeake, VAThe acft was being flown on a test flt after a new fuel pump had been installed. While taxiing for takeoff, the eng stopped. The plt restarted the eng & subsequently performed a takeoff. Witnesses saw the acft climb to about 500 ft AGL & begin a turn onto the…NTSB LAX84LA184Accident · No injuriesLimited investigationFinal reportBeech M35 · Santa Ana, CAThe plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…NTSB MIA83LA234Accident · No injuriesLimited investigationFinal reportBeech M35 · Bartow, FLDuring arrival, the plt had intended to reposition the fuel selector from the right main to the left main position. However, he left the selector positioned at the right main tank. While on final apch, the eng lost power. The plt activated the boost pump &…NTSB MKC83LA183Accident · No injuriesLimited investigationFinal reportBeech M35 · Sioux City, IAThe plt stated that the landing gear switch was down when he started tha takeoff roll. When the acft had accelerated to aprx 50 mph during the takeoff roll, the landing gear retracted/collapsed, nose wheel first, followed by the main gear. The plt stated that…NTSB MKC83FA061Accident · Serious injuriesField investigationFinal reportBeech M35 · Cedar Rapids, IAThe acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through…NTSB LAX82DA209Accident · No injuriesFinal reportBeech M35 · Coalinga, CAAs the pilot was arriving to an uncontrolled airport, he could see a group of planes on the runup pad at the approach end of the runway. As he continued with his arrival and approach, he radioed his intentions, but heard no transmissions from the departing…NTSB MKC82IA070Incident · No injuriesIncident investigationFinal reportBeech M35 · Ava, MODuring a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension…NTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…NTSB MKC82FCQ01Accident · Minor injuriesClosedBeech M35 · Garden City, KSNTSB MIA81FA123Accident · 1 fatalClosedBeech M35 · Lake Worth, FLNTSB NYC80FHA11Accident · No injuriesClosedBeech M35 · Somerville, NJNTSB FTW80DPD11Accident · No injuriesClosedBeech M35 · Wichita Falls, TX
Back to Beech M35