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 ('1151522')
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 ('1151522')
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 WPR24LA323AccidentClass 3 · LimitedPreliminary reportBeech J35 · Belgrade, MTOn August 27, 2024, about 1845 mountain daylight time, a Beech J35, N8350D, was substantially damaged when it was involved in an accident near Belgrade, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · 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 WPR20LA161Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Cascade Locks, ORThe pilot’s improper fuel tank selection which resulted in fuel starvation to the engine and a loss of engine power.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19LA024Accident · Minor injuriesLimited investigationFinal reportBeech 35 · State College, PAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18LA319Accident · No injuriesLimited investigationFinal reportBeech 35 · Knox, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR13FA288Accident · 1 fatalField investigationFinal reportBeech J35 · Helena, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB CEN10CA110Accident · No injuriesData collectionFinal reportBeech J35 · Russellville, ARThe pilot's improper engine starting procedures.NTSB ERA09TA466Accident · No injuriesFinal reportBeech J35 · Spartanburg, SCThe Cessna pilot's inadequate visual lookout.NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.NTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…NTSB NYC04FA036Accident · 3 fatalField investigationFinal reportBeech J35 · Somerset, KYA total loss of engine power during takeoff for undetermined reasons. A factor was the impairment of the pilot in command due to an over-the-counter antihistamine.NTSB MIA03LA169Accident · No injuriesLimited investigationFinal reportBeech 35J · Avon Park, FLThe failure of the pilot to maintain directional control during landing resulting in the airplane drifting to the right, encountering standing water on the runway edge, and running off the runway where it incurred substantial damage.NTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.NTSB LAX01LA247Accident · No injuriesLimited investigationFinal reportBeech J35 · Las Vegas, NVThe pilot's failure to comply with the airplane flight manual, resulting in fuel starvation and subsequent forced landing on rough terrain.NTSB ATL99FA134Accident · 2 fatalField investigationFinal reportBeech BE-35-J35 · Bartow, FLThe pilot's inadequate fuel management that resulted in the complete loss of engine power.NTSB SEA99LA169Accident · No injuriesLimited investigationFinal reportBeech J-35 · Union, ORDirectional control not maintained. A rough/uneven landing area was a factor.NTSB LAX99FA270Accident · Serious injuriesField investigationFinal reportBeech J35 · Marysville, CAA loss of engine power due to improperly torque cylinder base nuts by maintenance personnel during a top overhaul.NTSB FTW99LA126Accident · No injuriesLimited investigationFinal reportBeech J35 · Bass, ARThe pilot's failure to maintain aircraft directional control during landing roll on a gravel road. Factors were the clouds and low ceilings, the low fuel status, and the gravel road condition.NTSB LAX98FA086Accident · 1 fatalField investigationFinal reportBeech J35 · Morgan Hill, CAThe pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors.NTSB FTW98LA045Accident · No injuriesLimited investigationFinal reportBeech J35 · Provo, UTthe pilot's failure to properly position the fuel tank selector to a tank with adequate fuel, which resulted in fuel starvation, and a subsequent forced landing due to lack of engine power. His failure (or inability) to extent the gear for landing was a…NTSB LAX97LA116Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Morristown, AZfailure of the crankshaft due to improper inspection/overhaul procedures.NTSB LAX96LA286Accident · Serious injuriesLimited investigationFinal reportBeech J-35 · Lovelock, NVfuel starvation.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.NTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.NTSB DEN91LA107Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Tulsa, OKThe engine ailure for undetermined reasons. Factors were the light condition and the lack of suitable terrain.NTSB LAX91LA223Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Chinle, AZFuel starvation due to fuel mismanagement by the pilot in command.NTSB DEN91IA019Incident · No injuriesIncident investigationFinal reportBeech J-35 · Brighton, COThe failure of the engine fuel feed line resulting in a complete loss of power. Contributing to the incident was improper installation of the fuel feed transducer.NTSB DEN90FA170Accident · 2 fatalField investigationFinal reportBeech J35 · Santa Fe, NMFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB MKC90FA101Accident · 1 fatalField investigationFinal reportBeech J-35 · Pine Bluff, ARAircraft stall, from which recovery was not achieved.NTSB SEA89FA160Accident · 4 fatalField investigationFinal reportBeech J35 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.NTSB DEN88FA030Accident · 2 fatalField investigationFinal reportBeech J35 · Knolls, UTThe last comm with the flt was when the plt contacted elko radio and requested the salt lake city wx. He reported that he was at 11500 ft and VFR on top. The specialist on duty was unable to provide the wx info due to a computer sys outage but recommended…NTSB MIA86LA223Accident · No injuriesLimited investigationFinal reportBeech J35 · Bunnell, FLThe plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment.NTSB BFO86FA032Accident · Serious injuriesField investigationFinal reportBeech J-35 · Myersville, MDWhile in cruise flight at 3500 feet the pilot stated he experienced a rapid loss of power. Unable to restart the engine, he was forced to land in a pasture which was divided by barbed wire fences. The aircraft collided with a fence and came to rest inverted.…NTSB LAX86FUA01Accident · No injuriesFinal reportBeech J35 · Long Beach, CAThe acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…NTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…NTSB CHI85FA314Accident · 4 fatalField investigationFinal reportBeech J35 · Eden Prairie, MNThe plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left…NTSB DEN85LA072Accident · No injuriesLimited investigationFinal reportBeech J35 · Salt Lake City, UTThe pilot was practicing touch and go landings. He stated the landing gear collapsed during landing. Investigation revealed gear door damage (gear intransit) and ldg gear circuit breaker was 'popped.' Post accident exam of the gear system failed to reveal any…NTSB NYC84LA308Accident · No injuriesLimited investigationFinal reportBeech J35 · Hyannis, MAAprx 30 min after departure, according to the plt, the eng began running rough and stopped about 1 min later. The gear down forced landing was made in salt water aprx 6 mins from the dest arpt. Exam of the wreckage by FAA personnel revealed that the electric…NTSB ATL84LA260Accident · No injuriesLimited investigationFinal reportBeech J35 · Chesapeake, VAThe acft had not been flown for about 5 yrs. The plt, who was a mechanic, performed an eng ground run & the eng stopped after he noted a fuel flow problem. He examined the eng & found that the fuel injectors were clogged with corrosion. They were cleaned, &…NTSB MKC83FA128Accident · 4 fatalField investigationFinal reportBeech J35 · Knoxville, IAThe acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…NTSB MKC83LA119Accident · No injuriesLimited investigationFinal reportBeech J35 · Fulton, MOThe pilot stated that before landing he was having electrical problems and shortly after touchdown all three landing gear collapsed. The persons who removed and inspected the acft have stated that the damage to the landing gear doors consisted of…NTSB SEA83LA004Accident · No injuriesLimited investigationFinal reportBeech J35 · Friday Harbor, WAWhile on the takeoff roll, the engine was slow to accelerate, and just prior to rotation, it coughed and sputtered. The takeoff was abandoned, but the pilot was unable to stop the aircraft on the remaining runway. The aircraft penetrated the perimeter fence…
Back to Beech J35