NTSB investigations, ID
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 SEA97FA070Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Boise, IDthe accumulation of airframe ice on the aircraft, and the pilot's delayed remedial action after intentionally flying into forecast adverse weather conditions. The adverse weather (icing) conditions were related factors.NTSB SEA97LA046Accident · Serious injuriesLimited investigationFinal reportCessna TU-206 · Cascade, IDThe pilot's failure to maintain adequate altitude/clearance from the terrain while reversing course in mountainous terrain. Factors include the mountainous terrain and tall trees in the area where he was maneuvering.NTSB SEA97FA041Accident · 5 fatalField investigationFinal reportCessna P210N · Cambridge, IDthe pilot's failure to maintain control of the aircraft. Flight into adverse weather and turbulence were factors.NTSB SEA97FA034Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Boise, IDA fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.NTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…NTSB SEA97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pocatello, IDinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Soft terrain at the emergency landing site was a related factor.NTSB SEA97LA009Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Caldwell, IDthe pilot's misjudgment of distance and altitude to the runway, while on final approach to land. The sunglare was a related factor.NTSB SEA96LA217Accident · No injuriesLimited investigationFinal reportCessna 182P · Driggs, IDthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty wind and soft terrain beside the runway.NTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.NTSB SEA96LA204Accident · No injuriesLimited investigationFinal reportPrice Acro Sport II · Coeur D'Alene, IDthe pilot's improper inflight planning/decision, and his failure to properly monitor (manage) the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing. Soft terrain in the forced landing area was a related factor.NTSB SEA96LA198Accident · Serious injuriesLimited investigationFinal reportBell 206B · Glenns Ferry, IDfuel contamination, due to improper servicing of the helicopter, which resulted in an intermittent loss of engine power. A factor relating to the accident was: the pilot's inadequate control of the helicopter, during autorotation with intermittent engine…NTSB SEA96LA195Accident · No injuriesLimited investigationFinal reportCessna 182E · Grangeville, IDfailure of the pilot to maintain proper runway alignment and clearance from a fence post during landing. Factors relating to the accident were: an animal (deer) on the approach end of the runway, an encounter with a downdraft, and a fence post near the edge…NTSB SEA96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDcorrosion in the left main landing gear cluster, which resulted in a failure of the left main landing gear. Inadequate inspection by undetermined maintenance personnel was a related factor.NTSB SEA96FA187Accident · Serious injuriesField investigationFinal reportGarlick UH-1H · Coeur D'Alene, IDFatigue fracture of the left forward vertical stabilizer spar, resulting in loss of the vertical stabilizer and tail rotor and subsequent loss of control. A factor was insufficient applicability (by make and model) of an existing FAA airworthiness directive…NTSB SEA96FA185Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Marsing, IDloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with terrain.NTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.NTSB SEA96FA182Accident · 1 fatalField investigationFinal reportCessna 182P · St. Anthony, IDThe pilot's failure to maintain directional control during a landing attempt. Factors included: probable dusk lighting conditions and no lights on the airstrip. Conributing to the pilot's injury severity was his failure to fasten his seat belt and shoulder…NTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…NTSB SEA96LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Nez Perce, IDthe pilot's improper in-flight decision to turn up a canyon, which the aircraft was unable to out-climb. Factors relating to the accident were: high ambient temperature, high density altitude, blind/box canyon, and trees in the area where the aircraft's climb…NTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…NTSB SEA96FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Yellow Pine, IDfailure of the pilot to maintain adequate airspeed, while maneuvering in mountainous terrain, which resulted in a stall/spin and collision with terrain.NTSB SEA96LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164A · New Plymouth, IDa cracked cylinder head, which resulted in partial loss of engine power during takeoff. Factors relating to the accident were: the pilot allowed the gross weight of the airplane to be exceeded, and tall wheat (crop) in the emergency landing area.NTSB SEA96LA151Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Stanley, IDthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The crosswind was a related factor.NTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.NTSB SEA96LA143Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sun Valley, IDthe pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.NTSB SEA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Paris, IDthe pilot forgot to extend the landing gear before landing. Factors relating to the accident were: an interuption of the pilot's habit pattern, when he circled to provide time for another airplane to takeoff as he entered the traffic pattern; and his failure…NTSB SEA96FA134Accident · 2 fatalField investigationFinal reportCessna 150B · Hailey, IDthe pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…NTSB SEA96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hazleton, IDpartial loss of engine power for undetermined reason(s). Factors relating to the accident were: high density altitude; the pilot's delay in dumping the entire chemical load, when he first perceived a power loss; and rough/uneven terrain in the emergency…NTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.NTSB SEA96LA113Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Aberdeen, IDpilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…NTSB SEA96LA103Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Moscow, IDinflight loss of an unsecured access plug from the engine crankcase, which resulted in a loss of engine oil and a forced landing. Factors relating to the accident were: hilly terrain, and foreign material (engine oil) on the windscreen which limited forward…NTSB SEA96LA099Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDthe pilot's failure to properly judge the distance and speed of the airplane during the final approach, his failure to obtain a proper touchdown point for landing, and his failure to perform a go-around, while there was sufficient runway remaining. A factor…NTSB SEA96LA089Accident · No injuriesLimited investigationFinal reportCessna A185E · Cascade, IDthe pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.NTSB SEA96LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Salmon, IDfailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. A factor relating to the accident was: the rock pile to the left of the runway.NTSB SEA96MA043Accident · 8 fatalMajor investigationFinal reportMitsubishi MU-2B-36 · Malad City, IDcontinued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…NTSB SEA96IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Boise, IDthe pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.NTSB SEA96FA021Accident · 3 fatalField investigationFinal reportCessna 210D · Yellow Pine, IDimproper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB SEA96LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Ola, IDThe pilot's inadequate preflight preparation by failing to determine that the takeoff area was clear of obstructions. The rock was a factor.NTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.NTSB SEA95LA225Accident · No injuriesLimited investigationFinal reportCessna TR182 · Richfield, IDThe instructor's failure to use carburetor heat during a simulated engine-out descent. Carburetor icing conditions was a factor.NTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…NTSB SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.NTSB SEA95FA212Accident · 2 fatalField investigationFinal reportAero Commander 560 · Ketchum, IDThe pilot-in-command's failure to maintain adequate airspeed during a turn resulting in a stall/spin. Factors contributing to the accident were the pilot-in-command's becoming geographically disoriented as well as his improper in-flight decision, and…NTSB SEA95LA192Accident · Serious injuriesLimited investigationFinal reportNorth American T-28A · Rexburg, IDfatigue failure of the main hydraulic line and a resulting hydraulic fluid fire. Lack of suitable terrain for the forced landing contributed to the accident.NTSB SEA95LA174Accident · No injuriesLimited investigationFinal reportCessna T210K · Bliss, IDThe pilot's failure to properly manage the fuel system to avoid running a tank dry at a low altitude. A factor was the lack of suitable terrain for a forced landing.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB SEA95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe left main landing gear tire burst during takeoff.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.