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 ('1152740')
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 ('1152740')
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 FTW84FA104Accident · 4 fatalField investigationFinal reportBeech 58 · Marquez, NMThe acft was flown at altitudes up to 15000 ft in areas of forecast icing. The acft was not equipped with oxygen. The acft was flown above 14000 ft for about 20 minutes after which it descended into icing conditions. Shortly thereafter, the acft made a climb…NTSB ATL84LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Middlesboro, KYDuring arrival, the acft was landed with the landing gear retracted. An exam of the acft revealed no evidence of a preimpact malfunction or failure of the landing gear system.NTSB ATL83LA385Accident · No injuriesLimited investigationFinal reportBeech 58 · Birmingham, ALThe acft swerved off the rwy after the left tire deflated during heavy braking & the left landing gear collapsed during the swerve. The pilot stated the acft was rolling too fast after landing to make the first turn off. The pilot then applied heavy braking…NTSB NYC83FA253Accident · 1 fatalField investigationFinal reportBeech 58 · Arkville, NYPrior to taking off, the plt advised company personnel that he planned to fly vfr-on-top at 8500 ft MSL. He planned to depart at 1400 EDT, but did not specify his route of flt. When the acft did not arrive, a search was initiated, it was found where it had…NTSB ATL83LA362Accident · No injuriesLimited investigationFinal reportBeech 58 · Chamblee, GAThe acft ran off the departure end of the rwy after an aborted takeoff due to a cabin door opening. The CFI said that more than half the rwy remained when the throttles were retarded and the right door popped open at 91 mph. One attempt was made to close the…NTSB NYC83LA149Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Glens Falls, NYThe acft landed with the wheels up on a dual instructional flight. The flight had been doing air work before returning to glen Falls to continue training with takeoffs and landings. During the 1st landing the acft came over the threshold a little low but it…NTSB MIA83LA153Accident · No injuriesLimited investigationFinal reportBeech 58 · Clearwater, FLThe acft collided with a dirt mound and taxiway during landing to the left of the rwy. The plt stated that due to poor visibility caused by haze and the setting sun that he mistook a white line of sand as the centerline of the rwy. This line was left of the…NTSB FTW83LA188Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Little Rock, ARThe pilot reported that prior to glide slope interception he placed his hand on the landing gear selector switch and was simultaneously told to contact the tower, which he did. As the acft approached the threshold, the throttles were retarded and props pushed…NTSB CHI83LA117Accident · No injuriesLimited investigationFinal reportBeech 58 · Detroit, MIDuring arrival, the plt received vectors for an ILS approach. He elected to make a localizer only approach. At the outer marker, the acft was aprx 200 ft above the minimum altitude & above the approach speed. The plt reported that he reduced the airspeed…NTSB FTW83LA055Accident · No injuriesLimited investigationFinal reportBeech 58 · Lovington, NMThe pilot reported that while taking off with a light crosswind, the right passenger door opened. While trying to catch papers and hold the door, the right propeller struck the runway and the right main gear began collapsing. By this time, the pilot decided…NTSB FTW83FRG01Accident · 2 fatalFinal reportBeech 58 · Round Rock, TXBfr tkof, the plt obtained a wx briefing & filed an IFR flt plan. He tkof at aprx 0816 CDT. At aprx 0820, the acft was radar identified about 1 mi south of Round Rock, TX, heading eastbound. The plt was issued an IFR clnc, as filed, & was clrd to climb from…NTSB ATL83FA009Accident · No injuriesField investigationFinal reportBeech 58 · Allendale, SCAbout 30 min after departure, electrical equipment began to fail. The plt turned off the alternator & reset with no change. He then switched to the #1 regulator which did not correct the problem. While turning on downwind the gear handle was placed down & all…NTSB ATL82DA235Accident · No injuriesFinal reportBeech 58 · Birmingham, ALThe pilot stated that after a normal touchdown and a landing roll of 300-500 feet the gear retracted/collapsed. Subsequently, the entire landing gear system was ground checked and normal function of the system was found. The aircraft flaps were found in the…NTSB ATL82FKQ16Accident · No injuriesFinal reportBeech 58 · Madison, MSThe pilot reported that during flight, the right front door suddenly opened after light turbulence was encountered. The pilot followed the procedure, as prescribed by the owner's manual, to secure and close the door. As a precaution, he canceled the remainder…NTSB FTW82DA232Accident · No injuriesFinal reportBeech 58 · Oak Grove, LAThe pilot reported that during his landing roll, he intended to retract the flaps, but inadvertently rectracted the landing gear instead.NTSB FTW82FA103Accident · 6 fatalField investigationFinal reportBeech 58 · Magdalena, NMThe plt was advised of the icing conditions to be expected three different times during his wx briefing. At 1524 while enroute at 14,000 ft, the plt was advised of a PIREP of light to moderate icing between 14,O00 & 22,000 ft. the plt replied that was about…NTSB LAX82FUJ32Accident · 1 fatalFinal reportBeech 58 · Tucson, AZThe plt departed phoenix at 0045 for the third leg of a six leg bank run between phoenix & Tucson intl arpt. He was in contact with the phoenix TRACON during departure & was released at the toltec intersection (V16) at 5,500 ft. there was no further radio…NTSB FTW82DA083Accident · No injuriesFinal reportBeech B58 · Hot Springs, ARWhile on final approach to memorial airport the pilot stated that he heard another pilot announce that he was turning right base for landing on the active runway. The pilot on final became distracted while looking for the other aircraft and forgot to lower…NTSB LAX82FA048Accident · 2 fatalField investigationFinal reportBeech 58 · Cherry Valley, CAAt 0702 the plt received a weather briefing for a VFR flight to fresno. The area forecast contained flight precautions for obscured mountains & IMC in the sierra nevadas, and occassional moderate icing below 15,000 ft. the flight departed at 0728. The…NTSB ATL82FA033Accident · 1 fatalField investigationFinal reportBeechcraft BE-58 · Pinehurst, NCThe aircraft departed fulton county airport at 0306 EST and climbed to 13000 feet MSL. The flight was routine until approximately 0422 when the pilot of the unpressurized Beech 58 requested and was given a lower altitude. During the next 35 minutes the…NTSB LAX82FA032Accident · 3 fatalClosedBeech 58 · Elko, NVNTSB ATL82FA011Accident · No injuriesClosedBeech 58 · Selma, ALNTSB MIA82FA001Accident · 3 fatalClosedBeech 58 · Gainesville, FLNTSB ATL81DKG45Accident · No injuriesClosedBeech 58 · Savannah, GANTSB LAX81FA092Accident · 2 fatalClosedBeech 58 · Avalon, CANTSB FTW81DPG26Accident · No injuriesClosedBeech B58 · Benton, ARNTSB LAX81FA053Accident · 1 fatalClosedBeech 58 · Bisbee, AZNTSB MIA81FLD25Accident · No injuriesClosedBeech 58 · Clearwater, FLNTSB MKC80FCG34Accident · No injuriesClosedBeech 58 · Kansas City, KSNTSB DEN80FA033Accident · No injuriesClosedBeech 58 · Casper, WYNTSB LAX80AA087Accident · 4 fatalClosedBeech 58 · Salinas, CANTSB FTW80DA053Accident · Serious injuriesClosedBeech 58 · Houston, TXNTSB MIA80DA043Accident · 1 fatalClosedBeech 58 · Missing AircraftNTSB FTW80DRA16Accident · No injuriesClosedBeech 58 · Eagle Lake, TXNTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILNTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONTSB NYC80FA085Accident · 1 fatalClosedBeech 58 · Middletown, PANTSB IAD79FID20Accident · No injuriesClosedBeech 58 · Keysville, VANTSB MIA79FA071Accident · 2 fatalClosedBeech 58 · Boca Ration, FLNTSB CHI79FEE46Accident · No injuriesClosedBeech 58 · Lansing, ILNTSB FTW79FPG21Accident · No injuriesClosedBeech 58 · Fort Smith, ARNTSB MKC79FCA11Accident · Serious injuriesClosedBeech 58 · Chesterfield, MONTSB MIA79FA054Accident · 3 fatalClosedBeech 58 · Greenville, MSNTSB NYC79FA025Accident · Serious injuriesClosedBeech 58 · Oneonta, NYNTSB MIA79DKG19Accident · No injuriesClosedBeech B58 · Augusta, GANTSB NYC79FGM14Accident · No injuriesClosedBeech 58 · Beaver Falls, PANTSB NYC79FGM09Accident · No injuriesClosedBeech BE-58 · Beaver Falls, PANTSB MIA79DLA1ZAccident · No injuriesClosedBeech 58 · Cross Cty, FLNTSB FTW79FA016Accident · 3 fatalClosedBeech 58 · George West, TXNTSB CHI79FEG02Accident · No injuriesClosedBeech 58 · Cincinnati, OH
Back to Beech 58