NTSB investigations, OR
6 cases where NTSB found Monitoring other person.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2024 | 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\", '02021535'))
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", '02021535')) 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 ANC24LA022Accident · No injuriesClass 4 · LimitedFinal reportCory Green Kitfox Series 7 STI · Hermiston, ORThe pilot’s failure to maintain directional control during takeoff, which resulted in a nose over. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR20CA276Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Hillsboro, ORThe pilot’s failure to maintain altitude on short final due to an encounter with a down draft and the flight instructor's delayed remedial action.NTSB WPR19TA085Accident · Serious injuriesClass 3Final reportPiper PA46 · Aurora, ORThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing during a simulated power-off approach and landing, which resulted in an aerodynamic stall and loss of control and the flight instructor’s failure to adequately…NTSB WPR13CA261Accident · No injuriesData collectionFinal reportBeech A23-24 · La Grande, ORThe pilot’s failure to maintain airplane control and the flight instructors failure to monitor the pilot during a simulated emergency landing.NTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.NTSB LAX08CA185Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Philomath, ORThe student pilot's failure to maintain rotor rpm during a pinnacle approach and the flight instructor's delayed remedial action and inadequate supervision of the flight. Contributing to the accident was the downdraft weather condition.