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 LAX92WA284Accident · 3 fatalForeign investigationBeech 58 · Ensenada, MexicoNTSB MIA92LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · West Palm Beach, FLPartial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.NTSB ATL92FA013Accident · Serious injuriesField investigationFinal reportBeech 58 · Pelham, ALThe pilot's failure to correct the position of the fuel selector before takeoff, and her inattentiveness to fuel consumption during the flight, which resulted in fuel starvation. Factors were the non-performance of engine out emergency procedures and the…NTSB NYC91FA212Accident · 1 fatalField investigationFinal reportBeech 58 · Brookhaven, NYPilot physiological incapacitation which resulted in a loss of control in flight, and an uncontrolled descent into water.NTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.NTSB MIA91LA080Accident · No injuriesLimited investigationFinal reportBeech 58 · St. ThomasExcessive descent rate by the pilot, improper recovery from the bounced landing, and failure to recover from the porpoise condition.NTSB NYC91FA073Accident · 2 fatalField investigationFinal reportBeech BE-58 · Skaneateles, NYThe pilot's loss of situational awareness/disorientation due to the influences of cocaine, which resulted in the loss of airplane control in instrument meteorological conditions. Factors related to the accident were: psychological impairment, fatigue and…NTSB NYC91LA064Accident · 1 fatalLimited investigationFinal reportBeech 58 · Batavia, NYThe failure of the pilot to ensure an adequate amount of fuel was on board for the planned flight which resulted in a double power loss due to the fuel exhaustion.NTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NTNTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.NTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesNTSB NYC90LA150Accident · Serious injuriesLimited investigationFinal reportBeech BE-58 · St. Albans, VTFlight into trees while recovering from an inadvertent spin after a pilot used incorrect procedures during a simulated engine failure below VMC and the instructor pilot delayed the corrective actions.NTSB FTW90FA097Accident · 1 fatalField investigationFinal reportBeech 58 · Dallas, TXThe pilot's improper use of the fuel boost pumps for take, and his failure to maintain airspeed above the minimum single engine control speed (VMC), which resulted in a loss of aircraft control.NTSB ATL90FA070Accident · 2 fatalField investigationFinal reportBeech 58 · Demorest, GAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions. Contributing factors were: the pilot's overconfidence, lack of recent flight experience, and the weather conditions.NTSB MIA90FA064Accident · 2 fatalField investigationFinal reportBeech 58 · Pensacola, FLIn flight loss of control for undetermined reasons.NTSB FTW90FA015Accident · No injuriesField investigationFinal reportBeech 58 · San Antonio, TXA fuel tank leak, arcing from the exterior lighting system, and failure of company/maintenance personnel to comply with an airworthiness directive (AD).NTSB NYC90LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Philadelphia, PAThe failure of the pilot of N333TQ to taxi at a speed that would allow him to stop under existing conditions of visibility and taxiway conditions.NTSB CHI89FA128Accident · 3 fatalField investigationFinal reportBeech 58 · Battle Creek, MIThe flight crew inadvertently shut down the left engine after the right engine lost power, and the copilot failed to maintain control of the aircraft while maneuvering the aircraft back toward the runway. Factors related to the accident were: improper…NTSB MKC89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Brainerd, MNThe pilot's failure to follow procedures which resulted in the failure to extend the landing gear prior to touchdown. A contributing factor was the pilot's inattentiveness.NTSB MKC89FA061Accident · 2 fatalField investigationFinal reportBeech 58 · Hamburg, ARThe pilot continued VFR flight into IMC conditions and failed to maintain sufficient altitude above the wooded terrain. Weather conditions, low light conditions at or near dusk, lack of visual cues (visual perception) by the pilot, and trees were contributing…NTSB ATL89LA077Accident · No injuriesLimited investigationFinal reportBeech 58 · Walnut Cove, NCThe pilot made the landing approach too high and too fast for the available runway, and failed to abort the landing. The fence was a related factor.NTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…NTSB DEN89LA014Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Garfield, CON31135 was being ferried to japan from wichita with an enroute stop in oakland, CA. The acft was equipped with cabin mounted ferry tanks. The plt stated that he switched from the acft fuel tanks to the ferry tank and about 20 minutes later the right eng quit.…NTSB MKC88FA037Accident · No injuriesField investigationFinal reportBeech 58 · Dewitt, ARThe pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,…NTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…NTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…NTSB MIA88IA052Incident · No injuriesIncident investigationFinal reportBeech 58 · Vicksburg, MSWhile on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction.NTSB BFO87FA065Accident · No injuriesField investigationFinal reportBeech 58 · Baltimore, MDDuel alternator failure occurred abt 13 min aft dept. The acft returned and lndd uneventfully. However, while taxiing back to the maint hgr the plt failed to follow the marked taxiway and collided with a ditch. Construction was taking place on the arpt and…NTSB MKC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58 · Arkansas City, KSDuring ldg roll, following a personal flight, the acft had a failure of the left main gear tire. The PIC said the acft began violently shaking and wobbling followed by collapse of the left main lndg gear. The acft swerved off the runway and incurred…NTSB MKC87LA134Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Benton, ARDuring a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated.NTSB ATL87FA161Accident · No injuriesField investigationFinal reportBeech 58 · Atlanta, GAThe two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…NTSB FTW87IA097Incident · No injuriesIncident investigationFinal reportBeech 58 · Bridgeport, TXDuring cruise flight, the aircraft's right engine caught fire. The pilot shutdown the engine and feathered the prop, extinguishing the fire. The pilot declared an emergency with ATC and landed safely at an alternate airport, with only minor damage to the…NTSB MKC87LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Houston, MOThe airplane was on an IFR flight plan and five miles from the airport, the airplane broke out of the clouds and proceeded VFR to the airport. It was a dark night and light rain was falling. The pilot stated he flew over the airport twice looking for a wind…NTSB DEN87LA062Accident · No injuriesLimited investigationFinal reportBeech 58 · Bismarck, NDThe plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…NTSB DEN86LA255Accident · No injuriesLimited investigationFinal reportBeech B58 · Fargo, NDThe pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps.NTSB CHI86LA168Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INThe aircraft landed gear up at Indianapolis international airport. Pilot and witness report that gear was down. However, FAA inspectors and mechanics who inspected the aircraft state that the left main and nose gear were found in the wheels wells and the…NTSB CHI86LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt stated his left brake failed during landing roll on the 3,200 ft long rwy. The landing was made with a 20 deg right quartering 10 knot tailwind. To prevent running off the departure end of the rwy in to a 50 ft dropoff, the plt ground looped the acft…NTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…NTSB CHI85LA195Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt was practicing touch-&-go landings on rwy 13, then elected to make another on rwy 5. He stated that the gear was extended on downwind & a safe gear indication was received. However, the acft was landed with the gear retracted. The plt stated that…NTSB CHI85FA138Accident · 1 fatalField investigationFinal reportBeech 58 · Chicago, ILThe Beech 58 plt was returning at ngt when traffic was very light. After lndg, the acft was retained on local control (lc) freq for the plt's convenience. The plt requested clnc to the twa hangar & was cleared on the most expeditious route. This route went…NTSB ATL85LA095Accident · No injuriesLimited investigationFinal reportBeech 58 · Natchez, MSPlt descended below mda to 720 ft MSL until observing the rwy during a LOC 17 apch at night. An arpt attendant said plt did not call UNICOM for wind info. Plt acknowledged touchdown at midfield with a 30 kt tailwind on the 5000 ft rwy. The plt said braking…NTSB CHI85LA095Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INPlt stated the landing gear was lowered on final apch at an airspeed of 148 KTS and a gear down & locked indication was received. Plt continued to state the acft settled closer to the rwy then usual during the landing flare and when the acft was nearing a…NTSB CHI85LA092Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Lafayette, INPlt diverted due to icing/unfavorable wx at dest. Plt stated the windshield iced over during the apch at purdue university arpt (the alternate) and he flared high resulting in a hard landing.NTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…NTSB CHI85LA090Accident · No injuriesLimited investigationFinal reportBeech 58 · Hayward, WIThe acft sustained subst damage after uncontrolled contact with the rwy during landing. Investigation revealed that the landing was inadvertently attempted at a time when the winds shifted to a direct x-wind with gusts to 35 KTS.NTSB BFO85FA001Accident · 2 fatalField investigationFinal reportBeech 58 · Hot Springs, VAThe destn arpt was unattended at night & when the plt received his last wx briefing at 0519 CDT, no current wx info was available. During arrival, the acft was vectored for an ILS rwy 24 apch & the plt was advised that current wx info was still not available.…NTSB ATL84LA279Accident · No injuriesLimited investigationFinal reportBeech 58 · Laurens, SCThe acft ran off the end of the rwy during landing. The plt reported that he started using brakes to stop the acft but it veered to the right. Examination by maintenance revealed that the left brake disc, p/n 164-06100, had failed at the mount flange.NTSB MKC84LA266Accident · No injuriesLimited investigationFinal reportBeech BE 58 · Bridgeport, NEPlt initiated take-off from rough, 2800 ft sod strip in light wind conditions and known high density alt situation. Slight back yoke pressure was being used during takeoff roll to moderate effect of rough surface on nose gear. Additional back pressure was…NTSB CHI84LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Iron Mountain, MIThe plt reported that after he made a normal landing, he retracted the gear instead of the flaps. However, there were indicates that the gear was not fully extended during touchdown. The landing gear circuit breaker was found popped. The landing gear safety…NTSB NYC84FA142Accident · 1 fatalField investigationFinal reportBeech 58 · Bentley Creek, PAThe last radio call made by the plt was at 0658 EST when he reported level at 8000 ft. radar data at 0708 EST, showed the acft changing heading from 327 to 335 degrees, alt decreased from 8000 to 5000 ft and ground speed increased from 179 to 188 KTS.…
Back to Beech 58