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 ATL96LA072Accident · No injuriesLimited investigationFinal reportCessna 140 · Elkin, NCfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB FTW96FA156Accident · Serious injuriesField investigationFinal reportThunder and Colt 180A · Hartsel, COThe pilot's selection of unsuitable terrain on which to make a landing. The rocky terrain was a related factor.NTSB LAX96LA144Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Hollister, CAthe pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.NTSB LAX96LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Minden, NVthe pilot's misjudgment of distance and altitude from the airport, which resulted in an off-airport forced landing.NTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.NTSB LAX96LA089Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Lucerne Valley, CAthe balloon's encounter with unexpected high wind conditions, and the pilot's inability to stop the balloon prior to contacting ground obstructions.NTSB MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.NTSB LAX96LA060Accident · Serious injuriesLimited investigationFinal reportLaister LP-15 · Adelanto, CAthe pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB BFO96LA009Accident · No injuriesLimited investigationFinal reportAerostar Raven S49A · Ark, VAthe flight instructor's improper procedures while inflating the balloon using an external fuel source, and the fuel leak.NTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.NTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.NTSB SEA95LA228Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAfailure of the pilot to properly flare the airplane during the landing. Factors relating to the accident were: the pilot's improper approach to land, exceeding the proper touchdown point for landing, failure to go-around, while there was sufficient runway…NTSB MIA95LA225Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU-2-22K · Picayune, MSThe pilot-in-command's disregard of a weather forecast and flight into known adverse weather condition (thunderstorm). The thunderstorm, and associated wind gusts, were factors.NTSB FTW95LA376Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colorado Spgs, COAn encounter with a wind shift during landing.NTSB LAX95LA315Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe pilot's selection of a runway inappropriate for the tailwind condition and his resultant failure to achieve a touchdown point which would allow the aircraft to stop prior to over running the departure end. The rough condition of the dirt runway, the lack…NTSB LAX95LA311Accident · Serious injuriesLimited investigationFinal reportElan Glaser Dirks DG-300 Elan · Truckee, CAthe pilot misjudged his planned approach by selecting a touchdown point close to the runway's approach end that did not provide sufficient clearance to safely maneuver when forcast turbulence and downdrafts were encountered. The pilot's early extension of…NTSB LAX95LA305Accident · No injuriesLimited investigationFinal reportSikorsky CH-54A · Emigrant Gap, CAa compressor stall in the right engine for an unknown reason, which resulted in a loss of power in that engine; and inadequate crew coordination between the pilot and copilot, which resulted in their failure to ensure that the external load was promptly…NTSB FTW95LA338Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon Newport AX8 · Houston, TXThe loss of lift and subsequent hard landing as result of the disengagement of a velcro strip at the top of the balloon's envelope.NTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.NTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.NTSB SEA95LA188Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ephrata, WAThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were crosswinds and gusts.NTSB FTW95LA326Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Red River, NMThe pilot's lack of compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the lack of thermal lift and the tailwind.NTSB NYC95LA160Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Deerfield, MAThe pilot's inadequate evaluation of the weather, which resulted in an encounter with unfavorable winds and an inflight loss of control. The unfavorable/high winds and sudden wind gusts were related factors.NTSB FTW95LA299Accident · Serious injuriesLimited investigationFinal reportSlingsby T-51 · Odessa, TXThe pilot's failure to maintain airspeed required for flight, resulting in an inadvertent stall/spin at low altitude. A factor was the windshear.NTSB NYC95LA156Accident · No injuriesLimited investigationFinal reportSchweizer S-2-33A · Elmira, NYThe pilot's delayed decision to return to the departure airport, which resulted in insufficient gliding altitude, and the subsequent off airport landing in the trees.NTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.NTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.NTSB FTW95LA209Accident · No injuriesLimited investigationFinal reportPurdy HP-18 · Hempstead, TXThe pilot's poor in flight planning/decision. The lack of thermal lift was a factor.NTSB LAX95LA184Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Honolulu, HIthe pilot's attempted flight in close proximity to terrain under gusty wind conditions at an inadequate terrain clearance altitude.NTSB LAX95LA172Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 180A · Tucson, AZthe inability of the pilot to compensate for the wind conditions which resulted in the basket tipping over following touchdown during a high-wind landing.NTSB BFO95LA046Accident · No injuriesLimited investigationFinal reportSchweizer SC2-33A · North Adams, MAthe failure of the tow rope during the initial climb. Related factors are the gusty wind conditions, the low altitude at which the failure occurred, the tailwind during the emergency landing roll, and the CFI's intentional ground loop due to the obstacle…NTSB LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.NTSB ATL95LA069Accident · Minor injuriesLimited investigationFinal reportAerotek Zuni · Morganton, NCThe pilot's poorly planned approach which resulted in the loss of control of the aircraft because of gusty wind conditions.NTSB FTW95LA144Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Edgewood, NMThe flight's encounter with a downdraft. The lack of a suitable landing area was a factor.NTSB SEA95LA069Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Bozeman, MTThe pilot misjudged his altitude and distance from the runway. A factor was the pilot's failure to obtain the current altimeter setting.NTSB LAX95LA050Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Tehachapi, CAthe pilot's poor in-flight planning/decision and inadequate airspeed. The downdraft and trees were factors in this accident.NTSB NYC95LA040Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Blairstown, NJThe pilot's failure to maintain the proper descent rate.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB LAX95LA036Accident · Serious injuriesLimited investigationFinal reportThunder and Colt TC-180 · Peoria, AZthe flight's encounter with unforecasted high winds which resulted in a hard landing.NTSB FTW95LA046Accident · Serious injuriesLimited investigationFinal reportRaven S100A · Las Vegas, NMThe pilot's improper in-flight planning/decision. A factor related to the accident was: the high wind condition.NTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.NTSB MIA95LA013Accident · Minor injuriesLimited investigationFinal reportSemco Challenger · Miami, FLFailure of the basket suspension cables due to corrosion and overstress separations. Contributing to the accident was an inadequate annual inspection of the basket suspension cables by an authorized FAA repairman.NTSB MIA95LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Mulberry, FLThe failure of the pilot-in-command to perform an adequate preflight inspection resulting in a leaking brake going undetected. This resulted in the failure of the brake due to loss of hydraulic fluid and collision with a sign and a ditch when the aircraft…NTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.NTSB FTW95LA006Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Alamogordo, NMThe encountered turbulence. A factor was the lack of suitable terrain available for the forced landing.
Back to NONE