NTSB investigations, OR
134 cases where the sequence of events included Loss of control on ground.
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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" = '230' 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 GAA19CA202Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Sisters, ORThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose-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 GAA19CA150Accident · No injuriesData collectionFinal reportPiper PA22 · Scappoose, ORThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with taxiway signage.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 GAA19CA056Accident · No injuriesData collectionFinal reportGuimbal Cabri · Newberg, ORThe pilot under instruction's failure to maintain directional control and the flight instructor's delayed remedial action.NTSB GAA19CA061Accident · No injuriesData collectionFinal reportSocata TBM 700 · Corvallis, ORThe pilot's failure to maintain lateral control of the airplane during landing, which resulted in a wing strike.NTSB GAA19CA007Accident · No injuriesData collectionFinal reportMaule M7 · Medford, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.NTSB GAA18CA562Accident · No injuriesData collectionFinal reportRutan Rutan Long EZ · Independence, ORThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.NTSB GAA18CA569Accident · No injuriesData collectionFinal reportMaule M7 · Grass Valley, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.NTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA236Accident · No injuriesData collectionFinal reportL-Bird CCX-2000 · Hood River, ORThe pilot’s decision to take off in gusting wind conditions, which resulted in a loss of directional control.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 GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind 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 GAA17CA541Accident · No injuriesData collectionFinal reportRudberg Todd W Vans Acft RV8 · Manzanita, ORThe airplane’s collision with two elks during landing.NTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.NTSB GAA17CA424Accident · Minor injuriesData collectionFinal reportSalerno Kenneth G JR Kitfox Series 7 · Owyhee, ORThe pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.NTSB GAA17CA363Accident · No injuriesData collectionFinal reportPiper PA 22 · Pendleton, ORThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB GAA17CA358Accident · No injuriesData collectionFinal reportVans RV-12 · Eugene, ORThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.NTSB GAA17CA288Accident · No injuriesData collectionFinal reportAeronca 7AC · Lebanon, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.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 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 GAA16CA429Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Joseph, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.NTSB GAA16CA422Accident · No injuriesData collectionFinal reportCessna 195 · Hillsborough, ORThe pilot's failure to attain a proper touchdown point and loss of directional control and her subsequent excessive brake application, which resulted in a nose-over.NTSB GAA16CA424Accident · No injuriesData collectionFinal reportStinson 108 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in runway excursion and nose-over.NTSB GAA16CA366Accident · No injuriesData collectionFinal reportHelio H 295 · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB GAA16CA309Accident · No injuriesData collectionFinal reportMaule MX 7 · Ontario, ORThe pilot's failure to maintain directional control during landing, which resulted the right wing impacting the ground, and nose down.NTSB WPR16CA121Accident · Serious injuriesData collectionFinal reportChampion 7ECA · Brookings, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.NTSB GAA15CA231Accident · Minor injuriesData collectionFinal reportCessna 180H · Ione, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.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 GAA15CA302Accident · No injuriesData collectionFinal reportAviat A · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR15CA097Accident · No injuriesData collectionFinal reportSchneider Richard J Alaskan Bushmaster · Newburg, ORThe pilot's failure to maintain directional control during the takeoff roll into sunlight, which restricted his visibility.NTSB WPR15LA022Accident · No injuriesLimited investigationFinal reportCessna TU206G · Monument, ORThe loss of braking action during the landing roll on a gravel runway for reasons that could not be determined based on the available information.NTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.NTSB WPR14CA291Accident · Minor injuriesData collectionFinal reportDelconte Emidio J Kitfox Series V · Cove, ORThe pilot's failure to maintain directional control during takeoff when the airplane encountered standing water on the airstrip.NTSB WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.NTSB WPR13LA414Accident · No injuriesLimited investigationFinal reportCessna 180 - B · Redmond, ORThe pilot's inability to counter an unexpected wind gust after touchdown, which resulted in a loss of directional control.NTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.NTSB WPR13LA336Accident · No injuriesLimited investigationFinal reportWester/Steiger Glastar · Independence, ORThe total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA322Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Albany, ORThe loss of hydraulic fluid, which rendered the brakes ineffective. The reason for the loss of hydraulic fluid could not be determined based on the available evidence.NTSB WPR13CA324Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Canby, ORThe pilot's failure to maintain directional control during the landing rollout in gusting wind conditions.