NTSB investigations, OR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\" = 'OR' 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" = 'OR' 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 SEA83FYK04Accident · 1 fatalFinal reportHomebuilt Christen Eagle II · Bend, ORUpon completion of his routine during an airshow, the plt stated to the show announcer that he would do a low pass down the rwy followed by a vertical climb to a hammerhead stall & then into a lomcevak aerobatic maneuver. This maneuver is aclimbing outside…NTSB SEA83FU003Accident · Serious injuriesFinal reportSunburst Ultralight · Independence, ORThe pilot stated that he was trying to teach himself to fly his ultrlight. After several takeoffs from a friends field, a rather severe crosswind started which complicated landing. After numerous passes at the small strip, the pilot said he decided to land…NTSB SEA83IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, ORA broken hydraulic line near the left main landing gear allowed hydraulic fluid to leak on to the APU exhaust. The resultant smoke then was picked up by the left airpack and was blown into the cabin. The crew then ordered an evacuationof the passengers.NTSB SEA83LA136Accident · No injuriesLimited investigationFinal reportSnow S2C · Hepner, ORThe acft slid sideways on a sloping field during a forced landing and damaged a wing. The pilot said he had sprayed two fields and was enroute to spray another when a complete loss of power occurred. The pilot stated that he found no usablefuel in either fuel…NTSB SEA83LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Portland, ORWhile landing at night on rwy 34, the plt noticed that he was over half way down the rwy and still floating. He elected to go around but the acft collided with trees on the departure end & crashed. The plt reported that several of the threshold and rwy lights…NTSB SEA83LA114Accident · No injuriesLimited investigationFinal reportStinson 108 · Grants Pass, ORThe acft ran off the runway and collided with bushes during an aborted go-around. According to the pilot a crosswind caught the acft as he was landing, in spite of his attempts to keep it straight the acft started to veer to the left and he decided to…NTSB SEA83FYK03Accident · Serious injuriesFinal reportRyan-Navion NAV 4 · Cottage Grove, ORThe acft made a forced landing in a hay field and collaped the landing gear after the engine quit at 500 ft AGL during takeoff climb. During an on scene investigation there was no fuel visible in the rt wing tank. The left wing tank has nofiller access but is…NTSB SEA83LA107Accident · No injuriesLimited investigationFinal reportBeech V35-TC · Wendling, ORThe acft collided with trees and dense brush during an off airport forced landing in IMC weather. According to the pilothe was about 10 minutes into a cross country flight at 4000 feet MSL when fuel pressure dropped and he lost engine power. The pilot…NTSB SEA83LA104Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORAccording to the plt, he encountered a gust while landing on rwy 14 with a quartering tail wind, then lost directional control. Subsequently, the acft departed the left side of the rwy & the left gear collapsed. The tower control reported that the wind was…NTSB SEA83LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Klamath Falls, ORThe acft groundlooped off the runway during landing in a gusty crosswind. The pilot and passnger were not injured. The winds were reported as 300 degrees 18 knots gusting to 22 knots.NTSB SEA83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grass Valley, ORThe aircraft stalled while the pilot was attempting to land downwind on an uphill Grass strip. The wind was estimated at 15 gusting to 20 KTS. The pilot stated that on his approach, he was to the left of the center of the landing strip. He attempted to…NTSB SEA83LA098Accident · No injuriesLimited investigationFinal reportCessna 172-I · Wasco, ORThe acft went off the departure end of the runway during landing and groundlooped in a plowed field. The pilot landed in a 27 kt quartering tailwind. The acft rolled onto a freshly harrowed field. The nose wheel caught the dirt and veeredto the left and the…NTSB SEA83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · La Grande, ORThe acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14…NTSB SEA83FYM05Accident · 1 fatalFinal reportBrantly Helicopter B-2 · Milton Freewtr., ORThe helicopter was observed to climb to about 50-75 ft AGL & then something flew off the acft. One m/r blade was found intact 240 ft from the wreckage. The outer blade was heavily damaged at the tip area. The inboard blade section had the pylon tube attached…NTSB SEA83LA092Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Lakeview, ORThe acft had landed earlier at redmond in what was described as a hard landing. The plt stated the only problem noted was a 'loud squeeking brake' during the rollout. The next leg of the flight was to terminate at reno, but the plt landedat Lakeview to wait…NTSB SEA83FA089Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Lebanon, ORSeveral witnesses observed the plt making repeated low passes over the rwy. On the last pass, the acft entered a steep climb, fell off on one wing, then dove toward the ground. The plt started a pull-out, but the acft struck the ground before he recovered.…NTSB SEA83LA082Accident · No injuriesLimited investigationFinal reportStinson L-5 · Haines, ORThe aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and…NTSB SEA83LYK02Accident · Serious injuriesFinal reportCessna 210L · North Bend, ORThe aircraft collided with a parked fuel trailer after the engine started when the pilot turned the prop to loosen up the engine oil. The pilot received serious injuries when he was knocked down by the left horizontal stabilizer as he tried to reenter the…NTSB SEA83LA153Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2 · Rogue River, ORThe helicopter rolled over during lift off with pilot and one passenger and a full load of fuel. On a previous flt with one passenger and 8 gallons of fuel the pilot had noticed the left skid was about 8 inches lower than the right during lift off. On the day…NTSB SEA83LA081Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Near Rainier, ORAprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…NTSB SEA83LA078Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Near Sisters, ORAccording to the plt, he began climbing after making a pass over a frozen lake & Near a youth camp. He reported that the acft entered a stall, then began to spin to the right at aprx 1000 ft AGL. He initiated corrective action, but the main gear hit the lake…NTSB SEA83LA079Accident · No injuriesLimited investigationFinal reportErco 415C · Boring, ORThe aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…NTSB SEA83LA059Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Near Oakridge, ORAccording to the pilot, a 250 lb load on a 30 ft external line had been set down at a site at an elevation of about 3500 ft MSL. After the load was released, the pilot attempted to transition from a hover to a climb, but the helicopter began to settle.…NTSB SEA83LA051Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Oregon City, ORDuring arrival at dusk, the plt made an apch to rwy 9 with a headwind at 19, gusting 30 KTS. While on final apch, the acft collided with power lines near the apch end of the rwy. The plt reported that he did not see the lines until just prior to impact, then…NTSB SEA83LA050Accident · No injuriesLimited investigationFinal reportCessna 182N · Chiloquin, ORDuring a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…NTSB SEA83LA049Accident · No injuriesLimited investigationFinal reportCessna A188B · Medford, ORThe aircraft collided with a tree during aerial application operations. The pilot stated that there was a powerline at one end of the orchard he was spraying and a row of leafless trees at the other. One of the taller boundary trees was overlooked by the…NTSB SEA83FYM04Accident · No injuriesFinal reportMooney M20K · Dufur, ORThe aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a…NTSB SEA83FA044Accident · 1 fatalField investigationFinal reportCessna P210N · Burns, ORThe plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it…NTSB SEA83FA042Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Sunriver, ORThe aircraft departed the runway, entered a steep climb and reversed course back over the runway in the opposite direction. At about 200 feet AGL, the aircraft rolled to the left and nosed down into the ground. The pilot had called on UNICOM and said he was…NTSB SEA83FA041Accident · No injuriesField investigationFinal reportBeech 35-B33 · Redmond, ORThe pilot stated that the engine lost power at about 200 ft AGL during takeoff. He was unable to land straight ahead, so he tried to land back on the runway. The aircraft was landed on the airport property with the gear up. The pilot believed there was a fuel…NTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…NTSB SEA83FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Portland, ORThe acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…NTSB SEA83LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Newport, ORThe engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…NTSB SEA83LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Scappoose, ORAt about 300 ft AGL after a touch & go the eng quit. The non-pilot owner who was at the controls turned the acft over to the passenger who was a private pilot & he made the forced landing. There was no usuable fuel on board the acft the passenger/pilot…NTSB SEA83IA034Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Klamath Falls, ORDuring takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires…NTSB SEA83FYM02Accident · 2 fatalFinal reportEnstrom 280C · North Plains, ORAt about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…NTSB SEA83LA032Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Chemult, ORThe flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…NTSB SEA83LA026Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hood River, ORThe aircraft was heavily loaded and took longer than normal for takeoff. The acceleration was marginal. At the end of the runway, when the pilot pulled up over the wires, the airspeed decayed. The pilot maneuvered to avoid houses and large trees and flew into…NTSB SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…NTSB SEA83LA021Accident · No injuriesLimited investigationFinal reportCessna U206 · Cove, ORPilot landed on icy runway and slid 1200 feet into the river.NTSB SEA83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Vernonia, ORThe acft was observed high & fast during the approach & touched down about 300 ft from the departure end of the turf rwy. During the go-around the acft struck a wood fence, crossed a road & crashed in a "stumped off" area.NTSB SEA83FYK01Accident · Serious injuriesFinal reportPiper PA-32-300 · 27ne Rogue Rive, ORAt 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &…NTSB SEA83LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cascade Locks, ORPlt was making a precautionary landing after encountering fog enroute. Two approaches to rwy 24 were aborted due to gusting winds. A downwind approach was then made to rwy 06. When the acft descended below the height of surrounding trees the prevailing…NTSB SEA83LA013Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Madras, ORThe pilot reported that he made an off-airport landing in a grass field that was soft and wet. The field was square shaped and measured about 1500 ft on each side. While landing toward the west, he saw the end of the field approaching and applied heavy…NTSB SEA83LA011Accident · No injuriesLimited investigationFinal reportBrantly 305 · Hillsboro, ORThe tail skid hit the ground hard during landing. This caused the helicopter to bounce, and the left wheel contacted the ground causing the helicopter to turn sideways. The main rotor contacted the tail rotor, destroying both tail and main rotor blades.NTSB SEA83LA010Accident · No injuriesLimited investigationFinal reportCessna 182B · Redmond, ORThe pilot stated that during landing, the aircraft was hit with a 40 knot crosswind, which forced the aircraft into the runway. The nose gear collapsed causing structural damage T0 the aircraft.NTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.NTSB SEA83LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORDuring a local flight, the pilot made 3 landings on a 2860 ft runway at sportsman airpark. He then landed on a 2300 ft turf runway at chehalem airport in light and variable wind conditions. While landing at chehalem, the aircraft rolled beyond the departure…NTSB SEA82DA171Accident · No injuriesFinal reportPiper PA-38-112 · Hillsboro, ORThe dual student was executing touch and go landings. During the takeoff, at an altitude of approximately 20 ft AGL, the instructor reduced power simulating an engine failure. The student pilot maintained a nose high attitude and the aircraft landed hard on…NTSB SEA82DA169Accident · Minor injuriesFinal reportMooney M20E · Government Camp, ORThe pilot stated that the engine power became intermittent during cruise flight. A force landing was attempted on a highway. Upon touchdown, the aircraft skidded off the road and over an embankment. The state police arrived at the accident site shortly after…