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 ('1151510')
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 ('1151510')
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 GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB ERA16FA188Accident · 1 fatalField investigationFinal reportBeech D35 · Sevierville, TNThe pilot's failure to properly configure the landing gear and the pilot's inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and a subsequent loss of control of the airplane.NTSB ERA16LA062Accident · No injuriesLimited investigationFinal reportBeech D35 · Vine Grove, KYThe pilot’s failure to ensure that the fuel selector was properly positioned before takeoff, which resulted in the subsequent total loss of engine power due to fuel starvation.NTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…NTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.NTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.NTSB SEA07FA016Accident · 1 fatalField investigationFinal reportBeech D35 · Shelton, WAThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion, and his failure to maintain sufficient airspeed to avoid a stall during the subsequent forced landing. A factor associated with the accident is the inadvertent stall.NTSB ATL06WA036Accident · 2 fatalForeign investigationBeech D35 · Tierra Blanca, Costa RicaNTSB SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.NTSB ATL05FA139Accident · 1 fatalField investigationFinal reportBeech BE-D35 · Decatur, ALThe pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.NTSB CHI03LA021Accident · Serious injuriesLimited investigationFinal reportBeech D35 · Dodge Center, MNThe loss of engine power due to a fractured engine driven pump shaft pin. The low altitude and unsuitable terrain encountered were contributing factors.NTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB FTW01LA163Accident · No injuriesLimited investigationFinal reportBeech D35 · Houston, TXthe pilot's failure to maintain aircraft control during the takeoff roll.NTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.NTSB LAX00FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Agua Dulce, CAThe pilot's failure to maintain terrain clearance while cruising up a mountain pass, on a dark night, in IMC conditions, and his improper in-flight decision to perform a VFR flight in the inclement weather.NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.NTSB SEA98LA120Accident · No injuriesLimited investigationFinal reportBeech D35 · Driggs, IDExcessive pressure in the fuel control unit. A foreign material/substance found on the fuel system screens was a factor.NTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.NTSB SEA96FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Yellow Pine, IDfailure of the pilot to maintain adequate airspeed, while maneuvering in mountainous terrain, which resulted in a stall/spin and collision with terrain.NTSB SEA96LA121Accident · No injuriesLimited investigationFinal reportBeech 35 · Aurora, ORfailure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.NTSB FTW95LA180Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Mcgehee, ARThe pilot intentionally shutting down the airplane's engine. A factor was the pilot's improper maintenance procedures.NTSB LAX93FA335Accident · 2 fatalField investigationFinal reportBeech D-35 · Alpine, CAThe failure of the pilot to maintain direction control during the initial takeoff climb which placed an obstruction in the airplane's takeoff flight path and a subsequent inadvertent stall. A factor in the accident was the existing crosswind.NTSB LAX93LA134Accident · Minor injuriesLimited investigationFinal reportBeech D35 · San Manuel, AZThe pilot's improper use of carburetor heat. Contributing to this accident were weather conditions which were conducive to the formation of carburetor ice.NTSB LAX91LA073Accident · No injuriesLimited investigationFinal reportBeech D-35 · Bullhead City, AZLoss of directional control on the ground.NTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.NTSB ATL88LA057Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Monroe, GAThe Beech D35 was landing at a private airstrip from which it had departed fifteen minutes earlier. The final approach was to the south, into the sun. On short final the pilot looked down to verify that the gear was down. He looked outside again just in time…NTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…NTSB CHI84LA397Accident · No injuriesLimited investigationFinal reportBeech D 35 · Alexandria, MNThe acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced.NTSB DEN83LA220Accident · No injuriesLimited investigationFinal reportBeech D35 · St. Thomas, NDThe plt stated that after a flt to inspect farm fields he 'made an approach to the arpt and landed with the gear up.' He said he heard the gear warning as he crossed the threshold but interpeted it as a stall warning.NTSB SEA79FA057Accident · Serious injuriesClosedBeech D35 · Bellingham, WANTSB LAX79FA034Accident · 3 fatalClosedBeech D-35 · Los Angeles, CANTSB DEN78FTC19Accident · No injuriesClosedBeech D35 · Douglas, WYNTSB IAD78FA005Accident · 3 fatalClosedBeech D35 · Livingston, KYNTSB DEN77FA049Accident · 4 fatalClosedBeech D35 · Bakersville, CONTSB NYC77FFA25Accident · Minor injuriesClosedBeech D35 · Bloomingburg, NYNTSB OAK76DVA02Accident · No injuriesClosedBeech D35 · Sanger, CANTSB FTW75FPD26Accident · No injuriesClosedBeech D35 · Henrietta, TXNTSB FTW74DQD24Accident · No injuriesClosedBeech D35 · Marfa, TXNTSB MKC74FCJ45Accident · No injuriesClosedBeech D35 · Alliance, NENTSB CHI74AC033Accident · 1 fatalClosedBeech D35 · Aurora, WINTSB DEN73FTE28Accident · Serious injuriesClosedBeech D35 · Denver, CONTSB OAK73DXQ18Accident · No injuriesClosedBeech D35 · Truckee, CANTSB MIA73FLD14Accident · No injuriesClosedBeech D35 · St.Petersburg, FLNTSB NYC72FIJ43Accident · Minor injuriesClosedBeech D35 · Lebanon, VANTSB CHI72FEC33Accident · No injuriesClosedBeech D35 · Pontiac, MI
Back to Beech D35