NTSB investigations, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 GAA20CA011Accident · No injuriesData collectionFinal reportChampion 8GCBC · Henrys Lake, IDThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over.NTSB GAA20CA019Accident · Serious injuriesData collectionFinal reportAntares MA33 · Coeur d'Alene, IDThe student pilot's improper release of the throttle and failure to maintain lateral control during takeoff.NTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.NTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.NTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.NTSB WPR19TA248Accident · Minor injuriesClass 3Final reportHall Kitfox · Nampa, IDThe owner's improper installation of the tailwheel, which resulted in the pilot's inability to maintain directional control during landing as a result of severe tailwheel vibrations.NTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.NTSB GAA19CA479Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Mackay, IDThe pilot's failure to maintain lateral control of the glider during landing in gusting wind conditions, which resulted in the left wing striking the ground and a subsequent ground loop.NTSB ANC19LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boise, IDA ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.NTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.NTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.NTSB GAA19CA437Accident · Minor injuriesData collectionFinal reportPiper PA36 · Bancroft, IDThe pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB WPR19LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna P206 · Cascade, IDA loss of engine power due to the pilot’s improper leaning of the engine.NTSB GAA19CA393Accident · No injuriesData collectionFinal reportCessna A185 · Stanley, IDThe pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.NTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.NTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB WPR19LA170Accident · Serious injuriesClass 3 · LimitedFinal reportJames Experimental Cub · Stanley, IDOverstress failure of the right-wing spar due to an encounter with turbulence.NTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overNTSB GAA19CA323Accident · No injuriesData collectionFinal reportCessna 172 · Yellow Pine, IDThe pilot's improper approach, which resulted in the airplane touching down with insufficient runway remaining to stop on the runway, a runway overrun, and subsequent collision with bushes and terrain.NTSB GAA19CA283Accident · No injuriesData collectionFinal reportRockwell S2R · Grangeville, IDThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.NTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.NTSB WPR19LA157Accident · No injuriesClass 3 · LimitedFinal reportVought F4U-7 · Jerome, IDThe pilot’s decision to fly the airplane with a known mechanical deficiency.NTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.NTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA163Accident · No injuriesData collectionFinal reportAir Tractor AT 400A · Parma, IDThe pilot's failure to maintain directional control during landing in variable wind conditions, which resulted in the right wing impacting muddy terrain.NTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.NTSB GAA19CA110Accident · No injuriesData collectionFinal reportRobinson R44 · Grace, IDThe pilot's failure to maintain clearance from the power lines.NTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.NTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.NTSB GAA19CA054Accident · No injuriesData collectionFinal reportCessna 206 · Boise, IDThe airplane’s impact with a bird during the approach.NTSB GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB WPR18LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Malad, IDThe pilot’s failure to identify that he was not utilizing the full runway for takeoff, and his delayed decision to abort the takeoff, which resulted in a runway overrun.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.NTSB WPR18LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Marsing, IDThe loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.NTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB WPR18LA215Accident · No injuriesLimited investigationFinal reportCessna T337 · Lewiston, IDThe liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…NTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA405Accident · Minor injuriesData collectionFinal reportAviat A-1C · Dixie, IDThe pilot’s failure to maintain an adequate approach in gusting tailwind conditions, which resulted in a runway overshoot.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.NTSB GAA18CA315Accident · No injuriesData collectionFinal reportJim Green CCX · Couer D'Alene, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB WPR18LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Aberdeen, IDThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and nose-over.NTSB GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.