NTSB investigations, 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, 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 WPR22LA370Accident · No injuriesClass 4 · LimitedFinal reportAlisport Silent 2 Electro · Hood River, ORThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot’s failure to follow the checklist to remove the wing wheel and tail dolly before takeoff.NTSB WPR22LA372Accident · Minor injuriesClass 4 · LimitedFinal reportCessna P210N · Weston, ORThe pilot’s improper landing flare which resulted in a bounced landing and runway excursion.NTSB WPR22LA330Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky S-61N · Shady Cove, ORA total loss of engine power due to the failure of the No. 2 engine’s stage 1 turbine blades as a result of an unreported hot start two days earlier.NTSB WPR22FA312Accident · 2 fatalClass 3 · FieldFinal reportJackson Dennis RV-8 · Scio, ORThe pilot’s decision to perform a low-altitude aerobatic maneuver and his improper execution of the maneuver, which resulted in impact with terrain.NTSB WPR22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lexington, ORThe pilot’s failure to maintain directional control during the landing roll with a gusting wind.NTSB WPR22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Portland, ORThe pilot under instruction’s improper landing flare, and the flight instructor’s delayed remedial action.NTSB WPR22LA224Accident · No injuriesClass 4 · LimitedFinal reportRobert Fitts Fitts CUB · Hillsboro, ORThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB WPR22LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Sunriver, ORThe pilot's failure to maintain control of the airplane during takeoff, which resulted in a collision with terrain.NTSB WPR22LA203Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Hillsboro, ORA missing fuel filler cap O-ring, which resulted in a total loss of engine power due to water contamination in the fuel.NTSB WPR22LA193Accident · No injuriesClass 3 · LimitedFinal reportVans RV-8 · Galice, ORThe in-flight failure of the crankshaft gear’s alignment dowel as a result of the retaining bolt not being installed, which lead to a total loss of engine power.NTSB WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.NTSB WPR22LA182Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS 350B3 · Christmas Valley, ORThe pilot’s inability to maintain control in high wind conditions while repositioning during a landing attempt, which resulted in a loss of control and collision with terrain.NTSB WPR22LA177Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Enterprise, ORThe inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.NTSB WPR22LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Portland, ORThe pilot’s failure to maintain directional control during landing on a wet surface with a tailwind, which resulted in a runway excursion.NTSB WPR22LA122Accident · No injuriesClass 4 · LimitedFinal reportRaviraj Mohil CCX-2000 · The Dalles, ORThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR22LA112Accident · Minor injuriesClass 4 · LimitedFinal reportGregory S Miller GM CUB · Monument, ORThe failure of the pilot to maintain directional control during takeoff, which resulted in an impact with a tree.NTSB WPR22FA087Accident · 2 fatalClass 3 · FieldFinal reportBeech K35 · Salem, ORThe airplane’s excessive nose-up pitch attitude during landing for undetermined reasons.NTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.NTSB WPR22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Creswell, ORThe pilot’s excessive left brake pedal application during landing roll, which resulted a loss of directional control, runway excursion, and nose over.NTSB WPR22LA074Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Jordan Valley, ORThe pilot’s decision to takeoff on remote snow covered terrain which, resulted in a nose-over.NTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR22LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Eugene, ORThe pilot’s improper checklist use, which resulted in an electrical malfunction and subsequent gear up landing.NTSB WPR22LA045Accident · No injuriesClass 4 · LimitedFinal reportElvin Jack R JR Rotorway Exec 162F · Scio, ORThe pilot’s improper maintenance on the tail rotor assembly, which resulted in the loss of control and roll over.NTSB WPR22LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Molalla, ORThe loss of engine power for undetermined reasons.NTSB WPR22LA019Accident · No injuriesClass 3 · LimitedFinal reportLancair ES · Fall Creek, ORTotal loss of engine power due to fatigue failure of the camshaft gear.NTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.NTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.NTSB WPR22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportZenith CH750 · Oregon City, ORThe total loss of engine power for undetermined reasons.NTSB WPR21LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Salem, ORThe pilot’s improper landing flare in a tailwind, which resulted in a hard landing and subsequent impact with terrain.NTSB WPR21LA338Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tillamook, ORThe pilot's failure to maintain clearance from a powerline during a low reconnaissance, with sun glare.NTSB WPR21LA337Accident · No injuriesClass 3 · LimitedFinal reportCessna 172E · Enterprise, ORThe fatigue fracture of the nose gear upper torque link, which resulted in the separation of the torque link from the shock strut and a loss of directional control.NTSB WPR21LA333Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Glide, ORThe pilot’s failure to maintain clearance from a tree during an aerial application.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB WPR21LA344Accident · No injuriesClass 3 · LimitedFinal reportCessna 182E · Eugene, ORLoss of directional control due to damage to the nosewheel strut that was sustained during a previous landing.NTSB WPR21LA314Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Roseburg, ORThe pilot’s failure to maintain directional control during the landing roll which, resulted in a runway excursion and collision with a tree.NTSB WPR21LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Mt. Hood, ORThe total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…NTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.NTSB WPR21LA276Accident · No injuriesClass 4 · LimitedFinal reportPayne Steven R RV-8 · Hillsboro, ORThe second pilot’s diverted attention while taxing which, resulted in his failure to maintain clearance from another airplane holding short of the runway.NTSB WPR21LA274Accident · No injuriesClass 4 · LimitedFinal reportScott Mills CCX-2000 · Independence, ORThe pilot's loss of directional control while landing, which resulted in a runaway excursion and subsequent ground loop.NTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.NTSB WPR21LA250Accident · No injuriesClass 3 · LimitedFinal reportL-Bird CCX-2000 · Hood River, ORThe total loss of engine power due to improper construction of the muffler, which resulted in separation of the internal components.NTSB WPR21FA233Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-135 · White City, ORThe pilot’s failure to maintain control of the airplane during a go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s impairment due to his medical conditions and the effects of his medications.NTSB WPR21LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fields, ORThe pilot’s failure to maintain directional control during landing on a highway, which resulted in an impact with terrain and subsequent nose over.NTSB WPR21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Fields, ORThe pilot’s failure to maintain directional control during landingNTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.NTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.NTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.NTSB WPR21LA179Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30B · Corvallis, ORThe pilot’s failure to maintain airplane control during a simulated engine out landing which resulted in impact with terrain.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.