Fatal NTSB investigations, OR

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB SEA02LA039Accident · 1 fatalLimited investigationFinal reportBitton/Sport Flight Talon · Boring, ORLoss of control for undetermined reasons.Feb 10, 2002 · UNREG · Substantial damageNTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.Dec 11, 2001 · N5774Q · DestroyedNTSB 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…Oct 16, 2001 · N7502K · Substantial damageNTSB 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.Sep 9, 2001 · N3056F · Substantial damageNTSB 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…Sep 5, 2001 · N18414 · DestroyedNTSB 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.Nov 17, 2000 · N3762A · DestroyedNTSB 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.Nov 6, 2000 · N53301 · DestroyedNTSB 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.Sep 23, 2000 · N152RD · DestroyedNTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.Jul 8, 2000 · N7625M · DestroyedNTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.Jun 17, 2000 · N9022F · DestroyedNTSB SEA00LA051Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Odell, ORThe pilot's failure to maintain sufficient altitude over, or clearance with, a tree. Factors contributing to the occurrence of the accident were the tree and sharply rising terrain. A factor contributing to the severity of the accident was a post-crash fuel…Mar 13, 2000 · N9040V · DestroyedNTSB SEA00FA039Accident · 2 fatalField investigationFinal reportMooney M20K · Pendleton, ORThe pilot's failure to adequately remove ice and snow from the airplane. A contributing factor was the pilot's inability to maintain control during climb due to degradation of the airplane's aerodynamic performance.Jan 24, 2000 · N251BD · DestroyedNTSB SEA00FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Hermiston, ORThe pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.Dec 23, 1999 · N8129R · DestroyedNTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.Dec 11, 1999 · N5347C · Substantial damageNTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.Nov 11, 1999 · N6245E · Substantial damageNTSB SEA00FA014Accident · 1 fatalField investigationFinal reportEnstrom F28C · Pendleton, ORFailure to maintain clearance from the runway surface while maneuvering at low altitude, and inadequate remedial action after the tail rotor struck the surface.Nov 2, 1999 · N635H · DestroyedNTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…Aug 29, 1999 · N747CC · DestroyedNTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.Aug 8, 1999 · N383T · DestroyedNTSB SEA99LA129Accident · 3 fatalLimited investigationFinal reportVanek Sport Copter · Scappoose, ORThe failure of the ultralight operator to see and avoid the landing gyroplane, and the gyroplane pilot's inability to see the departing ultralight vehicle.Jul 24, 1999 · N61887 · 2 aircraft · DestroyedNTSB SEA99FA113Accident · 1 fatalField investigationFinal reportAlexander VAN'S RV-8 · Lafayette, ORFatigue of the number two connecting rod end resulting in a fracture at the rod end and release from the crankshaft, an ensuing in-flight fuel fed fire, followed by the pilot's abandoning the aircraft in flight. A contributing factor was pressure on the pilot…Jul 10, 1999 · N41VA · DestroyedNTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.Jun 13, 1999 · N9458H · DestroyedNTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.Mar 9, 1999 · N41096 · Substantial damageNTSB SEA99FA028Accident · 2 fatalField investigationFinal reportPacific Aviation Composites LC 40-550FG · Portland, ORAircraft control was not maintained and the pilot's lack of total experience in type operation. Weather conditions reported ceilings below approach/landing minimums and a dark night condition were factors.Jan 9, 1999 · N141LC · DestroyedNTSB SEA99FA027Accident · 4 fatalField investigationFinal reportBeech 58P · Yamhill, ORThe pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.Jan 7, 1999 · N700LF · DestroyedNTSB SEA98LA182Accident · 1 fatalLimited investigationFinal reportCora Allegro · Cresent Lake, ORThe pilot's failure to maintain clearance from trees located off the departure end of the runway. Factors include strong, variable, gusty winds, terrain-induced turbulence, a high density altitude, and trees off the departure end of the runway.Sep 18, 1998 · OKDUU · DestroyedNTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.Jul 31, 1998 · N835T · Substantial damageNTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.Jul 20, 1998 · N31066 · Substantial damageNTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.Jun 9, 1998 · N199JM · DestroyedNTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.Jan 31, 1998 · N50499 · DestroyedNTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.Oct 26, 1997 · N160HB · DestroyedNTSB 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.Oct 23, 1997 · N714 · DestroyedNTSB 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.Sep 18, 1997 · N8509 · DestroyedNTSB 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.Aug 3, 1997 · N20146 · Substantial damageNTSB 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…Jul 28, 1997 · N80222 · Substantial damageNTSB 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.Jun 21, 1997 · N6630C · Substantial damageNTSB 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…Jun 20, 1997 · N168RW · DestroyedNTSB 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…Jun 7, 1997 · N7973 · DestroyedNTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.May 24, 1997 · N83211 · DestroyedNTSB 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.May 21, 1997 · N3005J · Substantial damageNTSB 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.May 10, 1997 · N3152J · DestroyedNTSB 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…May 10, 1997 · N55676 · DestroyedNTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…Apr 27, 1997 · N30LL · Substantial damageNTSB SEA97FA049Accident · 2 fatalField investigationFinal reportChampion 7-GCBC · Creswell, ORthe pilot exceeded the design stress limits of the aircraft, while recovering from a spin, which resulted in failure and separation of the right wing tip and adjacent wing fabric (skin).Jan 19, 1997 · N9677S · DestroyedNTSB SEA97FA037Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Eagle Point, ORThe failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.Dec 14, 1996 · N278ML · DestroyedNTSB SEA97LA035Accident · 2 fatalLimited investigationFinal reportBell 47G · Pendleton, ORThe pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.Dec 10, 1996 · N4758R · DestroyedNTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.Nov 15, 1996 · N7823K · DestroyedNTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…Oct 29, 1996 · N200CQ · Substantial damageNTSB SEA97FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Halsey, ORThe pilot-in-command's failure to maintain main rotor RPM, resulting in loss of control of the helicopter and collision with terrain. Factors included the pilot's lack of experience in helicopters, and interpersonal relationship problems between the pilot and…Oct 19, 1996 · N512HH · DestroyedNTSB SEA97LA011Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 · Tillamook, ORfailure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.Oct 11, 1996 · N7150A · DestroyedNTSB SEA97FA001Accident · 3 fatalField investigationFinal reportBoeing Vertol BV-107 II · Canby, ORfailure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…Oct 4, 1996 · N196CH · Destroyed