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 SEA05LA006Accident · 1 fatalLimited investigationFinal reportCaldwell Glasair II · Hermiston, ORThe pilot's failure to maintain an airspeed above stall speed while executing a wingover maneuver at the top of a vertical climb, leading to an inadvertent spin, and the pilot's inadequate remedial action in attempting to recover from the spin. Factors…NTSB SEA05FA004Accident · No injuriesField investigationFinal reportMaule MT-7-420 · Bend, ORLoss of engine power during takeoff climb for undetermined reasons. Rough terrain was a factor.NTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.NTSB SEA04CA186Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Brooks, ORThe flight instructor's failure to maintain altitude/clearance on final approach to land resulting in an in-flight collision with terrain. Contributing factors were the student pilot's failure to maintain adequate airspeed during the approach and the flight…NTSB SEA04LA187Accident · Minor injuriesLimited investigationFinal reportWSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, ORAircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.NTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.NTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.NTSB SEA04CA171Accident · Minor injuriesData collectionFinal reportCessna 182P · Hillsboro, ORThe pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.NTSB SEA04CA170Accident · No injuriesData collectionFinal reportCessna 180J · Pittsburg, ORThe pilot's failure to maintain clearance from an object (pole) during an aborted landing. The pilot's delayed decision to abort the landing and a pole were factors.NTSB SEA04LA156Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Wamic, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain airspeed, resulting in a stall. The pilot's failure to use all of the available runway, and the high-gusty winds were factors.NTSB SEA04LA153Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Redmond, ORUnknown malfunction of the landing gear system for undetermined reasons that resulted in a gear collapse during landing.NTSB SEA04TA147Accident · No injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORThe improper installation of the throttle linkage clevis to the throttle control arm by unknown maintenance personnel. Contributing factors were the nylon lock nut separating from its' bolt, which permitted the throttle cable to disconnect from the throttle…NTSB SEA04LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Nyssa, ORThe failure (fracture) of the number four cylinder head during an aerial application run. Factors include the soft crop-covered terrain.NTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.NTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB SEA04CA109Accident · Serious injuriesData collectionFinal reportBalloon Works Fire Fly 9 · Aurora, ORPilot's failure to compensate for wind conditions. Wind was a contributing factor.NTSB SEA04LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Bend, OROn ground encounter with terrain during the takeoff roll as a result of the left side brake not operating. Inadequate maintenance inspection, overload of the nose landing gear and soft terrain were factors.NTSB SEA04CA107Accident · No injuriesData collectionFinal reportSteward Rocky 162F · Hood River, ORThe pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.NTSB SEA04LA100Accident · 1 fatalLimited investigationFinal reportGann Glasair II-S RG · Baker City, ORThe pilot's inadequate in-flight planning/decision and his failure to maintain an airspeed above stall speed (Vs) after encountering airframe icing during cruise flight. Factors include the pilot's intentional continuation of his flight along the planned…NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB SEA04LA092Accident · Serious injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Creswell, ORThe pilot's failure to maintain clearance from the terrain while attempting to maneuver the aircraft into the wind during an off-airport landing in an open field. Factors include the pilot's inadequate in flight planning, tailwind conditions during an…NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.NTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.NTSB SEA04LA079Accident · No injuriesLimited investigationFinal reportSZD Jantar 42-1 · Wamic, ORThe glider pilot's inadequate en route planning, which resulted in a forced landing in an area without suitable landing terrain. Factors include no suitable landing terrain in the area where the pilot found it necessary to execute a forced landing, and trees…NTSB SEA04CA076Accident · No injuriesData collectionFinal reportMooney M-20J · Redmond, ORThe pilot's failure to adequately compensate for wind conditions. Unfavorable wind was a factor.NTSB SEA04LA073Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Haines, ORA momentary partial loss of power for undetermined reason(s) and the pilot's failure to maintain adequate RPM during his autorotation landing.NTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.NTSB SEA04LA058Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Chiloquin, ORThe pilot's failure to maintain airspeed during a downwind turn resulting in a stall-mush and collision with the ground. Wind gusts were a factor.NTSB SEA04LA052Accident · No injuriesLimited investigationFinal reportCessna 172N · Creswell, ORThe pilot's attempting takeoff with the fuel selector in the OFF position resulting in fuel starvation. Contributing factors were the change in habit pattern and expectancy of the fuel selector position as well as the fence and tree.NTSB SEA04LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sisters, ORThe loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.NTSB SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.NTSB SEA04LA040Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Redmond, ORThe pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.NTSB SEA04LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Turner, ORThe pilot's inadequate preflight inspection which failed to detect contaminated fuel. A collapsed fuel screen was a contributing factor.NTSB SEA04FA031Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Cave Junction, ORBoth the pilot-in-command and the co-pilot allowing the aircraft to enter into an area of adverse weather (icing conditions at low [-20 degrees C] temperatures) resulting in sequential induction icing, induction filter blockage, carburetor icing and the…NTSB SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.NTSB SEA04LA027Accident · 2 fatalLimited investigationFinal reportErickson SHA Glasair TD · Vansycle, ORThe pilot's failure to maintain adequate clearance with the anemometer pole/wires during low altitude flight. Contributing factors were the pole and the pilot's low altitude flight.NTSB SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.NTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.NTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.NTSB SEA04LA012Accident · No injuriesLimited investigationFinal reportGarnett-Robert Barnett J4B · Prineville, ORThe pilot's failure to maintain airspeed which resulted in an inadvertent stall during the initial takeoff climb. A factor was the lack of pilot certification.NTSB SEA04LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot's selection of unsuitable terrain for a practice auto rotation landing. A contributing factor was the soft terrain.NTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.NTSB SEA04LA014Accident · Serious injuriesLimited investigationFinal reportTracy Kolb Mark III · Prineville, ORThe pilot in command's failure to maintain aircraft control during an aborted takeoff. Factors include the pilot's lack of experience in this type of aircraft (pusher).NTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.NTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…NTSB SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.