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 LAX04CA220Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Sparks, NVthe student pilot's misjudged altitude, distance, and speed, and failure to attain the proper touchdown point, resulting in an overshoot of the runway.NTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.NTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.NTSB DEN04CA072Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 180A · Ridgeway, COthe sudden wind gusts and the pilot's failure to maintain control of the balloon resulting in the balloon's basket impacting two vehicles and a house, and subsequently impacting the terrain. Factors relating to the accident were the two vehicles, the house,…NTSB LAX04LA203Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…NTSB ATL04LA094Accident · 1 fatalLimited investigationFinal reportFirefly F8B · Eatonton, GAThe overload failure of the windline quick release tiedown eyebolt.NTSB FTW04LA103Accident · Serious injuriesLimited investigationFinal reportPdps PZL-Bielsko SZD-50-3 · Cherry Valley, ARThe pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.NTSB CHI04CA102Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Lake Village, INThe unsuitable terrain the Certified Flight Instructor encountered during the off-field landing. The low altitude, the downdraft or "sink" experienced during flight, and the soft terrain conditions were factors to the accident.NTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.NTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.NTSB LAX04LA123Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Phoenix, AZthe failure of the deflation vent line, which resulted in the pilot not being able to control the balloon in the increased wind conditions.NTSB ANC04FA016Accident · 4 fatalField investigationFinal reportSchleicher ASK-21 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB NYC04LA017Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Ithaca, NYThe pilot's excessive descent rate during the execution of a high wind landing. A factor was the high winds.NTSB DEN04LA006Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high-wind landing, resulting in a hard landing, the subsequent tipping of the balloon's basket, a post impact flash fire, and the ejection of two passengers. Contributing factors include the high wind…NTSB DEN04LA005Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons LBL · Albuquerque, NMthe inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.NTSB LAX04CA003Accident · Minor injuriesData collectionFinal reportBalloon Works Firefly II · Phoenix, AZthe pilot's diverted attention that resulted in the inadequate handling of the burner during ground operations.NTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…NTSB CHI03LA317Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Highland, ILThe pilot encountering unsuitable terrain during an off-airport landing. A factor to the accident was the high vegetation.NTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.NTSB CHI03LA328Accident · No injuriesLimited investigationFinal reportLet L-13 Blanik · Highland, ILThe pilot's failure to extend the spoilers and his inadvertent use of the flaps during final approach, which resulted in the proper touchdown point being exceeded due to excessive airspeed. A factor to the accident was the dirt mound.NTSB CHI03LA313Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Slayton, MNThe excessive descent rate during the balloon's landing by the student pilot.NTSB DEN03LA143Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Boulder, COpilot's improper in-flight planning and decision making. Contributing factors include the thunderstorms, the lack of suitable terrain available for a precautionary landing and the water.NTSB CHI03LA224Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Highland, MIFailure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.NTSB NYC03FA162Accident · 1 fatalField investigationFinal reportStart & Flug H101 · Rock Hill, NYThe pilot's selection of an unsuitable area for landing.NTSB DEN03LA130Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Snowmass Villag, COthe failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.NTSB DEN03LA130Accident · No injuriesLimited investigationFinal reportAerostar S-71A · Snowmass Villag, COthe failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.NTSB DEN03LA128Accident · 1 fatalLimited investigationFinal reportGrob G103 Twin Astir · Morgan, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's inadequate in-flight planning/decision to fly low over a mountain ridge. Contributing factors included the wind shear, altitude/clearance, and the…NTSB DEN03LA126Accident · Serious injuriesLimited investigationFinal reportNational Ballooning 858 · Louisville, COThe pilot's inability to control the balloon. Contributing factors include the high winds, the attempted remedial action by the pilot, the building, fence, and transmission wires.NTSB CHI03LA208Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-77 · Battle Creek, MIThe pilot's excessive descent rate. Factors to the accident were the trees lining the landing area.NTSB NYC03LA143Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Grove City, OHThe passengers failure to maintain her balance inside the balloon basket.NTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.NTSB ATL03LA112Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW28 · Batesburg, SCThe loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.NTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…NTSB DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.NTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.NTSB CHI03LA146Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Hampshire, ILThe unsuitable terrain encountered by the pilot during the off airport landing. A factor was the rock.NTSB DEN03LA081Accident · Serious injuriesLimited investigationFinal reportAerostar International S66A-3060 · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high wind landing, which resulted in a hard landing. Contributing factors include the high wind and the berm.NTSB SEA03LA072Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Ephrata, WAThe pilot's failure to maintain aircraft control while on final approach for landing. Low airspeed was a factor.NTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.NTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.NTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.NTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.NTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.NTSB MIA03CA074Accident · No injuriesData collectionFinal reportSchempp-Hirth DISCUS-2B · Clermont, FLAn in-flight encounter with wind gusts while making an approach to land in a field resulting in the aircraft landing early and colliding with a berm.NTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.NTSB LAX03LA099Accident · No injuriesLimited investigationFinal reportAerostar International S-71A · Scottsdale, AZthe pilot's inadequate in-flight decision to cross over four sets of power lines with the existence of a known low fuel state and lack of wind, and failure to maintain altitude/clearance from the power lines during the landing, which resulted in the envelope…NTSB ATL03LA036Accident · No injuriesLimited investigationFinal reportBeech 65 · Fitzgerald, GAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the loss of engine power in both engines. A factor was a tree.NTSB DEN03LA019Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-70 · Montrose, COthe unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.NTSB MIA03LA022Accident · No injuriesLimited investigationFinal reportLet L-23 · Groveland, FLthe pilot's failure to extend the dive brakes during approach and his excessive airspeed and improper landing flare which resulted in the airplane nosing down and impacting with the runway.NTSB NYC03LA013Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Cottageville, WVThe pilot's improper decision not to over fly the landing area, which resulted in an in-flight collision with power lines.
Back to NONE