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 SEA82FYM24Accident · 2 fatalFinal reportCessna 172P · 3nm Se Scappoos, ORThe acft struck & severed power lines strung between two 90-foot towers located about 1500 feet apart. The power lines were about 50 to 60 feet above the water at the lowest point of the line sag.NTSB SEA82DA161Accident · Minor injuriesFinal reportPiper PA-38-112 · Corvallis, ORThe flight instructor stated that while on a low final approach, a sudden downdraft of windshear occurred causing the aircraft to drop and the right wing to hit the top of a tree. Upon impact the aircraft spun out of control and impacted the ground.NTSB SEA82DA159Accident · No injuriesFinal reportCessna 172 · Prineville, ORDuring the landing attempt the aircraft was blown to the right side of runway 28. The pilot was unable to correct for the wind drift and attempted to execute a go-around but the left wing tip caught in sagebrush off the left side of the runway and the…NTSB SEA82DA154Accident · Minor injuriesFinal reportCessna R172K · Brownsmead, ORThe pilot reported that about 30 minutes after takeoff, the engine sputtered and quit. The aircraft was damaged from a landing on rough terrain. During an investigation, only about two pints of fuel were found in the aircraft.NTSB SEA82DYK12Accident · No injuriesFinal reportCessna 210 · Rosenburg, ORThe pilot attempted to hand start the aircraft due to a weak battery. The pilot told passenger to hold the brakes and assumed the passenger knew how, because of his many hours of flight time (as a passenger). When the engine started the aircraft began to move…NTSB SEA82FYM23Accident · No injuriesFinal reportHughes 369HS · Troutdale, ORThe flt originated at the plt's residence 20 mi south of the Troutdale arpt. The plt stated the purpose of the flt was to refuel the acft since he figured he had about 8 gals of fuel on departure. As the acft approached the ground at about 50 ft AGL the plt…NTSB SEA82DA151Accident · No injuriesFinal reportAeronca 7AC · 7nm So. Of Sale, ORImmediately after a soft field takeoff the pilot executed a right turn into a quartering tailwind condition in an effort to avoid trees beyond the upwind end of the field. The pilot reported that during this turn the aircraft stalled and struck the ground in…NTSB SEA82DA145Accident · No injuriesFinal reportGulfstream American AA-5A · Medford, ORThe pilot reported that while landing, he flared too soon, touched down hard, and bounced. He reported that he made a power adjustment after bouncing, but landed hard again on the second touchdown. The aircraft was substantially damaged after the second…NTSB SEA82DA144Accident · No injuriesFinal reportCessna 152-II · Grants Pass, ORThe instructor pilot stated that the student was having difficulty aligning the aircraft with the runway during the landing approach. As they approached the runway he instructed the student to "get the nose up." At an altitude of approximately three feet, the…NTSB SEA82DA143Accident · No injuriesFinal reportPiper PA-28-161 · Redmond, ORThe student pilot was on a solo cross-country flight from hillsboro, OR to yakima, WA, to Redmond, OR and then return to hillsboro. The pilot reported a number of altitude and course deviations during the first two legs of the cross-country to avoid clouds.…NTSB SEA82DA135Accident · No injuriesFinal reportMooney M20F · Sandy, ORAfter the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…NTSB SEA82DA134Accident · No injuriesFinal reportMaule M-5-210C · Klamath Falls, ORDrg tkof, the plt ntoed a partial pwr loss & elected to make a prctnry lndg on the remaining rwy (length 10,300'). Whileaborting, he flared late & lndd hard. Water & products of corrosion were fnd in the gascolator. An investigation revealed the acft was…NTSB SEA82FYK11Accident · 2 fatalFinal reportCessna T210M · Cottage Grove, ORThe aircraft crashed while receiving radar vectors from eugene approach control to the vor-dme runway 34 approach at eugene, OR. Investigation revealed that the aircraft impacted tree tops in a level, nose down attitude and traveled approximately 180 yard…NTSB SEA82FYM22Accident · 3 fatalFinal reportPiper 24-140 · Enterprise, ORWitnesses observed an aircraft fly over the city of Enterprise, Oregon on a bright night with clear sky conditions. Reportedly, the aircraft was flying very erratic; and just as it disappeared from the witnesses' sight, an explosion andfireball were observed…NTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…NTSB SEA82DA119Accident · No injuriesFinal reportHughes 369D · Creswell, ORThe pilot was practicing hovering autorotations and quick stops. He stated that after about six good quick stops, he made a tail low landing and the main rotor blades flexed into the tail boom.NTSB SEA82FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Portland, ORThe pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…NTSB SEA82DA116Accident · No injuriesFinal reportBeech C45G · Sheridan, ORThe aircraft was on a functional check flight. According to the pilot and a witness (employed by the pilot), the left brake was locked during touchdown. Subsequently, the aircraft nosed over and a ground fire erupted which destroyed the plane. The pilot…NTSB SEA82FYM21Accident · No injuriesFinal reportCessna TU206G · Hood River, ORThe eng failed as the plt switched from the left to right tank while turning base. He turned on the boost pump but the eng did not start. He switched back to the left tank & turned on the high boost. The eng failed to start & the acft crashed into an apple…NTSB SEA82DA121Accident · No injuriesFinal reportLake LA-4 · Newport, ORThe pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that…NTSB SEA82DA115Accident · Minor injuriesFinal reportGrumman AA-5A · Toketee, ORThe pilot calculated the weight of his aircraft to be 90 pounds below the maximum gross weight. The airport density altitude was calculated to be approximately 5000 feet. The pilot stated that after takeoff the aircraft achieved an altitude of 50 to 100 feet…NTSB SEA82FA111Accident · 4 fatalField investigationFinal reportCessna 172F · Oxbow, ORDuring the final approach the aircraft was observed to descend to approximately 50 feet above the river and then execute a pullup and begin a left turn to either reenter a left downwind or reverse the direction of landing. The pilot lost control, the left…NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…NTSB SEA82DA109Accident · No injuriesFinal reportPiper PA-12 · Eugene, ORThe pilot was high and fast on approach and bounced on the first touchdown. On the second touchdown the aircraft swerved and the left main landing gear collapsed.NTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…NTSB SEA82DA113Accident · No injuriesFinal reportCessna 340 · Sunriver, ORThe pilot reported that he landed 10 KTS fast to compensate for a 15 kt crosswind. He reported that during the landing roll, the right brake felt like it was not working. Rather than going off the end of the runway, he applied heavy left brake and steered the…NTSB SEA82FYK09Accident · Serious injuriesFinal reportAeronca 7AC · Near Creswell, ORThe aircraft crashed while the pilot was making a low pass over a grass field. The pilot reported that the plane struck the ground while he was proceeding westbound toward the setting sun, but he did not remember the details of the crash. An instructor pilot…NTSB SEA82DA091Accident · No injuriesFinal reportCessna 170A · Oregon City, ORThe pilot had just completed his bfr. On a return flight to his original departure point, he entered the traffic pattern for a landing in calm wind conditions. He stated that when he was about 25 ft above the runway on final approach, he entered an area of…NTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…NTSB SEA82FYM19Accident · Minor injuriesFinal reportChampion 7GCAA · Independence, ORThe pilot reported that during a full stall landing, the aircraft veered to the left at the moment of touchdown. Full power was applied for a go-around, but reportedly, the pilot was unable to turn the aircraft back to the right toward the runway. After…NTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…NTSB SEA82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Hillsboro, OROn touchdown the left main gear collapsed. No green down and locked light was observed prior to touchdown and the pilot made no attempt to go around, recycle the gear, OR other landing gear malfunction procedures. A retraction check after the accident showed…NTSB SEA82DA079Accident · No injuriesFinal reportCessna 177 · Waldport, ORThe pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area.NTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…NTSB SEA82DA076Accident · Serious injuriesFinal reportCessna 182F · Medford, ORAfter takeoff, engine oil began to accumulate on the windshield and restrict forward visibility. The pilot returned to land, bounced during landing, and elected to go-around. During climbout the aircraft struck trees on rising terrain and crashed. The owner…NTSB SEA82DA073Accident · No injuriesFinal reportCessna 182QII · Cove, ORThe pilot stated that he landed heavy and was not quite straight. When the aircraft bounced the pilot attempted a go-around but the nose gear contacted a fence and the aircraft nosed over.NTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…NTSB SEA82DA071Accident · No injuriesFinal reportCessna 180K · Jordan Valley, ORThe aircraft landed 1/3 of the way down the runway and continued off the end into a fence. The pilot stated that the wet sod runway surface hindered adequate braking.NTSB SEA82DA068Accident · No injuriesFinal reportde Havilland 2 · 15n Of Medford, ORThe pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control…NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…NTSB SEA82DA061Accident · No injuriesFinal reportGrumman AA-5B · Sunriver, ORAfter terminating his first approach in a go-around the pilot commenced a second approach. Just before touchdown the pilot stated that a gust of wind shoved the plane to the left. The pilot attempted to abort the landing by adding full power but the aircraft…NTSB SEA82DA058Accident · No injuriesFinal reportGrumman G-164A · S. Of Echo, ORDuring a spray run the pilot experienced a power loss. After pulling up to 100 feet AGL and turning 90 degrees the engine ceased to operate. The pilot completed a forced landing in a nearby soft wheat field and after rolling approximately 300 feet the…NTSB SEA82DA057Accident · Serious injuriesFinal reportHiller-Soloy 12E · Christmas Valle, ORThe helicopter was being used to string a transmission line. A rope (attach line) was used to connect the helicopter to the transmission line. The rope became detached and the pilot landed to have it reattached. A man, involved in the ground operations,…NTSB SEA82FYM13Accident · Serious injuriesFinal reportWeatherly 201B · Kent, ORThe pilot reported that he was working off of a 1700 ft dirt strip with a rough surface and with a slight cross- wind. The elevation was about 2650 ft MSL and the temperature was approximately 70 degrees fahrenheit. The pilot initiated a takeoff with about…NTSB SEA82FA046Accident · Serious injuriesField investigationFinal reportCessna 177RG · 10 East Of Till, ORDuring flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead…NTSB SEA82DA047Accident · No injuriesFinal reportSikorsky S-58J · Siletz, ORAfter lift-off with a 3000 pound external sling load, a "pop" was heard followed by low-level vibration. Rotor RPM decayed and an autorotation was effected to a forced landing in a revine. Postcrash inspection revealed a failure of the engine drive "short…NTSB SEA82DYM14Accident · No injuriesFinal reportCessna 182 · Albany, ORThe pilot proceeded to the run-up area at the end of the runway. After making a run-up, he elected to taxi to refuel before taking off. He stated that he was making a turn when a gust of wind picked up his right wing. The aircraft then turned until it was in…