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 ATL86LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Pandora, OHFollowing a early morning Balloon flight, the pilot attempted a landing in a cleared area with winds at about 14 knots. The pilot realized that the first attempt he would encounter powerlines and trees. The pilot climbed out and attempted another approach to…NTSB CHI86FEC04Accident · Serious injuriesFinal reportCameron 77 · Hamburg, MIPlt made a precautionary landing reportedly due to high winds. Upon touchdown the basket tipped and one of the pax received a fractured left leg.NTSB LAX86LA270Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Aguanga, CAA Schweizer sgs 1-26C glider collided with a wire fence while the plt was landing on a closed airstrip. The closed strip was marked with x's. several fences were stretched across the airstrip to control livestock. The pilot indicated that during flt, he had…NTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…NTSB CHI86LA154Accident · No injuriesLimited investigationFinal reportGlasflugel Club Libelle 205 · St. Elmo, ILThere was a loss of thermal activity while the glider plt was on a x-country flt. During an off arpt lndg, the wingtip of the sailplane struck weeds. Subsequently, the acft ground looped & was damaged.NTSB SEA86LA147Accident · No injuriesLimited investigationFinal reportAvian Skyhawk · Yakima, WAA forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently…NTSB MKC86FA117Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7-B · Lee'S Summit, MOThe PIC stated that prior to liftoff, the Balloon was gyrating and instructed the gnd crew member to steady the Balloon by holding the rope. Just as the Balloon became steady the PIC initiated his takeoff. The PIC was aware of turbulence in the takeoff site…NTSB NYC86LA137Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-32A · Kurtztown, PAAfter flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150…NTSB LAX86LA202Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Vacaville, CAAccording to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.NTSB LAX86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Benson, AZA Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see…NTSB CHI86LA128Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Pickney, MIThe balloonest had briefed and positioned his two pax for a anticipated hard/drag landing in a 9 kt wind. He stated the balloon touched and bounced then touched and bounced again before it entered the drag sequence of the landing. The female pax suffered a…NTSB SEA86LA114Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20-D · Minden, NVThe cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude.NTSB MIA86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Lauderdale, FLWhile towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…NTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.NTSB ATL86LA111Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Waynesville, OHThe pilot misread his altimeter and misjudged his altitude while in the traffic pattern for landing at the private gliderport. The glider collided with powerlines on the approach end of the runway and crashed short of the runway surface.NTSB LAX86FJA01Accident · No injuriesFinal reportSchweizer 2-32 · Dillingham Fld, HIThe glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident.NTSB DEN86LA107Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider L53 · Colorado Spring, COThe acft was making a landing due to an approaching thunderstorm. On final, the glider encountered moderate to severe turbulence and at 300 ft AGL, the glider was forced onto the ground by a microburst.NTSB DEN86FA103Accident · 2 fatalField investigationFinal reportI.C.A. Brasov IS-28B2 · Cedar City, UTThe plt and pax were returning from a LCL flt. Two fss specialists observed the glider on final approach to rwy 20. They stated that the acft completed two 360 degree turns with 90 degrees of bank. The glider was in the third 360 degree turn when the…NTSB LAX86LA144Accident · No injuriesLimited investigationFinal reportCentrair Schleicher ASW-20 · Phoenix, AZThe plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5…NTSB FTW86LRG15Accident · Minor injuriesFinal reportBalloon Works 8B · Round Rock, TXThe Balloon was damaged during landing in a wind of 15 KTS gusting to 40 KTS. The plt said that the surface wind increased during the flt. The Balloon was blown about 900 yds while dragging the basket across a grass field during the landing.NTSB LAX86LUG02Accident · 1 fatalFinal reportWhigham GW4A · Hemet, CADuring a tow operation, the plt of the tow plane stated that just after takeoff the glider assumed a very low tow position, then swung very high to the right then to the left. At aprx 250 ft AGL the glider plt released from the tow plane and executed a 180…NTSB MIA86LA070Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLThe pilot stated that he encountered sinking air & was unable to make the arpt. He also stated that he was operating east of the arpt & that a seabreeze wind from the west existed at the time of the accident. The effective glide ratio of a glider is reduced…NTSB DEN86LA068Accident · Minor injuriesLimited investigationFinal reportCameron 0-77 · Rio Rancho, NMThe plt stated that during the inflation of his balloon, the safety line holding the basket to his support vehicle broke during windy conditions. According to the plt, he tried to inflate the envelope in order to climb above buildings nearby. The plt…NTSB DEN86LA059Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Alamogordo, NMUpon returning to the arpt, the plt decided to make a fly-by. The plt reported that while on a modified downwind at an alt of aprx 50 ft AGL, the glider which he was piloting encountered adverse winds and downdrafts. Control of the acft was lost and it…NTSB CHI86LA018Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Comstock Park, MIAccording to the pilot she received wind information from a flight service station, the noaa and ATIS approximately 1.5 hours prior to takeoff. All these sources predicted winds to be less than 7 knots. Winds were 'very light' during Balloon inflation. The…NTSB NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…NTSB FTW86LA017Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Tulsa, OKThe plt experienced fuel exhaustion while on final apch for landing on rwy 35L at Tulsa international arpt, OK. The acft undershot the rwy by 1/2 to 3/4 of a mile where it contacted railroad tracks.NTSB DEN86LA010Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Albuquerque, NMDuring landing, while the basket of a Raven balloon was being pulled by the wind driven envelope, it struck a fence and a mobile home trailer. Of the four passengers aboard, one received minor injuries and one received serious injuries. The pilot stated that…NTSB DEN86LA006Accident · Minor injuriesLimited investigationFinal reportSkypower GBN-41-100 · Pecos, NMFlt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered…NTSB NYC85LA254Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Preble, NYA Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed…NTSB BFO85LA078Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · New Castle, VAAccording to the plt, after experiencing a loss of lift, he flew over the open field, observed electrical wires, and continued to fly parallel with the wires. As he turned westward to land in the field, the plt lost sight of the power lines in the sunset.…NTSB LAX85LA394Accident · No injuriesLimited investigationFinal reportGlasflugel ST Liebelle 201B · California City, CAThe glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt.NTSB CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…NTSB ATL85LA267Accident · No injuriesLimited investigationFinal reportBryan HP-14 · Aiken, SCPlt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to…NTSB DEN85LA234Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe plt attempted to land his Balloon in high winds resulting a hard ldg which threw him out of the basket the Balloon then began an immediate asent until a pax pulled the vent line and the Balloon settled rapidly until it hit the grd. Injuries to passengers…NTSB ATL85LKG11Accident · Minor injuriesFinal reportLet L-13 · Huntsville, ALThe commercial plt was in training for a glider rating & was on a supervised solo flt to practice a landing. During the traffic pattern, he rolled out hi on final & extended the spoilers to adjust to the desired glide path, then retracted the spoilers to the…NTSB ATL85FMG06Accident · No injuriesFinal reportLet L-13 · Chester, SCThe glider landed about 150 ft short of the rwy on the plts 1st solo in this acft. He said he noticed a rapid drop in alt at 55 mph on final approach and began to change spoiler position to compensate. He complained that the stiffness of the operation of the…NTSB MKC85LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Shawnee, KSThe commercial Balloon plt was giving a ride to three paying passengers. Plt stated that during the landing apch higher than normal winds were present so he briefed the passengers to lean against the side of the basket. He stated that he pulled the deflation…NTSB DEN85LA216Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus B · Colorado Sprgs, CODuring takeoff the glider left wing touched the ground. The glider then cartwheeled sustaining substantial damage.NTSB ANC85LA140Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Anchorage, AKWhile the plt was approaching a field to land, the wind shifted & gusted, blowing the Balloon toward a light standard. The envelope grazed the standard, ripping the material near the top of the Balloon. The Balloon then landed in the field. The wind was…NTSB NYC85LA191Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Plymouth, MAThe aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…NTSB DEN85FA196Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7 · Brighton, COA hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…NTSB DEN85FQG01Accident · Serious injuriesFinal reportRolladen-Schneider LS-4 · Tatum, NMThe plt stated that 7 miles sw of Tatum, NM, an area of 'sink' was encountered and insufficient alt remained to glide to the Tatum arpt. An apch was then made (into the sun) for a landing in a fld. During the landing flare, the plt noticed a row of fence…NTSB BFO85LA053Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Warrenton, VAAfter liftoff both the PIC and the plt getting checked out in the Schweizer sgs 2-33A stated that they encountered moderate turbulence in the area. When the sailplane reched approximately 200 ft AGL the tom rope separated from the aircraft and N65818 was…NTSB DEN85LA185Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20B · Grand Lake, COOn returning from a 300-kilometer cross-country flight, in a glider the pilot noticed the absence of thermal activity and was forced to land in an open field. The pilot said he landed with a 2-5 knot tailwind and his approach and touchdown speed was too fast.…NTSB NYC85LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Cambria, NYThe glider, while returning to land after a pleasure flt, encounter a rainshower and strong downdraft. The plt made a landing in a farmers fld. During the landing the right wing caught and the acft ground looped, incurring substantial damage.NTSB FTW85LA266Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Georgetown, TXThe accident occurred during an glider launch. The tow acft was unable to gain alt, and turned back to the arpt to release the glider. The tow acft began to sink into the trees and was forced to release the glider beyond safe gliding distance to the rwy. The…NTSB CHI85LA247Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe glider landed in trees after the spoiler 'popped' open in flt during a towed takeoff. The tow plane released the glider at 300 ft AGL after the spoilers opened. The plt landed without retracting the spoilers. Two FAA inspectors stated that they checked…NTSB CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…NTSB NYC85LA151Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103-II Aero · Erwinna, PAThe glider contacted tall hay in a fld and ground looped during an off arpt forced landing. The plt stated the glider was released downwind from the arpt at an alt of aprx 3000 ft AGL. A sink rate of 1000 fpm developed preventing the plt from returning to…
Back to NONE