NTSB investigations, ID
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.NTSB SEA92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Blackfoot, IDThe pilot's failure to use proper airspeed for takeoff, resulting in loss of control during initial climb. Factors relating to the accident were the high da weather conditions, power line obstructions and a highway with a dirt bank at the end of the runway.NTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.NTSB SEA92T#A04Accident · No injuriesClass 3Final reportBell 205A-1 · Arco, IDNTSB SEA92LA162Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Headquarters, IDFuel exhaustion and the pilot in command's delay in refueling.NTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.NTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.NTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.NTSB SEA92FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Pierce, IDInflight loss of control when aircraft control was not maintained. Factors to the accident were: flight into known adverse weather and thunderstorm activity.NTSB SEA92LA145Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Driggs, IDThe pilot in command's failure to insure adequate clearance. Factors contributing to the accident were: weather condition (downdraft) and object (transmission wires).NTSB SEA92LA142Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Paul, IDLoss of engine power for undetermined reasons and aircraft control not possible by the pilot in command. A factor contributing to the accident was: rough/uneven terrain.NTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.NTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.NTSB SEA92LA119Accident · No injuriesLimited investigationFinal reportMooney M20K · Stanley, IDThe failure of the pilot to maintain runway alignment and his loss of directional control during takeoff ground roll, resulting in a swerve off the 150 ft wide runway and impact with a fence. Factors relating to the accident were the lack of runway lights,…NTSB SEA92FA109Accident · 1 fatalField investigationFinal reportCessna 172L · Colburn, IDThe pilot became lost/disoriented, failed to maintain airspeed when he attempted to reverse course in a box canyon, and the aircraft stalled. Factors relating to the accident were the narrow box canyon, the high density altitude, and the lack of mountain…NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.NTSB SEA92LA093Accident · No injuriesLimited investigationFinal reportAviat A-1 · Arco, IDThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.NTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.NTSB SEA92LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Nordman, IDThe pilot selected unsuitable terrain. Factors contributing to the accident were: the snow covered runway, and the pilot in command's inadequate preflight planning.NTSB SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.NTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.NTSB SEA92FA001Accident · 1 fatalField investigationFinal reportNorth American Navion · Ola, IDAn incapacitating heart attack while in flight.NTSB SEA91LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lewiston, IDThe pilot's failure to maintain directional control.NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.NTSB SEA91LA242Accident · Serious injuriesLimited investigationFinal reportAeronca 7DC · Yellow Pine, IDImproper inflight planning/decision by the pilot, which resulted in inadvertent flight into a box canyon and subsequent collision with trees, when there was insufficient space to reverse course and the aircraft would not outclimb rising terrain. The terrain…NTSB SEA91LA238Accident · No injuriesLimited investigationFinal reportChampion 7EC · Coeur D'Alene, IDA blocked fuel system vent, and an inadequate aircraft preflight by the pilot. Rough terrain in the emergency landing area was a related factor.NTSB SEA91LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dixie, IDThe pilot's failure to maintain adequate clearance with tree(s) during the initial climb. Factors contributing to the accident were the high density altitude and downdraft conditions.NTSB SEA91LA213Accident · No injuriesLimited investigationFinal reportCessna 177 · Nampa, IDThe pilot's delay in initiating a go-around (aborted landing) and his improper raising of the flaps. Factors related to the accident were: the high density altitude, tailwind, and the pilot's selection of the wrong runway.NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.NTSB SEA91LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Genesee, IDThe pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.NTSB SEA91LA191Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hamer, IDThe pilot's failure to maintain runway aligment. Factors include high vegetation, and an inadverent ground loop/swerve.NTSB SEA91FA186Accident · 5 fatalField investigationFinal reportCessna 206 · Salmon, IDImproper inflight planning and decisions and failure to maintain airspeed.NTSB SEA91FA183Accident · 4 fatalField investigationFinal reportCessna 177RG · Salmon, IDImproper inflight planning and decision by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous/hilly terrain.NTSB SEA91LA189Accident · No injuriesLimited investigationFinal reportBeech V35A · Weiser, IDThe pilot did not refuel the airplane resulting in fuel exhaustion.NTSB SEA91LA176Accident · No injuriesLimited investigationFinal reportMooney M-20K · Mccall, IDAn on ground collision with an animal during the landing roll. A factor to the accident was: a dark night condition.NTSB SEA91FA175Accident · 1 fatalField investigationFinal reportCessna TU206G · Mccall, IDProcedures/directives were not followed. Factors to the accident were: improper fuel boost pump selector position, leaded spark plugs and sunglare.NTSB SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.NTSB SEA91FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Driggs, IDThe pilot's poor inflight decision and his improper compensation for wind. Factors were rising, mountainous terrain; high, gusty winds; and a high density altitude.NTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.NTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB SEA91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180G · Challis, IDThat the pilot encountered unsuitable terrain during a forced landing after a power loss due to a fractured cylinder boss and a bent engine pushrod.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.NTSB SEA91LA105Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Lapwai, IDThe pilot's misjudgment of an aerial application swath run. Factors include a downdraft condition and soft terrain.NTSB SEA91LA088Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Clark Fork, IDThe pilot-in-command's failure to maintain proper altitude in cruise light resulting in an in flight collision with a wire and subsequent forced landing in a river.