NTSB investigations
3,567 cases where the first occurrence was “In flight encounter with weather”.
Cases, newest first
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 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 MIA86FA218Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Steinhatchee, FLOn 7/23/86, ARTCC lost radar & radio contact with the acft while the plt was in lvl flt at 6000 ft in an area of lvl 3 & 4 thunderstorms (tstms). Two days later, the left wing panel & the tips of the horizontal stabilators were fnd in the vicinity of where…NTSB ATL86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt received a wx briefing prior to takeoff which forecasted widely scattered thunderstorms. On arrival at destination a thunderstorm was over the arpt. The plt executed an ILS rwy 14 apch. A preceding DC-9 made a missed approach due to tower reported…NTSB ATL86LA202Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Montgomery, ALDuring flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi…NTSB SEA86LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Petersburg, AKThe plt reported he had taken off in 'ok visibility' and proceeded toward wrangell, Alaska. En route he encountered 'ground fog' and was in the process of turning around when he 'hit conner (SIC) of fog on the hillside. Then hit trees.'the passenger reported…NTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…NTSB DEN86LA197Accident · No injuriesLimited investigationFinal reportCessna A150N · Akron, COThe plt stated the acft he was piloting encountered a severe downdraft during initial climbout, which forced the acft to the ground. Upon ground contact, the acft nosed over onto its back.NTSB MIA86FA208Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-2C · West Palm Bch, FLThe captain stated that an announcement had been made that they were starting their descent into the miami area and turned the seatbelt sign on and the passengers had been instructed to return to their seats. Approximately 5 minutes later, turbulence was…NTSB DEN86LA186Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Salida, COAccording to the plt, upon entering the mountain pass, the acft he was piloting encountered downdrafts from which he was unable to recover. The plt stated he bled off airspeed until contact with the trees. A local flt instructor who witnessed the accident…NTSB NYC86LA174Accident · No injuriesLimited investigationFinal reportHughes 500A · Fall River, MAThe flight encountered fog and haze during return flight to new bedford, Massachusetts. The pilot failed to maintain direction control of the helicopter and crashed into the north watuppa pond.NTSB NYC86LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · West Dover, VTShortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.NTSB SEA86LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDDuring an aerial application turn the aircraft encountered a severe downdraft. Although the pilot lowered the nose of the aircraft, leveled the wings, added full power and dumped his chemical load, he was unable to climb. The aircraft then struck the ground…NTSB NYC86LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wellsboro, PADrg arrival, the plt was advised the winds were 5 to 7 KTS, favoring rwy 28. However, when he crossed over the arpt for a downwind entry, he noted that the wind sock had changed to indicate an upwind for rwy 10, so he elected to land on that rwy. On final…NTSB SEA86LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Durkee, ORWhile crossing a mountain ridge at low altitude, the aircraft encountered downdrafts. The pilot was forced to land as he was unable to arrest the descent rate. The landing was accomplished onto very rough terrain.NTSB NYC86LA161Accident · Minor injuriesLimited investigationFinal reportAlon A2 · South Sutton, NHThe plt rprtd that during a landing, the flight encountered a severe downdraft and impacted the ground hard, collapsing the nose gear and incurring other damage to the aircraft.NTSB MKC86FA139Accident · 4 fatalField investigationFinal reportCessna 182J · Hartford, ARWhen the acft did not arrive at its destn, a search was initiated. The wreckage was located 4 days later where the acft crashed in mountainous terrain. An investigation revealed there was severe thunderstorm activity in the area at the time of the accident.…NTSB DEN86LA176Accident · No injuriesLimited investigationFinal reportCessna T188 · Kimball, SDAccording to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.NTSB NYC86LA173Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · New York, NYThe plt performed a go-around due to excessive groundspeed during the first landing attempt. The plt reported that as he applied upward collective to terminate the second landing apch over the helipad, the helicopter descended rapidly. The helicopter…NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.NTSB NYC86FA158Accident · 1 fatalField investigationFinal reportBeech V35B · Bradford, PAThe private, instrument rated pilot flying a Beechcraft V35 collided with the ground, in an inverted attitude 1.5 miles from the approach end of the runway while on an ILS approach during IFR conditions. Heavy rainshowers fog and lightning were observed in…NTSB DEN86LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bosler, WYAccording to the plt, the acft had just become airborne when it encountered a gust of wind while simultaneously crossing a gully, lost lift & descended until ground contact. The plt also indicated there was a 'density altitude problem.' The density altitude…NTSB FTW86LA118Accident · Minor injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot decided to land due to rainy conditions shortly after departure. He had forgotten to retract the landing gear after takeoff and made a water landing with the gear down, causing the aircraft to invert and sink.NTSB ATL86FA176Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Columbus, GAJust as the aircraft flared for landing, a gust of wind struck the airport. The pilot and passengers reported that the aircraft ballooned up several feet, and the right wing dipped. The pilot got the wings level and attempted to perform a go-around. The…NTSB DEN86LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDAccording to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground.NTSB LAX86FA249Accident · 1 fatalField investigationFinal reportCarnes Osprey 2 · Julian, CAWitness statements & examination of the wreckage revealed that the aircraft struck the ground as a result of a stall-spin type accident near the end of the closed portion of a box canyon about 200 feet below the top of the ridge. The investigation revealed…NTSB DEN86LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vernal, UTWhile flying a pipeling patrol flt 1,000 feet AGL in mountainous terrain, the plt encountered a downdraft windshear which resulted in an uncontrollable 2,000 fpm acft descent from which the plt was not able to recover. The acft impacted in rough terrain and…NTSB DEN86FA150Accident · 2 fatalField investigationFinal reportBeech A36TC · Marietta, OKThe plt obtained a wx briefing and was advised of scattered thunderstorm activity along his route of flt. The plt then filed an IFR flt plan from wiley post airport, Oklahoma city, OK, to houston intercontinental airport, TX. The plt and his wife took off at…NTSB DEN86FA147Accident · 1 fatalField investigationFinal reportPiper PA-20-160 · Buena Vista, COWhen the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right…NTSB MKC86FA117Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7-B · Lee'S Summit, MOThe PIC stated that prior to liftoff, the Balloon was gyrating and instructed the gnd crew member to steady the Balloon by holding the rope. Just as the Balloon became steady the PIC initiated his takeoff. The PIC was aware of turbulence in the takeoff site…NTSB FTW86FA092Accident · 2 fatalField investigationFinal reportCessna 210M · Calumet, OKAcft on a night xc flt in marginal VFR to IMC conditions impacted in an 80 deg nose down attitude in a left spiral. Immediately prior to the accident the non-instrument rated pvt plt had indicated that he was IMC and was going to attempt to climb out of it.…NTSB NYC86FA216Accident · 3 fatalField investigationFinal reportBell 206B · Noman'S Land, MAThe Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's…NTSB NYC86FA133Accident · 3 fatalField investigationFinal reportMooney M20K · West Milford, NJWhile on an IFR flight the aircraft entered an area of thunderstorms, lost control of the aircraft and crashed. In an attempt to circumnavigate the storms the plt inadvertently entered a storm and collided with the ground in an uncontrolled descent. The plts…NTSB DEN86FA142Accident · 3 fatalField investigationFinal reportCessna T210N · Elgin, NDPlt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a…NTSB CHI86LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia City, INThe pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He…NTSB BFO86LA030Accident · Serious injuriesLimited investigationFinal reportShort Brothers SD3-30 · Hopewell, VAThe captain reported that moderate to severe turbulence was encountered while passing through some clouds. He called the flight attendant on the intercom and told her to sit down; while she was attempting to answer the intercom, an object from the galley area…NTSB DEN86FA137Accident · No injuriesField investigationFinal reportBeech BE-99C · Laramie, WYThis part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the…NTSB ANC86FA057Accident · Serious injuriesField investigationFinal reportWSK PZL-M-18 · Palmer, AKAircraft executed steep left 180 degree turn about 50 feet above runway just after takeoff. Pilot lost control and crashed. Turbulence and windshear had been reported. Wind speed and direction was variable.NTSB SEA86LA125Accident · Serious injuriesLimited investigationFinal reportMaule M-6-235 · Fallon, NVThe plt was attempting a precautionary landing on a remote ranch strip after encountering turbulence and high winds enroute. Control was lost on short final when the acft was caught by a gust of wind. The acft contacted the ground on one wingtip and…NTSB DEN86MA129Accident · 6 fatalMajor investigationFinal reportGulfstream 690D · Price, UTAt 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…NTSB DEN86FA125Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Almosa, COA southwest airline company Boeing 737, flt no. 558 en route from denver, Colorado, to albuquerque, new Mexico, at FL 350, encountered severe clear air turbulence. The unexpected wx phenomena caused the acft to 'drop' suddenly resulting in two flt attendants…NTSB LAX86LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CABefore takeoff, the plt tuned in the hayward ATIS & received information alpha, which rprtd the wx was: 2200' scattered,3000' overcast & visibility 8 mi. After taking off from rwy 28R, the plt climbed to about 650' & made a rgt turn. At about that time, the…NTSB LAX86FA206Accident · 3 fatalField investigationFinal reportMooney M20F · Morgan Hill, CAThe pilot requested and received preflight weather briefings, twice, and was advised that VFR flight was not recommended. The flight departed and crashed into mountainous terrain that was obscured by adverse weather conditions. Witnesses reported that the…NTSB NYC86LA116Accident · No injuriesLimited investigationFinal reportCessna 152 II · Pittstown, NJOn flare for landing, student pilot encountered wind shear and landed hard, collapsing the nose gear, bouncing off to the left of the runway, nose digging into soft turf, causing aircraft to come to rest inverted. Aircraft was substantially damaged.…NTSB FTW86MA074Accident · Serious injuriesMajor investigationFinal reportCessna 310Q · Houston, TXDrg ngt visual apch, plt enctrd dtrtg wx, got vectors for ILS rwy 8 apch, was clrd for apch at 0511 CDT. On final apch, he noted his #1 & #2 ils's giving erratic LOC & g/s info (but functioning) & that his LOC course deviation info didn't agree with adf, but…NTSB FTW86FA073Accident · 1 fatalField investigationFinal reportPartenavia P68C · Goudeau, LAThe pilot received a weather briefing indicating IMC conditions existed at the point of departure and at reporting stations near the point of the first intended landing. (There was no reporting stations at the airport of intended landing). Weather conditions…NTSB LAX86LA210Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearlake, CAThe flt instructor (CFI) said he was instructing the student in how to judge a straight-in approach and landing to a dock with minimal taxiing required. During the approach, the CFI determined that the student was overshooting the desired touchdown point, so…NTSB LAX86LA202Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Vacaville, CAAccording to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.NTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…NTSB LAX86LA198Accident · No injuriesLimited investigationFinal reportCessna 501 · Bermuda Dunes, CABased on the flt's landing weight, an approach ref speed of 99 knots was calculated by the pilot. He reported that 115 knots was used during the approach. The pilot said that during the descent to the airport, one aircraft was heard to make a go-around 'due…NTSB DEN86FA120Accident · Serious injuriesField investigationFinal reportConvair 580 · Denver, CON73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…