NTSB investigations, OR
289 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 15 |
| 2010 | 17 |
| 2011 | 13 |
| 2012 | 20 |
| 2013 | 16 |
| 2014 | 12 |
| 2015 | 12 |
| 2016 | 14 |
| 2017 | 15 |
| 2018 | 22 |
| 2019 | 21 |
| 2020 | 11 |
| 2021 | 20 |
| 2022 | 18 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 10 |
| 2026 | 5 |
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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106')) 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 WPR26LA221Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glastar · Summer Lake, ORThe pilot's selection of an unsuitable landing area, which resulted in the airplane nosing over during the landing roll.NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB WPR26LA175Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Prineville, ORThe pilot's inability to maintain directional control during the landing roll due to a flat tire.NTSB WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.NTSB WPR26LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206L-3 · Logsden, ORThe inadvertent entanglement of a long line with the skid, which resulted in a loss of flight control. Contributing to the accident was the use of nylon lines instead of steel cables to secure the bucket.NTSB WPR25LA287Accident · Serious injuriesClass 4 · LimitedFinal reportBriseno Samuel Kolb Firefly · Cave Junction, ORThe non-certificated pilot's improper landing flare in turbulent wind conditions, which resulted in a hard landing.NTSB WPR25LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR25LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Inhama, ORThe pilot’s failure to maintain clearance from trees while taxiing, which resulted in a wing strike.NTSB WPR25LA196Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Pendleton, ORThe pilot’s failure to maintain directional control during landing, in gusting crosswind conditions.NTSB WPR25LA191Accident · No injuriesClass 4 · LimitedFinal reportJeremy S Lezin Just Superstol · Owyhee, ORThe pilot’s failure to maintain directional control during landing.NTSB WPR25LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA144Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26B · Ontario, ORThe pilot's exceedance of the airplane's critical angle of attack during the final approach to land, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR25LA138Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Madras, ORThe pilot’s loss of control during landing roll with gusty winds.NTSB WPR25LA034Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Durkee, ORThe pilot's inadequate performance planning, which resulted in insufficient engine power to transition into an out-of-ground-effect hover at a high gross weight.NTSB WPR25LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Creswell, ORThe pilot’s loss of aircraft control during the landing flare and subsequent aborted landing.NTSB WPR24LA276Accident · No injuriesClass 4 · LimitedFinal reportMaule M4 · Scappoose, ORThe pilot’s loss of directional control after an encounter with a wind gust.NTSB WPR24FA255Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Izee, ORThe pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB WPR24LA237Accident · No injuriesClass 4 · LimitedFinal reportBaxter Daniel David Starduster TOO SA300 · Scappoose, ORThe pilot’s failure to maintain directional control during landing roll with a tailwheel shimmy.NTSB WPR24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sunriver, ORThe pilot’s loss of control during landing roll with a gusty tailwind.NTSB WPR24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV-12IS · Scappoose, ORThe pilot’s failure to remove the seat belt used as a flight control lock from the right control stick before takeoff, which resulted in a loss of control, an aerodynamic stall, and a collision with terrain during takeoff. Contributing to the accident was the…NTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.NTSB WPR24LA169Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Hillsboro, ORThe pilot’s failure to maintain direction control during the landing roll with a left crosswind.NTSB WPR24LA165Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Rome, ORThe pilot’s failure to maintain airplane control during landing.NTSB WPR24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportEngineering & Research Ercoupe 415-C · Ontario, ORThe non-certificated pilot’s unstable approach to landing, which resulted in a collision with approach lighting, hard landing, and postimpact fire.NTSB WPR24LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Scappoose, ORThe pilot’s failure to maintain aircraft control during the landing roll in gusting wind conditions.NTSB WPR24FA104Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar KXP · Cave Junction, ORThe pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…NTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB WPR24LA036Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Estacada, ORThe pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.NTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.NTSB WPR24FA004Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Newberg, ORThe pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.NTSB WPR23LA328Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Hillsboro, ORThe student pilot’s failure to maintain airplane control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB WPR23LA243Accident · No injuriesClass 3 · LimitedFinal reportKitfox 2 · Cave Junction, ORThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB WPR23LA150Accident · No injuriesClass 3 · LimitedFinal reportCompagnie Daher TBM 700 · Ashland, ORThe pilot’s failure to maintain adequate airspeed during an attempted go around, which resulted in a runway excursion and impact with terrain.NTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.NTSB WPR22LA364Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20 · Hood River, ORThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR22LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Hermiston, ORThe pilot’s loss of directional control during landing, which resulted in a ground loop.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 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.