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 ANC03LA003Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235 · Wrangell, AKThe pilot's inadequate weather evaluation, his continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate altitude/clearance from terrain/water, which resulted in a collision with water while maneuvering. Factors…NTSB ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.NTSB LAX02LA291Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-42-2 Jantar · Hemet, CAthe pilot's failure to maintain an adequate terrain clearance altitude.NTSB LAX02LA277Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus-B · Peoria, AZThe pilot's abrupt maneuver, which resulted in an inadvertent stall.NTSB FTW02FA243Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Decatur, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.NTSB FTW02LA240Accident · Serious injuriesLimited investigationFinal reportBalloon Works FireFly 7B-15 · Oklahoma City, OKthe pilot's inadvertent flight into adverse weather conditions resulting in a hard landing. A contributing factor was the high wind.NTSB CHI02LA266Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Ionia, MIThe pilot's failure to maintain clearance from the runway end identifier light (REIL). A factor to the accident was the REIL.NTSB LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.NTSB SEA02LA140Accident · Minor injuriesLimited investigationFinal reportBlanik L-13 · Belgrade, MTThe glider pilot's improper in-flight planning decision and his failure to attain the proper touchdown point. Contributing to the accident were the inadvertent activation of the speed brakes, the pilot's failure to maintain altitude, the high vegetation and…NTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.NTSB DEN02LA095Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Lehi, UTthe pilot's inadequate in-flight planning resulting in the glider impacting terrain short of the runway, and the pilot's subsequent abrupt handling of the glider when it became airborne again, which resulted in a hard second landing. A contributing factor was…NTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.NTSB LAX02LA215Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS8-18 · Incline Village, NVthe pilot's inadequate in-flight planning and failure to maintain an adequate clearance from terrain.NTSB IAD02LA071Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Unionville, PAThe pilot's evasive maneuver to avoid a collision with a departing airplane, which resulted in a landing short of the runway. A factor was the pilot's decision to land on the runway opposite the one in use.NTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.NTSB LAX02LA208Accident · Serious injuriesLimited investigationFinal reportWSK PZL Swidnik PW-5 · Loch Lomand, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during final approach. A contributing factor was the windshear and turbulence encountered during the approach.NTSB CHI02LA169Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Mukwonago, WIThe inadequate weather evaluation by the pilot and high winds.NTSB IAD02LA059Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK21 · Woodstock, VAThe pilot's failure to recognize the loss of orographic lift conditions. A factor was the loss of orographic lift.NTSB FTW02LA146Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Port Allen, LAThe pilot's decision to land in the sugar cane field, which resulted in the pilot's unintentional exit from the basket. A contributing factor was the high vegetation in the field.NTSB CHI02LA131Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks-Flugzeubau DG-100G · Union, ILThe pilot not maintaining aircraft control during the aero-tow takeoff. Factors to the accident were the high wind velocity and the gusting wind condition.NTSB NYC02LA092Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Saratoga Spring, NYThe glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.NTSB IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.NTSB IAD02LA042Accident · No injuriesLimited investigationFinal reportWSK PZL PW-5 · New Smithville, PAThe pilot's inadequate evaluation of the weather which resulted in the loss of thermal lift and collision with trees.NTSB NYC02LA079Accident · Serious injuriesLimited investigationFinal reportMaule M-5-180C · Bennington, VTThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB LAX02LA111Accident · Serious injuriesLimited investigationFinal reportAvian Magnum IX · Sedona, AZThe pilot's decision to continue the landing approach after encountering a high wind condition. A factor in the accident was the pilot's decision to use the trees to try and slow the balloon's ground speed.NTSB FTW02LA092Accident · Minor injuriesLimited investigationFinal reportSchleicher AS-W19 · Moriarty, NMThe pilot's attempt to perform a turn upwind at a altitude too low to complete the turn. A factor was the turbulance.NTSB LAX02LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Peoria, AZFailure of the cyclist to coordinate and communicate that he was on the active runway. A contributing factor was the sun glare encountered by the pilot on final approach.NTSB LAX02LA150Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 120 A · Moreno Valley, CAThe pilot's inadequate handling of the aircraft. High winds were a contributing factor.NTSB LAX02LA079Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe student pilot's failure to maintain directional control during the landing sequence.NTSB LAX02FA069Accident · 1 fatalField investigationFinal reportCameron Balloons US N-145 · North Las Vegas, NVThe pilot's misjudged approach and inadequate obstacle clearance, which resulted in his failure to attain the proper touchdown point. Contributing factors were the high gusty wind condition, and the pilot's failure to provide protective safety equipment.NTSB FTW02LA270Accident · Serious injuriesLimited investigationFinal reportRaven S60A · La Vernia, TXThe pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.NTSB ATL02LA027Accident · No injuriesLimited investigationFinal reportFlugzeugbau DG-200 · Benton, TNThe pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.NTSB FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.NTSB LAX02LA042Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Banning, CAOn final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.NTSB FTW02LA043Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Alamogordo, NMThe pilot's failure to maintain altitude and clearance with small trees during a precautionary landing.NTSB IAD02LA009Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Jersey Shore, PAThe pilot's in-flight encounter with weather, which led to a forced landing to unsuitable terrain.NTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.NTSB CHI02LA013Accident · Serious injuriesLimited investigationFinal reportMeester HP-14 · Sturtevant, WIThe restricted movement of the aileron control system for undetermined reasons.NTSB NYC02LA014Accident · 1 fatalLimited investigationFinal reportNicolosi Challenger II · Midland, VALoss of engine power for an undetermined reason.NTSB NYC02LA015Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-105 · Morgantown, WVThe passengers failure to remain in the balloon basket after landing which resulted in the inadvertent lift-off of the balloon and subsequent injury to the pilot. A factor related to the accident was the pilot's failure to perform a passenger briefing prior…NTSB FTW02LA016Accident · No injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Albuquerque, NMthe pilot's failure to maintain clearance with the obstacles during landing. A contributing factor was the gusty winds.NTSB FTW02LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Albuquerque, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in an inflight collision with objects while landing. A contributing factor was the high wind weather condition.NTSB FTW02LA012Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Albuquerque, NMthe pilot's failure to maintain clearance with a power line during landing. A contributing factor was the high wind during the landing.NTSB FTW02LA013Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Albuquerque, NMthe selection of an unsuitable landing area by the pilot. A contributing factor was the high wind during the landing.NTSB FTW02LA011Accident · Serious injuriesLimited investigationFinal reportCameron 105 · Albuquerque, NMTher pilot's delay to compensate for changing weather conditions in-flight. Contributing factors were the high winds and an inaccurate weather forcast.NTSB NYC02LA027Accident · No injuriesLimited investigationFinal reportLet Blanik L 33 Solo · Windsor, VAThe pilot's inadequate preflight inspection, which resulted in a loose battery charger becoming entangled in the rudder pedals during a spin recovery, and a subsequent overstress of the glider. Factors included the loose battery charger, and the non-standard…NTSB NYC02LA004Accident · Serious injuriesLimited investigationFinal reportRich Woodstock I · Waynesburg, PAAn improperly secured canopy latch, which resulted in canopy separation during liftoff and the pilot's subsequent loss of control. A factor was the improper installation of the latch.NTSB FTW01LA213Accident · Serious injuriesLimited investigationFinal reportCameron Balloon N-77 · McKinney, TXthe pilot's failure to maintain clearance with the fence while landing. A contributing factor was the high wind condition.NTSB SEA01LA173Accident · 1 fatalLimited investigationFinal reportKaman HH-43 · Bonners Ferry, IDThe pilot's inadequate visual lookout which lead to his failure to maintain clearance from the nearby trees while in a high-hover. Factors include mountainous/hilly terrain, and tall trees in the area where the helicopter was hovering.NTSB NYC01LA225Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Cumberland, MDThe pilot misjudged distance and altitude. A factor was the pilot's lack of familiarity with the glider.
Back to NONE