NTSB investigations, ID
171 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 15 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 10 |
| 2013 | 11 |
| 2014 | 9 |
| 2015 | 6 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 12 |
| 2019 | 7 |
| 2020 | 8 |
| 2021 | 14 |
| 2022 | 10 |
| 2023 | 4 |
| 2024 | 14 |
| 2025 | 8 |
| 2026 | 2 |
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 c.\"eventStateOrRegion\" = 'ID' 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\", '0303'))
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" = 'ID' 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", '0303')) 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 WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.NTSB WPR26LA053Accident · Serious injuriesClass 4 · LimitedFinal reportTecnam P2008 · Blackfoot, IDThe student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night.NTSB WPR25LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hayden, IDThe student pilot’s inability to maintain control of the airplane during a sudden wind gust resulting in the airplane coming to rest inverted.NTSB WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB WPR25LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Warren, IDThe pilot’s failure to adequately compensate for a wind gust during the departure roll, which resulted in a loss of directional control and a runway excursion.NTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB WPR25LA186Accident · No injuriesClass 4 · LimitedFinal reportKohut Mark A Murphy SR 2500 · Challis, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.NTSB WPR24LA292Accident · No injuriesClass 4 · LimitedFinal reportRonald J Mclaughlin Bearhawk Patrol · Shearer, IDThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.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 WPR24LA280Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Island Park, IDA loss of lateral control during takeoff due to an accumulation of water in the right wing.NTSB WPR24LA279Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Boise, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…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 WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.NTSB WPR24LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Nampa, IDLoss of directional control during the takeoff roll.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.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…NTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.NTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.NTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.NTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.NTSB WPR22LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna T210R · Stanley, IDThe pilot’s failure to provide adequate braking during a tailwind landing, which resulted in a runway excursion.NTSB WPR22LA212Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A-1B · Big Creek, IDThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with fencing.NTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…NTSB WPR22LA132Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Howe, IDThe pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.NTSB WPR22LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Nampa, IDThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR22LA089Accident · No injuriesClass 3 · LimitedFinal reportBlake D Barrymore Just Acft Superstol · Ketchum, IDThe total loss of engine power due to carburetor ice.NTSB WPR22LA037Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.NTSB WPR21LA360Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182E · Warren, IDThe pilot’s failure to maintain altitude while maneuvering in a valley of mountainous terrain.NTSB WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.NTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.NTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.NTSB WPR21LA212Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Stanley, IDThe pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB WPR21LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Lewiston, IDThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in a taxiway excursion and collision with a fence.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.