NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ATL04WA147Accident · 2 fatalForeign investigationPiper PA-28-161 · Liverpool, United KingdomNTSB NYC04CA155Accident · No injuriesData collectionFinal reportBellanca 7ECA · North Creek, NYThe pilot's failure to maintain directional control during the landing roll. A factor in this accident was the pilot's lack of experience in tail-wheeled airplanes.NTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB ATL04CA146Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Hillsboro, ALThe pilot's inadequate visual lookout and failure to maintain adequate obstacle clearance, which resulted in collision with transmission wires.NTSB NYC04RA153Accident · 7 fatalForeign investigationIsrael Aircraft Industries 1124 · Tocumen, PanamaNTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.NTSB IAD04LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chatsworth, NJA blocked internal oil passage, which resulted in inadequate lubrication of the blower impeller shaft, and the subsequent partial loss of engine power.NTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.NTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.NTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.NTSB LAX04LA254Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Scottsdale, AZInadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was caused by the improper installation and/or adjustment of the collective locking system, which…NTSB ATL04TA142Accident · No injuriesFinal reportBell UH-1H · Childs, FLThe vehicle driver's inadequate visual lookout and his failure to maintain clearance. A factor was the lack of company standards and operation procedures.NTSB ATL04LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston Salem, NCThe pilot's failure to maintain clearance from the fence post, while taxing which resulted in a collision.NTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.NTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.NTSB NYC04CA164Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe pilot's improper flare during touch down, which resulted in a hard landing.NTSB MIA04CA104Accident · Minor injuriesData collectionFinal reportWilliam K. Crawford Tango 2 · Williston, FLThe failure of the pilot to maintain directional control of the airplane during a high speed taxi test resulting in the airplane veering off the left side of the runway, becoming airborne, and nosing over.NTSB CHI04LA167Accident · No injuriesLimited investigationFinal reportBeech 200 · Green Bay, WIThe loss of engine power after takeoff for an undetermined reason.NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB ATL04IA132Incident · No injuriesIncident investigationFinal reportPilatus PC-12-45 · LaGrange, GAThe pilot's failure to maintain aircraft control during the landing flare.NTSB ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB SEA04WA131Accident · 2 fatalForeign investigationSocata TB-200 · Mianyang, ChinaNTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.NTSB SEA04LA119Accident · 2 fatalLimited investigationFinal reportApco Powered Parachute · Wolf Point, MTThe pilot's loss of control as a result of trying a low altitude quick turning maneuver. A factor was the pilot's lack of experience in the aircraft.NTSB LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.NTSB FTW04LA171Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Tulsa, OKThe loss of engine power for undetermined reasons.NTSB ANC04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Beluga, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with rocks during the landing roll, and the collapse of the left main landing gear.NTSB LAX04LA251Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Perris, CAA loss of engine power due to oil exhaustion as a result of the mechanic's use of an incorrect gasket during the installation of the vacuum pump.NTSB NYC04WA147Accident · 4 fatalForeign investigationCessna U206F · Honiton, United KingdomNTSB MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.NTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.NTSB FTW04FA167Accident · 2 fatalField investigationFinal reportBell 206B · Cushing, OKthe pilot's inadequate in-flight planning/decision and his failure to maintain obstacle clearance. Contributing factors were low altitude flight, sun glare, and the static wires.NTSB ATL04FA141Accident · 3 fatalField investigationFinal reportRobinson R44 · Barnesville, GAThe certified flight instructor's in-flight decision to continue VFR flight into IMC, which resulted in spatial disorientation, and the subsequent in a loss of control. A factor was fog.NTSB LAX04LA285Accident · No injuriesLimited investigationFinal reportEurocopter France AS350B3 · Cibecue, AZthe pilot's failure to maintain a proper decent rate during the landing approach and misjudged landing flare, which resulted in a hard landing. A factor in the accident was the brownout conditions created by the dust cloud that interfered with the pilot's…NTSB LAX04CA250Accident · No injuriesData collectionFinal reportCessna 172S · Glendale, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a veer off the runway and collision with terrain.NTSB CHI04CA166Accident · No injuriesData collectionFinal reportBeech 23 · Saginaw, MIThe pilot's inadequate compensation for wind conditions, and his inadequate recovery from the bounced landing. The wind gusts and the runway sign were factors.NTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.NTSB ANC04FA070Accident · 1 fatalField investigationFinal reportBeech 36 · Talkeetna, AKThe pilot's failure to maintain clearance from terrain during cruise flight, which resulted in an in-flight collision with terrain.NTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.NTSB LAX04LA266Accident · No injuriesLimited investigationFinal reportLancair LC-40-550FG · Show Low, AZthe pilot's failure to maintain directional control of the airplane during landing after encountering a dust devil.NTSB LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.NTSB FTW04LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Dalhart, TXloss of engine power due to a corroded magneto for undetermined reasons.NTSB ATL04LA140Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Asheville, NCThe CFII's inadequate visual lookout and failure to maintain clear of objects during flight. Factors were clouds and dark night.NTSB ANC04LA071Accident · No injuriesLimited investigationFinal reportChristen Industries Husky A-1 · Bethel, AKThe pilot's failure to attain the proper touchdown point, which resulted in an in-flight collision with terrain during the ensuing aborted landing. A factor associated with the accident is the pilot's misjudgment of the airplane's speed and distance.NTSB SEA04LA117Accident · No injuriesLimited investigationFinal reportCessna 185F · Bozeman, MTThe failure of the right main gear brake disk attach flange during the landing roll, due to fatigue cracks emanating from numerous corrosion pits present on the surface of the disk, leading to the right brake becoming totally inoperative, and resulting in a…NTSB NYC04WA172Accident · 1 fatalForeign investigationBell 205A1 · Tschagguns, AustriaNTSB FTW04LA178Accident · No injuriesLimited investigationFinal reportCessna 172S · San Antonio, TXThe student pilot's failure to maintain control of the airplane during landing.