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.engine_model_code IN ('00000')
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.engine_model_code IN ('00000')
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 MIA94LA208Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Deland, FLThe pilot in command's failure to maintain ground clearance while maneuvering over the runway threshold resulting in the left wing contacting the ground.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB CHI94LA275Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 120A · Bloomington, ILthe unforcast, unanticipated adverse wind conditions and thermal activity. A factor was the powerlines.NTSB CHI94LA280Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIno thermal lift available, and the lack of suitable terrain for landing. A factor related to the accident was the high wind condition.NTSB NYC94LA155Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Cannan, NHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and inflight collision with terrain. Factors were a loss of lift and the pilot's in-flight decision to maneuver too close to the ridge.NTSB FTW94LA250Accident · No injuriesLimited investigationFinal reportLet L-23 · Stillwater, OKThe certified flight instructor's failure to maintain flying speed.NTSB FTW94LA243Accident · No injuriesLimited investigationFinal reportCameron V-77 · Pflugerville, TXThe pilot's failure to maintain control. A factor was the unfavorable wind.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.NTSB FTW94LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Littlefield, TXAn inadvertent stall. Factors were low altitude and airspeed at the beginning of the downwind turn.NTSB FTW94IA227Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Denver, COFailure of the right main landing gear torque link assembly and shimmy dampener for unknown reasons.NTSB FTW94LA219Accident · No injuriesLimited investigationFinal reportCameron V-77 · Littleton, COA total failure of the balloon's heater system (pilot light) for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB BFO94LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-32 · Plymouth, MAThe pilot-in-command's improper in-flight planning and decision. A factor related to the accident is a downdraft.NTSB CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.NTSB LAX94LA259Accident · Serious injuriesLimited investigationFinal reportMascari Discovery S-12 · Salinas, CAThe failure of the muffler assembly due to preexisting cracking in the oxidized area of the weld, with subsequent damage and separation of the propeller and reduction gear box. A related factor was the excessive taxispeed which resulted in the airplane…NTSB SEA94LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · North Plains, ORProper touch down point was not obtained. Factors to the accident were: canopy not secured, and inadequate preflight planning/preparation.NTSB LAX94LA244Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Acton, CAthe pilot's improper in-flight planning and his misjudging the wind speed information. Contributing factors were the gusty winds and the lack of suitable terrain.NTSB FTW94LA197Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COWas the pilot's improper compensation for the crosswind. A factor was the crosswind.NTSB BFO94LA083Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-C · Fairfield, PAThe pilot-in-command's failure to maintain control of the airplane during the maneuver.NTSB FTW94LA184Accident · Minor injuriesLimited investigationFinal reportLockheed P-38 · Breckenridge, TXThe fuel starvation induced loss of power due to improper positioning of the fuel selector. Factors were the pilot's lack of experience in the type airplane, and the lack of suitable terrain for the forced landing.NTSB FTW94LA172Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Durango, COThe pilot did not attain a proper level off during landing. A downdraft which was encountered was a factor.NTSB CHI94LA165Accident · No injuriesLimited investigationFinal reportBurkhart Grob BG 103 · Ionia, MIa hard landing as a result of the early disconnect of the glider launch/tow equipment.NTSB NYC94LA081Accident · No injuriesLimited investigationFinal reportLet Super Blanik L-33 · New Castle, VAThe pilot's improper use of the flight controls resulting in failure to maintain a proper descent rate during the approach for landing. A factor in this accident was the pilot's lack of total experience in this type of glider.NTSB SEA94LA118Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Columbia, CAThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB FTW94LA151Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Elbert, COInadequate visual lookout on the part of both pilots. A factor was poor airport operations.NTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.NTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.NTSB BFO94LA074Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Plymouth, MAThe pilot's failure to maintain adequate airspeed.NTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.NTSB LAX94LA162Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9-118 · Sedona, AZthe failure of the pilot lights and burners to relight in flight once extinguished due to the installation of an incorrect gas pressure regulator.NTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.NTSB LAX94LA102Accident · 1 fatalLimited investigationFinal reportFurche-Bielsko SZD-48 Jantar · Warner Springs, CAThe pilot's improper remedial action to recover from the spin. The intentional stall/spin was a factor in this accident.NTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.NTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB CHI94LA042Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Pratt, KSThe pilot-in-command's failure to maintain clearance from obstacles. Factors contributing to the accident are the pilot's misjudged fuel consumption calculations and the weather (high winds).NTSB BFO94LA003Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morrisville, VTThe pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.NTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.NTSB FTW94LA020Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · San Antonio, TXThe pilot's failure to maintain a visual lookout. Factors were: inadequate altitude and distracted attention.NTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.NTSB CHI93IA372Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Indianapolis, INan undetermined problem which resulted in the physical impairment of flight attendants, passengers and the first officer.NTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.NTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.NTSB CHI93LA353Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 Twin Astir · New Douglas, ILFailure of the glider tow attachment. Factors related to the accident were the improper emergency procedure by the student, and the flight instructor's delayed remedial action..NTSB NYC93LA174Accident · Serious injuriesLimited investigationFinal reportCameron HAB-N90 · Niagara Falls, NYThe inadequate bracing of the passenger for landing which resulted in a fall.NTSB NYC93LA173Accident · Serious injuriesLimited investigationFinal reportCameron Bieu/V-65 · Lewiston, NYThe pilot's failure to maintain adequate clearance, which resulted in an inflight collision with a light pole.NTSB CHI93LA334Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Hinckley, ILthe failure of the cockpit canopy.NTSB LAX93LA326Accident · Serious injuriesLimited investigationFinal reportPilatus B4-PC11AF · Truckee, CAFailure of the pilot to conduct adequate preflight checks which resulted in the glider taking off with a frayed release hook cable, the pilot's failure to maintain airspeed, and the inadvertent stall.NTSB LAX93LA324Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-35C · Wickenburg, AZthe pilot's failure to maintain an adequate airspeed margin while maneuvering to land, resulting in an inadvertent stall/spin.NTSB DEN93FA101Accident · Serious injuriesField investigationFinal reportThunder and Colt 240A · Woody Creek, COAn inflight encounter with high winds which required a precautionary landing.NTSB DEN93FA100Accident · 6 fatalField investigationFinal reportCameron N-145 · Woody Creek, COFailure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.
Back to NONE