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 LAX84LA237Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Happy Camp, CAWhile waiting for fog to 'burn off,' the plt preflighted the acft & then waited for about 45 min at the end of the rwy. He then decided to takeoff while the wx was still IMC. Shortly after lift-off, the acft entered instrument conditions & began turning to…NTSB ANC84LA049Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Mcgrath, AKAccording to the plt, he flew over a frozen lake, then encountered reduced visibility down to about 1/8 mi. He made a 180 deg turn, but lost all referecne to the terrain during the turn. Shortly after completing the turn, he was proceeding eastbound & was…NTSB MIA84FA122Accident · 4 fatalField investigationFinal reportCessna 402C · Mineral Springs, FLThe acft collided with trees and the ground during flt in adverse weather. There is no record of the plt receiving a pre-flt briefing and no flt plan was filed. Witnesses heard an acft flying low followed by a loud thud. About 16 mi north at sarasota, FL, the…NTSB FTW84LA178Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Haskell, TXThe plt received a wx briefing and said, 'today was not the day to go', but later went. En route weather encouraged him to land at an arpt with a 1600 ft rwy with winds of 30 KTS gusting to 50 KTS, according to a witness. The plt landedwith no flaps and…NTSB MKC84FA106Accident · 2 fatalField investigationFinal reportBeech B36 · Webb City, MOThe plt was advised by springfield tower that icing conditions existed along his proposed route of flt. However, he elected to takeoff, & about 4 min later, the plt advised that he had encountered rime ice. He continued the flt to joplin, picking up more ice…NTSB ATL84LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Supply, NCThe plt and passg stated that as the flt approached Supply, NC, the wx conditions deterioriated and the helicopter encountered a fog bank. The passg recalled that the visibility reduced completely and visual contact with the ground was lost. The plt decided…NTSB MKC84FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gasconade, MOThe plt landed at an arpt where, by his own description, the wx was near zero in rain. He then received 2 wx briefings. During the 1st briefing the plt indicated that he could make the flt IFR. The plt was advised of a SIGMET for severe icing conditions at…NTSB NYC84FA110Accident · 2 fatalField investigationFinal reportLockheed 18-56 · Oneonta, NYAt aprx 2330 EST, witnesses near the crash site heard an acft, & shortly thereafter, they saw a flash. One of them, who was driving a car, went back to the area the next day & found the acft wreckage. The acft had crashed & burned about 1 mi from the apch end…NTSB SEA84FA071Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Humphrey, IDWhile on a x-country flt, the acft entered an area of rising terrain & blowing snow & the plt initiated a turn to reverse direction. During the turn, he encountered reduced visibility & the acft collided with the top of a knoll on snow covered rolling…NTSB NYC84FA108Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Groton, CTThe plt received 2 wx briefings prior to departing & both called for low ceilings. During arrival at the destination, the plt requested & was cleared for an ILS apch to rwy 5. While on the apch, the acft collided with a small tree & crashed. The wreckage came…NTSB FTW84LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Houston, TXThe non-instrument rated plt departed dallas, TX, and was on a VFR flight plan to Houston gulf port arpt. Unable to landthere due to wx, the plt requested ATC vectors to Houston intercontinental (iah). Iah ATC gave the plt vectors for an ILS apch to rwy 08.…NTSB SEA84FA068Accident · 6 fatalField investigationFinal reportPiper PA-28RT-201 · Hood River, ORAfter crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…NTSB FTW84LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Smithville, TXThe pvt non-instrument plt received two wx briefings for his route of flt from madison, MS, to lufkin, TX, to college station, TX, to san antonio, TX. The last briefing from college station fss informed the plt that marginal VFR conditions exsisted along the…NTSB DEN84FA223Accident · 3 fatalField investigationFinal reportCessna 310H · Questa, NMThe acft collided with rising terrain at the 12500 ft level. The summit was about 200 ft above the crash site. A friend of the plt was interviewed by the iic from NTSB. This friend was the host of the 3 accident victims for the weekend at his gunnison ranch.…NTSB LAX84LA213Accident · No injuriesLimited investigationFinal reportCessna 172M · Lebec, CAIn a preliminary oral statement, the plt said that they encountered an unforcasted overcast & rising mountainous terrain. Later, she stated they were trying to maintain VFR flt in mountains with scattered clouds in the area; then when they were initiating a…NTSB DEN84FA107Accident · 1 fatalField investigationFinal reportMooney M20K · Craig, COWitnesses observed & heard the plt making an apch & subsequent go-around or pass over the ground at the arpt. Heavy fog conditions existed which were below IFR minimums. The plt failed to realize higher terrain exsisted north of the arpt. The acft collided…NTSB MKC84FA097Accident · 1 fatalField investigationFinal reportTeratorn Acft Tierra II · Lexington, NEThe plt had flown from callaway to Lexington, NE, earlier in the day. After a short visit, he departed on a return flt. A search was initiated when the acft did not return. About 5 hrs after the estimated time of the accident, the acft was found where it had…NTSB DEN84FA307Accident · 4 fatalField investigationFinal reportRockwell 112TCA · Missoula, MTThe pilot had filed an IFR clearance. While taxiing to takeoff, he requested and received a clearance to climb VFR on course, via victor airway 2, with instructions to report when reaching 10,000' MSL. This was the last communication received from the pilot.…NTSB NYC84FA104Accident · 1 fatalField investigationFinal reportCessna 172Q · Meadville, PAPlts were briefed on snowstorm advancing toward destination, departed in hope of arriving ahead of wx. Encounting IMC conditions (snow) enroute, plt filed IFR and continued. Communications transcript indicates that when eng began to lose power, plt used carb…NTSB MKC84FA091Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Harrison, ARThe plt encountered a thunderstorm during a night x-country. The plt was being vectored by the controller to avoid the worst of the storm. After about 2 minutes memphis center heard the acfts call sign shouted over the radio. Further attempts at radio…NTSB FTW84FA153Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Lampasas, TXThe captain received a company briefing prior to the flt. A convective SIGMET was in effect & turbulence was forcast for the area. During flt, the acft was manuevered to avoid turbulence. The acft was clear of clouds & in a thin haze layer when the crew felt…NTSB ANC84LA039Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-100 · Glennallen, AKThe plt experienced a downdraft, while approaching a glacier at 5500 ft MSL. In turning downgrade to try to affect a descent of the acft, control was lost and the helicopter collided with the ground. The acft rolled inverted after ground contact.NTSB SEA84FA065Accident · 5 fatalField investigationFinal reportPiper PA-28-181 · Lewiston, IDThe acft crashed in mountainous terrain while the non-instrument rated plt was on a flt in marginal wx conditions. An investigation revealed that the acft had impacted in a steep nose down, high speed descent. No preimpact/mechanical problem was found. About…NTSB NYC84LA329Accident · 2 fatalLimited investigationFinal reportCessna U206A · North Hudson, NYAn inflight collision with trees in an area of high terrain. Factors related to the accident were: the pilot's decision to takeoff after he received a briefing advising, 'VFR flight not recommended', the dark night conditions, and snow showers.NTSB MKC84FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Oconto, NEAfter attending a business conference at muncie, IN, the plt received a wx briefing & took off at 2026 CST on a flt to des moines, IA, where he refueled. In a phone call to his wife at their home in north platte, NE, he indicated the wx was such that he would…NTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…NTSB SEA84FA064Accident · 2 fatalField investigationFinal reportCessna U206 · Stevenson, WAThe plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…NTSB CHI84FA121Accident · 1 fatalField investigationFinal reportBeech A36 · Wheeling, ILA go-around was initiated about midfield at what one witness estimated as 6 in above the rwy. The acft was between 20 and 50 ft above the trees when it rolled into a steep right angle of bank with the nose dropping simultaneously. Post crash fire destroyed…NTSB FTW84LA150Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Amarillo, TXPlt was advised by fss that Amarillo had snow flurries, visibility 4 miles and wind from 350 degs at 28 KTS gusting to 34 KTS, tucumcari, NM was reporting 2 miles visibility with light snow and areas further west were clearing. The plt departed Amarillo under…NTSB ATL84FA106Accident · 2 fatalField investigationFinal reportBeech A36 · Hamilton, ALThe acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…NTSB MIA84FA090Accident · 1 fatalField investigationFinal reportCessna 310R · St. Petersburg, FLPrior to departure the plt noticed thunderstorms & lightning to the north of the arpt. He stated that immediately after takeoff he remembered a flash of light & a noise. His next recollection is impact & being in the water. The area around St. Petersburg at…NTSB NYC84FFA02Accident · Serious injuriesFinal reportPiper PA-28-180 · Lexington, NYWeather briefing forecast low ceilings, mountains obscured and lgt to mod turbulence. VFR not recommended. Plt filed no flt plan. Plt reported that an encounter with turbulence caused a loss of control and collision with terrain during the recovery. Witness…NTSB LAX84LA187Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Lucerne, CAUpon reaching his destination, the plt was unable to see the arpt because of the presence of a solid lower layer of clouds. While looking for a break in the cloud layer for a VFR descent, the plt 'inadvertently flew into IFR conditions,' & impacted trees.…NTSB LAX84FA189Accident · 1 fatalField investigationFinal reportCessna 182P · Livermore, CAWhile on a night x-country flt, the acft collided with the ground near the top of hilly terrain at an elevation of about 1840 ft. the time of the accident was not known, but the acft had departed groveland, CA at sometime between 1900 & 1930 PST. Witnesses in…NTSB FTW84LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Brownsville, TXThe plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said…NTSB NYC84LA087Accident · No injuriesLimited investigationFinal reportMooney M20J · Bristol, PAThe acft encountered weather and head winds on a x-country flt. Nearing his destination after a long flt the plt was trying to let down VFR through breaks on the clouds when he realized the critical nature of his fuel level. A search foran arpt produced the…NTSB CHI84FA110Accident · 2 fatalField investigationFinal reportCessna 177RG · Salem, OHThe plt got a weather briefing and was advised of areas of fog. While taking off toward the west, he encountered fog. The acft entered a right turn about 1000 ft from the end of the rwy & subsequently crashed about 1 mi northwest of the arpt. Initial impact…NTSB LAX84FA178Accident · 1 fatalField investigationFinal reportBeech A-36 · Coyote, CAThe acft crashed in mountainous terrain during a night x-country in marginal weather. The plt made an approach to san jose, cancelled his IFR flt plan and advised he was proceeding to hollister. A common practice in the area is to fly the valley, following…NTSB LAX84FA176Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oakland, CAThe plt left the traffic pattern where the weather was VMC and proceeded northbound into IMC weather. The plt had just checked out in this acft. The field elevation of departure is 47 ft MSL. Thirteen miles north the terrain was mountainous and the acft…NTSB ATL84LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Grove, VAThe acft collided with trees during an approach to land in IMC weather. The plt had taken off about 10 minutes earlier and when fog rolled in he tried to land. After one go-around he made a 2nd approach and descended to 75 ft AGL to obtainbetter visibility…NTSB ATL84FA095Accident · 1 fatalField investigationFinal reportCessna 172RG · Chesapeake, VAPrior to departure, the plt was twice advised that the destination wx was below most users minimums. The non-instrument rated plt then departed dulles arpt on an IFR flt plan in IMC. After departure, he did not follow assigned headings, & for a period of…NTSB DEN84LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Laramie, WYThe plt stated that when he was 10 miles southeast with airport lights in sight, a convair plt reported inbound on an IFR clearance to land. Not wanting to possibly cause the convair plt to make a missed approach he elected to make a turn. In the turn, he…NTSB DEN84FA089Accident · 2 fatalField investigationFinal reportBeech 58P · Durango, COWhen the plt called the fss at 1341 MST, he stated he had already received some 'real time' wx & requested only the wx at Durango & farmington, NM. He filed an IFR flt plan to Durango & took off at 1437. Drg arrival, the plt attempted to get into VFR…NTSB CHI84FA107Accident · 1 fatalField investigationFinal reportCessna 150D · Wanatah, INAt about 1716 CST, the non-instrument rated plt contacted a fss, reported he was in the clouds with about 1 hr of fuel on board & requested 'vector me someplace.' He was told that indianapolis was VFR, but the plt stated that he could not reach indianapolis &…NTSB MKC84FA071Accident · 2 fatalField investigationFinal reportCessna 150M · Lincoln, KSThe non-instrument rated plt departed the russell control zone at night in IFR conditions by obtaining a special VFR clearance. After he reported clear of the control zone, there was no further radio contact with ATC facilities. At 0235 CST, the acft was…NTSB NYC84FA081Accident · 2 fatalField investigationFinal reportCessna 402 · Jaffrey, NHThe plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last…NTSB FTW84FA125Accident · 1 fatalField investigationFinal reportCessna 152 · College Station, TXThe plt had received a telephone wx briefing at 1610 & an in-person wx briefing at 1932, about 45 min before takeoff. The local wx deteriorated considerably between the last briefing & the time of the accident. The acft departed at 2016, & at 2024 the acft…NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB DEN84LA079Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Ogden, UTThe plt took off from a mountainous work site to return to salt lake city, UT. The wx was clear at the work site (elevation 6700 ft), but there was fog below. After encountering the fog, the plt hovered with a slow forward speed over snow covered terrain. A…NTSB SEA84LA046Accident · No injuriesLimited investigationFinal reportLark IS28B2 · Issaquqh, WAThe CFI stated that while returnsing to the airport he encountered turbulence. When it became obvious that reaching the intended airport would be marginal another landing field was chosen. During turn to final, the left wing tip struck a power pole and the…