NTSB investigations, 2024, ID
7 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
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\") = 2024
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") = 2024 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 WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.NTSB WPR24FA288Accident · 2 fatalClass 3 · FieldPreliminary reportTextron T206H · Yellow Pine, IDOn August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR24LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Stanley, IDThe pilot’s loss of directional control in reduced visibility conditions due to a wind gust, which resulted in a collision with a trailer.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…