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 SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.NTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.NTSB ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.NTSB DEN05LA108Accident · No injuriesLimited investigationFinal reportGrob G103 · Moriarty, NMthe glider pilot's intentional tow release at too low an altitude when he erroneously perceived the tow plane was about to crash. A contributing factor was the unsuitable terrain on which to make a landing.NTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.NTSB IAD05CA081Accident · Minor injuriesData collectionFinal reportPZL Swidnik PW-5 · Bloomingburg, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with terrain.NTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB LAX05LA196Accident · Minor injuriesLimited investigationFinal reportElan DG 300 · Jean, NVthe glider pilot's failure to release from the towline in a timely manner, and to maintain adequate airspeed. Contributing to the accident was the glider pilot's failure to recognize and correctly recover from the stall in a timely manner, and the inadequate…NTSB LAX05CA190Accident · No injuriesData collectionFinal reportS.A. Centrair Pegase 101D · Williams, CAloss of thermal lift during flight that resulted in a forced landing in an area without suitable landing terrain. Also causal was the pilot's inadequate compensation for the existing crosswind.NTSB CHI05CA133Accident · Serious injuriesData collectionFinal reportAerostar S-57A · Sparta, MOThe pilot's inability to maintain a proper descent rate due to the wind gust resulting in a hard landing. Contributing factors were the wind gust and the tree struck during the landing.NTSB ATL05CA089Accident · Minor injuriesData collectionFinal reportHughes TH-55 · Cornelia, GAThe pilot's failure to maintain adequate object clearance, which resulted in the in-flight collision with terrain, and the subsequent rollover.NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB DFW05LA125Accident · 2 fatalLimited investigationFinal reportAerostar International S53A · Shreveport, LAThe pilot's failure to maintain clearance from electrical power lines.NTSB LAX05LA171Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Jean, NVthe pilot's in-flight decision to continue a flight with weak thermal lift activity, and his delayed recognition of a loss of altitude while attempting to find a thermal in which to soar. A factor in the accident was the lack of suitable terrain for the…NTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.NTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.NTSB LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.NTSB ATL05CA072Accident · No injuriesData collectionFinal reportSchleicher ASW19b · Henderson, NCThe pilot's misjudgment of the landing area which resulted in overshooting the touchdown point. A factor was the in-flight encounter with weather (No thermal lift).NTSB LAX05LA131Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIthe pilot's failure to maintain an adequate airspeed while maneuvering during a scenic flight, which led to an inadvertent stall/spin and secondary stall/spin encounter. Contributing factors were the pilot's lack of total flight experience, his inadequate…NTSB DFW05CA096Accident · No injuriesData collectionFinal reportGlaser-Dirks DG 600 · Kent, TXThe pilot's misjudgement of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.NTSB DFW05CA075Accident · No injuriesData collectionFinal reportSchweizer SGS1-26B · Midlothian, TXThe pilot's misjudgment in distance/altitude and his failure to maintain clearance from a tree while on final to approach to landing. Contributing factors were the lack of thermal lift and the gusty wind conditions.NTSB LAX05LA094Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · Cave Creek, AZthe pilot's inadequate handling of the balloon during boarding resulting in a passenger falling and sustaining a serious injury.NTSB LAX05LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Waialua, HIthe pilot misjudged distance and altitude and failed to attain the proper landing touchdown point.NTSB DEN05CA006Accident · No injuriesData collectionFinal reportAerostar SP-1 · Albuquerque, NMthe pilot's failure to maintain clearance with the radio tower. Contributing factors were the pilot's improper compensation for the variable wind conditions.NTSB DFW05CA002Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Piedmont, OKThe pilot's failure to maintain clearance with power lines while landing. Contributing factors were the reduced visibility, fog, and low cloud ceiling.NTSB DEN05CA009Accident · Serious injuriesData collectionFinal reportThunder and Colt 180A · Albuquerque, NMthe balloon pilot's improper in-flight planning and failure to maintain aircraft control during descent into high winds resulting in a hard landing and subsequent serious injury to a passenger. Factors contributing to the accident were the high winds and…NTSB DFW05CA004Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-26E · El Paso, TXThe pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB FTW05CA001Accident · Minor injuriesData collectionFinal reportAerostar S-60A · Austin, TXThe pilot's excessive descent rate during the execution of a high wind landing, resulting in a hard landing. A factor was the high wind.NTSB NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.NTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB IAD04CA045Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Dover, PAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor was the relatively high winds (for balloon flight.)NTSB CHI04CA216Accident · No injuriesData collectionFinal reportGlasflugel H301 · Hutchinson, KSThe pilot's improper decision to change the landing area at a low altitude and the inadequate flare that resulted in a hard landing.NTSB CHI04CA200Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33 · Warrensburg, MOThe pilot's inadequate compaensation for the winds, and his inability to maintain directional control of the glider after encountering tall grass during the landing roll. The reported wind gust, tall grass, and the fence were contributing factors.NTSB SEA04LA146Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Homedale, IDThe loss of engine power for an undetermined reason while maneuvering at low altitude, which resulted in a hard landing.NTSB CHI04CA191Accident · Serious injuriesData collectionFinal reportAerostar RX-7 · Wausau, WIThe pilot's inability to compensation for the turbulence and wind conditions. Contributing factors were the variable winds and the turbulence.NTSB NYC04CA177Accident · Serious injuriesData collectionFinal reportAvian Falcon II · Middletown, OHThe passenger's inadvertent fall from the basket, during landing. A factor in this accident was the windy conditions.NTSB LAX04CA270Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-50-3 · Lone Pine, CAthe pilot failed to maintain runway alignment, and misjudged the clearance between the tree and the wing resulting in a collision with the tree.NTSB FTW04CA234Accident · No injuriesData collectionFinal reportLindstrand Balloons 90A · Allen, TXThe pilot's failure to maintain clearance with the power lines. A contributing factor was the gusty wind conditions.NTSB FTW04LA190Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Caddo Mills, TXThe other pilot's inability to maintain directional control during landing roll as a result of the failure of the landing gear.NTSB DEN04CA103Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 120A · Albuquerque, NMthe pilot's failure to maintain/obtain the proper descent rate.NTSB ATL04LA198Accident · Serious injuriesLimited investigationFinal reportThunder & Colt 210A · Huntersville, NCGusty weather conditions which resulted in an in-flight collision with terrain during touchdown.NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.NTSB LAX04CA246Accident · No injuriesData collectionFinal reportSchweizer 1-35 · Sparks, NVthe pilot's misjudgment of altitude and distance resulting in an undershoot of the runway.NTSB SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.NTSB SEA04CA109Accident · Serious injuriesData collectionFinal reportBalloon Works Fire Fly 9 · Aurora, ORPilot's failure to compensate for wind conditions. Wind was a contributing factor.NTSB DEN04CA085Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Durango, COthe pilot's improper in-flight planning and decision and his failure to maintain adequate terrain clearance. Contributing to the accident was the lack of suitable terrain, and the low approach.NTSB FTW04LA155Accident · No injuriesLimited investigationFinal reportSchreder HP-11A · Cherry Valley, ARThe pilot's improper flare which resulted in a stall and hard landing.NTSB SEA04LA092Accident · Serious injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Creswell, ORThe pilot's failure to maintain clearance from the terrain while attempting to maneuver the aircraft into the wind during an off-airport landing in an open field. Factors include the pilot's inadequate in flight planning, tailwind conditions during an…
Back to NONE