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 CEN10FA394Accident · 4 fatalField investigationFinal reportBeech 58 · St. Ignace, MIThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons.NTSB ERA10LA357Accident · No injuriesLimited investigationFinal reportBeech 58 · LaGrange, GAThe pilot not allowing sufficient time for fuel spill vapors to dissipate before starting the engine. Contributing to the accident was the inadequate maintenance of the fuel cap.NTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.NTSB ERA10CA191Accident · No injuriesData collectionFinal reportBeech 58 · Naples, FLThe pilot's improper flare while landing, resulting in a bounced landing.NTSB ERA10IA095Incident · No injuriesIncident investigationFinal reportBeech 58 · Lexington, KYThe overstress failure of the nose landing gear aft drag brace.NTSB CEN09CA213Accident · No injuriesData collectionFinal reportBeech 58 · Durango, COThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB CEN09CA120Accident · No injuriesData collectionFinal reportBeech 58 · Brainerd, MNThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the unforcasted freezing rain that obscured the windscreen and hindered the pilot's ability to judge the height of the airplane above the runway.NTSB CHI08LA070Accident · No injuriesLimited investigationFinal reportBeech 58 · Cahokia, ILMaintenance personnel's improper replacement of the landing gear leg brace assembly which subsequently failed to keep the landing gear in the locked position.NTSB LAX07LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Chino, CAThe pilot's failure to ensure the landing gear selector handle was in the extended position prior to departure, which resulted in a premature retraction.NTSB ANC07LA066Accident · No injuriesLimited investigationFinal reportBeech 58 · Northway, AKThe collapse of the landing gear during the landing roll for an undetermined reason.NTSB DEN07FA100Accident · 1 fatalField investigationFinal reportBeech 58 · Placitas, NMthe failure of the pilot to maintain adequate terrain separation, for undetermined reasons, which resulted in controlled flight into terrain. A contributing factor was the mountainous terrain.NTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.NTSB CHI07FA084Accident · 2 fatalField investigationFinal reportBeech 58 · Munster, INThe fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.NTSB NYC07CA004Accident · No injuriesData collectionFinal reportBeech BE-58 · Annapolis, MDThe pilot's improper in-flight decision to attempt to land on the wet runway, which resulted in an overrun. Factors in the accident were rain, and the gusty wind conditions.NTSB MIA06CA003Accident · No injuriesData collectionFinal reportBeech 58 · Jacksonville, FLThe pilot's improper use of the normal brakes during the landing roll and his delay in performing a go-around resulting in an emergency descent/landing on grass past the departure end of the runway and subsequent collapse of the left main landing gear.NTSB MIA05WA154Accident · 1 fatalForeign investigationBeech BE-58 · Exuma Cay, BahamasNTSB MIA05LA108Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe inadequate maintenance inspection by maintenance personnel which resulted in damaged landing gear pulleys, resulting in the failure of the landing gear downlock to engage, and collapse of the main landing gear during landing.NTSB CHI05FA063Accident · 4 fatalField investigationFinal reportBeech BE-58 · Niles, MIThe steep nose down descent from cruise for undetermined reasons and the subsequent collision with terrain in a steep nose down attitude.NTSB MIA05CA034Accident · No injuriesData collectionFinal reportBeech 58 · Fort Pierce, FLThe failure of the pilot to follow the checklist and extend the landing gear during landing resulting in a gear-up landing.NTSB FTW04CA218Accident · No injuriesData collectionFinal reportBeech BE-58 · Groveton, TXThe pilot's intentional ground loop to avoid colliding with deer that entered the runway during the landing roll. A contributing factor was the tall grass adjacent to the runway that prevented detection of the deer.NTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…NTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.NTSB LAX03CA286Accident · No injuriesData collectionFinal reportBeech 58 · Kneeland, CApoor braking action due to the undulating runway surface and crumbling asphalt resulting in an on ground encounter with terrain. Contributing to the accident was the necessity for the pilot to fly an increased approach angle due to the trees at the approach…NTSB ANC03LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Hoonah, AKThe locking of the left brake during the landing roll, which resulted in the collapse of the left main landing gear.NTSB LAX03LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Big Bear City, CAThe pilot's excessive approach speed and misjudged landing flare, which resulted in a hard landing and collapse of the landing gear. A factor in the accident was the pilot's failure to use flaps.NTSB FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB NYC03LA006Accident · No injuriesLimited investigationFinal reportBeech 58 · Allentown, PAThe pilot's inadvertent retraction of the landing gear on the ground.NTSB MIA02LA146Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Fort Lauderdale, FLthe pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.NTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.NTSB ATL02IA138Incident · No injuriesIncident investigationFinal reportBeech 58 · Nashville, TNCollapse of the main landing gear for undetermined reasons.NTSB FTW02LA189Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Farmington, NMThe failure of the nose landing gear plunger assembly due to fatigue.NTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.NTSB FTW02LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Farmington, NMThe failure of the nose gear actuator retract arm due to fatigue.NTSB CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…NTSB CHI01LA140Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not maintaining directional control during the reported loss of number one engine power during initial climb and the pilot not following the airplane emergency procedure's corrective action for engine failure after lift-off, and the inadvertent…NTSB FTW01LA071Accident · No injuriesLimited investigationFinal reportBeech 58 · Shreveport, LAthe pilot's failure to maintain visual separation with a parked airplane while taxing. Contributory factors were the dark night light conditions, the rain, and the non-lighted ramp area where the unoccupied airplane was parked.NTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.NTSB CHI01LA050Accident · No injuriesLimited investigationFinal reportBeech 58 · Huntingburg, INThe proper touchdown point not obtained/maintained by the pilot. Factors were the snow covered runway, the ice contaminated windshield, and the airport snow removal performed by the driver of the vehicle.NTSB FTW00LA251Accident · No injuriesLimited investigationFinal reportBeech BE58 · Bethany, OKthe fire, which ignited in the engine compartment for undetermined reasons while taxiing.NTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportBeech 58 · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.NTSB NYC00IA131Incident · No injuriesIncident investigationFinal reportBeech BE-58 · Windsor Locks, CTInadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…NTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.NTSB ATL00FA041Accident · 1 fatalField investigationFinal reportBeech BE-58 · Palatka, FLThe pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.NTSB MIA00LA125Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rocky Mount, NCThe pilot's inadvertent VFR flight into IMC conditions and the failure of the pilot to maintain altitude/clearance resulting in the in-flight collision with trees and unmarked power lines during a visual approach to the runway.NTSB CHI00LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Festus, MOthe pilot inadvertently retracted the landing gear instead of the flaps during the landing roll.NTSB MIA00IA104Incident · No injuriesIncident investigationFinal reportBeech 58 · Memphis, TNfailure of the right main landing gear's dynamic brake relay, that resulted in the motor driving the gearbox past prescribed limits, resulting in a bent connecting rod, and failure of the gear to extend.NTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.
Back to Beech 58