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 ATL83LA325Accident · No injuriesLimited investigationFinal reportPiccard AX-6 · Louisvile, KYThe plt received a wx briefing at 0600 EDT & noted nothing significant that would be a hazard to flt. He proceeded to long run park, aprx 20 mi east of louisville, KY, to launch the ballon. There was a 654 foot tower in the vicinity, but the plt believed the…NTSB ATL83LA322Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20B · Cordele, GAThe plt was competing in a regional soaring contest. While en route from the 1st turn point he encounter rain & elected to land in a pasture. During the landing roll, the tail skid struck a hole which cracked the fuselage, immediately forward of the empennage.NTSB FTW83FA364Accident · No injuriesField investigationFinal reportBalloon Works Firefly AX-7 · Fort Worth, TXThe intended landing area was a parking lot. Adjacent to the lot was a one-story building on top of which a tv antenna about 20 ft above the roof top. In an effort to clear the antenna during the descent to the parking lot, the pltwas not aware of a set of…NTSB NYC83LA197Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Fairfield, PADuring the apch, the plt encountered unfavorable wind conditions & the glider touched down long. In order to avoid an embankment beyond the end of the strip, the plt turned toward a parallel rwy overrun area. Subsequently, the left wing hit two 55 gal drums…NTSB NYC83LA190Accident · No injuriesLimited investigationFinal reportLet L-13 · Fredericksburg, PAAfter lift-off from a tow takeoff, the towplane was unable to attain the normal tow airspeed of 65 to 75 mph & continuedat about 55 mph. The glider plt thought the towplane was having engine problems, & as the two acft circled the arpt, theglider plt released…NTSB LAX83LA358Accident · No injuriesLimited investigationFinal reportLaister LK10 · Jacumba, CAThe acft struck a bush during a landing short of the rwy. The instructor in the rear seat noted that the airspeed indicator at that position did not register below 60 mph by design. The instructor had no recent experience in this makeof acft and had no…NTSB CHI83LA318Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Utica, MIThe student pilot made a delayed decision to land and landed within a few ft of wires without seeing them. The ground crew tried to hold him but the balloon still had too much lift. The student then saw the wires and tried to go over thembut the collision…NTSB CHI83LA310Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Hamel, MNDuring flt, the plt used fuel from 2 of 4 propane tanks, then switched to the 2nd 2 tanks & started a descent. At aprx 300 ft AGL, he tried to start the burner, but could not get a light because the pilot light was out. He attempted to manually relight the…NTSB FTW83FA324Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Azle, TXDuring a landing in light wind conditions, the balloon touched down beside a power line. After touchdown, the balloon envelope collapsed over the power line which carried 7200 volts. The voltage traveled to the basket/gondola which overturned on the grass…NTSB CHI83LA314Accident · No injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diamant · Frankfort, MIThe plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.NTSB ATL83LA266Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrenton, VAThe pilot collided with a tree while landing in windy conditions. The pilot had flown one dual flt on this day and then went up for a 39 minute solo flt. Upon her return she was low on downwind so she made a close in base but drifted to theright on final in…NTSB ATL83LA259Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Cirrus · Damascus, MDThe glider collided with a fence during an off arpt forced landing. The plt stated that she did not see the power lines until she was on the final approach. She maneuvered the glider to miss the powerlines but was unable to miss the fence and landed short.…NTSB MKC83LA140Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Ellsworth, KSThe Balloon collided with a radio tower during takeoff. The wind was reported to be from 180 degrees at 12-18 KTS. There is no evidence that this plt received weather briefing. This Balloon was launched closer to the tower than any of the other balloons…NTSB LAX83LA347Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Phelan, CAWhile on a local flt, thermal activity decreased, so the glider plt headed back to the arpt. On the way back, he encounted an area of sinking air & lost 1500 to 2000 ft of alt. He elected to land on a road. During the roll-out, the left wing hit a dirt…NTSB ATL83LA243Accident · No injuriesLimited investigationFinal reportSchleicher AS-K13 · Tullahoma, TNThe pilot stated that his approach was too fast and he bounced the acft during the landing. The glider drifted left and collided with a hayroll. The collision caused another swerve and a subsequent collision with another hayroll.NTSB CHI83LA265Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Flint, MIAfter takeoff, the plt leveled the Balloon, and a short time later, he collapsed to the floor of the gondola & had difficulty breathing. The Balloon began descending. Subsequently, it hit the porch of a house & was damaged. The plt died from acute myocardial…NTSB MIA83LA157Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Chuluota, FLThe plt reported that after he was airborne for 40 min, he was forced to terminate the flt due to the apch of a severe rain shower. He stated that when the acft was on a final apch to rwy 11, a sink rate developed that he could not arrest. Subsequently, the…NTSB ATL83LA226Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe pilot stated that this was his third flt of the day and his first in this particular acft. He misjudged his glide path and landed about 100 feet short of the runway. The glider rolled into the creek and the nose impacted about 2 feet below the top of the…NTSB ATL83LA223Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Ashburn, GAThe plt was participating in a soaring contest & was on a round robin course from cordele, GA to perry, dawson, sylvester & back to cordele. On the return leg, there was insufficient lift to complete the trip, so an alternate landing site (wheat field) was…NTSB NYC83LA154Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Freeport, PAThe glider collided with a fence during landing. The glider had experienced loss of lift shortly after a release from tow at 2500 ft AGL. Heavy sink and alt loss was encountered and continued. The pilot started a long straight in final approach to land but it…NTSB DEN83FTE03Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Del Norte, COWhile circumnavigating snow showers at night in mountainous terrain the plt elected to make a precautionary landing on a highway. The acft struck trees on a hillside that the plt hadn't seen in the darkness.NTSB FTW83LA255Accident · No injuriesLimited investigationFinal reportGlasflugel H-301 · Los Lunas, NMThe glider ground looped off the rwy after the wingtip contacted tall grass. The acft had gone to the right early in thetow but the plt thought the tow would straighten him out even after the wing dropped to the ground. When the right wing contacted tall…NTSB CHI83LA226Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Lansing, MIThe plt was participating in the national 15 meter championship meet. During a triangular course, he ran out of thermal activity & selected a field for a landing. From the air, he thought he had selected an alfalfa field with a 5 to 6 inch growth. However, he…NTSB LAX83FA242Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Bridgeport, CATwo Schempp-Hirth gliders, N184N & N6482, were being flown in a x-country contest along a triangular course. The course started at minden, NV & went to schurz, NV & Bridgeport, CA, then back to minden. The plts of both gliders had participated in contests for…NTSB CHI83FA220Accident · Serious injuriesField investigationFinal reportSchaffer-Provencher UW · Stockbridge, MIThe balloon landed downslope at about 7 KTS in a rip/drag landing without ground assistance. One of the two passengers was on the downslope side of the basket facing the direction of landing. She lost her grip on the top rail of the basketduring touchdown and…NTSB CHI83LA179Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Cadiz, OHThe student pilot had spiraled down on base to final approach instead of entering a downwind leg as briefed. As the student turned on final for runway 31, he saw an aircraft that had departed runway 13 and thought a hazard existed. Witnesses reported there…NTSB NYC83LA099Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Erwinna, PAThe glider was on a dual instructional flight for landing practice. On the final approach to landing the glider lost lift after experiencing excessive sink and clipped the tops of trees. The glider landed short of the intended area and the wings and nose of…NTSB LAX83LA190Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-4 · La Jolla, CAThe plt was qualified for solo winch launches in an SGS-1-26 glider. On his 1st winch launch using a c.g. hook in this glider, he allowed the acft to enter an abnormally high angle of attack, which was observed thru-out the takeoff process. The glide then…NTSB LAX83LA234Accident · No injuriesLimited investigationFinal reportLet L-13 · California City, CADuring flt, the glider sustained in-flt structural damage while maneuvering at an altitude of aprx 17,500 ft MSL in the vicinity of California City, CA. During a preliminary verbal statement to an FAA inspector, the plt stated that he had done a couple of…NTSB MIA83LA095Accident · No injuriesLimited investigationFinal reportMolino PIK 20 · Highsprings, FLThe acft crashed short of the runway during a pleasure flight. The pilot was not injured. The pilot stated that he descended below the tree line and encountered a wind shear. He traded altitude for airspeed and the acft encountered thetop wire of a fence. The…NTSB LAX83LA170Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Mesa, AZAccording to the plt, there was no wind when he began the sight-seeing flt; however, after takeoff, the wind steadily increased to aprx 12 KTS. By this time, the balloon was approaching a large green field, so he elected to land rather than take a chance of…NTSB NYC83LA076Accident · No injuriesLimited investigationFinal reportBurkhart Grob G10Z Astir CS · Buena Vista, PAThinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft…NTSB FTW83LA155Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Springtown, TXThe balloon was on a 'hare & hound' competition flight with a commercial plt & student plt on board. After the competition portion was completed, the pilot-in-command told the student to take control & continue flying, then land at her discretion. After about…NTSB CHI83LA134Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly AX-7 · Augusta, MIThe Balloon made a hard landing and ejected the pilot and passenger. The landing was made in a school parking lot. Afterdropping the occupants the Balloon contacted power lines with the envelope. The occurants were not injured.NTSB LAX83LA145Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-33A · Fremont, CAThe acft banged into the ground during the takeoff ground run. The glider had swerved off the rwy during the tow into a muddy grass area, the plt attempted a premature takeoff to prevent getting struck in the mud. He stated that lack of forward speed and the…NTSB ANC83LA049Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Anchorage, AKThe two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the…NTSB ATL83LA123Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau L SPATZ-55 · Woodbine, MDThe aircraft collided with a snowbank during landing roll. The turf landing site was clear but snow had been piled two to four feet deep alongside the strip during the clearing process. As the aircraft neared the end of the strip during landing the pilot…NTSB FTW83LA112Accident · No injuriesLimited investigationFinal reportPratt-Read PRG-1 · Littlefield, TXThe glider was being operated by a boy scout explorer post. The 15 year-old scout was one of the first boys to solo the 40 year-old glider. While returning from a 50 min soaring flt, the glider spun to the ground after entering a strong thermal. According to…NTSB FTW83FA102Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-26B · Hempstead, TXThe glider was observed to stall/spin during turn from base to final. The plt was endorsed for solo in the heavier blanik L-13 & Schweizer 2-33, but not in the 1-26B. His logbook revealed four instructor entries concerning airspeed control. The acft was being…NTSB MKC83LA053Accident · No injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-B · Greenwood, MOThe student plt/owner was being instructed by a free Balloon plt with a commercial certificate. According to the commercial plt, the Balloon had been inflated, but the air was still not hot enough for flt, and the wind blowing over the envelope created a…NTSB DEN83FTE05Accident · No injuriesFinal reportSchweizer 1-36 · Colo Springs, COThe glider was substantially damaged during a pullup from a dive at altitude. The wing was rippled and beckled and damaged at the attach points. The dihedrial had changed from 6 degrees to 8.5 degrees. There was also unmeasured change in the sweepback. It is…NTSB MKC83LA051Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Indianola, IAThe pilot elected to make a touch and go landing in wind that was from 010 deg at 7, gusting 9 KTS. During touchdown, the basket was drifting and tilted over sideways. The passenger weithed 290 lbs and was unable to maintain his balance. When the basket…NTSB LAX83LVG02Accident · No injuriesFinal reportSchleicher ASW-20 · Calistoga, CAThe pilot stated that he forgot to connect the elevator control when he assembled the glider for the flight. He also stated that he did not become aware of this situation until he tried to use the control during takeoff. The aircraft crashed in a nose down…NTSB NYC83LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33AK · Mecklenburg, NYDuring approach the pilot misjudged the wind velocity and failed to allow for strong downdrafts. The glider lost altitude 4-500 feet short of the field over a wooden area and came to rest in a nosed over position in the trees.NTSB FTW83LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon collided with trees while landing in a zoo parking lot. The weather was VMC and no flight plan was filed. The pilot stated that in attempting to land next to the Balloon they were chasing in a hound and hare game, he allowed the gondola to drag…NTSB NYC83LA001Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26 · Kutztown, PAThe student pilot reported that while he was landing the glider, he overshot. Subsequently, the glider collided with a signboard and pole.NTSB ATL83FA001Accident · 3 fatalField investigationFinal reportEagle C-7 · Piedmont, SCBalloon was inflated with difficulty because of gusty winds. Balloon did not have a skirt. During the flight which ended in the accident the balloon seemed to have trouble and during the final moments it was in a descent which ended with the envelope as a…NTSB FTW83LA010Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon landed in high winds and was dragged by the envelope for about 150 yards. While the gondola was being dragged a passengers boot got caught and twisted his leg so that both bones were broken. The weather was VMC and no flight plan was filed. The…NTSB FTW82DA368Accident · No injuriesFinal reportI.C.A. Brasov IS-28B2 · Katy, TXN1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to…NTSB MIA82DA186Accident · No injuriesFinal reportSchweizer SGS 1-26B · High Springs, FLThe pilot was on a round robin cross-country flight. On the last leg of the flight, he was unable to locate sufficient lift to reach the destination. A large, unobstructed field was selected for a landing. However, the field contained a stand of waist High…
Back to NONE