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 SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.NTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.NTSB SEA08LA098Accident · No injuriesLimited investigationFinal reportKenney RV6 · Aurora, ORA propeller malfunction for undetermined reasons.NTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.NTSB SEA08FA078Accident · 1 fatalField investigationFinal reportLancair LC41 · Portland, ORThe pilot's failure to follow the missed approach procedure. Contributing to the accident were the fog and below landing minimums visibility conditions.NTSB SEA08LA072Accident · 3 fatalLimited investigationFinal reportWooters Lancair ES · Albany, ORThe pilot-in-command's failure to maintain aircraft control while in cruise flight. Contributing to the accident were inadequate planning/decision, icing conditions, and continued flight into known icing conditions.NTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.NTSB SEA08LA035Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Newberg, ORThe student pilot's inadvertent application of the fuel shut off valve during flight. Contributing to the accident were the locations of the heater and fuel shutoff controls.NTSB SEA08LA024Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · McMinnville, ORThe failure of the pilot to maintain an adequate airspeed during the initial climb after takeoff that resulted in an inadvertent stall. Contributing to the accident was the pilot's unfamiliarity with the accident airplane.NTSB SEA08FA022Accident · 1 fatalField investigationFinal reportHughes 269C · Baker City, ORThe pilot’s failure to maintain main rotor rpm while maneuvering.NTSB LAX08LA025Accident · Serious injuriesLimited investigationFinal reportInterplane XJ · Independence, ORA partial loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain adequate airspeed, which resulted in a spin and collision with terrainNTSB SEA08CA016Accident · Minor injuriesData collectionFinal reportDye Rans S-12 Airaile · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX08CA012Accident · No injuriesData collectionFinal reportCessna 150M · Hillsboro, ORThe pilot's misjudged and delayed landing flare that resulted in a hard landing and porpoise down the runway. Contributing factors in the accident were the night conditions and the optical illusion created by the narrow runway width and upsloping terrain.NTSB LAX08CA017Accident · No injuriesData collectionFinal reportCessna 182P · Troutdale, ORThe pilot's inadequate compensation for the tailwind condition and failure to maintain an adequate airspeed.NTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB SEA07CA274Accident · No injuriesData collectionFinal reportCessna A185F · Lexington, ORThe pilot's failure to maintain directional control during the landing roll which resulted in an inadvertent ground loop/swerve.NTSB SEA07CA269Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Bend, ORProper descent rate not obtained/maintained during a pinnacle approach.NTSB SEA07CA272Accident · No injuriesData collectionFinal reportJeffrey Wilson Escapade · La Grande, ORThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and substantial damage to the airplane's left wing. A contributing factor was the flight instructor's delayed remedial action.NTSB LAX07LA280Accident · Serious injuriesLimited investigationFinal reportRoot Sherpa · Scappoose, ORA loss of aircraft pitch control due to the fatigue failure of the fuselage tube structure at the flight control stick gimbal mechanism due to an incomplete weld penetration at the root of the weld.NTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB SEA07CA239Accident · No injuriesData collectionFinal reportCessna 210L · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07CA229Accident · Serious injuriesData collectionFinal reportQuicksilver Manufacturing GT-500 · Newberg, ORThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to terrain impact. A contributing factor was the pilot's lack of certification.NTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.NTSB LAX07CA232Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Eagle Point, ORFuel exhaustion due to the pilot's inadequate fuel consumption calculations.NTSB SEA07LA217Accident · 2 fatalLimited investigationFinal reportTaylorcraft BF12 · West Linn, ORThe corrosion, fatigue fracture, and subsequent separation of the left wing lift strut attachment fitting. Also causal was the inadequate maintenance and annual inspection by the owner/pilot/mechanic.NTSB SEA07CA216Accident · No injuriesData collectionFinal reportCessna 182P · Baker City, ORThe pilot's failure to maintain airspeed and misjudged flare during landing.NTSB SEA07FA208Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cottage Grove, ORThe partial/momentary loss of engine power during the takeoff initial climb for undetermined reasons, and the pilot's failure to maintain an airspeed above stall speed while maneuvering following the loss of engine power. Contributing to the accident was the…NTSB SEA07CA205Accident · No injuriesData collectionFinal reportRobinson R22 · Bend, ORAn excessive descent rate during a simulated power-off autorotation, and the pilot's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.NTSB SEA07CA197Accident · No injuriesData collectionFinal reportCessna 182S · Astoria, ORThe pilot's failure to maintain directional control during the landing flare/touchdown, resulting in an inadvertent swerve and collapse of the left main and nose landing gears.NTSB LAX07TA208Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07FAMS1Accident · 1 fatalMissing aircraftFinal reportCub Crafters CC11-100 · Aurora, ORThe airplane is missing.NTSB SEA07CA184Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 · La Pine, ORThe pilot's selection of an unsuitable landing site for a precautionary landing. Contributing factors were the pilot's failure to refuel the airplane, the low fuel level, and trees.NTSB LAX07LA195Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORThe pilot's failure to maintain directional control during the landing roll.NTSB SEA07LA158Accident · 3 fatalLimited investigationFinal reportShepard Lancair Propjet · Portland, ORThe loss of airplane control during climb for an undetermined reason.NTSB SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…NTSB SEA07CA150Accident · No injuriesData collectionFinal reportCessna 182P · Aurora, ORThe pilot's misjudged flare during landing, and his improper recovery from a bounced landing, resulting in collision with the runway.NTSB LAX07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Eugene, ORCollapse of the landing gear during landing for undetermined reasons.NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.NTSB LAX07LA156Accident · 2 fatalLimited investigationFinal reportTeague Rans S-6ES Coyote II · Nyssa, ORLoss of aircraft control while maneuvering for undetermined reasons.NTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.NTSB SEA07CA116Accident · No injuriesData collectionFinal reportCessna 172M · Astoria, ORThe student pilot's failure to adequately correct for changing wind conditions, leading to a loss of directional control during the takeoff ground roll. Factors include wet, soft terrain along the side of the runway.NTSB SEA07CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Prineville, ORThe total loss of engine power due to fuel exhaustion as a result of the pilot failing to correctly read the fuel quantity sight gauges. Factors include soft, brushy terrain, and the pilot's intentional excessive braking during the forced landing.NTSB LAX07CA133Accident · No injuriesData collectionFinal reportJiran FJ-1 · Banks, ORthe pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.NTSB SEA07LA095Accident · No injuriesLimited investigationFinal reportDiemert/Rotorway Exec 162 F · Roseburg, ORa total loss of engine power due to the failure of the primary and secondary electronic control units (ECU's) within the engine's Fully Automated Digital Electronic Control.NTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.NTSB SEA07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Crescent Lake, ORThe loss of a significant amount of engine power for undetermined reasons. Factors include no suitable place in which to make an emergency landing, and densely forested, mountainous/hilly terrain.NTSB LAX07LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monmouth, ORThe failure of the main drive belt tension assembly shaft due to high cycle, low stress fatigue.NTSB SEA07LA068Accident · No injuriesLimited investigationFinal reportEurocopter France SA330J · Lakeview, ORThe dual student's failure to extend the landing gear during a simulated single-engine forced landing, and the flight instructor's failure to take remedial action to keep the aircraft from touching the runway surface without the landing gear extended.