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 ('1153408')
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 ('1153408')
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 ERA26LA071Accident · No injuriesClass 4 · LimitedFinal reportBeech D95A · Jasper, ALThe pilots’ failure to ensure that the airplane’s landing gear was extended before landing. Contributing was the flight instructor’s inadequate supervision during the landing approach.NTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.NTSB CEN17FA005Accident · 1 fatalField investigationFinal reportBeech D95A · Hitchcock, TXThe flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…NTSB ERA15LA202Accident · No injuriesLimited investigationFinal reportBeech D95 · Jacksonville, FLThe pilot's failure to properly configure the airplane for landing. Contributing to the accident were pilot fatigue, distraction, and complacency and the failure of the landing gear warning horn to sound for reasons that could not be determined based on the…NTSB ERA15FA023Accident · 1 fatalField investigationFinal reportBeech D95 · Bahama, NCThe pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…NTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.NTSB ATL06CA001Accident · Minor injuriesData collectionFinal reportBeech D-95A · Greensboro, NCThe pilot mistakenly shut down the operating engine when the passenger interfered with the rudder pedals as he attempted to identify the inoperative engine.NTSB ATL04CA101Accident · No injuriesData collectionFinal reportBeech D95A · Athens, GAThe pilot's misjudgment of airspeed and distance which resulted in an overshoot of the runway and collision with ground. The tailwind was a factor.NTSB LAX03FA078Accident · 2 fatalField investigationFinal reportBeech D95A · Lancaster, CAa loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.NTSB DEN02LA104Accident · No injuriesLimited investigationFinal reportBeech D95A · Broomfield, COthe dual student pilot's inadvertent retraction of the landing gear. Contributing factors included the dual student's lack of familiarity with the airplane, and inadequate supervision by the flight instructor.NTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.NTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.NTSB DEN99LA090Accident · No injuriesLimited investigationFinal reportBeech D95A · Englewood, COThe collapse of the right main landing gear during landing due to a fatigue crack, in the strut, which had an undetermined origin.NTSB LAX99LA124Accident · No injuriesLimited investigationFinal reportBeech D95A · Dillingham, HIThe student's failure to maintain aircraft control in the gusty crosswind conditions due to limited left yaw authority induced by the simulated single engine approach. The flight instructor's inadequate supervision of the flight and his failure to terminate…NTSB FTW98LA375Accident · No injuriesLimited investigationFinal reportBeech D95A · Albuquerque, NMThe pilot's inadvertent raising of the landing gear during landing rolloutNTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.NTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.NTSB LAX94LA340Accident · 1 fatalLimited investigationFinal reportBeech D95A · Oakdale, CAImproper in-flight planning/decision by the flight instructor (CFI), and the cfi's inadequate supervision by not assuring that the minimum control speed (VMC) was maintained. A factor related to the accident was: the cfi's lack of experience in multi-engine…NTSB LAX94LA040Accident · No injuriesLimited investigationFinal reportBeech D95A · Hollister, CAThe improper position of the fuel selector switch by the dual student during the before landing checklist and inadequate supervision by the CFI. Fuel starvation to both engines was a factor in this accident.NTSB MIA90LA141Accident · No injuriesLimited investigationFinal reportBeech D95A · Mayaguez, PRThe pilot failed to property align the aircraft with the runway. A factor in the accident was the strong, gusty crosswind.NTSB LAX88FA134Accident · 3 fatalField investigationFinal reportBeech D95A · Santa Maria, CAFailure of the pilot to adequately compensate for the loss of power in the left engine and to maintain control of the aircraft.NTSB NYC87FA265Accident · 1 fatalField investigationFinal reportBeech D95A · Pittstown, NJPilot departed runway 26 at alexandria arpt toward trees in fog. Left wing hit trees. Acft landed hard collapsing landing gear. Acft hit a tree in area of pilot seat during lndg fatally injuring the plt.NTSB DCA82AA023Accident · 5 fatalFinal reportBeech D95A · Columbia, MDThe acft was vectored to intercept the localizer course for an ILS approach to rwy 10 at balt-wash-intl arpt. It was then observed to fly through & to the north of the localizer course. The acft was then directed to turn left to a heading of 360 for…NTSB MIA79FA064Accident · 1 fatalClosedBeech D95A · Davie, FLNTSB DEN79FQA11Accident · No injuriesClosedBeech D95A · Roswell, NMNTSB MKC78FA022Accident · 1 fatalClosedBeech D95A · Amidon, NDNTSB NYC78FA013Accident · 2 fatalClosedBeech D95A · Richland, PANTSB NYC77FFJ07Accident · No injuriesClosedBeech 95A · Buffalo, NYNTSB CHI76FEK01Accident · Minor injuriesClosedBeech D95A · New Knoxville, OHNTSB NYC75FHA13Accident · No injuriesClosedBeech D95A · Pittstown, NJNTSB SEA75AS002Accident · 4 fatalClosedBeech D95A · Anacortes, WANTSB OAK74AP055Accident · 3 fatalClosedBeech D95A · Novato, CANTSB FTW74AF071Accident · 2 fatalClosedBeech D95A · Sherman, TXNTSB IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDNTSB IAD74II009Incident · No injuriesClosedBeech D95A · Sparks, MDNTSB MKC73FCJ26Accident · No injuriesClosedBeech D95A · North Platte, NENTSB NYC72AN140Accident · Minor injuriesClosedBeech B95 · Atlantic City, NJNTSB NYC72AN117Accident · Serious injuriesClosedBeech D95A · Portsmouth, VANTSB MIA71FLA05Accident · No injuriesClosedBeech D95A · Panama City, FLNTSB MIA71FKJ43Accident · No injuriesClosedBeech D95A · Birmingham, ALNTSB NYC71FFD24Accident · No injuriesClosedBeech D95A · Norwood, MANTSB MIA71FLG19Accident · No injuriesClosedBeech D95A · Hampton, SCNTSB MKC71FDM33Accident · Serious injuriesClosedBeech D95A · Jacobson, MNNTSB MIA70AM071Accident · 3 fatalClosedBeech D95A · Duluth, GANTSB LAX70A0033Accident · 2 fatalClosedBeech D95A · Big Sur, CANTSB MKC70D0244Accident · No injuriesClosedBeech D95-A · Buffalo, MNNTSB SEA70A0008Accident · 3 fatalClosedBeech D95A · Livingston, MTNTSB MKC68D0537Accident · No injuriesClosedBeech D95A · Kansas City, MONTSB DIA68F0110Accident · No injuriesClosedBeech D95A · Greensboro, NCNTSB OAK68F0062Accident · Serious injuriesClosedBeech D95A · Cholame, CA
Back to Beech D95A