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 CHI85LA231Accident · Serious injuriesLimited investigationFinal reportJenkins HP-18 · Wellington, OHFollowing an aprx one-half hour flt, witnesses stated that the glider did not appear to flare for landing, but instead, impacted the ground without arresting the rate of descent. The plt eported he had very poor ventilation in the cockpit and feels that he…NTSB NYC85FHM01Accident · No injuriesFinal reportSchweizer SGS-1-35 · Middletown, NYThe acft landed off the arpt after the plt lost alt in a spin. The plt was afraid that the glider would land short in trees so he landed on a highway. The hard lndg damaged the acft.NTSB SEA85LA118Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Wenatchee, WAWhile returning to the arpt to land, the acft encountered strong downdrafts of 600 to 800 fpm. An off arpt landing was made and while turning from base to final, the left wing tip struck the ground. A groundloop then occurred.NTSB ATL85LA166Accident · No injuriesLimited investigationFinal reportSchweizer SGS-233 · Chester, SCThe instructor pilot cut loose from the tow plane at 200 ft AGL during takeoff to simulate a rope break. The acft collided with trees while circling to land. CFI stated that student plt was too slow in returning to land on the rwy.NTSB NYC85LA122Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Toughkenamon, PAThe glider was being towed for takeoff & had just become airborne when the canopy came open. The plt tried to latch the canopy, but was unable, so he released the glider from the tow plane. While the plt continued to try to latch the canopy, the glider went…NTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…NTSB ATL85LA154Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Williamson, GAThe student plt stated his final apch to the rwy was made off-center to account for a x-wind. The glider touched down to the left of the paved strip & began converging on a fence. The plt retracted the speed brakes & lifted off as the glider approached the…NTSB DEN85LA128Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Colorado Spring, COThe glider collided with a parked acft following a loss of directional control during the landing roll. The plt reported the left wing dipped during the landing roll because of the x-wind. The left wing tip wheel dug into an area of soft sand beside the rwy…NTSB DEN85LA127Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Fort Collins, COThe balloon basket containing 8 pass'g & 2 crewmembers brushed alongside a fence during lndg. One pass'g who had been jostled by the landing became a victim of 1ACERATIONS & a broken arm from contact with barbed wire fence. The plt stated that the wind was…NTSB LAX85LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Hemet, CAThis was the first flight after a cockpit check-out in the Schweizer sgc 1-36. The pilot released from the tow plane when he realized that the spoilers were deployed and landed short of the runway. The pilot reported that the spoiler handle in this model…NTSB LAX85FUG03Accident · Serious injuriesFinal reportVickers Slingsby T56A Vega · Hemet, CAThe sailplane was in level flt when the plt felt flutter and lost pitch control of the acft. After one uncontrolled loop the plt bailed out and received serioud injuries during the parachute landing. Loss of all six elevator hinges had caused the elevator to…NTSB BFO85LA037Accident · Minor injuriesLimited investigationFinal reportSlingsby Type 43 Series 3F · Lovettsville, VAThe plt stated that he normally avoided landing on the rwy since the glider landed on a skid & it took a few minutes to remount it on a ground handling dolly. On this flt, he planned to land on the grass beside the apch end of the rwy. However, he allowed an…NTSB LAX85LA209Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Hemet, CAThe plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the…NTSB MIA85FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 7B · Orlando, FLThe Balloon was destroyed by an explosion and subsequent fire during touchdown in an open fld. The plt and witnesses stated the gondola touched down with a 'jolt' and tilted in the direction of travel. Shortly thereafter, a popping noise was heard followed by…NTSB LAX85LA223Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Panamint Valley, CAThe plt reported that he was landing on desert terrain in nearly calm air when a 'strong thermal wind pushed the balloon 90 degrees from the direction of track.' Subsequently, the balloon landed hard & was dragged about 150 ft across the desert. While…NTSB MIA85LA093Accident · Minor injuriesLimited investigationFinal reportMonerai S-P · Immokalee, FLThe plt was making an apch to a grass portion of the arpt not usually used for acft. The glider contacted pwr lines during the apch and subsequently collided wtih the terrain. The plt stated he never saw the pwr lines before contacting them.NTSB MKC85LA048Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Davenport, IABalloon encountered gust during initial climb and began drifting toward wires. Plt elected to deflate & balloon collided with wires & building.NTSB DEN85LA078Accident · No injuriesLimited investigationFinal reportRaven S55A · Littleton, COThe balloon envelope collided with power lines after dragging the basket & occupants aprx 200 yards along an open fld and through a fence which damaged the basket containing the occupants. The balloon plt said that the wind was only 5 KTS at takeoff but after…NTSB MIA85LA072Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pompano Beach, FLThe balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over.NTSB MIA85LA068Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Orlando, FLThe acft was flared for landing about 1/2 way down the rwy at excessive airspeed. The plt stated that as the acft touched down, it bounced into the air and impacted trees at 10-15 ft AGL. The spoilers were found in a retracted position after the accident.…NTSB DEN85LA005Accident · Serious injuriesLimited investigationFinal reportPiccard AX6W · Albuquerque, NMPlt stated he observed the wire about 3 secs before collision. Electrical short circuit severed load cables to basket, which fell to the ground, causing personnel injuries. Balloon envelope drifted away, finally coming to rest 150 mi from accident site.NTSB SEA85LA002Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hood River, ORAt about 150 ft AGL on climb out, the tow plane lost power for an unspecified reason. The glider pilot released the tow and executed a 180 degree course reversal to a downwind (15 KTS) landing. During roll out, the left wing contacted the ground, causing an…NTSB NYC85LA024Accident · No injuriesLimited investigationFinal reportRaven S-66A · Little Compton, RIPlt brushed basket against tree tops and bushes to slow the balloons forward speed. Plt pulled deflation port aprx 10 ft AGL over a mown hay field with an 8-10 mph horizontal, 100 fpm vertical speed. Basket bounced and gust of wind caught deflating envelope…NTSB NYC84LA327Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Churchton, MDDuring glider tow climbout, encounter with thermal resulted in momentary tow rope slack. Tow rope separated in overload when slack was taken up. Glider plt selected nearest open fld & set up landing pattern. On downwind leg, plt noted obstructions in fld,…NTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…NTSB CHI84LA409Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIAccording to the CFI the glider was at about 500 ft AGL on base leg when a downdraft caused the acft to descend and touch down 50 ft short of the rwy.NTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…NTSB LAX84LA492Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Marana, AZThe plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with…NTSB MKC84FCD03Accident · Serious injuriesFinal reportSchweizer SGU2-22E · Ames, IAThe glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field.NTSB MKC84LA276Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Cedar Rapids, IAThe Balloon landed in a field and as wind drifted it, the envelope draped over a pwr line. The plt said his burner malfunctioned and caused the inaccurate landing. Another account was told later in which the plt switched to an empty propane tank for landing.…NTSB DEN84LA276Accident · Serious injuriesLimited investigationFinal reportMolino PIK-20 · Calhan, COThe glider struck a barbed wire fence while landing in a pasture. The plt said he encountered a downwash at the edge of a storm that resulted in an 800 fpm rate of descent and forced landing.NTSB ATL84LA278Accident · Minor injuriesLimited investigationFinal reportHead Balloons AX7-77 · Austell, GAWhile flying at a low alt looking for a suitable landing area the plt noticed power lines at a higher alt. Plt initiallyapplied heat to the envelope to try and climb above the wires, but did not immediately realize the height of the wires. Plt then advised…NTSB DEN84LA289Accident · Serious injuriesLimited investigationFinal reportRaven AX-8 · Clark, CODuring a normal high wind landing a pax received two fractures of the fibula bone. Another pax reported that the injured pax was standing on one leg with the other knee bent resting on a propane tank during the landing. Pax were reportedly briefed on the…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB FTW84LA368Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · The Colony, TXThe plt reported that after takeoff, the wind picked up to about 12 to 15 KTS. She stated she made a normal high wind landing, but due to the angle of landing & position of the passenger's foot, her ankle broke during touchdown.NTSB ATL84LA300Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe plt inadvertantly deployed the flaps on final apch instead of the spoilers. The glider overshot the airstrip touching down in rough terrain off the departure end.NTSB LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…NTSB NYC84LA265Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Plymouth, MAThe plt stated that when he released his glider at 2500 feet, soaring conditions were good. Conditions deteriorated which resulted in no lift and altitude was insufficient to safely return to the departure airport. The pilot attempted to land off the airport…NTSB SEA84FA185Accident · 2 fatalField investigationFinal reportde Havilland Beaver DHC-2 · Ketchikan, AKThe plt flew into a canyon with a climb-out gradient in excess of the acft capability and collided with the upsloping terrain. The plt said he had hit a downdraft and turned away from the rising terrain just as collision occurred. Surviving passengers do not…NTSB MKC84LA216Accident · Serious injuriesLimited investigationFinal reportAdams AB · Ballwin, MOThe plt reported that before landing, he rebriefed the passengers on the landing technique. He noted that a lady passenger seemed nervous about the landing. The plt landed in a pasture with an estimate 6 kt wind. Reportedly, the balloon made a soft touchdown,…NTSB LAX84FA382Accident · 1 fatalField investigationFinal reportEntwicklungsgemeinschaft Phoebus C · Yermo, CAThe pilot encountered adverse soaring flight conditions during a long x-country attempt and was forced to divert to an intermediate airport. On a long glide to his selected landing site, the pilot encountered high powerlines. Turning to avoid them , he lost…NTSB DEN84LA210Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Eagle, COThe acft was turned at a low alt in high density alt on final approach and stalled at about 20 ft AGL. The glider contacted the rwy and ground looped.NTSB SEA84LA159Accident · No injuriesLimited investigationFinal reportApplebay Sailplanes Zuni II · Ephrata, WAThe two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.NTSB SEA84LA159Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ephrata, WAThe two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.NTSB NYC84FNC05Accident · Serious injuriesFinal reportRaven RX 6 · North Lebannon, MEStudent balloon pilot was on third supervised solo flt with his flt instructor acting as member of the chase crew. Plt was controlling descent with short bursts of propane burner. Ground contact was hard enough to cause the balloon skirt to continue downward…NTSB CHI84LA309Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle · Osseo, MIThe plt stated that the thermals dissipated & he had to make an off arpt landing. The landing was made in a field of tall grass & the left wing contacted the grass first resulting in a 90 deg ground loop. The aft fuselage section separated.NTSB SEA84LA148Accident · No injuriesLimited investigationFinal reportGlasflugel 604 · W Silver Spring, NVThe glider plt was returning to the Douglas country arpt after a 470 mi x-country flt. While at about 10,000 ft, he encounter a downdraft that was associated with a nearby thunderstorm & lost about 7000 ft in 7 miles. He elected to land on a highway. Just as…NTSB SEA84LA144Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes AX-8 · Monroe, WADuring the ballon descent, the plt said he briefed the passengers to bend their knees & hold onto something inside the basket. According to the plt , the descent became more rapid due to a downdraft. The passengers were again warned to 'hang on' because it…NTSB MKC84LA182Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Overland Park, KSPrior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…NTSB LAX84LA369Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126D · Lucerne Valley, CAThe student plt reported that during a winch launch with a left x-wind, the wind lifted the left wing & the right wing contacted the ground. The glider then veered to the right & the right wing hit a wind sock & a vehicle. He reported that a wind-shift had…
Back to NONE