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 SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.NTSB SEA98LA052Accident · No injuriesLimited investigationFinal reportBeech S35 · Medford, ORthe pilot's inadequate fuel management. Factors were the pilot's diverted attention and soft terrain in the forced landing area.NTSB SEA98FA047Accident · No injuriesField investigationFinal reportAerospatiale SN-601 · Portland, ORThe pilot-in-command's decision to attempt takeoff with the right engine inoperative, resulting in his failure to maintain directional control or attain adequate airspeed during the takeoff attempt. Factors included a fractured right engine starter-generator…NTSB SEA98LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mcminnville, ORDisconnection of the throttle cable at the throttle-to-carburetor adapter plate and the failure of the student pilot to shut the aircraft's engine down once a safe landing was assured. Factors contributing to the accident were the soft terrain and overloading…NTSB SEA98IA044Incident · No injuriesIncident investigationFinal reportMooney M20K · Klamath Falls, ORThe pilot's inadequate preflight which failed to detect water contaminated fuel that subsequently led to fuel icing at altitude, blockage of fuel lines which resulted in fuel starvation. A related factor was the dark night conditions.NTSB SEA98LA035Accident · Minor injuriesLimited investigationFinal reportBromley Steen Skybolt · Hillsboro, ORThe pilot's failure to maintain a proper glidepath.NTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.NTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.NTSB SEA98IA027Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Eugene, ORA checklist procedure was not followed. The initiation of an evacuation was a factor.NTSB SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.NTSB SEA98LA017Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Canby, ORThe pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.NTSB SEA98LA013Accident · No injuriesLimited investigationFinal reportBell 206B · Forest Grove, ORExcessive deceleration of the helicopter by the pilot-in-command, resulting in an in-flight main rotor blade strike on the helicopter's external load line and subsequent main rotor separation. Downhill terrain which led to a descending approach to the pickup…NTSB SEA98LA012Accident · No injuriesLimited investigationFinal reportAerostar PA-60-700P · Portland, ORThe pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.NTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.NTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.NTSB SEA98LA007Accident · 2 fatalLimited investigationFinal reportCessna 185A · Damascus, ORfailure of the pilot to maintain sufficient altitude/clearance from terrain. Factors relating to the accident included: darkness, and hilly/mountainous terrain.NTSB SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.NTSB SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…NTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.NTSB SEA97LA210Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · The Dalles, ORthe pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.NTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.NTSB SEA97LA199Accident · No injuriesLimited investigationFinal reportComeaux Kitfox 1 · Bend, ORThe private pilot-in-command's failure to ensure that directional control was maintained. A related factor was the private pilot's lack of total flight experience.NTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…NTSB SEA97LA190Accident · Minor injuriesLimited investigationFinal reportLaister LP-49 · North Plains, ORThe pilot's selection of an inadequate landing site, and his failure to adequately plan his return glide back to his home gliderport. A factor contributing to the accident was rough terrain.NTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB SEA97LA176Accident · Minor injuriesLimited investigationFinal reportGarner RAF 2000 GTX-SE · Bandon, ORThe pilot's failure to maintain sufficient rotor RPM. A factor was the pilot's limited flight experience in gyroplanes.NTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.NTSB SEA97LA161Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Bend, ORthe pilot's failure to attain a proper climb rate. High density altitude and the pilot's failure to use all of the available runway were factors.NTSB SEA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Prineville, ORThe pilot's selection of an unsuitable landing area, his improper decision to attempt an aborted takeoff on a short airstrip surround by rising terrain and trees, and his failure to maintain clearance from the trees during the aborted takeoff attempt. Factors…NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.NTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.NTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…NTSB SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.NTSB SEA97LA144Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORthe pilot's failure to ensure the landing gear was down and locked for landing. The unlatched passenger door, the uphill (unidirectional) landing area, and trees off the departure end of the landing runway were related factors.NTSB SEA97LA142Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Weston, ORThe pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…NTSB SEA97LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldport, ORthe pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…NTSB SEA97LA135Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau 1.131 Jungmann · Cottage Grove, ORfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve and gear collapse. The wet runway surface was a related factor.NTSB SEA97FA130Accident · 1 fatalField investigationFinal reportLockheed P-38L · Tillamook, ORfailure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…NTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.NTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.NTSB SEA97LA117Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Miltonfreewater, ORThe main rotor blade separated due to fatigue. Factors were: an Airworthiness Directive was not properly performed, and inadequate inspection of the main rotor blades.NTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.NTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.NTSB SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.NTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…NTSB SEA97LA096Accident · Minor injuriesLimited investigationFinal reportHendrix Talon XP · Redmond, ORincomplete installation (omission of the aft control stick and interlink tube) of the flight control system, resulting in failure of the combined (torque) elevator and aileron rod and a disconnection of the forward flight control stick from the ailerons and…