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 SEA91LA087Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Coeur D'Alene, IDThe pilot's misjudgement of his aircraft's climb capability when flying towards rising terrain. Factors include his lack of familiarity with the geographic area.NTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…NTSB SEA91FA071Accident · 1 fatalField investigationFinal reportCessna 337 · Boise, IDThe pilot's failure to remove the aircraft control locks prior to attempting flight. Factors include an inadequate preflight.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB SEA91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Kamiah, IDThe pilot's inadequate compensation for the wind conditions.NTSB SEA91FA021Accident · 3 fatalField investigationFinal reportBeech 95-55 · Hayden Lake, IDThe pilot's improper IFR procedure in failing to intercept the proper glideslope path.NTSB SEA91FA020Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Albion, IDThe pilot-in-command's failure to maintain control of the airplane in instrument meteorological conditions. Factors which contributed to the accident were the pilot's apprehension of flying in the forecasted weather, and the adverse weather conditions…NTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…NTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.NTSB SEA90LA196Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Twin Falls, IDThe pilot's inability to maintain directional control during a takeoff in strong crosswind conditions.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB SEA90LA156Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Coeur D'Alene, IDPassenger spilling a hot cup of coffee in her lap while the flight was in cruise flight.NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.NTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.NTSB DEN90FA149Accident · 2 fatalField investigationFinal reportTaylorcraft BC 12-D · Homedale, IDThe failure of the pilot to maintain adequate airspeed during maneuvers (buzzing) which resulted in an inadvertent stall of the aircraft. A factor was the intentional buzzing of family members.NTSB SEA90LA111Accident · Minor injuriesLimited investigationFinal reportCallair A-3 · Burley, IDAn encounter with meteorological conditions that exceeded the aircraft's ability to climb or maintain level flight. The high density altitude and lack of suitable terrain were factors related to the accident.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.NTSB SEA90FA100Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Pocatello, IDThe instructor pilots poor judgement in performing low altitude steep turn maneuvers resulting in an inadvertant stall at an altitude too low for recovery. Factors in the accident were the over gross weight and out-of-cg aircraft loading, and strong gusty…NTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.NTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.NTSB SEA90FA086Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Atlanta, IDPoor preflight planning premature lift-off on takeoff by the pilot in command.NTSB SEA90FA080Accident · 1 fatalField investigationFinal reportSwearingen SA226-T(B) · Coeur D'Alene, IDInadequate coordination between the pilot and the ground lineman. A factor related to the accident was: impairment of the ground lineman from consumption of alcohol.NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB SEA90LA068Accident · 1 fatalLimited investigationFinal reportTruckee Meadows Tierra II · Moscow, IDThe pilot did not maintain a proper airspeed during the climb to cruise.NTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB SEA90LA037Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Coeur D'Alene, IDThe loss of the flight crew's visual perception, due to an unforeseen whiteout condition. A related factor was the snowbank.NTSB SEA90LA035Accident · 1 fatalLimited investigationFinal reportStanger Aircommander 532 · Hansen, IDFailue of the pilot to maintain control of the gyrocopter after entering an abrupt pull-up from a low pass. Factors related to the accident were: failure of the pilot to follow procedures/directives, his lack of certification (qualification) for this flight,…NTSB SEA90LA008Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Salmon, IDFailure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.NTSB SEA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Homedale, IDInaccurate preflight planning and fuel consumption calculations by the pilot, and the pilot becoming lost or disoriented which resulted in fuel exhaustion.NTSB SEA89LA179Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Mackay, IDThe pilot failed to maintain an adequate airspeed for flight. High density altitude was a factor.NTSB SEA89LA162Accident · No injuriesLimited investigationFinal reportCessna TU206G · Moore, IDFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Contributing to the accident was a fence.NTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.NTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.NTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.NTSB SEA89FA139Accident · 2 fatalField investigationFinal reportStinson 108-2 · Athol, IDThe pilot failed to maintain airspeed and inadvertently stalled.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA89FA113Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Stanley, IDPilot continued VFR flight into IMC conditions in mountainous terrain. Factors were snow squalls and obscured mountainous terrain in the area.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB SEA89LA095Accident · No injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDA loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB SEA89LA087Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDThe pilot's improper use of the helicopter's flight controls. Contributing to the accident was the pilot's misjudgement of the external load characteristics.