NTSB investigations, OR
122 cases where the first occurrence was “Loss of control - on ground/water”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 SEA99LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Oakridge, ORThe pilot's failure to maintain aircraft control during a go-around. A downdraft during the approach is a factor.NTSB SEA99LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ORAircraft control was not maintained. The pilot's misjudged flare and inadequate remedial action, along with the flight instructors delayed remedial action were factors.NTSB SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB SEA98LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Aurora, ORDirectional control was not maintained by the pilot in command. Factors include rough terrain and hidden obstructions.NTSB SEA98LA012Accident · No injuriesLimited investigationFinal reportAerostar PA-60-700P · Portland, ORThe pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.NTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.NTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.NTSB SEA97LA135Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau 1.131 Jungmann · Cottage Grove, ORfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve and gear collapse. The wet runway surface was a related factor.NTSB SEA96LA156Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Arock, ORfailure of the pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground loop. The tailwind was a related factor.NTSB SEA96LA069Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Sunriver, ORthe pilot's failure to maintain directional control during the landing rollout. A factor contributing to the accident was the presence of a tree near the edge of the runway.NTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB SEA95FA170Accident · No injuriesField investigationFinal reportDornier DO 328-100 · Portland, ORinsufficiently defined information from the manufacturer and operator concerning the landing/taxi procedures.NTSB SEA95LA091Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Prospect, ORThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was wet grass.NTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.NTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.NTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.NTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.NTSB SEA94LA219Accident · No injuriesLimited investigationFinal reportCessna 150E · Mcminnville, ORThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include soft terrain in the vicinity of the runway.NTSB SEA94LA153Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hillsboro, ORThe improper servicing of the skid shock struts.NTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.NTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.NTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.NTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.NTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…NTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.NTSB SEA90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · White City, ORThe pilot did not maintain direction control of the airplane during the landing roll and took inadequate remedial action. Factors contributing to the accident include terrain and the pilot's lack of total expereince.NTSB SEA89LA168Accident · No injuriesLimited investigationFinal reportCessna R182 · Jordan Valley, ORFailure of the pilot to maintain directional control. Factors related to the accident were: the pilot's selection of unsuitable terrain (closed/rough runway), and the crosswind.NTSB SEA89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Independence, ORFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop and subsequent overload failure of the left main gear. A factor related to the accident was: improper flare by the pilot.NTSB SEA89LA051Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Albany, ORThe failure of the student pilot to maintain directional control of the airplane during landing and the improper use of flight controls. Contributing to the accident were the crosswind and the pilot's lack of total experience.NTSB SEA88LA190Accident · No injuriesLimited investigationFinal reportCessna 185F · Hillsboro, ORDuring landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt.NTSB SEA88LA075Accident · No injuriesLimited investigationFinal reportPiper J-3 · Newberg, ORThe pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The…NTSB SEA87LA077Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Scott Mills, ORWith a gusting crosswind from the left the pilot allowed the student pilot to make the take off. The student pilot rotated prematurely and the aircraft weathercocked to the left. The pilot then took the controls of the aircraft but by then it was pointed 90…NTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…NTSB SEA86LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dallas, ORA precautionary landing was made due to deteriorating weather. Directional control was lost while attempting to land on the 70 foot wide, wet, grass airstrip during gusty crosswinds. The aircraft veered to the side of the runway striking four parked…NTSB SEA86LA050Accident · No injuriesLimited investigationFinal reportCessna T210-H · Cascade Locks, ORDuring landing roll on the 1800 foot long 30 foot wide wet runway, the aircraft veered right off the runway and then nosed over. The pilot applied brakes twice with no effect and the third time they grabbed. No malfunctions were found during inspection or…NTSB SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.NTSB SEA86LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Lebanon, ORA loss of directional control occurred during landing roll. The acft veered to the right, struck a ditch and then nosed over. A helicopter was hovering to the left of the landing rwy, probably causing enough wake turbulence to cause the loss of directional…