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 DEN83FA152Accident · 2 fatalField investigationFinal reportCessna U206 · Cortez, COThe plt filed a company VFR flt plan & took off at aprx 0930 MDT on a return flt to farmington, NM. According to a surviving passenger, after departing blanding, the acft entered low clouds. Reportedly, the plt flew in the clouds for a period of time until he…NTSB ATL83FA238Accident · 1 fatalField investigationFinal reportCessna 172K · Millhaven, GAThe plt & his son took off at night to participate in the search for a downed acft. Subsequently, they found the burning wreckage of the downed plane. They saw people moving around the accident scene & made a pass over it by diving with the landing light on.…NTSB CHI83FA267Accident · 2 fatalField investigationFinal reportPiper PA28-161 · Cambridge, OHThe acft collided with the ground during a night flt after the plt encountered weather according to the radio transmissions to cleveland center. His statements were 'what have you got me into' and 'what are we into here' when asked by cleveland if he was into…NTSB SEA83FA131Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Glacier Peak, WAThe acft collided with a side of Glacier Peak at about 10000 ft MSL while in level flt. The exact weather conditions at the accident site at the time of the accident are unknown but several mountain climbers at 6000 ft about 2 miles away atabout the same time…NTSB CHI83LA271Accident · No injuriesLimited investigationFinal reportBeech E18S · Youngstown, OHThe plt had not obtained a wx briefing, but had gotten info from another company plt who had flown into the destination arpt earlier. During arrival, he could see the rotating beacon & rwy lights thru some fog & elected to make a visual apch. At aprx 75 ft…NTSB SEA83LA126Accident · No injuriesLimited investigationFinal reportCessna 182H · Petersburg, AKThe student plt was on a night flt from whitehorse to prince rupert, Canada via skagway & juneau, AK. According to him, when passing the five fingers NDB to enter the strait, he encountered southeast winds of aprx 25 KTS. On attempting to return to juneau, he…NTSB NYC83FA144Accident · 1 fatalField investigationFinal reportBeech 76 · Moultonboro, NHAfter making an instrument acph to laconia, NH, the plt landed, phoned his wife & advised her of his intention to fly to Moultonboro, NH. After taking off, he advised Moultonboro UNICOM that he had departed laconia & was over a nearby lake, but was having a…NTSB CHI83IA263Incident · No injuriesIncident investigationFinal reportBoeing 737-201 · Charlotte, NCDuring climb to cruise the acft encountered unforcast hail. The flight continued to destination and landed without further incident.NTSB NYC83LA143Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Marlboro, MAThe acft ran off the end of the runway while making a precautionary landing due to weather. During the overrun the acft collided with a fence. The pilot was not injured.NTSB MKC83FA127Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Newton, IAThe non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…NTSB MIA83LA157Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Chuluota, FLThe plt reported that after he was airborne for 40 min, he was forced to terminate the flt due to the apch of a severe rain shower. He stated that when the acft was on a final apch to rwy 11, a sink rate developed that he could not arrest. Subsequently, the…NTSB LAX83LA281Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tuba City, AZThe pilot had landed in a river bed due to an encounter with and downdrafts while flying in canyons. Then a storm and flash flood threatened so he decided to takeoff. During takeoff roll a wing struck river rocks.NTSB SEA83FA118Accident · 4 fatalField investigationFinal reportPiper PA28RT-201T · Gov'T Camp, ORWx conditions along the flt route indicated ceilings of 25,000 ft & unrestricted visibility except for the area south & west of mount hood. Mount hood, elevation 11,239 ft MSL, on the sw side of government Camp & clear lake (accident site),was covered by…NTSB LAX83FA276Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAThe plt was first wx briefed at 0916 for a flt to catalina island & on to san jose. VFR flt was not recommended. Subsequently the plt called fss four more times, the final call at 1402 during which he requested & received the wx for montgomery & gillespie…NTSB MIA83FA152Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Sebastian, FLDuring the flt, the plt contacted vero beach tower & requested the wx. He was advised that vero beach & ft pierce, FL were VFR, but there was wx north of vero beach, a convective SIGMET was in effect & there were thunderstorms in the area. The plt…NTSB DEN83LA125Accident · No injuriesLimited investigationFinal reportCessna TU206 · Evanston, WYAfter departing Evanston the plt encountered adverse wx about 100 mi east & returned to Evanston. The plt executed a go-around from a rwy 34 approach due to unfavorable winds & then landed on rwy 16. Directional control was lost & the acft collided with a…NTSB DEN83FA129Accident · No injuriesField investigationFinal reportCessna 182 · Colorado Sprgs, COThe acft made a controlled hard emergency landing in an open field off airport after an encounter with icing. The pilot was making a turn during an instrument approach procedure and felt the acft begin to stall and buffet and slow in its response to roll. He…NTSB SEA83FA115Accident · 1 fatalField investigationFinal reportCessna 180J · North Bend, WAThe plt had requested a VFR departure eastbound to waterville & radar flt following. He stated he would be going VFR through stampede pass. After takeoff the acft was tracked on a radar heading of ene at an altitude of 2,500 ft MSL. Shortly thereafter the plt…NTSB FTW83FA254Accident · 5 fatalField investigationFinal reportPiper PA-28-180 · Haskell, TXThe acft crashed while on a flt in an area where thunderstorm warnings were in effect. There were no known witnesses to the actual crash, but 2 or 3 local residents heard an acft eng at about the estimated time of the accident. One resident about 1/4 mi from…NTSB DEN83FTE03Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Del Norte, COWhile circumnavigating snow showers at night in mountainous terrain the plt elected to make a precautionary landing on a highway. The acft struck trees on a hillside that the plt hadn't seen in the darkness.NTSB DEN83FA123Accident · 1 fatalField investigationFinal reportPiper 24-180 · Horse Creek, WYThe acft crashed in rolling terrain minus about 6 ft of its left wing. This portion of wing was found about 339 ft east of the main wreckage. Exam revealed evidence that the outboard portion of the wing separated in an upward and aft direction indicative of…NTSB CHI83LA233Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Woodruff, WIThe plt was briefed on the wx before departing waukegan, IL. At the destination, Woodruff, WI, the wx was forecasted to be VFR, except for light rain & the chance of scattered thunderstorms. While en route, the plt checked on the wx & spoke with another plt…NTSB LAX83FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Norco, CAThe student plt had flown to the riverton arpt to attend a ground school. Reportedly, prior to his departure at aprx 2235 PDT, stars were visible overhead, but the horizontal visibility was poor & there was a haze layer at about 500 ft AGL. At aprx 2250, a…NTSB NYC83FA125Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Haines Falls, NYOn the previous day, the plt had flown to poughkeepsie, NY. Before he departed on the retrun trip, the manager of a flt school informed him that the wx was bad; however, he took off at about 0912 EDT. While enroute, the acft collided with trees near the top…NTSB DEN83FA116Accident · 2 fatalField investigationFinal reportCessna 172P · Lander, WYAt noon on 5/21/83, the plt departed riverton, WY on a flt to ogden, ut to transport a minister back to riverton for a wedding. After arriving at ogden, he obtained a wx briefing for the return flt. He was warned of possible thunderstormactivity, turbulence,…NTSB NYC83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Greenville, METhe wx was estimated at 2,000 to 2,500 ft overcast when the flt departed Greenville at 1820. Horseshoe pond is 1,500 ft MSL & surrounded by 2,700 ft mountains. As the acft approached the pass the pond was visible. However a south wind prevailed & fog had…NTSB DEN83LA115Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Montrose, COWx at the departure point was VMC but the surrounding mountans were partially obscured. The plt stated that he was following a road up the mountain & landed as the visibility deteriorated. Each time the cloud lifted the plt would lift-off & again land as the…NTSB MIA83FA143Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Near South Bay, FLThe plt had recently purchased the acft & was using it to commute on a weekly basis between his residence in hialeah & la belle where he worked as an acft mechanic. The wreckage was found completely submerged in a canal after a Florida fish & game official…NTSB DEN83FA114Accident · 1 fatalField investigationFinal reportPiper PA-28R · Burns, WYBefore departing, the plt received a wx briefing & was advised that VFR flt was not recommended thru western Nebraska & eastern Wyoming. A frontal wx sys was forcasted to produce thunderstorm activity with associated turbulence & rain. Reportedly, the plt was…NTSB LAX83FU004Accident · Serious injuriesFinal reportEipper Quicksilver MX · Lakeside, CAAfter takeoff, the plt encountered clouds in a mountainous area. She elected to fly above the clouds, but had difficulty finding an opening for a descent. After eventually finding an opening, she descended below the clouds, but found she was in an unfamiliar…NTSB CHI83FA213Accident · 1 fatalField investigationFinal reportMooney M-20-J-201 · Bloomington, ILPrior to the accident, a witness heard the acft, then saw it for a short time thru an opening in the clouds. In his opinion, it was heading directly into a thunderstorm, which concerned him. He said that rain was falling, and about 10 min later, the…NTSB ATL83FA185Accident · 2 fatalField investigationFinal reportCessna 150L · Cheraw, SCThe student was on his 5th dual instructional flt & was practicing landings with his instructor. They had completed 3 or 4 landings & were in the traffic pattern for another when an intense thunderstorm cloud moved over the arpt. A plt/witness stated that a…NTSB ATL83AA184Accident · 3 fatalFinal reportAero Commander 680 · Titusville, FLWitnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then…NTSB FTW83FA226Accident · 4 fatalField investigationFinal reportCessna 182R · New Braunfels, TXAt 2006 CDT, before departing san antonio, TX, the plt obtained a wx breifing. At that time, he was advised to expect VFR conditions on his flt to san marcos, TX, but IFR conditions were expected when he planned to return at about midnight. The plt flew to…NTSB DEN83FA108Accident · 1 fatalField investigationFinal reportPiper 28-180 · Alpine, WYThe acft collided with mountainous terrain in IMC weather. The pilot had been briefed on the weather. Part of the observation called for mountain obscuration by clouds or precipitation. A person who resides in Alpine, WY said the mountain tops were obscured…NTSB FTW83LA215Accident · 2 fatalLimited investigationFinal reportCessna 177B · Port Aransas, TXDuring a wx briefing, the non-instrument rated plt was told to expect no significant en route wx, but was advised of lower ceilings along the coastline, later that night. There were no records of en route wx briefings. When the acft was about 40 mi northwest…NTSB MKC83FA098Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Stover, MOThe acft crashed into a wooded area in a high speed descent on a dark and stormy night. The pilot had telephoned the st. louis fss on 04/30/83 and requested Kansas city weather. The weather briefer advised the pilot that the area was in a tornado watch. The…NTSB NYC83FFJ02Accident · No injuriesFinal reportGrumman G-164A · Clarkson, NYThe pilot was diverting from the arpt of departure to an alternate arpt because of the severe weather. The turbulence encountered was so severe, according to the pilot's statement, that he lost control of the acft. Partial control was regained but too late to…NTSB LAX83FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Redlands, CABefore flying, the plt told the FBO that he would stay in the local Redlands/riverside, CA area. However, after taking off, he flew to las vegas, NV. He departed las vegas at 1636 PDT. When he did not return to Redlands, a search was initiated. The wreckage…NTSB ANC83FA071Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Bettles, AKAccording to witnesses, the acft was seen flying along the trans Alaska pipeline at an estimated alt of 200 ft AGL. As the acft entered a pass, where the pipeline crossed rising terrain, a witness heard the acft's eng power increase, then the plane…NTSB DEN83FA092Accident · 1 fatalField investigationFinal reportBell 206L-1 · Salt Lake City, UTThe helicopter collided with the side of a mountain during a turn after departing from a hospital helipad while on an emergency medical flt to pick up a medical team to care for a critically ill child. The plt was notified at 0510 by his dispatcher. After…NTSB MIA83FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Gainesville, FLThe acft crashed about 8 miles from the intended destination during weather on a dark night. The plt had gone outbound that afternoon with two passengers who did not return with him because of motion sickness. According to the one of his former instructors…NTSB CHI83FA161Accident · 2 fatalField investigationFinal reportCessna 182 · Coulterville, ILDuring a wx briefing before takeoff, the non-instrument rated plt was advised that VFR flt was not recommended. However, he departed sheboygan, WI at aprx 1500 CST with no flt plan. At dusk, witnesses (near the crash site) heard the acft maneuvering. One…NTSB NYC83FA087Accident · 6 fatalField investigationFinal reportPiper PA-32RT-300 · Wellsville, NYJust prior to this flt, the plt had flown from hornell, NY to Wellsville, NY. Before departing hornell, he radioed that the vacuum annunciator light was on, & during a run-up, the suction gauge read zero. Ground personnel advised that with this problem, the…NTSB ANC83FA068Accident · 2 fatalField investigationFinal reportBritten-Norman BN-2A-8 · Selawik, AKAccording to the FAA specialist on duty at the nome flight service station the plt of munz northern flt 601 requested only the ambler wx at 0030 gmt. The only surviving passenger stated that the flt deptd nome, AK at 1330 bst and as the flt continued north…NTSB ATL83FA155Accident · 1 fatalField investigationFinal reportCessna 182 · Rocky Face, GADuring two wx briefings the plt was advised that wx enroute would be marginal VMC to IMC. He was given a convective SIGMET covering tenessee & north carolina. There was a possibility of thunderstorm activity, low ceiling & visibility, high surface winds,…NTSB NYC83FA085Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Captree Island, NYThe plt contacted the islap west arrival controller with the intention of landing at islap, NY. However, islap was below mins, so the plt diverted toward farmingdale, NY & asked about the wx there. The islap controller coordinated the diversion with the…NTSB FTW83FA178Accident · 1 fatalField investigationFinal reportCessna T310R · Dalhart, TXAs the plt was approaching Dalhart, TX, he was in radio & radar contact with albuquerque ARTCC (center). Aprx 15 mi from delhart, the plt asked center about the wx over Dalhart. He was advised that the fss there was shut down & no current wx for Dalhart was…NTSB ATL83FA328Accident · Serious injuriesField investigationFinal reportBoeing 707-323C · Baltimore, MDThe flt encountered turbulence about 20-25 min prior to landing. The flt attendants were retrieving cups & trash at the conclusion of a hot meal service. An attendant was thrown upward striking the ceiling, then fell to the floor causing a lower back injury.…NTSB LAX83LA234Accident · No injuriesLimited investigationFinal reportLet L-13 · California City, CADuring flt, the glider sustained in-flt structural damage while maneuvering at an altitude of aprx 17,500 ft MSL in the vicinity of California City, CA. During a preliminary verbal statement to an FAA inspector, the plt stated that he had done a couple of…