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 CHI84LA268Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Batavia, ILThe plt received a wx briefing before the flt. The 1950 surface observation reported winds from 090 deg at 4 KTS. During flt, the winds suddenly picked up & the plt attempted a landing. A rapid rate of descent developed & the balloon collided with trees…NTSB CHI84LA260Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Geneva, ILThe Balloon descended in an area of thunderstorms and turbulence and collided with trees. The plt said the Balloon 'caved in' and descended rapidly. The plts husband and a passenger revealed that the Balloon was 'vented' by the plt to land before reaching a…NTSB ANC84LA104Accident · No injuriesLimited investigationFinal reportRaven S-55A · Anchorage, AKWhile apchg to land on a school ground, the balloon plt lowered a drop line for the ground crew, then looked forward & saw a power line. He told the ground crew not to touch the drop line. The drop line contacted & pulled one power line into another, causing…NTSB NYC84LA259Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Sugarbush, VTThe acft lost lift & made an emergency landing in a field. During the landing the acfts wing struck a haystack which pitched the nose of the acft down. This resulted in a hard landing & ground loop.NTSB NYC84LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perkasie, PAThe sailplane lost lift and during a forced landing wires were spotted on the approach. In attempting to fly under the wires the acft was flown into an embankment.NTSB DEN84LA183Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Zugvogel Iiib · Taos, NMAccording to the plt, the winds increased during a flt in a mountainous area & the thermal updrafts 'broke up.' While gliding back to the arpt, he encountered sinking air & was forced to make an emergency landing on rough, sage brush covered, terrain. This…NTSB CHI84LA244Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7B · Lake Orion, MIA 74 year old passenger in a balloon lost her footing during landing and fell on her arm. Later examination revealed that her arm was broken. The plt and another passenger were not injured. The plt reported that the passengers had been briefed on landing and…NTSB ATL84LA204Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Manning, SCThe plt entered a steep turn at the end of a 2nd field that she had selected for a landing. While maneuvering to land, the right wing contacted the ground & the left wing hit a power line. This was the plt's 1st tow & release in this model.NTSB NYC84LA195Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Saratoga, NYGlider was on final approach in severe turblence. Acft drifted on final apch and plt used full control deflection with no effect. A collision with trees resulted. The plt said that the wind before takeoff was greater then 30 KTS from 360 degrees. The apch was…NTSB CHI84LA227Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Flint, MIThe balloonist stated that the wind became stronger during her flt and even though she selected a landing area adequate for a high wind landing the balloon was dragged about 200 ft until the envelope became entangled in trees. The flt lasted about 1 hour and…NTSB CHI84LA242Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Grayslake, ILThe plt stated that as the balloon touched down, he lost his footing & his left ankle slipped into the corner of the gondala. He suffered a fractured, dislocated ankle.NTSB LAX84LA327Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS1-26D · Lucerne Valley, CAThe plt reported that his glider was the 3rd to launch (using an auto tow) on a distance completion flt. He released the tow cable at about 900 ft & began searching for lift. No lift was found. After a short time, he attempted to return to the departure…NTSB FTW84LA254Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Amarillo, TXDuring a pre-flt breifing, the wind was reported to be from 280 deg at 6 to 12 KTS. At launch time, the plt estimated the wind was blowing at 7 KTS. He took off at 0720 CDT without difficulty & climbed to about 1000 ft AGL. Aprx 1 hr after taking off, the plt…NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…NTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…NTSB DEN84FA161Accident · 1 fatalField investigationFinal reportLet L-13 · Edgewood, NMWitnesses reported that the acft appeared to be too high, too fast, and in a crab as it approached the rwy. Over the rwy the glider was observed to roll into a right turn as the nose came up. Shortly thereafter the right wing struck 3 parked acft and collided…NTSB LAX84LA297Accident · No injuriesLimited investigationFinal reportLet L-13 · El Mirage, AZThe glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a…NTSB NYC84IA164Incident · Minor injuriesIncident investigationFinal reportBarnes Firefly 7 · Gorham, MEDuring touch and go landings the balloon encountered increased winds. The balloon touched down hard tilting the basket onto its side. A passengers arm became caught between the basket and the ground.NTSB LAX84LA276Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Vacaville, CAThe student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He…NTSB LAX84LA262Accident · No injuriesLimited investigationFinal reportMolino PIK-20B · El Mirage, CAThe plt reported that when he was 1/2 mi from the rwy at 835 ft AGL, his airspeed was 70 KTS. While descending through 400 ft AGL, his airspeed flickered 3 times to zero. The 3rd time, it stayed at zero & the glider dropped to the ground. The reported wind 11…NTSB LAX84LA257Accident · Serious injuriesLimited investigationFinal reportRaven S-55A-707 · Glendale, AZDuring a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry…NTSB SEA84LA080Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26C · Mount Vernon, WAThe sailplane encountered deteridrating thermals & elected to make an off airport landing as he did not think he could reach the airport. He overshot the selected field in his attempt to miss some wires at the apch end of the field despitethe use of spoilers…NTSB LAX84LA246Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Prescott Valley, AZWhen the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers…NTSB MIA84LA120Accident · No injuriesLimited investigationFinal reportSchweizer SGU-22 · Williston, FLThe acft collided with the wind tetrahedron during landing. The plt stated he landed on the grass parrllel to rwy 22 and a combination of landing long and ground effect caused him to hit the telrahedron.NTSB LAX84LA216Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Marana, AZThe plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted…NTSB LAX84FA180Accident · 1 fatalField investigationFinal reportMaupin WOODSTOCK-I · California City, CADuring flt, the glider sustained an in-flt failure of both wings, then entered an uncontrolled descent & crashed. An exam of the wreckage revealed no preexisting structural problems. The glider was equipped with a recording barograph. A barograph trace showed…NTSB NYC84LA139Accident · No injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Butler, PADuring a descent to land, the plt of a Balloon tried to level off to reach a desired touch down point. The plt added heat, but the Balloon continued to descend. After a hard bounced landing, the Balloon began to ascend, but it collided with tree limbs & was…NTSB SEA84LA046Accident · No injuriesLimited investigationFinal reportLark IS28B2 · Issaquqh, WAThe CFI stated that while returnsing to the airport he encountered turbulence. When it became obvious that reaching the intended airport would be marginal another landing field was chosen. During turn to final, the left wing tip struck a power pole and the…NTSB LAX84LA135Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mokuleia, HIThe plt was rated for airplanes & helicopters, but did not have a glider rating. He had only 2.5 hrs in gliders, all of which was in this same make & model. During a solo instructional flt, he encountered a high sink while on a base turn to land. He stated…NTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…NTSB LAX84LA091Accident · No injuriesLimited investigationFinal reportLet L-13 · Jacumba, CAThe acft collided with a bush and groundlooped short of the rwy. The wind was unusually strong and the glider plt stated he misjudged its effect and should have flown the base leg closer. The acft landed short of the rwy and ground looped.NTSB FTW84LA087Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched…NTSB DEN84LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Colorado Spring, COThe plt reported that during his apch to land, the glider encountered turbulence. He stated that he was 'unable to maintain directional control on landing contact with ground.' The glider touched down in a left yaw. Shortly after touchdown, he regained…NTSB LAX84LA076Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-103 · California City, CAAccording to the plt, he was turning to final approach when the glider's left wing struck the ground. Reportedly, he had gotten 'too low & slow.'NTSB LAX84LA070Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Temecula, CAThe plt reported that he had received wx info from the tv, but no wx report was obtained from flt service. When he took off on a sight-seeing flt at 0745 PST, the wind was calm. After takeoff, he flew at lower altitudes, then climbed & flew between 1200 &…NTSB LAX84LA063Accident · Serious injuriesLimited investigationFinal reportRider AA-4 · Salome, AZThe plt of the balloon was making a precautionary landing due to his proximity to the mexican border. To avoid high tension wires, the plt 'ripped out' at a higher than normal altitude resulting in a hard landing. The plt received a fractured skull when he…NTSB LAX84LA061Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Lucerne Valley, CAThe student plt was on his 1st solo launch using an auto tow & a nose hook. During the launch, the glider became airborne at about 42 mph. Thereafter, the student climbed successfully to an estimated alt of aprx 200 ft. at about that time, the student's…NTSB LAX84LA052Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Fremont, CAAfter receiving an aero tow to 3,000 ft MSL & being released 5 mi from the departure arpt, the plt thermaled for about 5 min. He then descended to 2,300 ft MSL & turned back toward the arpt. He encountered 'heavy sink' had insufficient altitude to reach the…NTSB DEN84LA043Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Monte Vista, COThe plt was participating in a 'hare & hounds' Balloon contest. The aircrews were wx briefed at the launch site before the event. Reportedly, there was a front approaching but it was not expected to move thru until about 2 to 3 hrs after the contest.…NTSB NYC84LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · North Conway, NHAccording to the pilot, the glider was towed to 2000 feet and released, in lift. Flt was in lift for about 30 minutes when a strong sink was suddenly encountered. The glider crashed into trees.NTSB LAX84LA037Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · New River, AZThe student plt was on his 9th solo landing when he landed on rwy 27 with a x-wing from 200 deg at 10 KTS. During the landing, the glider drifted to the north into some bushes, then swerved into a tree. The plt reported that upon landing, he lower the wrong…NTSB DEN84LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Falcon, CODuring the descent for landing, the plt observed that the wind was from the south. The plt decided to land downwind in the upsloping direction of the glider strip rather than upwind in the downsloping direction. He made his base leg too close to the strip &…NTSB CHI84LA018Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Dorr, MIDuring landing the basket hit a hill resulting in the basket stopping suddenly & ejecting the plt & passengers from the basket. The plt thought a passenger was still in the basket so she grabbed the valve line & hung on as the Balloon rose approximately 100…NTSB CHI84LA015Accident · Serious injuriesLimited investigationFinal reportAdams AB · Wyoming, MIThe balloon collided with the ground, bounced, hit a house and a utility pole before being torn enough to come to rest. The hard landing in an 8 kt wind tore the vent line from the pilots hand, he lost the ability to vent the balloon and during the collisions…NTSB MKC83LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrensburg, MOThe glider landed short of the rwy hitting a rough hump which was an old fence line. The glider bounced & landed hard on the rwy. The pax was hospitalized for 4 days for observation & treatment.NTSB FTW83LA440Accident · No injuriesLimited investigationFinal reportRaven S-55A · Santa Fe, NMThe plt elected to land the balloon between 2 power lines. During the landing, the balloon impacted another power line that was installed across the main lines. Electrical arcing occurring occurred. The balloon attachment cables, skirt & gondola were scorched…NTSB DEN83LA210Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COAfter releasing from an aerial tow about 2,000 ft AGL, the plt was unable to find lifting thermals. The glider began to descend about 800 fpm so the plt maneuvered to return to the airstrip. The glider collided with several small trees short of the rwy.NTSB NYC83LA229Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G103 · Julian, PAThe student plt & instructor (CFI) were practicing pattern work & landings. During the 1st 3 patterns, the wind was calm, however, by the time they were on their 4th pattern, the wind increased & became gusty. While the student was flying the pattern, he…NTSB LAX83FA386Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-35C · Jamul, CAReportedly, after waiting almost 2 hrs, the plt decided he would fly the sailplane, either for 1 hr or until the owner arrived, when the owner arrived, he observed the sailplane flying back & forth along the north side of ridge area. Subsequently, the acft…NTSB FTW83LA374Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26F · Caddo Mills, TXThe student plt saw a small thunderstorm moving toward the arpt, so he returned to land before it arrived. He stated he was 2 to 3 min too late. While in the traffic pattern, he encountered turbulence, downdrafts & winds reportedly gusting to 30 KTS. As the…
Back to NONE