NTSB investigations, OR
8 cases where NTSB found Total experience w/ equipment.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02031025'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02031025')) 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 WPR23LA328Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Hillsboro, ORThe student pilot’s failure to maintain airplane control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB GAA20CA053Accident · No injuriesData collectionFinal reportZenair CH701 · Salem, ORThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.NTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…NTSB WPR13FA393Accident · 1 fatalField investigationFinal reportStuart Vortex · Scappoose, ORThe student pilot's unintentional takeoff followed by his failure to maintain control of the gyroplane during the landing approach. Contributing to the accident was the student pilot’s lack of both flight training and flight experience and his lack of a solo…NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB WPR09LA475Accident · No injuriesLimited investigationFinal reportWaco QCF-2 · Bend, ORThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.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 WPR09LA052Accident · Serious injuriesLimited investigationFinal reportAdkins Ridge Runner II · Mulino, ORThe pilot's failure to attain an adequate airspeed that resulted in a stall/mush during the initial climb. Contributing to the accident were the pilot's lack of experience in this make and model airplane and the improper adjustment of the propeller pitch.