NTSB investigations, UT
91 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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' AND 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 DEN90LA151Accident · No injuriesLimited investigationFinal reportCessna 172XP · Tooele, UTThe flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.NTSB DEN90LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Price, UTThe pilot's inadequate conpensation for the gusty wind conditions, which were a factor.NTSB DEN89LA224Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Monument Valley, UTThe pilot's failure to adequately compensate for windshear.NTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.NTSB DEN88LA108Accident · No injuriesLimited investigationFinal reportCessna 210L · St. George, UTNTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…NTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…NTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…NTSB DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…NTSB DEN87FA230Accident · 1 fatalField investigationFinal reportCessna 170B · Cedar City, UTWhile on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon.NTSB DEN87FA081Accident · Serious injuriesField investigationFinal reportPiper PA-22-150 · Morgan, UTThe plt departed Morgan arpt with an acft near gross weight, in a relatively strong cross wind. After a successful takeoff at about 100 AGL, he said he encountered moderate turbulence and a downdraft. Altitude and airspeed could not be maintained. The acft…NTSB SEA87FA036Accident · No injuriesField investigationFinal reportSwearingen SA227AC · Salt Lake City, UTThe f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent…NTSB DEN86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Monument Valley, UTThe plt was on an approach for landing when the acft began to settle. He said that increasing power did not seem to have an effect. Subsequently, the acft landed hard, collapsing the nose gear. The plt believed that he had encountered wind shear during the…NTSB DEN86LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vernal, UTWhile flying a pipeling patrol flt 1,000 feet AGL in mountainous terrain, the plt encountered a downdraft windshear which resulted in an uncontrollable 2,000 fpm acft descent from which the plt was not able to recover. The acft impacted in rough terrain and…NTSB DEN86MA129Accident · 6 fatalMajor investigationFinal reportGulfstream 690D · Price, UTAt 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…NTSB DEN86FA060Accident · Serious injuriesField investigationFinal reportCessna 152 · Salt Lake City, UTAn instructor with his student plt were returning from a cross-country training flt. Three attempts were made to complete an ILS approach in heavy fog to the arpt. With each approach the instructor partially lost control of the acft and then recovered but on…NTSB DEN86FA232Accident · 2 fatalField investigationFinal reportCessna T210L · Salina, UTThe non-instrument rated plt did not obtain a wx briefing nor file a flight plan. He and his wife took off from bullfrog basin airport, glen canyon, UT, en route to heber city, UT, on 12-30-85. Acft did not arrive. Civil air patrol search was conducted from…NTSB DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…NTSB DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…NTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…NTSB DEN86LA005Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Fillmore, UTThe plt departed delta, UT on a VFR x-c flt after being advised by fss that VFR was not recommended due to IMC conditions on the proposed route of flt. He flew into an area of rising terrain, encountered IMC wx conditions, attempted to reverse course and…NTSB DEN85LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage.NTSB DEN85FA233Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Ogden, UTThe plt and his party were en route from minden, NV to casper, WY and had stopped at Ogden, UT to refuel. The plt obtained an updated wx briefing fr fss and field an IFR flt plan. After takeoff the plt was told to climb in the holding pattern to 13000 ft.…NTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.NTSB DEN85FA096Accident · 3 fatalField investigationFinal reportPiper PA-28 · Logan, UTThe plt (non-inst rated) & 2PAX dept Logan airport under extreme IMC conditions. Visability in ice fog was down to just a few feet. The a/c crashed during a rt turn after t/o.there were no survivors.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 DEN84FTM02Accident · Minor injuriesFinal reportAmateur Built Thorp T-18 · Salt Lake City, UTThe plt was on a x-country to Salt Lake City. Approaching Salt lake he saw thunderstorms in the area. At this point he said he had 1/4 of a tank of gas so he diverted to ogden then tried for morgan where he was waved off by 3 people on therwy. Plt then…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 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 DEN83FA203Accident · 2 fatalField investigationFinal reportCessna 140A · Sevier, UTThe flt was returning to san jose,CA after an extended x-country flt to oshkosh,WI which began in the latter part of July. Earlier on the day of the accident, at 0645, the plt received a wx briefing at miles city,MT. He requested the general outlook to the…NTSB DEN83LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Heber City, UTThe acft collided with a pole during an off airport precautionary landing in IMC weather. The non instrument rated student pilot took off for a 150 mile cross country with less than full fuel tanks because no 87 octane was available. He also failed to get a…NTSB DEN83FA092Accident · 1 fatalField investigationFinal reportBell 206L-1 · Salt Lake City, UTThe helicopter collided with the side of a mountain during a turn after departing from a hospital helipad while on an emergency medical flt to pick up a medical team to care for a critically ill child. The plt was notified at 0510 by his dispatcher. After…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 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 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 DEN83FA053Accident · 4 fatalField investigationFinal reportCessna T210N · Minersville, UTThe acft impacted in a near vertical attitude near the top of a mountain & adjacent to a highway where witnesses had observed the acft flying at very low altitues under a low ceiling. There was no record of a preflight wx briefing or inflight advisories. No…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 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 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 DEN82FTM16Accident · 2 fatalFinal reportVarieze · Milcreek Canyon, UTThe aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…