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 WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB ERA26LA346Accident · 1 fatalClass 3 · LimitedPreliminary reportSchleicher ASW-24 · Edinburg, NYOn September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was…NTSB ERA26LA346Accident · 1 fatalClass 3 · LimitedPreliminary reportSchemp-Hirth Ventus · Edinburg, NYOn September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was…NTSB WPR26LA299Accident · No injuriesClass 4 · LimitedInvestigation openSchleicher ASK-21 · Tehachapi, CANTSB CEN26LA282Accident · 1 fatalClass 3 · LimitedPreliminary reportPzl-Bielsko B1-PW-5 · Briggs, TXOn August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal…NTSB WPR26LA287Occurrence · 1 fatalClass 3 · LimitedPreliminary reportCameron Balloons A-315 · Menifee, CAOn August 2, 2026, about 0710 Pacific daylight time, a Cameron Balloons A-315, N315U, was not damaged when it was involved in an accident near Menifee, California. The pilot and one passenger were not injured, and one passenger was fatally injured. The…NTSB WPR26LA271Accident · No injuriesClass 4 · LimitedInvestigation openLet L-23 Super Blanik · North Plains, ORNTSB WPR26LA263Accident · No injuriesClass 4 · LimitedInvestigation openSchleicher ASW-27 · Montague, CANTSB WPR26LA273Accident · Minor injuriesClass 4 · LimitedInvestigation openSchweizer SGS 2-33A · Boulder, CONTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB WPR26LA203Accident · No injuriesClass 4 · LimitedFinal reportPzl-Swidnik PW-5 · Soap Lake, WAThe pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight.NTSB ERA26LA207Accident · 1 fatalClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Scotts Fork, VAThe photographer’s failure to remain clear of an active taxiway.NTSB WPR26LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US C-80 · Rio Rancho, NMThe passenger’s improper hand placement on the basket upright during landing, which resulted in injury when the upright fractured during the basket’s bounce and drag sequence.NTSB ERA26LA138Accident · Minor injuriesClass 4 · LimitedFinal reportGlasflugel Kestrel · Little Switzerland, NCA loss of thermal lift during a glider flight, which resulted in a collision with trees during a landing approach to a diversionary airport.NTSB WPR26LA118Accident · Minor injuriesClass 4 · LimitedFinal reportLindstrand 260A · Casa Grande, AZThe hot air balloon’s encounter with downdraft wind conditions in mountainous terrain and subsequent impact with terrain.NTSB CEN26LA108Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon A55S · Durango, COThe ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb while landing.NTSB WPR26LA079Accident · No injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26M · La Verkin, UTThe pilot’s failure to maintain clearance from powerlines after an aborted landing attempt.NTSB ERA26LA085Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Luft UND Raumfah G103 Twin Astir Trai · Brownsboro, ALThe flight instructor’s failure to properly lock the rear canopy prior to flight, which led to the canopy opening during aerotow at low altitude, and a subsequent off-airport landing in a corn field.NTSB WPR26LA052Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon landing in increased wind, and the pilot’s inability to maintain the proper descent rate, which resulted in a hard landing.NTSB WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB CEN26LA018Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Wallis, TXThe pilot’s failure to maintain control during landing roll that resulted in an impact with terrain.NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.NTSB WPR26LA010Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel STD Libelle 201B · Moriarty, NMThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB WPR25LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon pilot’s improper landing, which resulted in serious injury to a passenger. Contributing to the accident was the pilot’s failure to brief the proper landing procedure.NTSB ERA25LA336Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Ridgeland, SCThe pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.NTSB CEN25LA340Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.NTSB ERA25LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Fly Balonismo E Inflaveis AF-SS-94 · Walbridge, OHThe balloon pilot’s failure to see and avoid powerlines during an off-field airport landing.NTSB CEN25LA311Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Monee, ILThe student pilot’s failure to maintain airspeed and altitude resulting in a collision with the ground during the base to final turn.NTSB WPR25FA232Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW27-18 · Morgan, UTOn August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…NTSB CEN25LA271Accident · No injuriesClass 4 · LimitedFinal reportPZL Swidnik PW-5 · Kerrick, TXThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB CEN25LA227Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob G-103A Twin II Acro · Midlothian, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen Schneider LS-7WL · Tonasket, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.NTSB WPR25LA144Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26B · Ontario, ORThe pilot's exceedance of the airplane's critical angle of attack during the final approach to land, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR25LA138Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR25LA023Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons US A-275 · Wittmann, AZThe pilot’s failure to maintain clearance from a power line during an approach.NTSB WPR25LA016Accident · No injuriesClass 4 · LimitedFinal reportLindstrand 80E · Albuquerque, NMThe pilot’s loss of control during landing, which resulted in the balloon’s envelope contacting powerlines.NTSB WPR25LA015Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Moriarty, NMThe pilot’s failure to maintain an adequate glidepath, which resulted in the glider landing on rough terrain short of the runway.NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB ERA25LA009Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher ASK-21 · Front Royal, VAThe pilot’s improper landing flare and subsequent improper recovery from a hard, bounced landing.NTSB CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.NTSB ERA24LA382Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX-7 · Amsterdam, NYThe pilot’s failure to maintain adequate clearance from powerlines during final approach for landing.NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB WPR24LA274Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Minden, NVThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.NTSB CEN24LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Colorado Springs, COThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing.NTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.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.
Back to NONE