NTSB investigations, 2015, OR
14 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 10 |
| 2010 | 18 |
| 2011 | 10 |
| 2012 | 17 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 14 |
| 2016 | 13 |
| 2017 | 15 |
| 2018 | 14 |
| 2019 | 27 |
| 2020 | 6 |
| 2021 | 12 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 5 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2015
AND 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\" = '470' 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 year(c."eventDate") = 2015 AND 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" = '470' 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 WPR16LA023Accident · No injuriesLimited investigationFinal reportThorp T 18 · Independence, ORA separation of the canopy mechanism during flight, which resulted in the pilot’s precautionary landing and the airplane’s subsequent collision with a fence post.NTSB WPR16CA022Accident · No injuriesData collectionFinal reportKnox Marion L RV-6A · Lebanon, ORThe pilot's failure to maintain airplane control following an aborted landing which resulted in a collision with trees.NTSB WPR16LA020Accident · Minor injuriesLimited investigationFinal reportBell 206B · Dallas, ORA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…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 WPR15LA228Accident · No injuriesLimited investigationFinal reportHudson Zodiac CH 601 XLB · Hubbard, ORA severe propeller vibration due to the pilot's improper installation of the propeller spacer assembly, which necessitated an engine shutdown, an off-airport landing, and a collision with a sprinkler system.NTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB GAA15CA135Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Nyssa, ORThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with terrain.NTSB WPR15LA192Accident · Minor injuriesLimited investigationFinal reportRoberts Super Bear · La Grande, ORA 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 WPR15FA161Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Juntura, ORThe pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.NTSB WPR15LA155Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Crescent Lake, ORThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…NTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.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 WPR15LA084Accident · 1 fatalLimited investigationFinal reportBruct J Myers RV-9A · Prineville, ORThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.