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 SEA07TA203Accident · No injuriesFinal reportCessna TU206G · New Meadows, IDThe loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.NTSB SEA07CA186Accident · No injuriesData collectionFinal reportCessna 182 · Bear Lake, IDThe separation of the bolt that holds the nosewheel steering torque arm to the nose wheel strut during the takeoff roll, resulting in no nosewheel steering being available during the landing roll at the pilot's destination. Factors include the pilot's failure…NTSB SEA07LA173Accident · Minor injuriesLimited investigationFinal reportHalsted Flightstar Pioneer · Nampa, IDThe failure (fracture) of the crankshaft of the non-certificated two-cycle engine during cruise flight. Factors include a ditch running through the field in which the pilot executed his engine-out forced landing.NTSB SEA07CA164Accident · Minor injuriesData collectionFinal reportCessna 180H · Nampa, IDThe pilot's failure to stop for additional fuel, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07FA165Accident · 1 fatalField investigationFinal reportCessna 172 · Yellow Pine, IDThe pilot's selection of the wrong routing through mountainous terrain and his failure to maintain adequate terrain clearance.NTSB SEA07CA157Accident · Minor injuriesData collectionFinal reportCessna 210M · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll. Wind gusts and a quartering tailwind were factors.NTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.NTSB SEA07CA169Accident · No injuriesData collectionFinal reportBoeing Stearman A75N1 · Coeur d'Alene, IDThe pilot's failure to maintain directional control during landing. The crosswind condition was a contributing factor.NTSB SEA07LA140Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Shearer, IDA fracture and separation of the left main landing gear strut during the landing roll due to fatigue.NTSB SEA07CA125Accident · No injuriesData collectionFinal reportCessna 170B · Fairfield, IDThe pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.NTSB LAX07CA132Accident · No injuriesData collectionFinal reportCessna U206-C · Cottonwood, IDThe pilot's misjudgment of distance/speed, which resulted in a overshoot of the runway in tailwind conditions and subsequent nose over. Factors in the accident were the tail wind condition and the short runway.NTSB SEA07LA145Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · McCall, IDThe nosewheel steering system's uncommanded turn during the landing roll, making it impossible for the pilot to maintain directional control. Factors include a snow bank running parallel to the side of the runway.NTSB SEA07CA089Accident · No injuriesData collectionFinal reportCessna T206H · Boise, IDThe pilot's failure to maintain aircraft control which resulted in the aircraft porpoising during the landing. A factor was the wind gusts.NTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.NTSB SEA07CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Lewiston, IDthe inadvertent use of the rudder by the passenger, which resulted in an inadvertent ground loop.NTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.NTSB SEA07FA061Accident · 1 fatalField investigationFinal reportCessna T210R · Rexburg, IDThe loss of engine power due to the contamination of the fuel manifold valve, and the pilot's continued operation of the airplane with known maintenance discrepancies.NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB SEA07LA043Accident · No injuriesLimited investigationFinal reportBell 206B · Boise, IDThe pilot's failure to maintain clearance from tall brush during a low-hover pedal turn. A factor was the six foot-tall brush located adjacent to the area where the pilot was operating.NTSB SEA07LA037Accident · Minor injuriesLimited investigationFinal reportCavalier F51D Mustang · Rexburg, IDThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.NTSB SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.NTSB SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.NTSB SEA06CA190Accident · No injuriesData collectionFinal reportColtrin RV-6 · Burley, IDA loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.NTSB SEA06CA192Accident · No injuriesData collectionFinal reportAmorde Glasair II-S RG · Rockford, IDThe pilot's failure to maintain aircraft control during landing. A contributing factor was gusty winds.NTSB SEA06GA158Accident · 4 fatalFinal reportEurocopter AS-350-B3 · Yellow Pine, IDThe pilot's intentional low altitude flight and his failure to maintain an adequate altitude to clear the trees.NTSB SEA06CA160Accident · No injuriesData collectionFinal reportRobinson R-22B · Boise, IDThe instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.NTSB SEA06CA156Accident · No injuriesData collectionFinal reportCessna 180 · Elk City, IDThe pilot's failure to maintain directional control, which resulted in a ground loop during the landing roll.NTSB SEA06CA151Accident · No injuriesData collectionFinal reportCessna 180H · Hailey, IDThe pilot's failure to maintain directional control of the airplane during taxi, which resulted in a nose over. A factor was the wind gust condition.NTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.NTSB SEA06CA148Accident · No injuriesData collectionFinal reportCessna 172F · American Falls, IDThe pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.NTSB SEA06TA152Accident · No injuriesFinal reportCessna TU206G · Lowman, IDThe pilot's loss of aircraft control due to a downdraft on short final followed by an uncontrolled descent to a hard landing.NTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB SEA06CA128Accident · No injuriesData collectionFinal reportUnknown Challenger II · Emmett, IDThe pilot's failure to maintain aircraft control, which resulted in an off-airport landing. Contributing factors were the pilot's lack of familiarity with the airplane and the soft terrain.NTSB SEA06CA123Accident · No injuriesData collectionFinal reportSchweizer G-164B · Murtaugh, IDThe pilot's excessive brake application during the landing roll, which resulted in a nose over.NTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.NTSB SEA06CA111Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · American Falls, IDThe pilot's performance of low altitude flight and his failure to maintain clearance with a power line, which resulted in an in-flight collision with the power line.NTSB SEA06CA136Accident · No injuriesData collectionFinal reportCessna 206G · Stanley, IDThe pilot's failure to maintain directional control during an aborted takeoff. Factors include a tailwind gust, and a large rock near the side of the runway.NTSB SEA06CA117Accident · No injuriesData collectionFinal reportAyres S-2R · Grand View, IDThe pilot's inadvertent reduction of turbine engine power to the reverse position while landing on a desert road. A factor was the fence adjacent to the road.NTSB SEA06LA096Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Boise, IDThe reduction of the throttle to idle at a high density altitude during a practice autorotation, which resulted in the engine stoppage. Factors contributing to the accident included the instructor pilot's improper planning by not adhering to the flight…NTSB SEA06CA097Accident · No injuriesData collectionFinal reportRupp Rutan Defiant · Coeur d'Alene, IDThe pilot's failure to put the nose wheel landing gear down for landing.NTSB SEA06CA090Accident · No injuriesData collectionFinal reportCessna A188B · Minidoka, IDThe pilot's failure to abort the takeoff. A berm at the end of the runway was a factor.NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB SEA06CA081Accident · No injuriesData collectionFinal reportCessna 172 S · Malad City, IDThe private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.NTSB SEA06LA077Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Clark Fork, IDThe pilot's failure to maintain aircraft control during a go-around. A quartering tailwind was a factor.NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB SEA06CA066Accident · No injuriesData collectionFinal reportCessna 182D · Sandpoint, IDThe pilot's failure to maintain clearance from an object (snow blowing equipment) while taxiing. The snow blowing equipment, and the pilot's failure to adequately maneuver the aircraft around snow berms were factors.NTSB SEA06CA048Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, IDThe failure of the left main landing gear attaching bolt, which resulted in the left main gear collapsing during the landing roll.NTSB SEA06CA043Accident · No injuriesData collectionFinal reportAviat A1-A · Pine, IDThe pilot's failure to maintain clearance from terrain while maneuvering. Snow covered terrain and flat light conditions are contributing factors.NTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.