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 LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…NTSB NYC87LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-34 · Dansville, NYThe plt stated that as he was adjusting his seat belt with the canopy open, the glider began being pulled by the tow pilots acft. He maneuvered the wing tip clear of some parked acft, grabbed the canopy hatch, and held it shut during the tkof. The cockpit…NTSB FTW87DRG06Accident · Minor injuriesFinal reportWilliam M. Burge Tern · Refugio, TXOn August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…NTSB FTW87LA186Accident · No injuriesLimited investigationFinal reportLet L-13 · Hempstead, TXAcft landed short of threshold following a low release shortly after t/o. release was low due to tow plane's being unable to climb above 200' AGL due to the glider's spoilers being deployed inadvertently during the t/o. the plt stated that he executed a 270…NTSB MKC87LA145Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Ulysess, KSDuring a helicopter aerial application operation, acft suffered a main rotor system hub failure. PIC was unable to control the acft and an uncontrolled descent resulted. Acft struck the terrain and was substantially damaged and the PIC suffered minor…NTSB CHI87LA167Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Springfield, MITwo hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…NTSB DEN87LA174Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Silverthorne, COThe commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose…NTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…NTSB DEN87FA153Accident · No injuriesField investigationFinal reportConcept 70 · Durango, COThe plt reported that he had been flying for one hour and had been doing acrobatics. He had started an inside loop and during pull up, he reported indicating 5.5 g's on his new g meter. The plt reported that both wings left the acft and he jettisoned the…NTSB SEA87LA117Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Reno, NVWhile soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno…NTSB ATL87LA158Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Kannapolis, NCThe Balloon pilot was executing a landing approach to a clear area. He failed to see and avoid electrical power lines on the near side of the field as he made his approach. The Balloon collided with the power lines and the basket landed hard. The Balloon…NTSB CHI87LA142Accident · No injuriesLimited investigationFinal reportSchleicher KA-6-CR · Staunton, ILThe plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further…NTSB LAX87LA224Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Fremont, CAWhile on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing…NTSB SEA87LA071Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Issaquah, WADuring a local training flight a downdraft was encountered. At about two miles from the airport the acft was at about 200 feet MSL. The instructor plt decided to land the acft on a field. On short final the acft struck a barbed wire fence prior to touchdown.NTSB BFO87DID02Accident · Serious injuriesFinal reportEagle Balloons C-7 · Montvale, VAThe balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to…NTSB DEN87FA069Accident · 1 fatalField investigationFinal reportRaven S-77A · Park City, UTWhile on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted…NTSB MIA87LA108Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLOn final apch, with full flaps extended, the glider began to float down the rwy. The plt then retracted them, after which, it descended, collided with a fence, & came to rest in a field.NTSB DEN87LA065Accident · No injuriesLimited investigationFinal reportRaven S60A · Grand Lake, COThe balloon encountered turbulence during normal cruise at 100 to 150 feet AGL, while crossing a ridgeline. Gusts extinguished both burner plt lights and partially collapsed the envelope. The balloon began an uncontrolled descent. The plt re-ignited both…NTSB CHI87DEE06Accident · No injuriesFinal reportSchleicher ASK-21 · Plainfield, ILThe glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…NTSB DEN87LA054Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colo. Springs, COThe Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing.NTSB LAX87LA109Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Vacaville, CADuring a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…NTSB FTW87LA065Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Midlothian, TXThe acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field…NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…NTSB ATL87IA067Incident · No injuriesIncident investigationFinal reportBurkhart Grob G103 Twin Astir · Williamson, GAAs the glider plt was apchg the entry point for landing, he checked the spoilers for operation. The spoilers extended, but would not retract. There was a significant increase in the sink rate & the plt realized he would be unable to reach the arpt.…NTSB NYC87DFA02Accident · No injuriesFinal reportSchweizer SGS 2-33A · Wurtsboro, NYThe pilot was landing a Schweizer SGS-233 when he started to get into a pilot induced oscillation. The oscillations increased and the aircraft impacted in a nose low attitude. The pilot said the accident could have been prevented with less control input,…NTSB ATL87IA027Incident · No injuriesIncident investigationFinal reportBritish Aerospace BA-31 · Louisville, KYWhile taxiing for takeoff, a jetstream 31 operating as a commuter carrier to dayton, Ohio, collided with the fourth baggage cart of a four car train. The visibility on the ramp was reduced due to rain and fog. The baggage cart driver stated that he was…NTSB FTW87LA020Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Holden, LAA commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student…NTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…NTSB MIA87LA030Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Brandon, FLA high sink rate was not arrested prior to the hard ldg. The plt stated that he briefed the pax on ldg procedures which included a tight grip in the event of an emerg ldg. The pax statements differed from those of the Balloon crew concerning the content of…NTSB CHI87LA034Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · Baldwin, WIWhile landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and…NTSB NYC87LA042Accident · Minor injuriesLimited investigationFinal reportRaven S60A · Montville, CTWhile landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage.NTSB CHI87LA002Accident · No injuriesLimited investigationFinal reportLet L-13 · White Bear Lake, MNThe plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated…NTSB LAX87LA006Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Calistoga, CAAt the end of a local pleasure flight near clistoga, claifornia, the pilot stated the nose of his glider was pushed down while on base leg at calistaga airpark. Due to a loss in altitude to increase airspeed, the pilot was unable to reach the runway. A forced…NTSB LAX86LA359Accident · No injuriesLimited investigationFinal reportCameron 0-77 · Tiburon, CAAfter completing an aerial advertising flight across the san francisco bay, the plt attempted a landing on up-sloping terrain. The terrain was steeper than anticipated & the plt became distracted. The plt forgot to turn off the pilot light to the left burner.…NTSB DEN86LA263Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Durango, COWhile flying low level inside a river gorge at 200-300 feet above the water, the balloon impacted a power line and fell into the river.NTSB LAX86FUG05Accident · Serious injuriesFinal reportSchweizer SGS-1-35C · Palm Springs, CADuring a pleasure flight, the acft was not getting the lift required to maintain alt. The plt decided to return to the arpt, however, enroute the plt realized that he would not make it back to the rwy. The plt decided to land in an east west direction on a…NTSB ATL86LA262Accident · No injuriesLimited investigationFinal reportAlexander AS-K13 · Tullahoma, TNDuring an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high…NTSB ATL86LA253Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19B · Griffin, GAThe glider departed on an aerial tow and was released at 1700' AGL. Intention of the flt was an out and back x-country. During the flt the plt could not find lift and radioed a friend, also in a glider, that he intended to land at a sod strip. The plt stated…NTSB LAX86LA360Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 III B · California City, CAThe plt stated he was towed to an alt of aprx 2,000 ft AGL. After release the canopy came open and the plt returned to the arpt. On final apch he noticed the airspeed indicator was indicating 'low forties'. The plt stated the next thing he remembered was…NTSB MKC86LA174Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KSThe pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further…NTSB SEA86LA199Accident · No injuriesLimited investigationFinal reportSchweizer 2-22EK · Easton, WAThe instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The…NTSB FTW86LRA12Accident · No injuriesFinal reportMolino PIK-20B · College Station, TXThe glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area.NTSB DEN86LA226Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COThe plt was attempting to land his glider. He said that he was unable to reach the airport and elected to land in a nearby pasture. Prior to touchdown he discovered some cattle in the field but was unable to avoid a collision with one of the animals. The…NTSB FTW86LRG31Accident · No injuriesFinal reportRolladen-Schneider LS-6 · Uvalde, TXPilot of a Rolladen-Schneider LS-6 glider, N25SG, impacted terrain short of runway at Uvalde, TX airport. Pilot held U.S.-foreign private pilot certification based on german certification and was representing the aircraft manufacturer during glider…NTSB FTW86FRG30Accident · Serious injuriesFinal reportSchleicher ASW-20 · Uvalde, TXAcft was competing in the natl soaring championships and had just crossed the finish line at 50' AGL and 85 kns a/s when it entered a maneuver to reverse direction and climb to pattern alt for landing. During the turn the acft stalled and struck a power line…NTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…NTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…NTSB SEA86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus Iiit · Hawthorne, NVAfter a 5 hour flight in the motorized glider during which the engine was utilized on several occasions the pilot returned to his destination. Upon arrival he executed a number of low passes over the runway for photographers. The pilot executed a fly by…NTSB DEN86FA210Accident · Serious injuriesField investigationFinal reportBurkhart Grob G-102 Astir CS · Black Forest, COThe glider plt, took off at 1155 and was towed to an alt of 10,200 ft MSL and released. The plt said that a rapidly developing thunderstorm cut off his route back to the glider port and he was forced to make an off airport landing at about 1300. The plt said…NTSB NYC86LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Plymouth, MAShortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the…
Back to NONE