NTSB investigations, OR
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 SEA89LA076Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Milton-Freewtr, ORImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel.NTSB SEA89LA070Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4 · Yamhill, ORPilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.NTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.NTSB SEA89LA066Accident · No injuriesLimited investigationFinal reportThiessen RV-4 · Independence, ORFailure of the propeller. A related factor was the obstruction (transmission line) in the emergency landing area.NTSB DEN89FA091Accident · 1 fatalField investigationFinal reportCessna 210D · Eugene, ORThe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: the terrain and weather conditions at the accident site, and the pilot's lack of instrument experience.NTSB SEA89LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Hillsboro, ORThe improper landing flare performed by an unqualified person at the controls who had no flight training.NTSB SEA89FA053Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lakeview, ORFailure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…NTSB SEA89LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forrest Grove, ORThe pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.NTSB SEA89LA051Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Albany, ORThe failure of the student pilot to maintain directional control of the airplane during landing and the improper use of flight controls. Contributing to the accident were the crosswind and the pilot's lack of total experience.NTSB SEA89LA049Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Beaver Marsh, ORAn loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.NTSB SEA89LA030Accident · 1 fatalLimited investigationFinal reportCessna 205 · Cottage Grove, ORThe student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'…NTSB SEA89LA029Accident · Minor injuriesLimited investigationFinal reportBell 47G3-B1 · Newberg, ORAs plt slowed helicopter to about 10 KTS forward speed, tail rotor effectiveness decreased. Acft yawed right into descent to ground contact.NTSB SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…NTSB SEA89LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Oregon City, ORThe pilot was landing his aircraft on a very wet 1,170 foot grass runway. The pilot was not able to stop the aircraft before it collided with a fence at the end of the runway. According to the manufacturers performance figures, under the given temperature and…NTSB SEA89LA020Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Bend, ORThe pilot visually inspected the runway while making a low pass. He reported afterward that he saw no evidence of ice or snow on the runway. The copilot called UNICOM but was told, while the aircraft was on short final, that the winds were calm and the…NTSB SEA89LA007Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Fields, ORThe plt rprtd that as he was in a slow descending turn to the left at about 20 KTS (translational lift). The helicopter suddenly rotated to the left without warning. He estimated that this occurred at about 30 ft AGL. He applied right pedal & the rotation…NTSB SEA88LA191Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Troutdale, ORThe plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the…NTSB SEA88LA190Accident · No injuriesLimited investigationFinal reportCessna 185F · Hillsboro, ORDuring landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt.NTSB SEA88LA184Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Eugene, ORPlt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…NTSB DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…NTSB SEA88LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Bend, ORAt aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost…NTSB SEA88LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cottage Grove, ORWhen plt realized strong headwinds at cruise alt would preclude reaching intended destination, he attempted to divert to another alternate. Fuel exhaustion occurred before reaching arpt. During a lndg, executed in dark, acft collided with a fence.NTSB SEA88LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Cottage Grove, ORA loss of power occurred after takeoff from runway 33, during turn from upwind to crosswind, while doing touch and go landings. After checking the fuel selector and applying carburetor heat, the instructor pilot made a right turn back to the runway. The wind…NTSB SEA88LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Nehalem, ORAfter executing one go-around due to overshoot, plt landed long on second approach. Plt attempted to brake to stop, then rejected landing, applied power and became airborne prematurely. Loss of control and collision with terrain followed.NTSB SEA88LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe student pilot reported that during cruise while on a solo cross country training flight the engine began to surge. He called ATC and was directed to the nearest available airport. The student pilot landed long and fast and departed theend of the runway.…NTSB SEA88FA160Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · John Day, ORWhile elk spotting in mountainous terrain, the aircraft collided with trees in a nose low turn similar to the intermediate stages of a stall. A severe post impact fire erupted. The density altitude at the accident site elevation was approximately 10,100 feet.…NTSB SEA88LA158Accident · No injuriesLimited investigationFinal reportCessna 185 · Hillsboro, ORThe pilot reported that the engine lost power during a fuel tank switchover. The aircraft collided with a telephone pole guy wire on the road during the forced landing. The investigation revealed a fuel leak induced when the fuel boost pump was in operation.…NTSB SEA88LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Tyge Valley, ORThe pilot reported that late in the apch, the acft developed a high sink rate. However, he used elevator only to correct the sink rate. The aircraft impacted the runway and bounced. On the third bounce, the nose gear failed and the aircraft nosed over. The…NTSB SEA88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Yoncalla, ORStudent plt was at 8500 ft crz when pwr loss occurred. Forced lndg made in open field where acft collided with fence on lndg roll. Engine ran normally post-mishap. Fuel sample clear of water or other contaminant. Plt did not use carb heat when pwr loss…NTSB SEA88LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Enterprise, ORWhile in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard…NTSB SEA88LA143Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · North Bend, ORDrg a logging opn, the plt noted an apparent transmission malfunction. An autorotative landing was made on unprepared terrain & the helicopter was damaged. An investigation revealed the tail rotor drive input gear in the 42 deg gearbox had failed from…NTSB SEA88LA129Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA315B · Oakridge, ORWhile slinging a log the pilot allowed the log/sling line to contact a tree. The momentum of the log and helicopter bowed the tree over when the line contacted it. The pilot chose to release the log from the sling line rather than disengage the entire line…NTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.NTSB SEA88LA123Accident · Serious injuriesLimited investigationFinal reportKaman HH43 · Joseph, ORThe pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.NTSB SEA88LA117Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Bend, OROn arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due…NTSB SEA88LA106Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Elgin, ORThe purpose of the flight was for the pilot to practice for his aerial applicators certificate. Water was being used instead of chemical. The pilot reported that as the aircraft began to accelerate during takeoff it began to oscillate. As in prior…NTSB SEA88LA097Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Chemult, ORThe pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to…NTSB SEA88LA093Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Prineville, ORThe pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…NTSB SEA88LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Yamhill, OROn short final for landing onto a 2100 foot airstrip at about 12 feet AGL, the aircraft encountered adverse winds and struck the ground in a three point attitude breaking off the nose gear. The aircraft then nosed over inverted striking a barbed wire fence.…NTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…NTSB SEA88LA087Accident · Minor injuriesLimited investigationFinal reportStearman A-75-N1 · Medford, ORPlt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of…NTSB SEA88FA084Accident · 1 fatalField investigationFinal reportMaule M5-210C · Bend, ORPlt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective…NTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…NTSB SEA88IA074Incident · No injuriesIncident investigationFinal reportBoeing 727-290 · Portland, ORThe Boeing 727 was pushed back fm the gate counterclockwise through an arc of 90 degrees resulting in mispositioning the acft relative to the intended taxi direction. The ground crew (tug and safety operators) attempted to resolve the out of position…NTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…NTSB SEA88IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Portland, ORCrew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.NTSB SEA88LA066Accident · No injuriesLimited investigationFinal reportCessna 150 · Fox, ORWhile departing an airstrip situated on top of a hill the aircraft was not able to clear power lines at the end of the airstrip. The pilot lowered the nose of the aircraft to clear the wires and the aircraft's elevator struck a road sign in flight. The…NTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…NTSB SEA88LA075Accident · No injuriesLimited investigationFinal reportPiper J-3 · Newberg, ORThe pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The…NTSB SEA88FA054Accident · Minor injuriesField investigationFinal reportCessna T210N · Burns, ORThe aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…