NTSB investigations, OR
25 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 3 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 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 WPR26LA049Accident · Minor injuriesClass 4 · LimitedFinal reportZenair Stol CH 701 · Shady Cove, ORThe pilot’s improper throttle input during an approach, which resulted in a rapid descent, hard landing and runway excursion.NTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.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 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 WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.NTSB WPR20CA254Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Clearwater, ORThe pilot's improper pitch attitude during the soft-field landing roll, which resulted in the tail striking the runway.NTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…NTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.NTSB GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.NTSB GAA18CA383Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Malin, ORThe pilot’s misjudgment of the approach and his subsequent exceedance of the airplane’s critical angle of attack during an agricultural application flight, which resulted in an aerodynamic stall and collision with power lines.NTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.NTSB GAA18CA084Accident · No injuriesData collectionFinal reportCorbeil Shawn Corbeil Shawn SER VI · Rogersburg, ORThe pilot’s improper landing flare and his subsequent failure to see and avoid a tree during a go-around.NTSB WPR18LA005Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 24-250 · Hillsboro, ORThe student's pilot’s failure to maintain adequate airspeed during approach and subsequent exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall and a subsequent hard landing. Contributing to the accident was…NTSB GAA17CA110Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Milton-Freewater, ORThe pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.NTSB WPR14CA077Accident · Minor injuriesData collectionFinal reportCessna T182T · Hillsboro, ORThe pilot's decision to continue the instrument approach beyond the published missed approach point.NTSB WPR13CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · The Dalles, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB WPR13LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Hillsboro, ORA runway overrun due to an insufficient stopping distance due to the downsloping runway during a rejected takeoff. Contributing to the accident was a cabin door that inadvertently opened during the takeoff roll.NTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.NTSB WPR10LA300Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 120A · Grants Pass, ORThe balloon ground crew member's decision to not release his hold on the basket of an ascending hot air balloon basket as it lifted off of the ground.NTSB WPR10CA206Accident · No injuriesData collectionFinal reportCessna 150L · Princeville, ORThe pilot’s failure to ensure that the parking brake was set prior to hand-starting the engine.NTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB WPR09LA189Accident · No injuriesLimited investigationFinal reportBeech A36TC · Roseburg, ORThe pilot's failure to follow the landing checklist, which resulted in a gear up landing. Contributing to the accident was the pilot's diverted attention.NTSB WPR09LA184Accident · No injuriesLimited investigationFinal reportSikorsky CH-54B · Corvallis, ORThe improper assembly of main rotor blade control components by the operator's maintenance personnel, which resulted in the main rotor blade's divergent path and their contact with the tail rotor drive shaft during ground operation following landing.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.