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 ATL84MA052Accident · 4 fatalMajor investigationFinal reportBeech 58TC · Knoxville, TNDuring arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…NTSB ATL84FA054Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lexington, TNThe acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who…NTSB NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…NTSB LAX84FA071Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Oceanside, CABefore takeoff, the plt received a wx briefing & was advised to expect IFR conditions in the vicinity of Oceanside, CA & that moderate turbulence existed below 20,000 ft. after takeoff, he obtained an IFR clearance to climb & cruise at 6000 ft. at about 2005…NTSB DCA84AA008Accident · Serious injuriesFinal reportLockheed L-1011 · Charleston, SCDuring flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of…NTSB ATL84FA058Accident · 2 fatalField investigationFinal reportCessna 414A · Waynesville, NCAfter departure at 1417 CST, radar track showed the acft climbing to & maintaining 7,600 ft until about 1733 EST & 28-30 mi north of the knoxville VOR. The acft then descended & crossed the snowbird VOR at about 6,700 ft. there were several up & down altitude…NTSB DEN84FA030Accident · 2 fatalField investigationFinal reportCessna 414 · Aurora, CODuring wx briefings the plt was advised of icing conditions in the denver area. While approaching the denver area the plt radioed 'can you get me down, it's a little bit icy up here.' The plt was subsequently asked & was given a close turn onto the outer…NTSB FTW84FA068Accident · 1 fatalField investigationFinal reportMooney M20J · El Paso, TXThe acft collided with the ground at 4380 ft MSL. The plt had called the control tower in El Paso and advised that he was at 8500 ft and would have to start descending due to weather in the area. The plt was VFR and no flt plan had been filed. He was advised…NTSB LAX84FA068Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Wikieup, AZBefore taking off, the plt obtained 2 wx briefings & was advised that VFR flt was not recommended. He departed at 1730. Several requests were made for en route wx from las vegas flt watch. At 1945, the plt declared an emergency & indicated that he was lost.…NTSB CHI84FA049Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Dexter, MIAt 2135 EST, the plt called the lansing fss & requested a wx forcast for the detroit city arpt & winds aloft. He was briefed, but he did not file a flt plan, sometime after 2200 EST, he took off form mason, MI on a passenger flt to ann arbor, MI. At 2252, the…NTSB NYC84LA031Accident · No injuriesLimited investigationFinal reportBeech B23 · West Dover, VTThe plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still…NTSB FTW84FA064Accident · 3 fatalField investigationFinal reportCessna T210N · Nageezi, NMBefore takeoff, the plt was informed of a segmet which forcasted occasional severe rime or mixed icing from the freezing level at 8000 ft up thru 20,000 ft & moderate to severe turbulence below 18,000 ft. also, embedded thunderstorms, lightning & thunder were…NTSB MKC84LA024Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Sargent, NEThe pilot became dioriented on a flight from hastings, NE enroute to Sargent, NE. He decided to land on a county road west of Sargent. During the landing the acft right wing tip struck a pole and the acft tipped up on its nose.NTSB CHI84LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mankato, MNThe plt received 2 wx briefings before the flt & was advised that VFR flt was not recommended. Prior to departing, the 50 gal fuel sys was serviced with 35 gal of fuel. The plt reported that during the flt, he descended the acft thru a hole in the clouds…NTSB LAX84FA065Accident · 2 fatalField investigationFinal reportMooney M20A · Mammoth Lakes, CAThe acft crashed into a mountain side at some time prior to 0900 on 11/12/83 when the ELT signal was 1st reported, via satellite. Before the flt, the student plt was last seen in bakersfield, CA at about 0100 that morning. A rescue mission was delayed due to…NTSB FTW84FA047Accident · 2 fatalField investigationFinal reportAero Commander 520 · Clines Corners, NMThe non-instrument rated plt was on ferry flt from bartlesville, ok to ontario, CA. An en route stop was made at tucumcari, NM, where the acft was refueled & 14 qts of oil was added to the left eng. The line boy who serviced the acft saw no visible oil leaks…NTSB NYC84FA022Accident · 2 fatalField investigationFinal reportCessna 210L · Rhinebeck, NYThe above reported basic wx data was the 2050 observation at poughkeepsie, NY located about 20 NM south of the accident site. However, a witness who was 1,000 ft north of the accident site stated the wx consisted of a low overcast & that the visibility was…NTSB MKC84FA014Accident · 5 fatalField investigationFinal reportCessna 210M · Greensburg, KSAt 1619 CST, the non-instrument rated plt called the dodge city fss & requested the current dodge city wx. He was given the current & forcasted wx. He took off at 1825 & at 1846, he called the la junta radio & requested an update on the dodge city wx as well…NTSB CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…NTSB ATL84FA038Accident · 5 fatalField investigationFinal reportCessna T210M · Banner Elk, NCBefore takeoff, the plt obtained wx for ashville & hickory, NC & for the tri-city arpt, all of which were 30 to 54 mi from Banner Elk, NC. At that time, he told the briefer that there were clouds at Banner Elk, but he thought he could get out all right. The…NTSB DEN84LA020Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, NDThe student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the…NTSB ATL84FA033Accident · 1 fatalField investigationFinal reportCessna 172F · Brunswick, GAThe acft was observed entering a cloud layer about 500 ft AGL after takeoff. Another witness observed the acft's navigational lights in a circling motion as the acft plunged to the ground.NTSB NYC84LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · North Conway, NHAccording to the pilot, the glider was towed to 2000 feet and released, in lift. Flt was in lift for about 30 minutes when a strong sink was suddenly encountered. The glider crashed into trees.NTSB FTW84FA032Accident · 1 fatalField investigationFinal reportCessna 182Q · Columbus, NMThe non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500…NTSB CHI84FA027Accident · 2 fatalField investigationFinal reportMooney M20E · Newark, INThe acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…NTSB ATL84FA028Accident · 2 fatalField investigationFinal reportCessna TU206G · Brentwood, TNThe acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with…NTSB FTW84LA027Accident · No injuriesLimited investigationFinal reportCessna U206G · Midland, TXThe plt took off to check the wx & intended to proceed on a business flt, if conditions permitted. After taking off, he noted that the wx would not be satisfactory, so he elected to land & travel by other means. His apch to land was high & the acft touched…NTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…NTSB FTW84FA023Accident · 3 fatalField investigationFinal reportCessna 172M · Redfield, ARAt aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,…NTSB LAX84FA012Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Schurz, NVThe acft was on a crosscountry flight in VFR conditions. The non-instrument rated pilot encountered instrument conditions at night and lost control of the acft in flight. The post crash investigation revealed evidence of an inflight structural failure due to…NTSB DEN84FA011Accident · 2 fatalField investigationFinal reportCessna 182 · Hanksville, UTThere were two pilots aboard this acft which impacted in a steep nose down attitude on a plateau at 5000 ft MSL. Flight control continuity was established. The pilot was recently certificated & his class iii medical had expired. The second pilot held a…NTSB FTW84LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXWhile still several miles from addison, TX, the acft encountered the leading edge of a thunderstorm. Both occupants stated the acft encountered wind shear. Reportedly, the wind shear was so severe that it forced the acft down & it contacted the ground. A few…NTSB ANC84FA004Accident · 1 fatalField investigationFinal reportCessna 206 · Egegik River, AKThe plt flew the acft with 4 passengers to a dirt/gravel strip near the Egegik River & becharof lake, aprx 45 mi south of king salmon, AK. The plt was aware that the operator (ft richardson flying club) prohibied the operation of its acft into unapproved…NTSB FTW84FA014Accident · 1 fatalField investigationFinal reportCessna 195B · Alanreed, TXA recovered flt log indicated a route of flt via tulsa, OK; klahoma city,OK; sayre,OK; amarillo, TX; then tucumcari,NM. While taxiing for takeoff at the departure arpt, the plt received a wx briefing along the route to Oklahoma city. The accident site was 44…NTSB DEN84FA019Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Kim, COThe acft collided with the ground in a wing down nose low attitude. The plt had been advised that VFR flt was not recommended for his route of flt. The non-instrument rated plt went anyway and encountered weather. In maneuvering to get below or out of the…NTSB FTW84LA018Accident · No injuriesLimited investigationFinal reportCessna 182M · Aline, OKBefore departing norman, OK, the plt obtained a wx briefing from the Oklahoma city fss. During that briefing, he was advised that VFR flt was not recommended. He then took off for dodge city, KS without filling a flt plan. However, en route, he encountered wx…NTSB MKC84FA002Accident · 4 fatalField investigationFinal reportCessna 182R · Springfield, MOAt 2346 CDT, Kansas city center provided the 2251 CDT Springfield wx & advsed the plt to expect vectors for an apch to rwy 1. Vectors were provided until 0006;50 CDT, when center advised that radar contact was lost, 3 mi south of the outer marker compass…NTSB LAX84FA005Accident · 1 fatalField investigationFinal reportCessna 175B · Burbank, CARelatives expected the plt to return home on the evening of 10/4/83. When he did not return, relatives report the acft was overdue. The acft was found where it collided with a mountain at an elevation of about 3580 ft, 10 mi north of the destination arpt.…NTSB SEA84LA001Accident · No injuriesLimited investigationFinal reportBeech A23 · Burley, IDThe plt was participating in an open course air race to jackpot, NV. He planned to make an en route stop at arco, ID to refuel. The wx forcast called for marginal conditions. The plt made a telephone call to arco & confirmed that the wx (at that time) was…NTSB LAX84FA002Accident · 2 fatalField investigationFinal reportCessna 182M · Snow Water Lake, NVThe acft collided with the terrain in a high speed wings level descent at night after encountering weather and icing at flt level of 13000 ft. the plt was in contact with salt lake center until 5 minutes before radar contact was lost and gave no indication of…NTSB ATL83LA006Accident · No injuriesLimited investigationFinal reportCessna 150G · Glenville, WVGround fog started developing as the flt approached its destination. During the vor-b approach to rwy 16 the plt spotted the rwy lights about a mile out & set up on left base to the rwy. The plt turned final but drifted left of base. The plt stated that due…NTSB NYC83LA258Accident · No injuriesLimited investigationFinal reportCessna 172G · Woodford, VTAccording to the pilot weather was clear at time of departure with clouds at about 4000-4500 feet but clr above. He entered a break in the clouds and began following a road. As the weather began closing in from above and the road became curvy, the pilot had…NTSB CHI83FA445Accident · 1 fatalField investigationFinal reportCessna 182B · Constantine, MIThe non-instrument rated plt was on a x-country flt on a dark night. During the flt, the acft crashed in a corn field. Just prior to the initial impact, there was aprx a 15 deg descending angle cut thru the corn in the direction of flt & a 30 deg angle cut to…NTSB CHI83FA441Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bethany, ILPrior to this flt, the plt had contacted a fss & inquired about the wx. He was advised that VFR flt to terre haute, IN, was not recommended. He took off at about 1830 CDT. The plt again contacted the fss & inquired about the wx at burlington, IA &…NTSB CHI83FA440Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Raymond, ILDuring a wx briefing at 1433 CDT, the plt was advised to expect 500 ft ceilings, 2 mi visibilities, rain showers & thunderstorms. He then took off from bismark, MO with no flt plan. Reportedly, wx was encountered during the flt which deteriorated as he…NTSB LAX83FA458Accident · 2 fatalField investigationFinal reportCessna TU206-G · Flagstaff, AZThe acft collided with trees shortly after takeoff. The weather was marginal with 700 ft scattered, ceiling 3000 ft WITH8 miles visibility. The plt received two weather briefings about an hour apart while waiting for weather improvement. The briefer commented…NTSB LAX83FA456Accident · 1 fatalField investigationFinal reportMooney M20K · Patterson, CADuring a x-country flt, the acft crashed into rising terrain in a semi-box canyon in the diablo range. The crash site was at an elevation of aprx 1200 ft MSL. The canyon tops ranged from 1500 to 1700 ft. according to a farmer residing 2 mi west of the…NTSB NYC83FA253Accident · 1 fatalField investigationFinal reportBeech 58 · Arkville, NYPrior to taking off, the plt advised company personnel that he planned to fly vfr-on-top at 8500 ft MSL. He planned to depart at 1400 EDT, but did not specify his route of flt. When the acft did not arrive, a search was initiated, it was found where it had…NTSB LAX83FA455Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Lake Genevieve, CADuring cruise flight the acft encountered a downdraft while flying in mountainous terrain. The pilot lost control of the acft & it crashed. The pilot was student pilot rated only & had not been endorsed for this flight. He also was carrying a passenger who…NTSB LAX83LA452Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Palm Springs, CAWhile en route, the plt encountered deteriorating wx. He was an instrument plt, but had chosen not to file & fly under IFR due to terrain, wx, low performance of the acft & lack of pitot heat. The plt noted a ceiling at 5500 ft MSL when he crossed banning…