NTSB investigations, OR
32 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 1 |
| 2024 | 1 |
| 2025 | 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\" = '090' 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" = '090' 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 WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR25FA002Accident · 1 fatalClass 3 · FieldPreliminary reportTaylor J-2 · Roseburg, OROn October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR20CA316Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Pacific City, ORA loss of directional control during landing for reasons that could not be determined due to lack of available evidence.NTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.NTSB WPR19LA196Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 5(205) · Dallesport, ORThe pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.NTSB GAA19CA369Accident · No injuriesData collectionFinal reportPiper L21 · Imnaha, ORThe pilot's failure to maintain directional control while taking off from a soft, rough field, which resulted in a ground-loop.NTSB GAA19CA226Accident · No injuriesData collectionFinal reportGuimbal Cabri · McMinnville, ORThe pilot's improper landing flare during a turning, full-down autorotation, which resulted in a lower-than-normal rotor rpm, a faster-than-normal ground run speed, and the subsequent loss of directional control, a runway excursion, and a roll-over.…NTSB GAA19CA189Accident · No injuriesData collectionFinal reportCessna 140 · Corvallis, ORThe pilot’s failure to maintain directional control during the landing roll, which resulted in a propeller strike and subsequent nose-over.NTSB GAA19CA169Accident · No injuriesData collectionFinal reportCessna 152 · Madras, ORThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a collision with a snow berm and a subsequent nose-over.NTSB GAA19CA134Accident · No injuriesData collectionFinal reportCessna R172 · Troutdale, ORThe student pilot's failure to maintain the proper pitch attitude during touchdown, which resulted in a bounced landing and subsequent propeller strike.NTSB GAA19CA111Accident · Minor injuriesData collectionFinal reportCessna 180 · Bend, ORThe pilot's failure to maintain directional control in gusting crosswind conditions.NTSB GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.NTSB GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.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 GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA16CA443Accident · No injuriesData collectionFinal reportCessna A185 · Klamath Falls, ORThe pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.NTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.NTSB GAA16CA407Accident · No injuriesData collectionFinal reportCessna 152 · Scappoose, ORThe student pilot's failure to maintain pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard landing/abnormal runway contact, a partial nose wheel collapse and substantial damage to the firewall.NTSB WPR16CA022Accident · No injuriesData collectionFinal reportKnox Marion L RV-6A · Lebanon, ORThe pilot's failure to maintain airplane control following an aborted landing which resulted in a collision with trees.NTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB GAA15CA132Accident · Minor injuriesData collectionFinal reportErvin Rex H Bear Hawk · Merrill, ORThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…NTSB WPR13CA365Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Independence, ORThe pilot's improper flare with a crosswind condition, and unsuccessful attempt to correct a bounced landing, which resulted in a runway excursion and subsequent nose over.NTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR12CA399Accident · No injuriesData collectionFinal reportCessna 182F · Hood River, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.NTSB WPR11CA330Accident · No injuriesData collectionFinal reportCessna 210-5(205) · McKenzie Bridge, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR11LA276Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.3 · Jefferson, ORThe pilot's failure to maintain airplane control while on short final after experiencing a downdraft, which resulted in a subsequent hard landing.NTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.NTSB WPR10CA361Accident · No injuriesData collectionFinal reportBeech V35 · Bend, ORThe pilot's inadequate compensation for a wind gust during the landing flare, which resulted in a hard landing.NTSB WPR10CA334Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Tillamook, ORThe certified flight instructor’s selection of an inappropriate landing surface and the loss of engine power as a result of the improper use carburetor heat. Contributing to the accident was the flight instructor's inadequate supervision.