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 FTW83FA175Accident · 4 fatalField investigationFinal reportCessna 500 · Eagle Pass, TXThe acft was on a flt to a private ranch landing strip at night. The strip had an unlighted windsock at midfield & portable rwy edge lights were in use. During arrival, the aircrew estimated the visibility was 3 to 4 mi & reported they would be able to land.…NTSB DEN83FA089Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Castle Rock, COThe pilot made two enroute stops at places other than planned because he was confused and disoriented. When he could notget a sectional chart he wanted he tookoff without it after one of these landings. After the second landing he took off ignoring a red…NTSB LAX83FVG10Accident · 1 fatalFinal reportChampion 7ECA · Georgetown, CAThe acft collided with a mountainside at the 3500 ft level in a 45 degree nose down attitude after colliding with a 30 ft tree during IMC weather on a dark night. There is no record that the plt received a weather briefing. The pilot was not instrument rated…NTSB CHI83FA156Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Miltona, MNPrior to separting, the plt was advised of low ceilings & poor visibility over the entire proposed route & was advised that VFR flt was not recommended. In a discussion with persons at fergus falls, MN, he stated that he was going to follow the highway. About…NTSB FTW83FA170Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKDuring the early morning hours, the acft crashed at the edge of a wheat field on relatively level terrain. The main wreckage then crossed a road & came to rest in another field. There were no known witnesses. A passing farmer discovered the wreckage at about…NTSB CHI83LA154Accident · No injuriesLimited investigationFinal reportCessna 182RG · North Canton, OHThe plt reported that he had filed an IFR flt plan to youngstown, OH, with a cruise alt of 9000 ft. after passing appleton, OH, he changed his destination to the akron muni arpt. During the apch, icing conditions were encountered. The plt reported that ice on…NTSB LAX83FVA02Accident · Serious injuriesFinal reportCessna 150F · Coulterville, CAThe pilot made two telephone calls to the fss requesting wx briefings for a VFR flt to medford, OR. He was provided with a summary of the current and forecast wx for his route and destination. He was advised that VFR flt was not recommended for that day. The…NTSB MKC83FA081Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Salem, MOThe student plt departed dexter, MO at aprx dusk on a VFR, no-flt-plan flt to houston, MO. Time required for the flt would have been aprx 30 min (estimated). At 1900 CST, the bunker, MO city marshal reported that an acft flew over bunker so low that he…NTSB ATL83FA145Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Roanoke, VAThe acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to…NTSB LAX83FA160Accident · 1 fatalField investigationFinal reportMooney M20E · Cobb, CAThe plt had left his acft at lakeport, CA for maintenance to be performed & barrowed Mooney M20E, N2571W. Before the plt took off, the owner heard him talking to someone about the wx, but no record of a wx briefing was found. While en route to palo alto, CA,…NTSB DEN83FA087Accident · 3 fatalField investigationFinal reportCessna T210M · Salt Lake City, UTBefore departing phoenix, AZ, the plt obtained a wx briefing, was advised of forcasted icing conditions & was informed that the Salt Lake City (slc) VORTAC was out of service. While en route, at 0931, he received a wx update. The slc wx at that time was, in…NTSB LAX83FA166Accident · 3 fatalField investigationFinal reportBeech A36TC · Sedona, AZDuring preflt briefings, the plt was briefed to expect deteriorating wx conditions with associated flt precautions for mountain obscurement, icing & moderate turbulence. The wx briefings were complete, except due to an inoperative circuit, the 0654 prescott &…NTSB DEN83FA084Accident · Serious injuriesField investigationFinal reportCessna 182 · Huntsville, UTThe afct collided with a tree and crashed during a go-around. The weather was IMC and the pilot and passenger were seriously injured. The pilot received a weather briefing and was told that VFR flt, on his intended route, was not recommended due to low…NTSB FTW83LA165Accident · No injuriesLimited investigationFinal reportBeech 200 · High IslandThe pilot stated that he was being vectored around thunderstorms when severe turbulence was encountered. The pilot was attempting to penetrate a line of thunderstorms about four mile wide when the turbulence was encountered. The course of penetration was…NTSB FTW83FA164Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Salt Flat, TXBefore departing tucson, the plt was advised of 2 marginal wx systems along his route. He took off at 1038 MST. At 1130,he contacted ATC & reported at 13,800'. From then until 1214, his alt varied between 10,000' & 16,000'. Radar contact was lost at 1228…NTSB LAX83FA154Accident · 1 fatalField investigationFinal reportBell 206 B III · Salinas, CAPurpose of flt was to transport a technician & his equipment to a mountain top to service a microwave antenna site. Cloud coverage precluded a landing at the site, but the plt was able to land in a clearing on the eastern ridge line about 100 yds below the…NTSB LAX83FA153Accident · 2 fatalField investigationFinal reportCessna 170B · Near Pala, CAAccording to a friend of the plt, he (the plt) had watched wx infor on tv, on 3/20/83. To the friend's knowledge, the plt had never telephoned the FAA fss for a wx briefing or to file a flt plan. After the friend took the plt & his wife (who was also a plt)…NTSB NYC83FA078Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · North Adams, MAAt 1145 the plt reported VFR conditions & requested radar vectors to the arpt. He was issued a cruise clearance of 5,000 ft & given a heading. 18 mi from the arpt he reported visual contact with the ground. At 1151 he was asked if he was familiar with the…NTSB FTW83LA160Accident · No injuriesLimited investigationFinal reportBeech K35 · Torreon, NMThe pilot, who was not certificated, stated that prior to departure he received a wx briefing by telephone from the fss. Enroute, after making several heading changes to avoid wx he found himself surrounded by low ceiling and precipitation. He decided to make…NTSB ATL83FA176Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Waverly, GAThe acft crashed into trees during an instrument approach at night in stormy weather. Both the CFI, seated in the front left seat, & the new owner of the acft, were fatally injured. An IFR flt plan was filed & the CFI had obtained 2 wx briefings prior to…NTSB DEN83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Coalville, UTThe acft nosed over during an precautionary landing due to deteriorating weather. The plt had received a weather briefing. The wx conditions deteriorated enroute due to a snow storm and the plt elected to land on a private strip to await improved weather. The…NTSB CHI83FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Danvers, ILThe aircraft crashed at night during IMC weather conditions on the return portion of a cross-country. The pilot had checked the weather outbound, but there was no record of a briefing for the return flight. The outbound flt was in early dusk. The return was…NTSB LAX83LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Delhi, CAThe plt reported that he had been spraying fertilizer in the area all day. While taking off from a strip surrounded by trees, the acft climbed above the treetops, then began to settle. Subsequently, it crashed into almond trees & burned. The plt stated that…NTSB CHI83LA131Accident · No injuriesLimited investigationFinal reportMooney M20C · Solon Springs, WIThe pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The…NTSB SEA83FA113Accident · 2 fatalField investigationFinal reportCessna 182Q · Mccall, IDThe acft impacted a rocky slope of a box canyon at the 6300 foot level. The weather was reported to be IMC with thunderstorms, overcast skies and the mountain tops obscured. The wreckage location was on a direct line between departure point and destination.…NTSB DEN83FA072Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Evanston, WYWhen en route, the acft collided with power lines where they crossed over a highway about 39 ft AGL. Two witnesses near this location reported that the acft was flying low & was following the highway on a westerly heading when the acft struck the wires. The…NTSB DEN83FA070Accident · 1 fatalField investigationFinal reportCessna 172 · Limon, COThe acft crashed in a snow covered field during IMC weather. Witnesses heard and saw an acft flying low in the area of the accident just before the crash. There are no known witnesses to the actual crash. The acft was discovered several hours later by a snow…NTSB ATL83FA128Accident · 3 fatalField investigationFinal reportCessna 310 · Hopkinsville, KYThe plt obtained a wx briefing & filed a flt plan from lexington to paducah,KY with a 15 min en route stop at bowling green, KY. While inbound to bowling green, he reported that the cloud base was at aprx 6000 ft & that there was lightning to the west. After…NTSB FTW83FA142Accident · 1 fatalField investigationFinal reportCessna 210-5 · Orange Grove, TXThe plt was believed to have departed hebbronville muni arpt at about 0500 CST. When the acft failed to arrive at its destination, a search was initiated. The wreckage was found where it crashed in an area of mesquite trees & brush, about halfway between the…NTSB FTW83LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Killeen, TXThe acft was on the return leg of an out-and-back, night, cross-country flt. The acft had 26 gal of fuel on board when it departed Killeen, TX. Reportedly, there was 18 gal on board when it took off from dallas, TX. The flt was initially conducted in VFR…NTSB MIA83FA082Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Brooksville, FLThe acft disappeared from radar during descent from 4000 ft MSL to 2000 ft MSL. Investigation revealed SIGMET bravo 3 in effect in the area of the accident at the time of the crash. The transcript of radio communications with the flt shows no in-flt weather…NTSB LAX83FA320Accident · 2 fatalField investigationFinal reportBeech E55 · Bridgeport, CAThe recorded transcript between the plt and the reno fss specialist reveals that the plt was aware of moderate icing conditions below 18000 feet and reported moderate to severe turbulence along his proposed route of flt. The plt reported icing conditions and…NTSB DEN83LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Emerado, NDThe acft made a forced landing due to weather which included icing and low ceilings. According to the plt. The acft would no longer hold level flt due to icing and after the acft broke out at 300-350 ft AGL he landed and the gear collapsed. The plt had…NTSB LAX83FUM04Accident · 1 fatalFinal reportCessna 180J · Descanso, CAThe non-instrument rated plt was on a flt from farmington, NM to el cajon, CA, but made a stop at borrego springs, CA where a passenger deplaned. Before departing farmington, he obtainend a wx briefing for the trip, but only filed a flt plan for the 1st leg…NTSB FTW83FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Pineville, LAThe owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed…NTSB ATL83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ahoskie, NCThe acft was struck by lightning while cruising at 9000 ft MSL. At that time, the plt observed a blue flash off the nose & heard a loud boom. All radios and navigational & electrical equipment became inop. The plt circled down thru a hole in the clouds &…NTSB MKC83FA069Accident · 1 fatalField investigationFinal reportCessna 150L · Ellsworth, KSThe pilot departed red cloud, NE for a VFR, no-flight-plan flight to kingman, KS. Witnesses reported an aircraft flying in flight conditions that appeared to deteriorate from a weather stand standpoint in the direction of flight. One witness stated that he…NTSB FTW83LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Nacogdoches, TXDuring arrival, a landing was made at night IMC conditions with low ceilings, heavy rain & gusty winds. The plt reported that during the landing, there was a x-wind component, light turbulence & a wind shift. Reportedly the acft was landed aprx half way down…NTSB DEN83FA059Accident · 4 fatalField investigationFinal reportCessna 340A · Aspen, COPrior to departure the flt was given an IFR clearance which began at herls intersection (16 mi nne) & to cross herls at or above 16,000 ft MSL. Departure arpt field elev is 7,793 ft. flts are required to proceed VFR to the initial fix of the IFR clearance.…NTSB CHI83LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Worthington, MNThe plt reported that he was able to maintain visual ground contact after he left blue earth, MN. However, as he was following an interstate highway near Worthington, MN, the visibility decreased. He attempted to get to the arpt at Worthington, but saw a…NTSB FTW83FA108Accident · 1 fatalField investigationFinal reportBeech A36TC · Addison, TXThe non-instrument rated, student plt used another person's name while filing an instrument flt plan. When he contacted ground control for departure, he was advised that the arpt had just become IFR. After some confusion concerning canceling & filing flt…NTSB MKC83FA065Accident · 2 fatalField investigationFinal reportCessna TR182 · Garwin, IADuring a briefing for a flt to western Oklahoma, the plt was advised that IMC wx was forcasted along the route. He changed his destination to waterloo, IA & was advised of IMC in that area also. While en route, the acft crashed in a field covered with snow.…NTSB LAX83FA095Accident · 4 fatalField investigationFinal reportCessna T210N · Gorman, CAThe plt received a wx briefing before takeoff, but did not file a flt plan. Aprx 35 min later, the acft was observed flying low over interstate highway 5 near the Gorman VOR & tejon pass. A patrolman that saw the acft estimated that it crossed aprx 25 ft over…NTSB FTW83LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Farmington, NMThe plt received a weather briefing & filed an IFR flt plan prior to the flt. Reportedly, the fss specialist did not advise the plt of a pertinent forcast for moderate icing in clouds & precipitation up to 18,000 ft. the forecast was available to the…NTSB DEN83FA056Accident · 2 fatalField investigationFinal reportNavion G · Leadville, COThe acft crashed into a mountain at the 12000 ft level in bad weather during a cross-country flt. Before takeoff the pilot had been advised of adverse weather enroute with VFR flt not recommended. He said he would fly out to check the weather and return if it…NTSB LAX83FA091Accident · 3 fatalField investigationFinal reportCessna 177RG · Las Vegas, NVThe acft collided with a mountain during a night cross-country. The weather was VMC at takeoff but became IMC later nearthe mountains. A VFR flight plan was filed but never opened. The pilot continued flight into an area of known IMC conditions. He had…NTSB LAX83FA090Accident · 2 fatalField investigationFinal reportBeech 58 · Indio, CAThe plt & passenger had flown from bermuda dunes to yucca valley, CA on a business flt. Reportedly, they terminated their business early because wx was building over the mountains between yucca valley & bermuda dunes. While on the return trip, the plt…NTSB NYC83FA060Accident · 2 fatalField investigationFinal reportAero Commander 680FL P · Sunbury, PAAt aprx 0928 EST, the plt obtained a fss wx briefing by telephone. He was briefed on conditions of low ceilings, fog, light rain, drizzle, snow & blowing snow along his route. However, he did not ask about icing conditions & the briefing did not include a flt…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…NTSB LAX83LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tucson, AZThe acft crashed about one mile north of the runway after engine failure during a go-around. The student pilot on a solotraining flight had returned to Tucson international airport and could not land because of cross-winds. He diverted to davis-monthan afb.…