NTSB investigations, 1997, OR
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 per year
| 1962 | 1 |
|---|---|
| 1964 | 74 |
| 1965 | 88 |
| 1966 | 121 |
| 1967 | 121 |
| 1968 | 84 |
| 1969 | 80 |
| 1970 | 68 |
| 1971 | 77 |
| 1972 | 75 |
| 1973 | 84 |
| 1974 | 71 |
| 1975 | 77 |
| 1976 | 81 |
| 1977 | 95 |
| 1978 | 88 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 75 |
| 1982 | 82 |
| 1983 | 65 |
| 1984 | 70 |
| 1985 | 56 |
| 1986 | 51 |
| 1987 | 40 |
| 1988 | 41 |
| 1989 | 45 |
| 1990 | 49 |
| 1991 | 51 |
| 1992 | 48 |
| 1993 | 39 |
| 1994 | 46 |
| 1995 | 56 |
| 1996 | 60 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 43 |
| 2000 | 56 |
| 2001 | 47 |
| 2002 | 39 |
| 2003 | 48 |
| 2004 | 40 |
| 2005 | 54 |
| 2006 | 38 |
| 2007 | 47 |
| 2008 | 40 |
| 2009 | 31 |
| 2010 | 40 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 31 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 23 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 42 |
| 2020 | 23 |
| 2021 | 36 |
| 2022 | 24 |
| 2023 | 23 |
| 2024 | 30 |
| 2025 | 20 |
| 2026 | 23 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1997
AND 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 year(c."eventDate") = 1997 AND 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 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…NTSB 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…NTSB SEA97LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Portland, ORthe flightcrew's inadequate preflight, and the ramp agent's inadequate dispatch of the aircraft. The unsecured cargo door was a factor.NTSB SEA97LA084Accident · Minor injuriesLimited investigationFinal reportHutton Rand Robinson KR-2 · Grants Pass, ORThe pilot's failure to adequately compensate for wind conditions, his failure to maintain directional control on takeoff, and his failure to abort the takeoff. Factors contributing to the accident are gusty crosswinds.NTSB SEA97LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Manzanita, ORThe pilot's failure to adequately compensate for wind conditions, and his failure to maintain directional control of the airplane during the go-around attempt. Factors contributing to the accident are gusty crosswinds.NTSB SEA97LA074Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Wasco, ORthe partial loss of engine power for undetermined reasons and the pilot's selection of unsuitable terrain for a precautionary landing. A factor was the rough terrain.NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.NTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…NTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.NTSB SEA97LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Hood River, ORThe pilot-in-command's misjudgment of altitude and airspeed during a turn.