NTSB investigations, UT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 DEN87LA238Accident · No injuriesLimited investigationFinal reportMaule M-5-210TC · Moab, UTThe pilot aborted his approach to runway 21 at canyon lands airport when he had 'indications of a crosswind.' The pilot radioed Moab UNICOM and reported he could not find the windsock and requested wind information. Moab UNICOM reported thewind was 'straight…NTSB DEN87LA235Accident · No injuriesLimited investigationFinal reportBell 47-G3B2 · Oakley, UTThe plt had just taken off from a confined area surrounded on two sides with electrical power lines. As he attempted to climb, he said his RPM began to bleed off. He stated that he made a right pedal turn to avoid the wires but was unable to prevent a hard…NTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…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 DEN87LA229Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Manila, UTThe student plt was landing at an uncontrolled airport with an asphalt runway 5300 x 60 ft oriented 250 degrees. She said she made 3 passes over the airport to check for conditions and then executed a normal landing. Shortly after touchdown the aircraft…NTSB DEN87LA217Accident · No injuriesLimited investigationFinal reportRockwell 200D · Ogden, UTThe pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was…NTSB DEN87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salt Lake City, UTThe pilot stated the touchdown seemed normal but the aircraft began to porpoise, the propellers struck the runway and the aircraft came to a stop. A post accident inspection revealed the nose gear steering roller had become dislodged and prevented proper…NTSB DEN87LA176Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Bountiful, UTThe private pilot was practicing touch and go landing. The pilot reported the third landing was a wheel landing. Just after touchdown, adjacent to large petroleum tanks, the aircraft weather cocked to the right. The aircraft swerved right and departed the…NTSB DEN87LA173Accident · No injuriesLimited investigationFinal reportBeech B-60 · Kanab, UTThe commercial corporate plt had deplaned his passengers and was beginning the second leg of a corp/exec flight. During ground run the plt detected a manifold pressure loss on the left engine. The plt aborted the takeoff and applied heavy braking. The…NTSB DEN87LA165Accident · No injuriesLimited investigationFinal reportCessna 150-J · Ogden, UTThe plt and his son were returning home to Ogden. The plt reported to Ogden tower, 'I'm out of fuel.' The plt later stated, 'I landed in a field of two foot tall grass about five miles north of Ogden arpt. Prior to coming to a stop the acft struck a ditch…NTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…NTSB DEN87LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Monument Valley, UTThe plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction.NTSB DEN87LA141Accident · No injuriesLimited investigationFinal reportCessna T210H · Salt Lake City, UTThe plt rprtd dscndg from 10,500 feet MSL for an apch to rwy 34 right at the Salt Lake City arpt. He stated he had selected landing flaps & had moved the mixture to rich & the prop to high RPM. At 8,500 MSL, 'the engine quit.' Subsequently, the plt made a…NTSB DEN87LA142Accident · No injuriesLimited investigationFinal reportBell 206B II · Logan, UTThe plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an…NTSB DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…NTSB DEN87LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The…NTSB DEN87FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Ogden, UTAcft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…NTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…NTSB DEN87LA115Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Roosevelt, UTDuring landing, as the acft neared the taxiway leading to the parking ramp, the plt applied brakes and the acft veered to the off the rwy. The plt then applied pwr in an attempt to takeoff. The acft paralleled the rwy for a short distance and after crossing a…NTSB DEN87LA097Accident · Minor injuriesLimited investigationFinal reportMclachlan Moni · Tooele, UTThe private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an…NTSB DEN87LA094Accident · No injuriesLimited investigationFinal reportHughes 269C · Scoffield, UTThe plt and his brother were on a long cross country flt, through mountainous terrain. After one hour of flt and while flying at 8,000 feet the plt noticed a change in engine noise and the acft had a partial power loss. The plt elected to autorotate to a snow…NTSB DEN87LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bountiful, UTThe stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…NTSB DEN87LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, UTN67880 experienced VOR receiver failure during a flt from ogden, UT to st. george, UT. The plt diverted to Milford, UT and another plt checked the receiver which functioned on the ground. The flt then departed Milford en route to st. george. Shortly after…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 DEN87LA074Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Park City, UTThe Balloon was landing in an open field and struck a rock. One pax had prepared for hard landing and one had elected to continue filming. The photographer was thrown forward out of the basket and the basket passed over him, coming to rest 50 feet away.NTSB DEN87FA069Accident · 1 fatalField investigationFinal reportRaven S-77A · Park City, UTWhile on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted…NTSB DEN87LA052Accident · No injuriesLimited investigationFinal reportCessna 185C · Cedar City, UTDuring normal descent at seven-thousand ft MSL, acft struck a bird. The left wing tip leading edge incurred a dent twenty-four inches long and twelve inches deep. Directional control became difficult so plt made a precautionary landing on highway I-15, and…NTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…NTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…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 DEN87LA026Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Vernal, UTThe plt attempted to land on a dirt road near two oil rigs. He said he made several low passes to view the road surface. During the landing roll, the wheels of the acft dug into the soft surface. A loss of control occurred which resulted in the acft traveling…NTSB DEN87LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · St. George, UTDuring a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy.NTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…NTSB DEN87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Price, UTThe student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft…NTSB DEN86LA253Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hurricane, UTUpon making a normal landing the aircraft groundlooped to the right, impacting with an embankment. Aircraft became airborne again and touched down in soft earth, nosed over and substantially damaged the aircraft. No injuries occurred on this VFR training…NTSB DEN86LA245Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Salt Lake City, UTThe plt rprtd that while he was performing aerobatics at an airshow, the acft's eng momentarily lost power during inverted flt at the top of a loop. He was unable to complete the loop. Subsequently, the acft contacted the rwy in a level attitude while it was…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 DEN86LA222Accident · No injuriesLimited investigationFinal reportBoeing E75 · Tooele, UTThe plt rprtd that he encountered a downdraft while crossing a ridgeline in mountainous terrain, aprx 5 mi NE of Tooele,UT. The elev of the acdnt site was about 9,000 ft & the temp was rprtd by the plt to be 80 deg. This would have resultedin a density alt of…NTSB DEN86LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Monument Valley, UTThe plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There…NTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…NTSB DEN86LA195Accident · No injuriesLimited investigationFinal reportCessna 320C · Cedar City, UTThe plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond…NTSB DEN86LA191Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Provo, UTPlt and three pax flew from el paso, TX to Provo, UT en route to Alaska vacation. Left main tire blew after acft touched down. Acft veered to left and went off rwy. Examination of tire revealed large hole but with good tread remaining. Acft damage was…NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…NTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…NTSB DEN86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Provo, UTThe student & instructor (CFI) were practicing touch-&-go lndgs. The CFI rprtd that drg a lndg, when the acft was aprx 6 inches above the rwy, the student suddenly applied full left rudder. The acft yawed sharply to the left & the CFI attempted corrective…NTSB DEN86LA159Accident · No injuriesLimited investigationFinal reportCessna 150L · Bountiful, UTThe plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on 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 DEN86FTM02Accident · Serious injuriesFinal reportDenney Aerocraft Kitfox · Ogden, UTShortly after takeoff, the acft had a partial power loss. The left wing then dipped sharply & the acft entered a steep nose low descent & crashed on the nw corner of the arpt. An investigation revealed a noise suppressor was installed on one of 2 spark plug…NTSB DEN86FA141Accident · Serious injuriesField investigationFinal reportCessna 150-H · Glen Canyon, UTWhile in a descent 20 miles before reaching the destination, the acft engine quit due to fuel exhaustion. The plt initiated an emergency forced landing to a dry stream bed in rough desert terrain. After touchdown, the acft impacted an embankment and flipped…NTSB DEN86LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAcft carburetor had been removed for maintenance and sign posted in acft to this effect. Student plt called to schedule acft and was put in another acft. Scheduler said plt was told acft was out of service but plt claimed he did not hear this. Plt met flt…