NTSB investigations, OR
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\" = '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 SEA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · McMinnville, ORThe student pilot's failure to adequately compensate for wind conditions while doing a touch-and-go landing.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…NTSB SEA01LA086Accident · No injuriesLimited investigationFinal reportCessna U206 · Yamhill, ORthe pilot's failure to adequately compensate for gusty tailwind conditions, resulting in an excessive rate of descent at touchdown. Factors include gusty tailwinds during the landing sequence.NTSB SEA01LA084Accident · No injuriesLimited investigationFinal reportCessna U206F · Imnaha, ORThe pilot's inadequate compensation for the wind conditions. Wind gusts were a factor.NTSB SEA01FA085Accident · No injuriesField investigationFinal reportMBB BO-105C · Medford, ORA leaking engine oil outlet line fitting in the #1 engine compartment, resulting in an oil fire in the engine compartment.NTSB SEA01LA079Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Summer Lake, ORthe pilot's decision to land on a dry lake bed without first taking action to determine the firmness of the surface. Factors include soft terrain at the location the pilot chose to land.NTSB SEA01LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Scapoose, ORthe pilot's failure to maintain a speed above minimum in-flight stall speed (Vs). Factors include gusty winds at the time of the attempted landing.NTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.NTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…NTSB SEA01LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Enterprise, ORInadvertent collision with a deer while landing. A contributing factor was night conditions.NTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…NTSB SEA01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · North Bend, ORThe pilot's failure to maintain clearance from the delivery truck while taxing. The pilot being distracted is a factor.NTSB SEA01LA053Accident · No injuriesLimited investigationFinal reportGibbs V-6 Stol · Newberg, ORthe pilot's mismanagement of his available fuel, the fuel starvation of the engine, and the pilot's excessive rate of descent during the touchdown portion of a power-off forced landing.NTSB SEA01LA049Accident · No injuriesLimited investigationFinal reportAero Commander AC-690 · Eugene, ORan undetermined malfunction of the nose gear system which resulted in the failure of the nose gear to fully extend and lock prior to landing.NTSB SEA01LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415G · Santiam, ORThe partial blockage of the carburetor main metering jet orifice by contamination of undetermined origin. Factors include a snow-covered runway upon which the pilot executed a forced landing.NTSB SEA01LA044Accident · No injuriesLimited investigationFinal reportBell 206B · McMinnville, ORThe pilot's failure to apply adequate power during a practice autorotation. A factor contributing to the accident was a rough/uneven area on the asphalt landing surface.NTSB SEA01LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Cottage Grove, ORThe flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…NTSB SEA01LA038Accident · No injuriesLimited investigationFinal reportCessna 402B · Ontario, ORPilot's failure to maintain aircraft control while landing. Factors include a snow covered runway.NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB SEA01LA034Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Hermiston, ORThree out of four snap rings holding the pistons for the landing gear actuators failed which resulted in the landing gear collapsing during landing. On ground collision with a berm was a factor.NTSB SEA01LA029Accident · No injuriesLimited investigationFinal reportKaman K-1200 · Prineville, ORThe pilot's failure to adequately compensate for wind conditions.NTSB SEA01LA027Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Gleneden Beach, ORThe pilot's excessive application of main wheel brakes. Factors include the pilot's failure to maintain directional control and his inadequate remedial action during his attempt to regain control.NTSB SEA01LA026Accident · No injuriesLimited investigationFinal reportCessna 150C · Pacific City, ORThe pilot's failure to maintain aircraft control during the landing roll. Factors include a higher than normal approach speed.NTSB SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.NTSB SEA01LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hood River, ORThe pilot's failure to maintain directional control during landing.NTSB SEA01LA002Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Hillsboro, ORClearance from an obstruction was not maintained during the go-around. The pilot's failure to maintain directional control during the landing roll was a factor.NTSB SEA00LA195Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salem, ORThe pilot's failure to maintain aircraft control upon experiencing a loss of normal braking effectiveness. Factors included a partial failure of the brake system, a tailwind, and a parked aircraft.NTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.NTSB SEA00LA189Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Corvallis, ORThe instructor pilot's delayed remedial action. Factors include the student's failure to properly initiate a flare, and the soft terrain immediately adjacent to the taxiway.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.NTSB SEA00LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brookings, ORThe pilot's loss of control during the landing attempt. Trees, a crosswind condition, the pilot's inadequate compensation for the wind conditions, and a delayed remedial action were factors.NTSB SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.NTSB SEA00LA174Accident · No injuriesLimited investigationFinal reportBeard Lancair 320 · Bend, ORThe pilot's failure to take adequate remedial action upon encountering aircraft control difficulties during landing. Factors included gusty wind conditions and the pilot's failure to maintain aircraft control during landing.NTSB SEA00LA168Accident · No injuriesLimited investigationFinal reportCessna 172B · Sunriver, ORThe pilot's improper decision to continue the takeoff after the aircraft failed to climb or accelerate immediately after the initial liftoff. Factors were inadequate preflight planning, to include the pilot's failure to calculate takeoff performance data,…NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.NTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…NTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB SEA00LA157Accident · No injuriesLimited investigationFinal reportHamer Lancair 235 · Chiloquin, ORLoss of engine power due to a fracture and separation of the engine's crankshaft. A factor was a vehicle on the roadway.NTSB SEA00LA156Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn inadequately planned approach. The encounter of wake turbulence and not being able to maintain aircraft control were factors.NTSB SEA00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gleneden Beach, ORThe pilot's failure to remove the control lock during his preflight inspection. Factors contributing to the accident were the pilot's failure to follow the BEFORE TAKEOFF checklist, trees beyond the upwind end of the runway, and the pilot's self-induced…NTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.NTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.NTSB SEA00LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birkenfeld, ORThe pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.NTSB SEA00LA147Accident · No injuriesLimited investigationFinal reportCessna A185F · Tillamook, ORThe pilot's failure to maintain directional control.