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 SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.NTSB SEA98LA115Accident · No injuriesLimited investigationFinal reportTracy Avid Mark IV · Coeur D'Alene, IDThe pilot's failure to maintain adequate airspeed.NTSB SEA98LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Creek, IDThe pilot's failure to maintain airspeed while maneuvering to an emergency landing, resulting in an inadvertent stall/mush into the terrain. A contributing factor was the high density altitude.NTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.NTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.NTSB SEA98LA102Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cascade, IDThe flight instructor's inadequate remedial action after his dual student attempted a soft field takeoff with inadequate airspeed and premature lift off.NTSB SEA98LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Blackfoot, IDA loss of power for undetermined reasons.NTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.NTSB SEA98FA084Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Shoshone, IDFailure to maintain clearance from wires. A transmission wire was a factor.NTSB SEA98FA083Accident · 2 fatalField investigationFinal reportPapa 51 Thunder Mustang · Marsing, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB SEA98LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sandpoint, IDLoss of consciousness by the pilot-in-command/flight instructor, resulting in loss of aircraft control and subsequent collision with terrain.NTSB SEA98FA081Accident · 3 fatalField investigationFinal reportCessna P206C · Dubois, IDAttempted VFR flight into IMC and a loss of aircraft control. An inadequate weather evaluation and drug impairment were factors.NTSB SEA98LA080Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Idaho Falls, IDThe pilot's failure to maintain clearance from a power transmission line during an aerial application flight. Factors include a power line located just beyond the boundary of the field being sprayed, and the pilot's incorrect judgement of the distance between…NTSB SEA98LA079Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Idaho Falls, IDThe pilot's inadequate inflight decision to land with a tailwind and his failure to maintain aircraft control. Also contributing was the pilot's improper setting of the fuel mixture which resulted in a partial loss of engine power.NTSB SEA98FA077Accident · No injuriesField investigationFinal reportGarlick UH-1H · Hope, IDFailure of a misaligned main bearing in the engine. Factors include returning a previously unairworthy-tagged engine to service by the operator's maintenance personnel without sufficient information to identify and correct an unknown engine deficiency.NTSB SEA98LA063Accident · 1 fatalLimited investigationFinal reportHughes 269A · Emmett, IDThe instructor pilot's failure to maintain the proper rate of descent on landing. Factors were a sudden wind shift, the instructor pilot's lack of recent experience, and terrain drop-off.NTSB SEA98LA053Accident · No injuriesLimited investigationFinal reportCessna 150G · Hailey, IDA fractured nosewheel steering linkage bolt, which permitted the nosewheel steering linkage to become disconnected, and the student pilot's subsequent failure to restore directional control by use of differential wheel braking.NTSB SEA98LA045Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Moreland, IDThe pilot's failure to maintain aircraft control resulting in an inadvertent stall/spin. A factor was his lack of familiarity in the make/model.NTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.NTSB SEA98FA042Accident · 6 fatalField investigationFinal reportCessna T303 · Midvale, IDThe pilot's failure to maintain aircraft control.NTSB SEA98FA040Accident · 2 fatalField investigationFinal reportFreije Lancair IV · Garwood, IDThe pilot's failure to maintain aircraft control after entering known adverse weather. Related factors were, the pilot's failure to follow the published IFR departure procedures, low ceilings and snow, and the pilot's lack of recent instrument experience.NTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.NTSB SEA98LA024Accident · No injuriesLimited investigationFinal reportBell 206L · Idaho Falls, IDloss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.NTSB SEA98LA019Accident · Serious injuriesLimited investigationFinal reportBlue Denney Kitfox Model 3 · Caldwell, IDThe pilot's failure to maintain adequate airspeed.NTSB SEA98LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Boise, IDThe student pilot's failure to maintain directional control due to excessive taxispeed. Pressure perceived by the student pilot to expedite clearing the runway after landing in order to facilitate an aircraft departure was a contributing factor.NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB SEA98LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDThe pilot's failure to maintain directional control during landing. Factors were inattention and fatigue.NTSB SEA98FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Leadore, IDthe pilot's inadvertent entry into instrument meteorological conditions, and his failure to maintain clearance from wooded terrain in the area where he was maneuvering. Factors relating to the accident include: darkness, low ceiling, and high/mountainous…NTSB SEA97LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Dixie, IDShifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.NTSB SEA97IA217Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Soda Springs, IDThe pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…NTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.NTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.NTSB SEA97LA205Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate planning/decision for taking off in the meteorological conditions present at the time. Factors include a high density altitude, gusty winds, downdrafts, and soft terrain in the area of the forced landing.NTSB SEA97LA200Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk City, IDA horse and children wandered onto the airstrip.NTSB SEA97LA195Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Elk City, IDOil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.NTSB SEA97LA183Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, IDThe pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.NTSB SEA97LA177Accident · 2 fatalLimited investigationFinal reportCessna 182G · Big Creek, IDThe flightcrew's failure to maintain clearance from trees. A factor was trees north of the departure end of the airstrip.NTSB SEA97LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Idaho Falls, IDThe pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.NTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.NTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…NTSB SEA97LA169Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Newdale, IDThe pilot's inadequate preflight/planning preparation which resulted in the aircraft exceeding the maximum gross weight, and inability to climb. A factor was high density altitude.NTSB SEA97LA168Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Idaho Falls, IDThe pilot mismanaged his fuel supply which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the lack of adequate altitude and airspeed to successfully execute an autorotation.NTSB SEA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…NTSB SEA97LA137Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Saint Anthony, IDthe pilot's improper planning/decision and failure to dump the load of chemicals. Related factors were: the high density altitude, and a dirt embankment that was encountered during the landing roll.NTSB SEA97LA136Accident · Serious injuriesLimited investigationFinal reportStaudacher S-260-2 · Wallace, IDthe pilot's improper planning/decision, which resulted in his failure to maintain adequate altitude/distance from wooded terrain during a low-altitude course reversal. Related factors include mountainous/hilly terrain, blind canyon, low ceiling, and trees in…NTSB SEA97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Big Creek, IDthe pilot's improper positioning of the fuel selector to the 'OFF' position, which resulted in fuel starvation and loss of engine power during takeoff. Factors relating to the accident were: down-sloping terrain (airstrip) and trees that were encountered…NTSB CHI97FA149Accident · No injuriesField investigationFinal reportBell 206L3 · Boise, IDthe improper torque meter installation by maintenance personnel, attempting flight with known discrepancies by the pilot-in-command and the check airman, and an improper autorotation by the pilot-in-command with improper oversight of the autorotation maneuver…NTSB SEA97LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pocatello, IDinadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.NTSB SEA97LA115Accident · No injuriesLimited investigationFinal reportRobinson R22B · Boise, IDimproper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.NTSB SEA97LA081Accident · No injuriesLimited investigationFinal reportNorth American NA-265-40 · Hailey, IDan electrical short in the electrical system, which resulted in a malfunction of the nosewheel steering system and loss of directional control.