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 ('1152746')
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 ('1152746')
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 CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB GAA17CA058Accident · No injuriesData collectionFinal reportBeech 58TC · Valdosta, GAThe pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.NTSB CHI08FA248Accident · 1 fatalField investigationFinal reportBeech 58TC · Marysville, OHThe pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an aerodynamic stall.NTSB SEA05CA029Accident · No injuriesData collectionFinal reportBeech 58TC · Everett, WAThe pilot's misjudgment of distance/speed on landing touchdown and rollout, and his subsequent excessive braking. A factor was the fence.NTSB CHI03WA198Accident · 1 fatalForeign investigationBeech BE-58TC · Toronto, CanadaNTSB LAX02FA247Accident · 2 fatalField investigationFinal reportBeech 58TC · Avalon, CAthe pilot's misjudged distance and speed during the landing approach, which resulted in an overrun of the runway. Also causal was the pilot's failure to conduct a go-around during the approach, or abort the landing when an overrun became obvious.NTSB NYC01FA178Accident · 3 fatalField investigationFinal reportBeech 58-TC · Sidney, NYThe pilot's failure to follow IFR procedures which resulted in a collision with rising terrain. Factors related to the accident were the rising terrain and fog.NTSB NYC00FA047Accident · 4 fatalField investigationFinal reportBeech 58TC · Hasbrouck Hts., NJthe failure of the pilot to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin.NTSB NYC97LA190Accident · No injuriesLimited investigationFinal reportBeech 58TC · E. Farmingdale, NYthe pilot's improper starting procedure, which led to an engine fire; and his failure to follow the emergency checklist, which contributed to the level of damage that the airplane received.NTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.NTSB MIA94WA018Accident · No injuriesForeign investigationBeech 58TC · Kingston, JamaicaNTSB ATL92FA031Accident · 5 fatalField investigationFinal reportBeech 58TC · Bluffton, SCThe pilot's failure to maintain minimum controllable airspeed after a reported engine power loss, resulting in a loss of aircraft control. A factor was the loss of power on the left engine. The reason for the left engine power loss could not be determined.NTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.NTSB DEN87LA187Accident · No injuriesLimited investigationFinal reportBeech 58 · Pagosa Springs, COThe plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing…NTSB DEN85LA116Accident · No injuriesLimited investigationFinal reportBeech 58TC · Gallup, NMThe pilot stated that he inadvertently raised the landing gear during the landing roll.NTSB SEA85LA055Accident · No injuriesLimited investigationFinal reportBeech 58TC · Spokane, WAThe acft touched down to the left of the runway onto snow. Visibility at the time of the accident was 1 mile with snow and a ceiling of 700 feet.NTSB NYC85LA040Accident · No injuriesLimited investigationFinal reportBeech 58TC · Norwood, MATouchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an…NTSB LAX84LA099Accident · No injuriesLimited investigationFinal reportBeech 58TC · Santa Rosa, CAAfter making an ILS localtizer-only apch in heavy rain, the plt landed the acft long. When the acft touched down, the plt thought there was sufficient rwy remaining. However, he reported that he encountered hydroplaning conditions & was unable to stop on the…NTSB ATL84MA052Accident · 4 fatalMajor investigationFinal reportBeech 58TC · Knoxville, TNDuring arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…NTSB LAX82DA302Accident · No injuriesFinal reportBeech 58TC · Oakland, CAN17841, landed with the landing gear retracted at metropolitan Oakland airport. The pilot claims that the landing gear was lowered prior to landing. Efforts to reach the pilot for further comments concerning this flight were unsuccessful.NTSB MKC81FA043Accident · 4 fatalClosedBeech 58TC · Kansas City, KSNTSB CHI81DA017Accident · No injuriesClosedBeech 58TC · Elkhart Lake, WINTSB SEA81FA009Accident · 6 fatalClosedBeech 58TC · Ellensburg, WANTSB FTW81FQA05Accident · No injuriesClosedBeech 58TC · Ruidoso, NMNTSB DEN81FA066Accident · 4 fatalClosedBeech C33 · Dubois, WYNTSB CHI79AA041Accident · 6 fatalClosedBeech 58TC · St.Anne, IL
Back to Beech 58TC