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 SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.NTSB SEA00TA138Accident · No injuriesFinal reportCessna 182R · John Day, ORThe pilot's improper flare on touchdown resulting in a hard landing. A factor was the pilot's entrance into an inadvertent porpoise condition.NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB SEA00LA125Accident · No injuriesLimited investigationFinal reportCessna 172I · Sandy, ORThe pilot's failure to attain the proper touchdown point for landing, and his failure to go around from the improperly executed approach. Factors included the pilot's failure to attain the proper glidepath on the approach, a short landing runway, and…NTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.NTSB SEA00LA121Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · West Linn, ORImproper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…NTSB SEA00LA118Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Bend, ORImproper preflight preflight planning/preparation by the pilot-in-command. Factors included a worn tailwheel tire and the VASI lighting system.NTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.NTSB 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.NTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…NTSB SEA00LA097Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene, ORInadequate quality control by the manufacturer during the manufacturing process, which led to the total failure of a fastener, and the separation of the tail rotor blade balance weight. An adhesive debond between the adhesive and the surface was a factor.NTSB SEA00LA106Accident · No injuriesLimited investigationFinal reportCessna 182M · Hood River, ORThe pilot's failure to adequately compensate for wind conditions. Factors include a tailwind.NTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…NTSB SEA00LA085Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Seaside, ORThe pilot's improper decision to continue to a point where he could not be assured of reaching a safe landing-out site if he encountered an area of significant sink after departing his planned route of flight. Factors include downdrafts, terrain that…NTSB SEA00LA079Accident · No injuriesLimited investigationFinal reportMorton Christavia Mark I · Salem, ORThe pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…NTSB SEA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hillsboro, ORAn inadequately planned approach. Misjudging distance/altitude and improper remedial action were factors.NTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.NTSB SEA00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lexington, ORThe pilot's failure to adequately compensate for wind conditions upon encountering a wind shift on takeoff. A factor was variable winds.NTSB SEA00LA077Accident · No injuriesLimited investigationFinal reportPZL-Bielsko Jantar 2A · Hood River, ORThe pilot's failure to maintain directional control of the glider after its wing came in contact with long grass growing on the runway surface. Factors include the pilot's improper decision to attempt a landing on a runway with known directional control…NTSB SEA00LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Wallowa, ORThe pilot's failure to maintain proper runway alignment upon encountering a wind gust, and his subsequent failure or inability to maintain clearance with a tree during a go-around attempt. Factors included a short and narrow airstrip, gusty wind conditions,…NTSB SEA00LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Creswell, ORThe pilot's failure to maintain directional control. Factors include a drainage ditch and a crosswind.NTSB SEA00LA052Accident · No injuriesLimited investigationFinal reportCessna A185-F · Bend, ORThe pilot's failure to adequately compensate for wind conditions.NTSB 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…NTSB 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.NTSB SEA00FA038Accident · No injuriesField investigationFinal reportHughes 269C · Sherwood, ORThe pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.NTSB SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.NTSB 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.NTSB 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.NTSB SEA00LA028Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Salem, ORFailure of the pilot to maintain ground clearance, resulting in the long-line snagging and then striking the tail rotor.NTSB SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…NTSB 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.NTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.NTSB 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.NTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.NTSB SEA99LA164Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crescent Lake, ORThe pilot's failure to maintain directional control during a bounced landing. Factors include a sudden wind shift, a crosswind gust, and tall trees growing along the side of the airstrip.NTSB SEA99LA161Accident · No injuriesLimited investigationFinal reportWild Goose A1 · Keizer, ORA loose fuel line fitting resulted in a loss of engine power. An intentional wheels down landing was a factor.NTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.NTSB SEA99LA155Accident · No injuriesLimited investigationFinal reportSchwarzler Kolb Mark 3 · Independence, ORThe pilot's failure to maintain airspeed while on approach.NTSB SEA99LA169Accident · No injuriesLimited investigationFinal reportBeech J-35 · Union, ORDirectional control not maintained. A rough/uneven landing area was a factor.NTSB 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…NTSB 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.NTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB 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.NTSB SEA99LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Oakridge, ORThe pilot's failure to maintain aircraft control during a go-around. A downdraft during the approach is a factor.NTSB 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…NTSB SEA99LA111Accident · No injuriesLimited investigationFinal reportWalentine RV4 · Creswell, ORA foreign material/substance was ingested into the carburetor which resulted in a power loss.NTSB SEA99LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cottage Grove, ORThe pilot's inadequate management of fuel which led to fuel starvation.. A related factor was the unsuitable terrain.NTSB SEA99LA108Accident · Serious injuriesLimited investigationFinal reportWilliamson/Williamson RV-4 · Coos Bay, ORInadequate aircraft preflight inspection (engine air inlet cover not removed) by the pilot, resulting in obstruction of the carburetor air inlet in flight and consequent inflight engine stoppage. Factors contributing to the accident included a vehicle…NTSB SEA99IA106Incident · No injuriesIncident investigationFinal reportJohn Hubbard Glasair II S · Florence, ORAircraft control was not maintained. Inadequate compensation for wind conditions and gusts were factors.