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 GAA20CA037Accident · No injuriesData collectionFinal reportUltramagic N 250 · Albuquerque, NMThe pilot's failure maintain clearance from power lines, which resulted in an explosion and preimpact fire.NTSB GAA20CA012Accident · Minor injuriesData collectionFinal reportAerostar International RX 7 · Rio Rancho, NMThe pilot's failure to maintain an adequate descent rate during landing, which resulted in a hard landing and a postaccident fire.NTSB WPR20LA004Accident · Minor injuriesClass 3 · LimitedFinal reportGlaser Dirks DG500 · Marana, AZThe pilots’ exceedance of the glider’s never-exceed speed (VNE) during recovery from an intentional aerobatic maneuver, which resulted in a failure of the right-wing air brake control drive, asymmetrical air brake deployment, and a subsequent hard landing.NTSB CEN19TA328Accident · Serious injuriesClass 3Final reportLindstrand 105A · Lawton, OKA hard landing, which resulted the basket tipping over and a passenger sustaining a serious injury.NTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.NTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.NTSB GAA19CA484Accident · Serious injuriesData collectionFinal reportCameron A 210 · Hume, NYThe pilot's failure to maintain a proper descent rate during landing, which resulted in a hard landing and a serious passenger injury.NTSB GAA19CA469Accident · No injuriesData collectionFinal reportSchempp Hirth Ventus 2A · Wurtsboro, NYThe pilot's failure to properly secure the glider’s canopy before flight, which resulted in it opening in flight and the pilot's inability to maintain an appropriate final approach path and altitude, which resulted in impact with a shipping container.NTSB WPR19LA191Accident · 1 fatalClass 3 · LimitedFinal reportBolkow Phoebus · Alvord Desert, ORPilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.NTSB GAA19CA447Accident · No injuriesData collectionFinal reportBiuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NVThe pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.NTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.NTSB GAA19CA399Accident · Serious injuriesData collectionFinal reportSchweizer SGS233 · Blairstown, NJThe student pilot's improper landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing and the instructor sustaining a serious injury.NTSB GAA19CA314Accident · Serious injuriesData collectionFinal reportCameron A-275 · Sedona, AZThe balloon’s encounter with rough terrain, which resulted in a bounced landing and a ground crewmember sustaining serious injuries.NTSB CEN19CA128Accident · Serious injuriesData collectionFinal reportUltramagic S90 · La Mesa, TXThe pilot's improper decision to launch the balloon in known high wind conditions, and his failure to fully vent the balloon upon landing, which resulted in the balloon landing hard several times, tipping over, being pushed along uneven ground, and a serious…NTSB ANC19TA017Accident · Serious injuriesClass 3Final reportCessna A185 · Nome, AKThe pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…NTSB WPR19LA104Accident · Serious injuriesClass 3 · LimitedFinal reportCameron A-400 · Yountville, CAThe pilot’s inability to maintain obstacle clearance after the balloon’s encounter with a downdraft, which resulted in a collision with power lines.NTSB WPR19TA005Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Placitas, NMThe pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.NTSB GAA19CA030Accident · Serious injuriesData collectionFinal reportUltramagic N 250 · Rio Rancho, NMThe balloon tipping over during deflation, which resulted in a passenger injury.NTSB ERA18TA267Accident · Serious injuriesClass 3Final reportGrob G103 Twin Astir · Groveland, FLThe student pilot's failure to relinquish the flight controls during landing when the flight instructor told him to do so, and the instructor’s subsequent inability to properly control the glider, which led to a hard landing.NTSB CEN18LA364Accident · Serious injuriesLimited investigationFinal reportLindstrand 77A · Brookfield, MOThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB ERA18FA238Accident · 3 fatalField investigationFinal reportSchweizer SGS 2 32 · Morrisville, VTThe pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…NTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB ERA18LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Churchville, MDThe pilots' decision to take off from a wet, upsloping turf runway with a quartering tailwind and elevated density altitude conditions, which degraded takeoff and climb performance and resulted in the glider flight instructor's decision to discontinue the…NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB WPR18TA192Accident · Serious injuriesFinal reportSchempp Hirth Discus CS · Goldfield, NVThe glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.NTSB CEN18LA245Accident · 1 fatalLimited investigationFinal reportKubicek BB30 · Ashland, OHThe pilot's failure to ensure that he was secure in the balloon's basket after landing, which resulted in him falling and striking his head on the burners when the wind caught the envelope and tipped the basket over. Contributing to the accident was the…NTSB GAA18CA389Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Boulder, COThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.NTSB GAA18CA377Accident · No injuriesData collectionFinal reportJonker Sailplanes JS1-C · Panguitch, UTThe pilot’s inability to maintain altitude and his delayed decision to deploy the powered-glider’s engine, which necessitated an off-airport landing.NTSB WPR18FA178Accident · 1 fatalClass 2 · FieldFinal reportSchempp-Hirth Standard Cirrus · Aguila, AZThe pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB CEN18FA217Accident · 2 fatalField investigationFinal reportLet L 23 Super Blanik · Moose, WYThe pilot's encounter with atmospheric conditions that resulted in a loss of lift and a subsequent loss of control near terrain that precluded recovery. Contributing to the accident was the pilot's failure to follow the operator's published tour flight…NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB GAA18CA314Accident · No injuriesData collectionFinal reportSchleicher ASW · Nephi, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a hard off-airport landing.NTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB GAA18CA283Accident · No injuriesData collectionFinal reportSchweizer SGS123 · Tunbridge, VTThe student glider’s inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.NTSB ERA18FA128Accident · 1 fatalField investigationFinal reportS.Z.D. SZD 48 Jantar STD 2 · LaBelle, FLThe pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence.NTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.NTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.NTSB GAA18CA172Accident · No injuriesData collectionFinal reportLithuanian Factory Of LAK 12 · Sunriver, ORThe glider pilot's inadequate flight planning, which resulted in an off-airport landing.NTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.NTSB CEN18LA006Accident · Serious injuriesLimited investigationFinal reportCameron N-105 · Albuquerque, NMThe steep approach and hard landing after the balloon encountered unexpected high wind conditions, which resulted in a serious injury to a passenger.NTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.NTSB GAA17CA566Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Hampshire, ILThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB CEN17LA305Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OHThe pilot’s failure to follow the before takeoff checklist, which resulted in an improper takeoff configuration and subsequent uncontrolled descent into terrain during a departure climb.NTSB GAA17CA477Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Homestead, FLThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in the pilot landing short of the intended runway.NTSB GAA17CA456Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD 55-1 · Mocksville, NCThe pilot’s improper landing flare in gusting wind conditions.
Back to NONE