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 SEA02LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Burns, ORThe pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…NTSB SEA02LA129Accident · No injuriesLimited investigationFinal reportRockwell International 690A · Crescent Lake, ORThe pilot's failure to maintain proper rate of descent resulting in a hard landing and subsequent nose gear separation. Contributing factors were the turbulent crosswind conditions the pilot encountered just before touchdown.NTSB SEA02LA127Accident · No injuriesLimited investigationFinal reportBredl Fokker DR1 · Troutdale, ORThe collapse, for undetermined reasons, of the left main landing gear spoked-wheel structure.NTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.NTSB SEA02LA120Accident · No injuriesLimited investigationFinal reportWelborn Pulsar XP · Prineville, ORThe disconnection of the throttle cable on landing resulting in the aircraft's engine going to full throttle and the pilot's subsequent failure to maintain directional control after securing the engine during the landing event.NTSB SEA02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Troutdale, ORA loss of engine power for an undetermined (non-mechanical) reason. Contributing factors were high grass and soft terrain which lead to the collapse of the nose gear during the landing roll.NTSB SEA02LA095Accident · No injuriesLimited investigationFinal reportCessna 441 · Medford, ORThe overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.NTSB SEA02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Umpqua, ORThe pilot's failure to adequately compensate for unfavorable wind conditions and maintain clearance from the terrain during an attempted VFR go-around. Factors include an encounter with unfavorable wind conditions during the landing flare and the attempted…NTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.NTSB SEA02FA097Accident · No injuriesField investigationFinal reportLewis Nieuport 11 · Independence, ORThe partial loss of engine power in maneuvering flight due to the rotation of the ignition distributor as a result of a failure to tighten the distributor positioning clamp after the last engine timing adjustment. Factors include an inadequate maintenance…NTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.NTSB SEA02LA082Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gaston, ORThe pilot's failure to maintain clearance from object(s) while executing a forced landing following a total loss of power for undetermined cause(s). Contributing factors where the pole impacted during the emergency landing and the pilot's diverted attention.NTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.NTSB SEA02LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Troutdale, ORImproper compensation for wind conditions while landing. Factors include a taxiway marker.NTSB SEA02LA073Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Goshen, ORThe failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…NTSB SEA02LA072Accident · 1 fatalLimited investigationFinal reportGallagher Taylor "Coot" · Creswell, ORA loss of engine power due to oil starvation followed by the pilot's failure to maintain aircraft control during the initial climb shortly after takeoff. An improper engine modification was a factor.NTSB SEA02LA069Accident · No injuriesLimited investigationFinal reportWoodley Zodiac 601HD · Beaver, ORA partial failure of the electrical (ignition) system and a short to the master electrical switch during cruise flight resulting in a loss of engine power. A collision with an embankment during the landing roll was a factor.NTSB SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.NTSB SEA02LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-24-180 · Scappoose, ORThe pilot's failure to tie down the aircraft prior to hand propping the engine. Factors were a fence, trees, and the pilot's inadequate preflight planning/preparation.NTSB SEA02LA039Accident · 1 fatalLimited investigationFinal reportBitton/Sport Flight Talon · Boring, ORLoss of control for undetermined reasons.NTSB SEA02LA038Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Creswell, ORThe pilot's failure to maintain directional control on landing resulting in the aircraft leaving the runway environment, crossing a ditch and nosing over. Contributing factors were variable winds reported by the pilot and the ditch.NTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.NTSB SEA02LA034Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Baker City, ORThe pilot's excessive descent rate at the time the aircraft came in contact with the runway during a night precautionary landing. Factors include extensive airframe ice accumulation, ice accumulation on the flight compartment windshield, ambient conditions…NTSB SEA02LA029Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll. An icy runway and a snow bank were factors.NTSB SEA02LA021Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Ashland, ORThe pilot's excessive use of brakes. A factor was the pilot's lack of recent experience in type of aircraft.NTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.NTSB SEA02LA020Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Halfway, ORA loss of aircraft control for undetermined reasons. A factor was a snow-covered landing surface.NTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB SEA02LA003Accident · Minor injuriesLimited investigationFinal reportEllsberg One Design · Bend, ORthe separation of a propeller counterweight mounting bracket due to incorrect mounting bolt torque. Factors include significant powerplant vibration during the forced landing, no suitable landing area, and soft terrain next to the narrow road on which the…NTSB SEA01LA177Accident · No injuriesLimited investigationFinal reportCessna 172RG · Newberg, ORThe pilot's failure to lower the landing gear. A factor was the pilot's failure to follow checklist procedures.NTSB SEA01LA176Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Estacada, ORThe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. A tailwind, fence and the pilot's lack of total experience in the type of aircraft were factors.NTSB SEA01LA170Accident · 1 fatalLimited investigationFinal reportCessna 182J · Gold Beach, ORThe pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…NTSB SEA01LA164Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winston, ORThe pilot's failure to maintain clearance from a fence during the initial takeoff. A fence was a factor.NTSB SEA01IA161Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Portland, ORImproper tension of the right control yoke chain; a worn right aileron spring tab hinge bearing; improper tension of the left aileron spring tab aft spring and worn contact stud; improper tension of the right aileron spring tab and a worn contact stud; a worn…NTSB SEA01TA152Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Ukiah, ORAn inadequate recovery from a bounced landing and directional control was not maintained during landing. A high flare and a fence were factors.NTSB LAX01LA275Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Klamath Falls, ORAn encounter with turbulence from a developing thunderstorm during cruise flight.NTSB SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…NTSB SEA01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Troutdale, ORthe pilot's inadvertent visual flight rules ( VFR) flight into instrument meteorological conditions (IMC) during cruise flight. Factors include his attention being diverted to the indications presented by his Global Positioning System (GPS), and low ceiling…NTSB SEA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-20-135 · Redmond, ORThe pilot's inadequate compensation for wind conditions during landing. A factor was variable winds.NTSB SEA01LA134Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Oregon City, ORThe front seat (pilot-in-command's) inadequate visual lookout during step taxi resulting in the aircraft's collision with a partially submerged log. A contributing factor was the log and it's lack of any conspicuous marking.NTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.NTSB SEA01LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Canby, ORFuel starvation as a result of a collapsed fuel nozzle filter screen. Contamination that blocked the fuel nozzle screen and water contamination were factors.NTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.NTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.NTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.NTSB SEA01LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Sunriver, ORThe pilot's failure to maintain clearance from trees during initial climb. Trees were a factor.NTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.