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 ('1151508')
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 ('1151508')
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 CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB WPR23LA283Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C35 · Rock Springs, WYMaintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.NTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.NTSB ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.NTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…NTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…NTSB CEN15LA436Accident · No injuriesLimited investigationFinal reportBeech C35 · Belen, NMThe total loss of engine power due to contamination in the fuel system.NTSB ERA15FA313Accident · 1 fatalField investigationFinal reportBeech C35 · Hicksville, NYThe pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…NTSB CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…NTSB CEN11LA173Accident · No injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe failure of the landing gear system for undetermined reasons.NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB CEN10FA458Accident · 3 fatalField investigationFinal reportBeech C35 · Rollinsville, COA loss of engine power for undetermined reasons.NTSB CEN09FA405Accident · 1 fatalField investigationFinal reportBeech C35 · Weslaco, TXThe pilot's failure to maintain aircraft control while operating with a fuel imbalance. Contributing to the accident was the pilot/owner's decision to fly the airplane outside of the operating limitations.NTSB CEN09CA307Accident · No injuriesData collectionFinal reportBeech C35 · Englewood, COThe collapse of the landing gear due to the mechanic's failure to properly wire the landing gear squat switch.NTSB LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB IAD05LA082Accident · No injuriesLimited investigationFinal reportBeech C35 · West Milford, NJThe pilot's failure to maintain directional control during landing, which resulted in a collision with a drainage ditch.NTSB LAX05LA208Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Pasadena, CAa fuel starvation induced loss of engine power due a failure of the electric fuel pump. A factor in the accident was the dark night lighting conditions.NTSB LAX05LA166Accident · No injuriesLimited investigationFinal reportBeech C35 · Rancho Santa Fe, CAfailure of the engine driven fuel pump due to the improper overhaul procedure of the fuel pump by an overhaul facility, and the use of parts that did not meet hardness specification.NTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB CHI04LA099Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Big Rapids, MIThe total loss of engine power due to the pilot's improper fuel management which led to fuel starvation.NTSB LAX03LA268Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Gerlach, NVa loss of engine power for undetermined reasons.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.NTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35C · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.NTSB CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.NTSB FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB NYC99LA027Accident · 1 fatalLimited investigationFinal reportBeech C35 · London, KYThe pilot's inadequate start procedure in which he fail to secure the aircraft from movement during an attempt to handprop the engine.NTSB LAX98LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Rio Linda, CAthe pilot's inadequate fuel management which led to fuel exhaustion.NTSB CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.NTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.NTSB LAX96FA119Accident · 1 fatalField investigationFinal reportBeech C35 · Lee Vining, CAFuel starvation due to the pilot's failure to adequate monitor the aircraft's fuel system and select a tank containing fuel in a timely manner. The pilot's failure to monitor the fuel system was due to the effects of hypoxia. Factors in the accident were the…NTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…NTSB CHI95FA305Accident · 1 fatalField investigationFinal reportBeech C35 · Omaha, NEthe pilot's failure to maintain airspeed during the takeoff climb. Factors associated with the accident were the pilot's inadequate compensation for the crosswind condition and exceeding the aircraft weight and balance.NTSB FTW95FA300Accident · Serious injuriesField investigationFinal reportBeech C35 · Plano, TXFuel starvation due to the improper position of the fuel selector, and failure the pilot to follow emergency procedures.NTSB NYC94WA183Accident · 1 fatalForeign investigationBeech C35 · Lake Erie, CanadaNTSB LAX94LA363Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Borrego Springs, CAThe pilot's inadvertent allowance of a fuel starvation loss of power event and his failure to select a tank containing fuel due to his lack of knowledge about the fuel pump/selector unit operating limitations. Factors in the accident were his limited…NTSB NYC94LA168Accident · No injuriesLimited investigationFinal reportBeech C35 · Rhinebeck, NYThe pilot's inadequate preflight planning and inaccurate fuel consumption calculations, resulting in fuel starvation and engine failure, and the subsequent collision with trees during a forced landing. A factor related to the accident was the turbulent air…NTSB BFO94FA043Accident · Serious injuriesField investigationFinal reportBeech C35 · Rockville, MDThe pilot's inadequate aircraft preflight inspection which resulted in a loss of engine power due to fuel contamination.NTSB MIA93FA200Accident · 1 fatalField investigationFinal reportBeech C35 · Ocklawaha, FLFailure of a propeller blade for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: low pass performed by the pilot, and his possible impairment from…NTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.NTSB FTW92FA202Accident · 1 fatalField investigationFinal reportBeech C35 · Leslie, ARPilot attempted VFR flight into IMC. Factors were fog, mountainous terrain, and the pilot's lack of instrument experience.NTSB MIA92LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Scottsmoor, FLEncounter with clear air turbulence during cruise flight.NTSB FTW92LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Henryetta, OKLoss of engine power for an unknown reason.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.
Back to Beech C35