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 WPR11CA338Accident · Serious injuriesData collectionFinal reportRolladen Schneider OHG LS-3-17 · Adelanto, CAThe pilot's incorrect use of the flap control pitch control recovery which resulted in an aerodynamic stall.NTSB ERA11FA401Accident · 1 fatalField investigationFinal reportSlingsby Capstan Type 49B · Hollywood, MDThe glider pilot’s improper response to the “check spoilers” signal from the tow pilot. Contributing to the accident was the glider pilot’s failure to confirm that the spoilers were closed and locked before takeoff, and the glider copilot’s improper crew…NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB WPR11FA302Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Lone Pine, CAThe glider encountered a strong downward orographic wind flow and turbulence that forced it into terrain. Also causal was the pilot’s decision to operate the glider very close to the terrain.NTSB CEN11CA440Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Stonewall, TXThe loss of directional control during an off-field landing in gusting wind.NTSB CEN11CA398Accident · Serious injuriesData collectionFinal reportLindstrand LBL120A · Le Center, MNThe failure of the passenger to follow the pilot's instructions during landing, which caused the pilot to be ejected from the balloon and sustain serious injuries.NTSB CEN11CA387Accident · No injuriesData collectionFinal reportBeech B200 · Waukegan, ILThe lightning strike during an en route descent.NTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB CEN11FA259Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Boulder, COThe pilot's incapacitation for undetermined reasons, which resulted in a loss of control.NTSB ERA11CA206Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Winchester, TNThe glider pilot's delayed response to changing weather conditions, which resulted in an off-airport landing into trees.NTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.NTSB CEN11CA225Accident · No injuriesData collectionFinal reportAms-Flight D.O.O. DG-500 Elan Orion · Boulder, COThe in flight loss of lift while landing, resulting in a collision with a fence.NTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB WPR11CA060Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Warner Springs, CAThe certified flight instructor's inadequate compensation for the crosswind and delayed remedial action during landing, which resulted in a ground loop.NTSB ERA11LA025Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Warren, VTThe pilot's inadvertent deployment of the airbrake handle past the upper limit of its normal operating range, which resulted in binding of the controls.NTSB WPR11LA017Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Cottonwood, AZThe paraglider pilot's failure to see and avoid the hot air balloon, which resulted in a midair collision.NTSB ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.NTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.NTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.NTSB ERA10CA462Accident · Serious injuriesData collectionFinal reportHead Balloons AX9 118 · Hanover, NHThe balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.NTSB CEN10CA507Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Socorro, NMA loss of lift that resulted in an off-airport landing.NTSB ERA10CA477Accident · Minor injuriesData collectionFinal reportBeam-Walter RS-15 · Windsor, VAThe pilot's inadequate installation and preflight inspection of the right rudervator assembly, which resulted in a loss control during takeoff.NTSB CEN10CA505Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Waynesville, OHThe pilot's loss of aircraft control during the tow for takeoff.NTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.NTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.NTSB ERA10CA427Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Erwin, NCThe pilot's excessive use of spoiler on final approach, which resulted in a landing short of the runway.NTSB ERA10CA419Accident · No injuriesData collectionFinal reportSchweizer SGS 1-34 · Groveland, FLThe pilot’s failure to attain the proper approach path to the runway, resulting in landing short of the runway.NTSB CEN10LA459Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth VENTUS-2B · Batesville, TXBoth glider pilots' inability to see and avoid the other resulting in a mid-air collision.NTSB CEN10LA459Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18 · Batesville, TXBoth glider pilots' inability to see and avoid the other resulting in a mid-air collision.NTSB WPR10LA377Accident · 1 fatalLimited investigationFinal reportGlaser Dirks DG300 · Morgan, UTThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall/spin and ground impact.NTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.NTSB CEN10CA456Accident · No injuriesData collectionFinal reportLindstrand 69A · Longview, TXThe the pilot's inadvertent movement of the burner assembly off center resulting in an in-flight fire of the skirt and envelope of the balloon. Contributing to the accident was the pilot's attention being diverted to venting the envelope to avoid an obstacle…NTSB WPR10LA356Accident · 1 fatalLimited investigationFinal reportParker RS-15 Sailplane · Marysvale, UTThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB CEN10CA388Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Waynesville, OHThe student pilot's delayed decision that resulted in insufficent altitude to return to the departure airport.NTSB CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.NTSB CEN10CA357Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Harrison, ARThe pilot’s failure to maintain control of the balloon during landing.NTSB WPR10LA300Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 120A · Grants Pass, ORThe balloon ground crew member's decision to not release his hold on the basket of an ascending hot air balloon basket as it lifted off of the ground.NTSB WPR10LA294Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Parowan, UTThe pilot's failure to see and avoid the other glider climbing in the same thermal.NTSB ERA10CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-36 · Jacksonville, FLThe glider pilot’s delayed decision to divert following a loss of thermal lift.NTSB WPR10CA244Accident · Minor injuriesData collectionFinal reportSchweizer SGS136 · Reno, NVThe student pilot’s selection of the wrong runway for the wind conditions and his failure to attain the proper touchdown point. Contributing to the accident was the student's lack of total experience, lack of experience in the operating area, lack of…NTSB CEN10CA257Accident · Serious injuriesData collectionFinal reportAerostar International S57A · Hilliard, OHThe passenger’s inadequate brace for the balloon landing, resulting in injury.NTSB ERA10CA260Accident · Serious injuriesData collectionFinal reportSchleicher ASW-20C · Unionville, PAThe pilot's lack of remedial action in response to a loss of altitude, which led to a forced landing in unsuitable terrain.NTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA10CA211Accident · Serious injuriesData collectionFinal reportFirefly AX8B · Durhamville, NYThe passenger's failure to adequately brace herself for the landing.NTSB WPR10LA169Accident · Serious injuriesLimited investigationFinal reportUltramagic S-160 · Rancho Santa Fe, CAA reduction of burner/heat production due to low fuel. Contributing to the accident was the pilot's continued flight with a low fuel status.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB ERA10CA176Accident · No injuriesData collectionFinal reportRolladen-Schneider LS-4 · Jasper, TNThe inadequate in-flight planning by the glider pilot to intentionally cross a ridge at low altitude, resulting in the in-flight collision with trees.
Back to NONE