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 DEN82DTE26Accident · Serious injuriesFinal reportBarnes AX-7 · Aurora, COThe VFR local pleasure flight was being conducted in strong 20-25 kt wind conditions. The wind condition had changed substantially during the duration of the flight. During a landing in a plowed field the gondola bounced and was drug approximately 270 feet.…NTSB DEN82DTK07Accident · Serious injuriesFinal reportRaven RX-7 · Phillip, SDAfter the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…NTSB CHI82DA325Accident · No injuriesFinal reportCameron 0-77 · Wall Lake, MIThe pilot reported that during flight, he encountered unexpected light turbulence and elected to land at the next available spot. He stated that during a landing approach at about 50 ft above the treetops, a gust of wind was encountered that forced hot air…NTSB LAX82DA304Accident · Serious injuriesFinal reportMenees LP-49MS · Sparks, NVThe plt stated he released from the tow plane at 1,200 ft AGL in a 200 fpm lift. Almost immediately he encountered a 1,000 fpm sink & immediately entered the pattern for a landing. He was unable to arrest the sink rate & the acft landed hard breaking off the…NTSB NYC82DA183Accident · No injuriesFinal reportSchweizer SGS-2-33A · Eighty Four, PAThe tow line released at 40 feet AGL in a glider tow launch. The glider pilot tried to land on the runway but landed adjacent to it and collided with a tree which ground-looped the glider. The tow hitch mechanism was broken off at the tubing cluster & was…NTSB FTW82DQA23Accident · Serious injuriesFinal reportRaven RX-6 · Albuquerque, NMThe pilot reported that the balloon was inflated and launched at about 0700 MDT. Later, the wind velocity increased and a final landing was made at about 0930 MDT. During the landing, a ground crewmember's leg was broken when it was hit by the gondola.NTSB NYC82FNC11Accident · Serious injuriesFinal reportFirefly 7 · Winslow, MEWhile descending to land in an open field, the balloon began drifting towards high powerlines. In an attempt to avoid a collision, the pilot fired the burner approximately nine times, using short blasts of the burner. The balloon failed to gain altitude and…NTSB SEA82FYP08Accident · Serious injuriesFinal reportLark IS28B2 · Springdale, WAThe pilot received an aerial tow to 5000 feet and was able to find lifting currents for approximately 1.5 hours. Unable to obtain adequate lift the pilot decided to attempt an off airport landing on a dirt road crossing a wheat field. At an altitude of…NTSB LAX82DA254Accident · No injuriesFinal reportBlanik L-13 · Murrieta, CAPilot landed short of runway in a glider and impacted the ground at high speed with high sink rate. He had released early from an aerotow and descended at high airspeed with dive brakes open which accelerated his rate of sink. He was not injured in the…NTSB ATL82DA189Accident · No injuriesFinal reportBalloon Works Firefly 7 · Greenville, SCThe ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…NTSB FTW82FQA21Accident · Serious injuriesFinal reportBarnes AX-7 · Albuquerque, NMThe pilot stated she made a practice landing near a large hill and had no problems landing. She continued flight for approximately 20 minutes and prepared to land on a road. The balloon impacted a road embankment at touchdown and the pilot broke her leg. She…NTSB FTW82DA264Accident · No injuriesFinal reportGlassflugel 604 · Refugio, TXThe pilot accidently released the tow line at about 50 feet AGL when his parachute caught on the tow release handle. In attempting to turn to the runway, he dragged a wing. The glider fuselage broke aft of the cockpit.NTSB NYC82DA153Accident · No injuriesFinal reportSchweizer SGS-1-36 · New London, NHWhile being towed during takeoff, the weak link on the tow rope failed when the glider was about 125 ft AGL. The pilot started to land on a golf course ahead, but spotted golfers in his intended landing area. The glider stalled while he was in a steep turn.…NTSB NYC82DHD14Accident · Serious injuriesFinal reportRaven S-66A · Washington Town, NJThe pilot reported that moments after initial ground contact (during landing), a passenger reported that he thought his leg had fractured. The passenger reported that the fracture occurred after initial impact, when another passenger leaned or stepped on his…NTSB SEA82DA092Accident · No injuriesFinal reportBlanik L-13 · Driggs, IDThe pilot held a commercial, airline transport certificate, but had only a student glider certificate. During a towed takeoff, witnesses observed the spoilers extend after about 200 ft of ground roll. The tow pilot gave an arm signal to indicate a problem.…NTSB ATL82DA168Accident · Serious injuriesFinal reportSchweizer SGS-2-32-A · Williamson, GAOn downwind, the pilot saw another glider on the runway. He maintained altitude until the glider cleared the runway. When clear the pilot started his descent extending the spoilers fully. The pilot stated that when he reached his desired altitude and leveled…NTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…NTSB CHI82DA178Accident · No injuriesFinal reportBalloon Works FIREFLY-7 · Wyoming, MIThe pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.NTSB NYC82DHA09Accident · No injuriesFinal reportBryan HP-18 · Hazelton, PAThe pilot departed blairstown, PA on a round robin, triangular course to bethel and dallas, PA and return to blairstown. He stated that while he was proceeding from bethel to dallas he encountered heavy sinking conditions in addition to a head wind.…NTSB FTW82FQA18Accident · 1 fatalFinal reportBlanik L-13 · Los Lunas, NMDuring landing the left wing struck a bystander who wandered onto the edge of the asphalt overrun taking photographs of the landing. There is a caution sign posted on the north access road of the runway.NTSB DEN82DA064Accident · No injuriesFinal reportSchweizer SGS-2-33A · Colorado Spring, COThe student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft…NTSB LAX82FA136Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Tulare, CAThe glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane…NTSB LAX82FA136Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbah Speed Astir II · Tulare, CAThe glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane…NTSB FTW82DQG17Accident · Serious injuriesFinal reportBalloon Works 7-B · Masterson, TXAfter making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking…NTSB LAX82DA123Accident · Minor injuriesFinal reportBölkow Phoebus C · Livermore, CAWhile returning to the gliderport, the aircraft had insufficient altitude to glide to the runway. The pilot elected to land in a field about 1/2 mile from the gliderport. Just before touchdown, he diverted his attention from the landing and became concerned…NTSB FTW82DA099Accident · Minor injuriesFinal reportAirmate HP-10 · El Paso, TXOn the first flight since purchase of the aircraft, the pilot stated that he was released from the tow at 1700 ft AGL and climbed in a thermal to 2000 ft AGL where he allowed the aircraft to stall and spin. The pilot stated that he had difficulty in…NTSB FTW82DA086Accident · No injuriesFinal reportSchreder RS-15 · Hempstead, TXThe pilot reported that he lost directional control on his first flight in this high performance glider. He stated that the right wing began to drag when the runner released it early. He attempted to lift the wing with left aileron and rudder. The glider…NTSB LAX82DA090Accident · No injuriesFinal reportSchweizer SGS1-260 · Phoenix, AZDuring the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther.NTSB LAX82DA089Accident · Minor injuriesFinal reportBarnes Balloon AX7 · Napa, CAThe pilot attempted to land short of powerlines after aborting an ascent to safely clear them because of what he reported as unstable air. The gondola bounced and slid into the wires. The pilot stated that electric current passed through the load lines and a…NTSB LAX82FUJ28Accident · No injuriesFinal reportBalloon Works Firefly · Phoenix, AZThe pilot was landing in a vacant lot when the light and variable wind shifted and started blowing the Balloon toward powerlines. Just prior to the wind shift, the Balloon was descending rapidly. Rather than make a hard landing, the pilot tried to "burn" his…NTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.NTSB NYC82FNA05Accident · Serious injuriesClosedRaven S-55A · Shirley, MANTSB LAX82FUJ07Accident · No injuriesClosedRaven AX-7 · Phoenix, AZNTSB NYC82DFJ04Accident · No injuriesClosedSchweizer 1-26 · Lockport, NYNTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PANTSB CHI82FA005Accident · 1 fatalClosedBLN Works FF-7 · Delaware, OHNTSB FTW82FQA04Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NMNTSB CHI81FEK31Accident · No injuriesClosedBLN Works FF-7B · Johnstown, OHNTSB LAX81DUK09Accident · No injuriesClosedSchweizer 1-26 · Sun City, AZNTSB CHI81FA100Accident · 1 fatalClosedSchweizer SGS232 · Waynesville, OHNTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJNTSB NYC81FNA25Accident · Serious injuriesClosedSchweizer 2-32 · Plymouth, MANTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WINTSB LAX81DUJ99Accident · Serious injuriesClosedGlasflugel H301B · Maricopa, AZNTSB NYC81FNE27Accident · No injuriesClosedSchweizer 1-23H · Plymouth, CTNTSB CHI81FA090Accident · Serious injuriesClosedRaven RX-7 · Barrington Hls, ILNTSB NYC81FFJ21Accident · Minor injuriesClosedNeukom S3 · Horseheads, NYNTSB FTW81DPA20Accident · No injuriesClosedSchleicher ASW-19 · Floyd, TXNTSB FTW81DPA19Accident · No injuriesClosedGlasflugel H-201B · Campbell, TXNTSB FTW81FQA41Accident · No injuriesClosedSchweizer 1-26 · Moriarty, NM
Back to NONE