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 LAX83FA041Accident · 2 fatalField investigationFinal reportCessna T210L · 13 Se Of Linden, CAPilot encountered weather on a cross-country flight and reported icing at 10,000 feet at 1828. He had been at 10000 feetsince 1745. At 1831, the pilot requested 8,000 feet to get out of ice and at 1836 requested 6,000 and was approved. At 1857 level at 6,000…NTSB NYC83FA033Accident · Minor injuriesField investigationFinal reportCessna 172M · Williamsport, PAThe aircraft departed the airport with ice on the airframe. The pilot encountered more icing in flight and decided to return to the airport, but was unable to maintain his altitude. The aircraft collided with trees during a forced landing. The pilot had been…NTSB MKC83FA028Accident · 2 fatalField investigationFinal reportPiper PA-34 · Kansas City, MODrg the 1027 wx briefing, the plt was advised that Kansas City was reporting very light rime icing from 4,000 to 11,000 ft & a PIREP of light to moderate rime ice between 6,000 & 8,000 ft 30 mi south of Kansas City. The plt announcedhis intentions of…NTSB NYC83FA032Accident · Serious injuriesField investigationFinal reportCessna 172H · Mount Alton, PAWhile enroute the plt reported he was icing up & would have to divert to bradford. About 12 mi from the arpt the plt declared an emergency stating he didn't think he could make a missed approach with the ice buildup. The plt then reported a rough engine & an…NTSB LAX83FVG03Accident · 2 fatalFinal reportPiper PA-28-161 · Lincoln, CAThe non-instrument rated pilot took off at about 2003 PST. The weather at the marysville fss (20 NM north) was; thin obscured, 500 ft overcast, 2 miles visibility with fog. The plane crashed about 1800 ft northeast of runway 33.NTSB LAX83FVG04Accident · 2 fatalFinal reportCessna 150L · Lincoln, CAThe acft crashed on the arpt immediately after takeoff. A plt who had landed at the arpt at 2030 reported that fog had just reached the arpt with a top approximately 1,100 ft AGL & the base a 200 ft AGL. He advised the plt against going, but the plt stated he…NTSB LAX83FA050Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Williams, AZThe original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…NTSB LAX83LUQ02Accident · 2 fatalFinal reportStinson 108 · Santa Barbara, CAThe aircraft collided with a power line as the pilot was flying at low altitude near a highway at dusk. After hitting the power line, the plane fell to the ground and burned. Witnesses reported there was a low cloud cover and light rain. One witness stated…NTSB SEA83FA057Accident · 1 fatalField investigationFinal reportCessna TU206G · Soda Springs, IDA search for the aircraft was begun after the pilot's relatives reported it was overdue and residents near the crash site heard the sounds of a low flying plane suddenly terminate. Unofficial reports of the weather indicated it was about 200 ft obscured, 1/4…NTSB DEN83LA022Accident · No injuriesLimited investigationFinal reportBell 206B · Near Kalispell, MTAcft departed hospital at missoula in good wx to assist highway accident victim 5 mi east of clinton. Victim was placed aboard helicopter on stretcher for emergency flight to hospital. About 5-6 mi east of missoula plt noticed light snow falling & observed a…NTSB FTW83LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Port O'Connor, TXThe pilot reported that when he took off at 1348 CST, the weather was 400 ft overcast, 2 to 5 mi visibility with rain. About 10 min later, he arrived at the Port O'Connor jetty and could see across matagorda bay to Port O'Connor. About halfway across the bay,…NTSB FTW83FPG03Accident · 1 fatalFinal reportCessna 182L · Mt. Vernon, ARThe flt of two acft (a C-150 & N42562) departed heber springs & were in radio contact during the flt. N42562 reported over the conway, AR arpt at 2,000 ft with good visibility but indicated that there was an area of rain between conway & heber springs. The…NTSB ATL83FLG01Accident · Serious injuriesFinal reportPiper 22 · Clinton, SCThe aircraft was refueled before departing greenville, KY. The pilot reported that as he approached his destination, he proceeded along a radial from the greenwood VOR but could not find newberry. He stated that he hunted too long before diverting back to…NTSB MKC83FA023Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Sharon, KSThe acft crashed 12 mi from the departure point in hilly terrain on a direct route to the destination in a 40 deg nose low & 75 deg right wing low attitude. There are no wx reporting facilities near the accident site. The 1851 wx observation at enid,ok (62 mi…NTSB CHI83LA040Accident · Serious injuriesLimited investigationFinal reportPiper 601P · Sheboygan, WIThe plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around.NTSB SEA83FA022Accident · 2 fatalField investigationFinal reportCessna 210 · Gorst, WAThe acft collided with a mtn drg a VFR flt under IMC. An arts-iii radar printout showed the acft was maintaining a fairly continuous heading until radar coverage was lost. The wreckage was located about 3.4 mi north of the last radar plot. ATC confirmed loss…NTSB NYC83LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTEnroute to destination through a mountain pass the pilot saw approaching snow & decided to return & land. While returning, a rapidly moving snow squall was approaching the arpt. At about 1/4 mi from the end of rwy 1 visibility dropped to about 1/8 mi in heavy…NTSB FTW83FPG02Accident · 2 fatalFinal reportCessna R172K · Near Paris, ARThe plt & pax were on a flt from amarillo, TX to little rock, AR. An enroute stop was made at haskell, ok at appr 1900 to refuel. The owner of the afpt at haskell stated that the plane arrived in a fairly heavy rainstorm. At that time, a winter type cold…NTSB FTW83FPM04Accident · 2 fatalFinal reportPiper PA23-250 · 8 Miles Se Bris, OKThe acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog.NTSB DEN83FA133Accident · 1 fatalField investigationFinal reportCessna 182A · Orderville, UTThe acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330…NTSB MIA83FA022Accident · 6 fatalField investigationFinal reportCessna 172P · Near Myakka Cit, FLThe plt was wx briefed four times prior to departure & again one minute after takeoff at 1821 when he activated his flt plan. He was advised that a cold front was moving se along st. petersburg & tampa, & the area was IMC at the time. At 1916 the plt called…NTSB NYC83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Willimatic, CTOn the second approach to the airport, after executing a go-around on the first, the pilot encountered ground fog. In zero visibility, at 3-5 feet above the ground, the pilot elected to execute a "controlled crash" rather than attempt a transition to…NTSB FTW83FA298Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Canjilon, NMPrior to departing helena, mt at 1209, the plt received a wx briefing from the great falls fss. The dfw 021240Z area forecast, valid until 0700Z on 11/3/82, was not available. The fss briefer made this deficiency known to the plt & recommended that he receive…NTSB FTW83FA031Accident · 4 fatalField investigationFinal reportCessna P210N · Normangee, TXA company plt received two wx briefings from the san antonio fss, one was at about 1700 the day before the accident & the other on 11/2. After each wx briefing the company plt briefed the plt of the accident acft. The acft departed at about 0835. At 0953 the…NTSB CHI83LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marshall, MNDuring a preflight weather briefing, the pilot was warned that VFR flight was not recommended. Also, a fixed base operator warned him of the weather (there were patches of ground fog). After takeoff, fog was encountered at about 200 to 500 ft AGL. During a…NTSB LAX83FA024Accident · 3 fatalField investigationFinal reportCessna 172N · Panoche, CAAt 1615 on 10/29 the plt obtained a fss wx briefing & filed a VFR flt plan to taft. The plt was advised his trip would be in VFR conditions to taft, but the wx would deteriorate tnto thunderstorms along his route as the evening progressed. The acft arrived in…NTSB DEN83FTE02Accident · 1 fatalFinal reportCessna 172G · Mack, COWhile on a flt from evanston, WY to glenwood, CO, the plt encountered "cloud to ground" conditins & diverted toward grand junction, CO. He stated that due to a nav problem, he radioed grand junction tower to verify his position. Grand junction had no radar &…NTSB LAX83LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Coolidge, AZThe pilot stated that he flew into a dust devil while in a downwind, procedure turn and the aircraft stalled. Reportedly, he dumped his load and applied full power, but he was able to recover before the plane hit the ground, left wing first. The pilot…NTSB LAX83FA020Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Vallejo, CAAt 1830, the plt received a wx briefing for a flt from fair oaks to san jose, CA with a passenger pickup stop at sacramento, CA. During the briefing, he was told that he ought to be able to make it if he traveled below 4000 ft MSL & left within the next hr.…NTSB CHI83FA022Accident · 1 fatalField investigationFinal reportCessna R182 · Lemont, ILThe pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as…NTSB SEA83LA008Accident · No injuriesLimited investigationFinal reportCessna T210M · Ashton, IDDuring a flight from el paso, TX to three forks, MT, the pilot noted clouds below his cruising altitude while crossing the Montana border. When he arrived at his destination, he was above a solid overcast, so he diverted to west yellowstone, MT. During…NTSB CHI83LA018Accident · 2 fatalLimited investigationFinal reportMooney M20E · Sault Ste Marie, MIThe pilot was on a VMC flight plainwell, MI. To Sault st Marie, MI. Prior to and during the flight the pilot obtained weather briefings on conditions relative to his intended route of flight. A witness near the crash site stated the aircraft passed over her…NTSB NYC83FA005Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Sanbornton, NHThe plt was advised during his wx briefing that VFR flt was not recommended for his proposed route of flt and destination. The plt, whose business concern was in the glens falls area, commuted almost daily to his home in gilford, NH. The wreckage was located…NTSB DEN83FTC01Accident · 2 fatalFinal reportGrumman American AA-5B · Albin, WYThe pilot was on personal cross-country. There was no record of a pre-flight or in-flight weather briefing. The weather at the accident site was near blizzard condition. The aircraft was heard circling, but it was not seen due to snow. The winds approached 50…NTSB ATL83FID01Accident · 1 fatalFinal reportCessna 172G · Boones Mill, VAThe pilot was trying to approach roanoke in weather that obscured the mountain tops. He crashed into a mountain slope at the 2900 foot level. He had contacted roanoke radio but radar contact had not been established. During his weather briefing VFR flight had…NTSB ATL83LLQ01Accident · Serious injuriesFinal reportBeech 35 · Hazard, KYThe pilot reported that the airport was located in a valley, and due to the terrain, it was necessary to takeoff on runway 17 with a quartering left tail wind. He reported that a mountain was located close to the runway centerline (to the right) as well as…NTSB FTW82FQA27Accident · 2 fatalFinal reportCessna 177B · Guadalupita, NMPilot on cross-country impacted the side of a 11,055 foot mountain at the 10,800 foot level. The mountains were obscured at the time.NTSB ANC82DAA21Accident · No injuriesFinal reportBellanca 17-30 · Tok, AKThe aircraft was on a low altitude VFR flight to nortway, AK. The pilot had just reversed course due to adverse weather when his auxiliary fuel tank ran dry. He switched to a main fuel tank which had fuel and turned the boost pump on, but the engine failed to…NTSB LAX82FVW04Accident · Serious injuriesFinal reportPiper PA-23-250 · Panaca, NVThe plt encountered thunderstorm activity at 1900. The left fuel gauge was inop & he had no communication equipment. There was only one nav receiver operative, no instrument lights or slaved dg available. As it became darker he was unable to see the…NTSB NYC82FA237Accident · 5 fatalField investigationFinal reportPiper PA-32-R-300 · Berkeley Spring, WVWhile en route, the aircraft collided with the side of a mountain during level flight at about 2000 ft MSL. The impact occurred where the terrain sloped upward at about a 45 deg angle. Prior to takeoff, the pilot was advised of marginal VFR conditions and…NTSB NYC82FA236Accident · 4 fatalField investigationFinal reportCessna 172H · Normalville, PADuring the wx briefing the plt was advised of marginal VMC with high overcasts but reduced visibilities in light rain & fog, with radar depiciting an area of showers moving into the pittsburg area from the carolinas. Witnesses near the crash site stated the…NTSB MIA82FLA07Accident · Serious injuriesFinal reportCessna 172N · Oak Hill, FLThe aircraft collided with trees while flying in fog and rain on a dark night. This occurred shortly after the non-instrument rated pilot canceled his VFR flight plan. Neither the pilot nor the passenger could remember the details of the crash. The pilot…NTSB DEN82DTM18Accident · No injuriesFinal reportCessna A185 · Huntington, UTThe aircraft struck trees with the left wing after takeoff. The pilot stated that he experienced a downdraft and that he was unable to recover altitude that was sufficient to clear the trees. The wind was reported to be from 270 degrees at 10 knots, gusting…NTSB ANC82DAA20Accident · 1 fatalFinal reportPiper J3 · Near Nome, AKThe pilot was flying home from a hunting trip. The weather was low ceiling and visibility was marginal in some of the valleys. The aircraft impacted at the 1300 foot level on a 30 degree incline of a rocky slope. The aircraft bounced backfour feet on impact…NTSB LAX82FXQ14Accident · 2 fatalFinal reportPiper PA-38 · Imlay, NVThe pilot flew up a canyon in weather that obscured the ridges in low visibility and rain. Clouds also covered the terrain. A witness saw the aircraft disappear behind a hill and a storm obscured her vision and hearing. The aircraft was located in a box…NTSB LAX82FA346Accident · 4 fatalField investigationFinal reportCessna 182P · Beldon, CAPortions of the acft's right wing were located north of highway 70 in remote rugged mountainous terrain near belden, CA.the remainder of the wreckage was located about 2 mi south of the highway on the east side of fern creek canyon at an elevation of about…NTSB DEN82DA190Accident · Minor injuriesFinal reportCessna 310P · Wendover, UTThe pilot stated he became disoriented while flying from salt lake city to Wendover. He descended to 8000 ft to keep clear of ice and hail and could not receive a navigational signal from the Wendover or bonneville navigational facility. While attempting to…NTSB ATL82FA267Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Itta Bena, MSAt 2329 while enroute the plt was advised of wx conditions along his route. He was advised of previous low VFR conditions in the greenwood area. The fss specialist stated that there had been "low conditions right around greenwood for about a hour and a half…NTSB ATL82FA278Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Alma, GADuring his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…NTSB MKC82FCD10Accident · 2 fatalFinal reportPiper 28-236 · Liscomb, IAN2157A departed on a VFR flight to marshalltown, IA. There is no record of a pilot weather briefing prior to departure. The reported weather at waterloo airport at the approximate time of the accident was: measured ceiling 600 foot overcast, visibility one…