NTSB investigations, OR
26 cases where the defining event was Hard landing.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 2 |
| 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 WPR26LA271Accident · No injuriesClass 4 · LimitedInvestigation openLet L-23 Super Blanik · North Plains, ORNTSB 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 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 WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.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 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 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 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 GAA15CA038Accident · Minor injuriesData collectionFinal reportUltramagic M90 - NO Series · Sherwood, ORThe pilot's failure to maintain the descent rate, resulting in a hard landing.NTSB WPR14CA088Accident · No injuriesData collectionFinal reportClayhold Sportsman GS-2 · Manzanita, ORThe pilot's inadequate landing flare and failure to maintain control of the airplane while landing with gusting wind.NTSB WPR14CA077Accident · Minor injuriesData collectionFinal reportCessna T182T · Hillsboro, ORThe pilot's decision to continue the instrument approach beyond the published missed approach point.NTSB WPR13CA421Accident · No injuriesData collectionFinal reportCessna E162 · Eugene, ORThe pilot's improper flare that resulted in a bounced landing.NTSB WPR12CA345Accident · No injuriesData collectionFinal reportCessna 172N · Ashland, ORThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.NTSB WPR11CA473Accident · No injuriesData collectionFinal reportCessna 152 · Scappoose, ORThe student pilot's improper flare, which resulted in a bounced landing from which she was unable to recover.NTSB WPR11CA368Accident · No injuriesData collectionFinal reportCessna R172K · Sandy, ORThe pilot's improper flare which resulted in a hard landing.NTSB WPR11CA489Accident · No injuriesData collectionFinal reportCessna 172C · Grants Pass, ORThe student pilot's failure to maintain an adequate airspeed on approach, which resulted in a hard landing.NTSB WPR11LA003Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scappoose, ORThe student pilot’s failure to maintain helicopter control during the landing flare and his subsequent interference with the flight instructor's control inputs. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB WPR10CA238Accident · No injuriesData collectionFinal reportCessna 172S · Corvallis, ORThe pilot's improper use of the flight and engine controls, resulting in a bounced landing.NTSB WPR09CA375Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe flight instructor's failure to maintain adequate main rotor RPM.NTSB WPR09CA377Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe student pilot's improper use of the collective control and the flight instructor’s delayed reaction to the student pilot’s incorrect control inputs.NTSB WPR09CA271Accident · No injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 235 · Ontario, ORThe pilot's misjudged landing flare. Contributing to the accident was the pilot's lack of any experience in the make and model airplane.NTSB LAX08CA285Accident · No injuriesData collectionFinal reportMason Falconar F-11 · Creswell, ORThe pilot's failure to maintain a stabilized approach, inadequate recovery from a bounced landing, and failure to maintain directional control.NTSB SEA08FA161Accident · 1 fatalField investigationFinal reportCessna 441 · Sunriver, ORThe pilot's misjudged landing flare and improper recovery from a bounced landing, and the pilot's failure to maintain directional control during the go-around after one of the airplane's propellers struck the runway.NTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.NTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.