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 FTW85LA119Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Houma, LAThe aircrew had just completed a medivac flt & were repositioning the helicopter to the home base. While they were en route, the company dispatcher informed the crew that fog was moving into the area & that they had better hurry. During the night apch, the…NTSB ATL85FA101Accident · 2 fatalField investigationFinal reportCessna 182R · Burkes Garden, VAThe plt departed manassas without a current wx briefing or filing a flt plan. Plt had also left maps and a list of checkpoints at home. His route of flt was into an area of low ceilings and visibility. The acft crashed into a mountain at the 3850 ft level.…NTSB MKC85LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Madison, IAThe plt stated that an inflight encounter with a gust of wind during landing resulted in a sharp loss of altitude and a bounced landing. Consequently a second gust on rollout followed by the plts loss of directional control resulted in the acft departing the…NTSB ATL85FA097Accident · 1 fatalField investigationFinal reportBeech H18 · Cartersville, GAThe flt had not yet been scheduled when the plt retired for the evening at 2230 to 2300 EST. At 0230, he was awoken & notified to make a ngt cargo flt. The owner obtained a wx briefing & filed a flt plan, then briefed the plt later. The plt arrived at the…NTSB NYC85LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-200 · Malone, NYThe acft collided with the terrain on the side of a hill after encountering low ceilings and snow. The plt departed massena under a special VFR clearance and after aprx 25 minutes he decided to return to massena because of deterioratingweather. After flying…NTSB DEN85FA074Accident · 1 fatalField investigationFinal reportBeech BE-23-24 · Eureka, UTOn feb 6, 1985,a Beech BE-23-24 musketeer,owned and operated by the plt crashed into the side of a 7000 ft mtn at the 6700 ft level. The ac was demolished and the plt received fatal injuries. The wx conditions were reported as VMC by provo, Utah and by a…NTSB SEA85LA054Accident · 4 fatalLimited investigationFinal reportCessna 182-F · Ashland, ORThe plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970…NTSB DCA85AA012Accident · 9 fatalFinal reportBeech 65-A80 · Soldotna, AKDuring arrival, the crew of npa flt 1802 contacted the company wx observer at Soldotna who advised the wx was: wnd calm,ceiling 600 to 800 ft, vis 8 to 10 mi, no precip. They made an NDB apch, but missed the apch & requested another apch. Aprx 1 min later,…NTSB ATL85LA088Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Hartford, TNThe plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to…NTSB ANC85LA187Accident · 1 fatalLimited investigationFinal reportCessna 210 · Sparrevohn, AKThe primary cause of this accident was the pilot's inability to see and avoid obstructing terrain. Since the accident occurred in February, the mountains were covered with snow and on an overcast day and with the reported fog, the pilot in command either flew…NTSB ATL85FA085Accident · 3 fatalField investigationFinal reportBeech B-50 · Edgewood, KYDuring a VFR flt from london, KY, to detroit, MI, the acft crashed into a single family home while attempting a landing at cvg arpt. The plt reported a right eng pwr loss, from suspected impact ice. The alternate air source did not change the acft…NTSB FTW85FA104Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Victoria, TXThe plt had rented the acft on January 28, 1985, with route of flt unknown. No reported contact was made with the acft. The acft impacted the surface during hours of darkness in instrument meteorological conditions and was demolished. The plt was fatally…NTSB SEA85FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bickleton, WAThe pilot began flight activity at dawn on the day of the accident. Weather briefings indicated marginal conditions for an afternoon flight to another city, which was accomplished without incident. At 2027 hours, without updated weather briefing, the pilot…NTSB ANC85FA041Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Savoonga, AKThe plt reported that during arrival, he overflew the arpt & made a right turn while watching the village. As he maneuvered, he encountered white-out conditions, turned too FAR & subsequently collided with rising terrain. The wx over the general area prior to…NTSB SEA85FA051Accident · 3 fatalField investigationFinal reportBeech BE-35 · Verdi, NVPilot impacted rising terrain while descending into & thru IFR weather conditions during VFR flight. Lost visual contact w/ground and broke out in mountains.NTSB LAX85FA119Accident · 2 fatalField investigationFinal reportCessna A185F · Pine Valley, CAThe acft crashed while the plt was returning from a x-country flt at night. Witnesses reported that the acft was flying low in a westerly direction & appeared to be following interstate highway 8. One witness, who was traveling westbound, stated that the acft…NTSB DEN85FA067Accident · 3 fatalField investigationFinal reportBell 206 L-1 · Carson, NMThe helicopter crashed in open terrain during a turn to reverse direction. Witnesses stated the acft was heading north and was on a converging course with high tension lines that were about 80 to 100 ft high and the belly counted spotlight was illuminated…NTSB FTW85LA098Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Abilene, TXDeteriorating wx was encountered & the plt elected to land short of the original destn. He was provided vectors for an ILS apch to rwy 35R at abiline, TX. During the night apch, he encountered strong gusty winds, severe turbulence & restricted visibility. The…NTSB DEN85LA066Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Canon City, COThe acft contacted trees on mountainous terrain after encountering IFR wx en route. The plt reported that upon arriving in the Colorado springs area an undercast prevailed. He contacted pueblo apch and denver center and was advised that alamosa, CO, was…NTSB ATL85FA079Accident · 3 fatalField investigationFinal reportCessna 340 · Johnson City, TNThe acft was IFR at 17000 ft flying thru wx SIGMET area for severe icing when the plt requested a descent due to airframe ice and turbulence. During the descent the plt reported shutting down the right eng. On final apch for an off-arpt landing attempt the…NTSB MKC85LA048Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Davenport, IABalloon encountered gust during initial climb and began drifting toward wires. Plt elected to deflate & balloon collided with wires & building.NTSB DEN85LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Wapiti, WYAccording to the pilot as she was flying her aircraft in a canyon she encountered downdrafts which pushed her aircraft down. She was unable to maintain her airspeed or altitude and elected to put the aircraft into the trees.NTSB LAX85FA100Accident · 4 fatalField investigationFinal reportBeech B-35 · Death Valley, CAThe plt got an extended wx fcst the day prior to departure which indicated bkn to ovc clouds based at about 8,000 ft for the first part of the trip & sct to bkn clouds for the last half. Mountain areas were predicted to be obscured. Plt was encouraged to call…NTSB ATL85FA077Accident · 4 fatalField investigationFinal reportCessna R182 · Crossville, TNThe acft collided with wooded, rising terrain at an elevation of about 2800 ft MSL on the west slope of hinch mountain. A passenger, who survived the crash, but died later due to burns, reported that light conditions were dark & she could not see anything…NTSB BFO85FA011Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-25 · West Point, VAAfter being delayed at least 2 days at youngstown, OH, due to maintenance problems the plt departed at aprx 1725 hrs with the knowledge that the wx at his destination was ift to lifr. In addition, the plt was scheduled for a vacation and had expressed hopes…NTSB MKC85LA043Accident · No injuriesLimited investigationFinal reportCessna 182P · Ellisonore, MOPlt obtained wx briefing for route from moline, IL, st. louis, MO, memphis, TX, to new orleans, LA. Plt was informed vfrwas not recommended in eastern Iowa but st. louis was VFR and forecast to be 1000 to 2000 ft broken to scattered all morning. VFR was also…NTSB DEN85FA055Accident · 2 fatalField investigationFinal reportCessna 310N · Edgewood, NMThe pvt rated pilot did not hold a multiengine or instrument rating. The pilot and passenger were returning from vacation. A witness near the accident site stated that she saw the aircraft descend out of a low over last at a very steep nose down angle. The…NTSB FTW85FA090Accident · 3 fatalField investigationFinal reportCessna 172L · Galveston, TXA recently certificated private pilot with no known instrument training was given a 'VFR not recommended' weather briefing for a return trip on a pleasure flight. Weather conditions were predicted to, and did, deteriorate rapidly. He took off and turned on…NTSB LAX85FA093Accident · 5 fatalField investigationFinal reportCessna 182P · Big Bear City, CAThe acft crashed in a mountainous area while on a VFR personal flt to long beach, CA. The non-instrument rated private plt & 4 minor children aboard the acft were killed. By low clouds & there were extensive snow showers in the arearea the plt's log book…NTSB LAX85FA088Accident · 4 fatalField investigationFinal reportCessna 182Q · Upland, CAThe instrument rated plt & 3 pax departed palo alto for an intended 3-hour long day VFR flt to santa ana, CA. The final destination was to be mx. The plt had not flown at night or on instruments in over 6 yrs. He elected to delay departing pao until 1611 PST…NTSB FTW85LA089Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Houma, LAThe plt departed into known bad wx with low ceilings and poor visibility. Very shortly after takeoff the plt elected to return to the arpt. During a descending right turn the plt broke out of IMC at a very low altitude. He pulledcollective but still landed…NTSB LAX85FA086Accident · 1 fatalField investigationFinal reportCessna 172N · Livermore, CAThe non-instrument rated pilot departed the arpt on a special VFR clearance. Wx at the time was 1,000 overcast, 2.5 miles in light rain and fog. Acft turned eastbound following a highway toward a pass in the hills to the east and collided with the rising…NTSB FTW85FA087Accident · 3 fatalField investigationFinal reportCessna T210N · Brackettville, TXThe plt had filed an instrument flt plan from how to dht and had received a wx briefing for the route. The flt proceededto dht where radar contact was lost and the acft was cleared for an apch. The plt canceled IFR. The plt then proceeded to Brackettville,…NTSB CHI85LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Byron Township, WIThe low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…NTSB DEN85FA048Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Billings, MTOn dec 23, 1984, a non instrument rated pvt plt crashed into the ground near the arpt at Billings, MT killing all three occupants onboard. Wx conditions at the time were indefinite ceiling 100 ft sky obscured, 1/2 vis with snow and fog. Theplt received prior…NTSB NYC85FA048Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Ellington, CTThe non-inst rated plt continued flt into IMC conditions in a helicopter which was not equipped for flt on instruments. There is no record or witnesses of the plt having received a formal wx briefing but it is reported that the plt was informed of fog moving…NTSB MKC85FPG01Accident · Serious injuriesFinal reportPiper PA-28-151 · Pine Bluff, ARWhile on a x-country personal flight, the plt became disoriented near Pine Bluff, AR. He flew for several minutes before contacting air traffic control for assistance. While being vectured to the Pine Bluff airport by ATC, the acft ran out of fuel and…NTSB ATL85LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Tuxedo, NCThe recently certified private plt was under a VFR flt plan and continued the flt into known adverse wx conditions. While attempting to maneuver the acft out of the low ceiling, it was flown into the high terrain.NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB NYC85FA044Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Bainbridge, NYVFR conditions prevailed when the flt departed binghamton, NY. The destination was reported as clear until just prior to the estimated time of arrival, then fog began to form. Witnesses who heard the acft, just prior to the accident, reported heavy fog. After…NTSB FTW85LA080Accident · No injuriesLimited investigationFinal reportCessna 421C · Vancourt, TXAfter a complete wx brf the plt departed into known IFR cond well below apch min at the dest arpt with inadequate fuel reserves and no field alternate. After 2 missed apchs the plts desired alternate was below minimums. En route to a second alternate airport…NTSB LAX85FA073Accident · 4 fatalField investigationFinal reportMooney M20J · Grand Canyon, AZThe plt received a wx briefing and was advised of moderate rime and mixed icing in clouds. He filed an IFR flt plan and departed. While at 12000 ft, he reported encountering severe rime ice and requested a lower altitude. He stated thathe was trying to fling…NTSB DEN85FA043Accident · 3 fatalField investigationFinal reportPiper PA-30-160 · Albuquerque, NMThe flt was en route from forth worth, TX, to santa fe, new Mexico, when the plt decided to divert to Albuquerque. The a/c crashed while being vectored for an ILS approach to rwy 8. The plt received his instrument rating slightly more than 6 mos before the…NTSB LAX85FA070Accident · 3 fatalField investigationFinal reportCessna R172K · Desert Center, CAThe flight departed on an IFR flight after receiving a weather briefing which included flight precautions for light to moderate icing in clouds and in precipitation from 7,000 ft to 20,000 ft. the pilot reported picking up ice and that he was unable to climb…NTSB FTW85LA077Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXAn experienced professional pilot encountered forecast icing conditions on approach that obscurred forward visibility. On go-around, anti-icing equipment cleared small area of windshield, pilot decided to land. He failed to maintain sufficient airspeed to…NTSB LAX85FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Gorman, CAThe plt was on a night x-country flt. When the acft did not arrive at its destination, a search was initiated. On 12/12/84, the plane was found where it had impacted an area of rising terrain while approaching the tehachapi mountains. Impact occurred on a…NTSB LAX85FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Rosamond, CAAcft crashed in mountainous area while on a VFR flight. No record of the plt obtaining a wx briefing was found. Local residents 3-4 miles from accident site reported clouds, fog, rain, snow and hail obscured the mountains on the afternoon of 12/12/84 on…NTSB LAX85FA068Accident · 1 fatalField investigationFinal reportHart-Thorp T-18 Tiger · Tulare, CAAcft departed arpt & about 5 mins later was seen 'descending vertically' out of 'dark rain cloud' at about 1,000 ft AGL. During attempted recovery at about 300 ft AGL, acft broke up & crashed in a field. Plt did not obtain wx briefing prior to flt and did not…NTSB DEN85LTE03Accident · 1 fatalFinal reportKenneth Roebuck Varieze · Antonio, COPlt had filed a VFR flt plan from espanola, NM, to durango, CO, with a proposed departure time of 1500 MST and as en route flt time of 1 hr 10 mins. The flt plan was not activated. A search for the acft began on 12/13/84 and ended on 12/24/84. On 6/10/85 the…NTSB SEA85FA030Accident · 2 fatalField investigationFinal reportCessna C-152 · Port Orchard, WALow ceilings, rain, fog were reported in area pt the time of the accident. The student pilot was on a solo x-c, flt plan was filed with help of instru. Wx VFR nr. Acft dep 1104 PST acft crashed abt 1317 no rcrd of des reached or where acft was for 2 hrs. Acft…