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 SEA02LA122Accident · No injuriesLimited investigationFinal reportHead Balloons AX8-88 · Victor, IDThe pilot's failure to maintain altitude/clearance from the power lines during the landing resulting in the balloon's impacting the wires. Contributing factors were the power lines and strong winds existent at the time.NTSB SEA02LA121Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Shelley, IDA loss of engine power due to the manufacturer's improperly machined threads, which prevented the cylinder base/head halves from being properly assembled, leading to fatigue propagation and the ultimate separation of the cylinder. A contributing factor was…NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB SEA02LA114Accident · Minor injuriesLimited investigationFinal reportHunter Comp Air 6 · McCall, IDThe pilot's inadequate compensation for wind conditions. Contributing factors were a 30 degree crosswind and the pilot's lack of experience in the newly acquired make/model aircraft.NTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.NTSB SEA02LA105Accident · No injuriesLimited investigationFinal reportCessna 180K · Idaho Falls, IDThe pilot's inadequate compensation for wind conditions during the landing roll. A crosswind was a factor.NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.NTSB SEA02LA103Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Heyburn, IDA blocked fuel line due to a gasket that had disintegrated and blocked the fuel line.NTSB SEA02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Yellow Pine, IDCompensation for wind conditions inadequate during the approach for landing. A downdraft was a factor.NTSB SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.NTSB SEA02LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carey, IDThe pilot's failure to maintain clearance from trees during takeoff.NTSB SEA02LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Lewiston, IDThe pilot's failure to maintain directional control during the landing resulting in the aircraft departing the runway environment and the wing impacting the ground. Contributing factors were the dustdevil/whirlwind which the aircraft encountered and the ditch.NTSB SEA02IA096Incident · No injuriesIncident investigationFinal reportKaman K-600 (HH-43B) · Cocolalla, IDThe reverse installation of the RPM compensator assembly control box bolts resulting in the threaded end of the bolt impinging on a clevis and jamming the collective during climb. A contributing factor was the lack of adequate documentation provided by the…NTSB SEA02FA083Accident · Serious injuriesField investigationFinal reportGrumman G-44 · Boise, IDA blocked fuel line that resulted in fuel starvation to the engine and the pilot's failure to follow emergency procedures. A contamination of metal flakes on the fuel filter, and an inadequate annual inspection were factors.NTSB SEA02LA081Accident · Minor injuriesLimited investigationFinal reportCook Coot A · Harrison, IDThe pilot's failure to detect an unsafe boat wake during the landing process, and his inadvertent initiation of a porpoise after coming in contact with the boat wake just after touchdown on a body of water. Factors include a large wake wave/swell created by…NTSB SEA02LA077Accident · No injuriesLimited investigationFinal reportCessna 177B · New Plymouth, IDThe pilot's use of unsuitable terrain (landing surface) at his privately owned landing site. A contribtuing factor was the soft area which the aircraft's right main wheel encountered.NTSB SEA02LA071Accident · No injuriesLimited investigationFinal reportBrunger Osprey II · Orofino, IDThe aircraft's inadequate carburetor heat air box system, leading to an accumulation of ice in the carburetor throat during final approach to landing. Factors include carburetor icing conditions, the pilot's failure to correctly judge the height of the…NTSB SEA02LA068Accident · No injuriesLimited investigationFinal reportSteele Steen Skybolt · Coeur d' Alene, IDThe pilot's failure to maintain directional control during the landing rollout.NTSB SEA02LA062Accident · Minor injuriesLimited investigationFinal reportStadden Flybaby · Buhl, IDThe pilot's failure to return the carburetor heat to the OFF (cold) position prior to applying full power following a touch and go landing, which resulted in poor climb performance and the subsequent impact with a fence and collision with the ground. A…NTSB SEA02LA059Accident · No injuriesLimited investigationFinal reportPotts KitFox · Shoup, IDThe pilot’s failure to maintain a speed above stall speed, and the resulting inadvertent stall/mush. Factors include the pilot's failure to abort the takeoff when he realized the aircraft's performance was not as expected, his decision to attempt a takeoff…NTSB SEA02LA057Accident · No injuriesLimited investigationFinal reportCessna 340 · Idaho Falls, IDThe overload of the right main landing gear bellcrank, adjustable end fitting and clevis ears resulting in fractures and the subsequent gear collapse.NTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB SEA02LA046Accident · No injuriesLimited investigationFinal reportCessna 421C · Hailey, IDWater contamination within the aircraft's landing gear hydraulic line(s) which froze and blocked the line(s) preventing extension of the right main gear. A factor was the below freezing environmental conditions which the aircraft was operating in prior to and…NTSB SEA02IA044Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-401 · Boise, IDThe partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…NTSB SEA02FA023Accident · No injuriesField investigationFinal reportBeech 58P · Boise, IDImproper clearance between an alternator wire and a pneumatic line and fuel fumes. The alternator wire chafe and arcing were factors.NTSB SEA02LA014Accident · Serious injuriesLimited investigationFinal reportBölkow BO 105 LS · Mud Lake, IDPilot's failure to maintain adequate separation from terrain during the initial climb. Factors include spatial disorientation and a dark moonless night.NTSB SEA02FA011Accident · 1 fatalField investigationFinal reportCessna A185F · Lucile, IDThe pilot's failure to maintain adequate altitude above, and/or clearance with, mountainous terrain during night visual flight rules flight. Factors included mountainous terrain and dark night light conditions.NTSB SEA02FA007Accident · 2 fatalField investigationFinal reportCessna TR182 · Dixie, IDThe pilot's failure to refuel en route resulting in fuel exhaustion, and his inadvertent entry into a stall condition during the emergency descent. Contributing factors were dark night conditions and mountainous/hilly terrain.NTSB SEA02LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Sulfur Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include the pilot's excessive rotation attitude, and soft/wet terrain conditions.NTSB SEA01FA175Accident · 1 fatalField investigationFinal reportPiper PA-30 · McCall, IDThe pilot's failure to maintain adequate airspeed following a loss of power on the left engine, resulting in loss of aircraft control. Factors included a loss of power on the left engine for undetermined reasons, and the pilot's failure to properly configure…NTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.NTSB SEA01LA173Accident · 1 fatalLimited investigationFinal reportKaman HH-43 · Bonners Ferry, IDThe pilot's inadequate visual lookout which lead to his failure to maintain clearance from the nearby trees while in a high-hover. Factors include mountainous/hilly terrain, and tall trees in the area where the helicopter was hovering.NTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.NTSB SEA01LA151Accident · No injuriesLimited investigationFinal reportPitts Special SC-1 · Jerome, IDThe pilot's failure to maintain directional control during landing. Factors included: an incorrectly manufactured or adjusted rudder travel setting, resulting in restricted movement of the left brake; the mechanic's failure to adjust the rudder travel to the…NTSB SEA01LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Blackfoot, IDPilot's failure to maintain directional control of the airplane while landing.NTSB SEA01LA131Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Nez Perce, IDThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB SEA01FA127Accident · 1 fatalField investigationFinal reportRockwell S-2R-1200 · Cottonwood, IDFailure to maintain adequate clearance from terrain while dropping fire retardant. Factors include low visibility with smoke.NTSB SEA01LA126Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Big Creek, IDThe pilot's failure to adequately compensate for the wind conditions during the landing roll. High and gusting winds were factors.NTSB SEA01LA123Accident · Minor injuriesLimited investigationFinal reportBreiter Aerosport Quail · Idaho Falls, IDThe pilot's failure to maintain an airspeed above stall velocity (Vs) during his attempt to stretch a reduced power forced landing glide. Factors include fuel starvation, a partial loss of power due to fuel contamination, and the pilots inadequate preflight…NTSB SEA01LA121Accident · Minor injuriesLimited investigationFinal reportKaman HH-43B · Mullan, IDThe development of multiple fatigue cracks which ultimately resulted in the fracture of the 1st stage gas producer turbine rotor sealing disc. Factors contributing to the accident were mountainous/hilly and unsuitable terrain conditions.NTSB SEA01LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Boise, IDThe pilot's failure to adequately compensate for wind conditions. Wind gusts were a factor.NTSB SEA01LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Pingree, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB SEA01LA082Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Nampa, IDthe pilot's inadequate compensation for strong, gusty, shifting winds while hovering in ground effect. Factors include a sudden directional change and increase in velocity of the gusty wind conditions.NTSB SEA01TA083Accident · No injuriesFinal reportde Havilland DHC-6-300 · Star, IDFatigue failure of the nose wheel steering cable during the landing roll. Rough/uneven terrain was a factor.NTSB SEA01LA074Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hagerman, IDThe pilot's failure to maintain proper runway alignment during an attempted go-around, resulting in an inflight collision with a wind sock. Factors were a short runway/landing area condition, the pilot's excessive airspeed on final approach, and the wind sock.NTSB SEA01LA072Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Bonners Ferry, IDInadequate preflight inspection/preparation of the aircraft by the pilot and consequent foreign object fouling of the rudder control, rendering directional control impossible. A factor was the pilot's distraction/preoccupation with personal problems.NTSB SEA01LA069Accident · No injuriesLimited investigationFinal reportCessna 180H · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty crosswinds.