NTSB investigations, 2015, ID
11 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 14 |
| 2010 | 12 |
| 2011 | 22 |
| 2012 | 15 |
| 2013 | 11 |
| 2014 | 14 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 12 |
| 2018 | 11 |
| 2019 | 20 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 7 |
| 2025 | 9 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2015
AND c.\"eventStateOrRegion\" = 'ID' 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" = 'ID' 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 WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…NTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…NTSB WPR15LA255Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/L · Jerome, IDThe pilot's failure to maintain clearance from terrain while conducting a low-altitude aerobatic maneuver.NTSB GAA15CA255Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Irwin, IDThe pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB GAA15CA164Accident · Minor injuriesData collectionFinal reportPiper PA 18-135 · Twin Falls, IDThe pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.NTSB WPR15FA206Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Carey, IDUndetermined because examination of the airplane wreckage did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA153Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Mackay, IDThe student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.NTSB GAA15CA134Accident · No injuriesData collectionFinal reportQuicksilver MX · Nampa, IDThe student pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and a collision with terrain.NTSB GAA15CA048Accident · No injuriesData collectionFinal reportCessna 180J · Boise, IDThe pilot's failure to maintain directional control during landing.