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 WPR24LA223Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic T210 · Arroyo Hondo, NMThe passenger’s failure to maintain a proper landing position and handhold during the landing sequence, which resulted in a serious injury.NTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.NTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB ERA24LA291Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Benton, NHAn encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in collision with trees.NTSB CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.NTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.NTSB ERA24LA119Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Polk City, FLThe glider pilot’s misjudged altitude, which resulted in an off-airport landing and collision with a fence.NTSB ERA24LA098Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Zephyrhills, FLThe glider pilot’s failure to release from the towline after the tow plane experienced a loss of engine power.NTSB WPR24FA072Accident · 4 fatalClass 3 · FieldFinal reportKubicek BB85Z · Eloy, AZThe pilot’s decision to open the rapid deflation valve during flight as a means of descending, which resulted in the deflation of the envelope and hard impact with terrain.NTSB CEN24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7-15 · Albany, TXThe pilot’s failure to maintain a proper descent rate during the landing approach in a high wind condition.NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB ERA24LA029Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Elmira, NYThe pilot’s failure to attain a proper glidepath for a landing on the intended runway, which resulted in an off-airport landing and impact with soft terrain.NTSB WPR24LA019Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Albuquerque, NMThe pilot’s inability to maintain control of the balloon during landing due to unforecasted windshear and turbulent air.NTSB WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.NTSB WPR23LA311Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Miles City, MTThe pilot's failure to maintain control of the airplane while landing on unimproved terrain.NTSB CEN23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-210 · Erie, COA hard landing due to the high wind conditions which resulted in two passengers sustaining serious injuries.NTSB CEN23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon AB · Lafayette, COAn inadvertent hard landing in high wind conditions resulting in serious injury of two passengers. Contributing to the accident was the increase in prevailing winds prior to the forecast.NTSB CEN23LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe pilot’s weather encounter that resulted in a high speed landing, the balloon tipping over, and serious injury to a passenger.NTSB CEN23LA293Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Canandaigua, NYThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing, the passenger’s leg hitting the gas tank, and serious injury.NTSB WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.NTSB WPR23LA362Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Minden, NVThe pilot’s failure to maintain directional control during the landing roll, resulting in an impact with a taxiway sign.NTSB ERA23LA207Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Wake Forest, NCThe student pilot’s failure to maintain airspeed during the landing approach, which resulted in an exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a loss of control.NTSB WPR23LA182Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Marana, AZThe pilot’s improper landing flare, which resulted in a hard bounced landing in a dust devil.NTSB ERA23LA115Accident · Minor injuriesClass 4 · LimitedFinal reportEiriavion PIK-20D · Benton, TNThe pilot’s decision to turn toward a mountain ridge in a thermal, which resulted in a collision with terrain.NTSB WPR22LA364Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20 · Hood River, ORThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB ERA22LA407Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Mount Bethel, PAThe glider’s encounter with atmospheric conditions, where the lift was not sufficient to maintain flight resulting in an off-airport landing and collision with powerlines.NTSB WPR22LA374Accident · No injuriesClass 4 · LimitedFinal reportIca Brasov IS-28B2 · Deer Park, WAThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN22LA363Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20B · Waller, TXThe pilot’s failure to maintain the proper descent rate during an off-airport landing.NTSB CEN22LA370Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB ERA22LA370Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Shirley, NYThe flight instructor’s failure to ensure clearance from an electrical junction box during takeoff, which resulted in a collision.NTSB CEN22LA365Accident · No injuriesClass 4 · LimitedFinal reportUltramagic M56C · Indianola, IAThe pilot’s failure to maintain adequate clearance from powerlines.NTSB WPR22LA270Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33 · Livingston, MTThe student pilot’s improper landing flare, and the instructor’s lack of remedial action.NTSB ERA22LA326Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot’s loss of situational awareness (geographic position), which resulted in his inability to locate the intended landing runway and his decision to perform an off-airport landing.NTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.NTSB ERA22LA365Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26D · Windsor, VAThe glider’s encounter with atmospheric conditions, where lift was not sufficient to maintain flight.NTSB WPR22LA223Accident · No injuriesClass 4 · LimitedFinal reportDG Flugzeugbau DG 1000S · Lake Chelan, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight. Contributing to the accident was the pilot’s decision to overfly a suitable landing site which resulted in an off-field landing in a lake.NTSB CEN22LA279Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Yoder, KSThe pilot's encounter with sinking air conditions that resulted in a loss of lift and a subsequent loss of control.NTSB WPR22LA225Accident · No injuriesClass 4 · LimitedFinal reportRolladen-Schneider LS-6 · Tahoe Vista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and subsequent water ditching.NTSB CEN22LA238Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Hot Springs, SDThe passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.NTSB CEN22FA224Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS135 · Midlothian, TXThe pilot’s incapacitation by an aortic dissection (natural disease).NTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.NTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.NTSB ERA22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Zebulon, NCThe flight instructor’s failure to maintain directional control with a quartering tailwind.NTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…NTSB WPR22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Balloons A55S · Safford, AZThe pilot’s decision to continue the balloon’s fast approach to an unsuitable confined landing site, which resulted in a collision with powerline wires.
Back to NONE