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 FTW04CA185Accident · Serious injuriesData collectionFinal reportGrumman G-164 · Havana, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight.NTSB FTW04CA184Accident · No injuriesData collectionFinal reportGrumman G-164C · Tiller, ARThe pilot's inability to maintain control of the airplane while landing due to a brake system failure.NTSB CHI04LA295Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A-9B · Norton, KSThe fire in the area of the fuel line and the unsuitable terrain encountered during an emergency landing by the pilot. Contributing factors were the pole.NTSB CHI04LA196Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Sheridan, ILThe convection induced turbulence and the flight attendant not being restrained.NTSB CHI04LA184Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · York, NEA loss of engine power for undetermined reasons. Contributing to the accident were the low altitude at the time of power loss and the unsuitable landing area encountered during the forced landing.NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…NTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.NTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.NTSB NYC04LA167Accident · No injuriesLimited investigationFinal reportCessna 210M · Quarryville, PAImproper maintenance performed on the airplane, which resulted in a total electrical failure during cruise flight in IMC, and a subsequent precautionary landing. A factor in the accident was the low ceiling.NTSB FTW04LA183Accident · 1 fatalLimited investigationFinal reportBeech C23 · Morrilton, ARThe pilot's inadequate preflight planning/preparation to assure adequate takeoff performance to clear obstacles.NTSB ANC04LA079Accident · No injuriesLimited investigationFinal reportHughes 500D · Iliamna, AKThe ground crew's failure to use proper procedures while securing a sling load to the helicopter, which resulted in foreign object damage to the helicopter's main rotor system while idling.NTSB ANC04IA078Incident · No injuriesIncident investigationFinal reportCessna 172M · Aniak, AKThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA04LA103Accident · No injuriesLimited investigationFinal reportLearjet 35A · Newcastle, St. Kitts & NevisThe pilot's encounter with a downdraft.NTSB LAX04LA265Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Santa Clarita, CAthe pilot's inadequate planning/decision by his inadequate evaluation of the weather resulting in an attempt to conduct flight beyond the aircraft's climb performance capability.NTSB LAX04CA262Accident · No injuriesData collectionFinal reportManoucher Lancair 360 Mkii · Pacoima, CAthe pilot misjudged the airplane's distance/speed which resulted in an overrun. A contributing factor was the tailwind.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB CHI04MA182Accident · 4 fatalMajor investigationFinal reportBell 407 · Newberry, SCThe pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.NTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.NTSB SEA04CA132Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Waitsburg, WAThe pilot's failure to maintain aircraft control and his inadequate compensation for the wind conditions during the landing. Gusts and high vegetation were factors.NTSB LAX04LA261Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Peach Springs, AZThe pilot's selection of downwind takeoff direction and improper use of the collective control prior to reaching translational lift, which resulted in a settling with power condition and a collision with the ground. Also causal was the pilot's failure to…NTSB FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ENG04IA021Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Sarasota, FLHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the high pressure compressor when the pilots retarded the power levers causing compressor surges and flameouts of both engines. Contributing factors were the lack of…NTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.NTSB ATL04LA153Accident · 1 fatalLimited investigationFinal reportConvair Div. of Gen. Dynamics 440 · Beef IslandThe in-flight fire on the number two engine, for undetermined reasons.NTSB SEA04LA129Accident · No injuriesLimited investigationFinal reportLogston Starduster SA100DL · Arlington, WAThe pilot's failure to maintain clearance during taxi from another aircraft standing on the runway resulting in a collision. The aircraft standing on the runway was a factor.NTSB NYC04LA163Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's inadequate preflight inspection, which resulted in the total loss of engine power due to fuel contamination, during the initial climb after takeoff.NTSB NYC04FA161Accident · 2 fatalField investigationFinal reportBeech E95 · Atlantic City, NJThe pilot's failure to maintain airplane control while performing a go-around after experiencing a loss of power to the left engine for undetermined reason(s). A factor related to the accident was the loss of power to the left engine.NTSB NYC04CA166Accident · No injuriesData collectionFinal reportRobinson R-44 II · Beverly, MAThe pilot's inadequate visual lookout, which resulted in a collision with transmission wires.NTSB LAX04LA283Accident · No injuriesLimited investigationFinal reportCessna 182A · Petaluma, CAthe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a collapse of the nose landing gear.NTSB LAX04LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CAthe pilot's failure to attain an adequate altitude to clear mountainous terrain during a high density altitude condition.NTSB LAX04LA259Accident · No injuriesLimited investigationFinal reportNorth American T28B · Apple Valley, CAThe pilot's failure to maintain an adequate airspeed during the conclusion of a low pass, which led to a stall/mush.NTSB LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB LAX04CA258Accident · No injuriesData collectionFinal reportBoeing A 75N1 · Auburn, CAthe pilot undergoing instruction's overcontrol of the aircraft by his excessive use of the rudder control and failure to maintain directional control of the airplane during landing, which resulted in a ground loop. Contributing factors to the accident were…NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB DEN04FA104Accident · 2 fatalField investigationFinal reportCessna 172I · Paris, ARthe pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…NTSB DEN04CA103Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 120A · Albuquerque, NMthe pilot's failure to maintain/obtain the proper descent rate.NTSB ATL04LA198Accident · Serious injuriesLimited investigationFinal reportThunder & Colt 210A · Huntersville, NCGusty weather conditions which resulted in an in-flight collision with terrain during touchdown.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB ANC04LA077Accident · No injuriesLimited investigationFinal reportHughes 369D · Nome, AKThe pilot's inadequate compensation for wind conditions while the helicopter was standing, which resulted in the coasting main rotor blade contacting the tail boom. A factor associated with the accident was the gusty wind condition.NTSB ANC04LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.NTSB ANC04CA076Accident · No injuriesData collectionFinal reportCessna 180J · Bettles, AKThe pilot's inadequate compensation for the wind conditions during takeoff/initial climb, which resulted in a loss of control and in-flight collision with terrain. Factors contributing to the accident were the pilot's inadequate weather evaluation, and a…NTSB SEA04LA128Accident · No injuriesLimited investigationFinal reportHughes 269C · Arlington, WAA significant power loss for undetermined reasons while in cruise flight, leading to a full autorotational landing. Factors include no suitable terrain in the area, and soft swampy terrain at the point where the pilot found it necessary to perform the forced…NTSB LAX04LA257Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Castaic, CAa catastrophic engine failure due to oil exhaustion, which was caused by the failure of maintenance personnel to completely tighten the oil screen.NTSB IAD04FA030Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ticonderoga, NYReason for occurrence undetermined.NTSB FTW04LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Winnsboro, LAThe pilot's mismanagement of fuel resulting in fuel starvation. A contributing factor was the ditch.NTSB DEN04CA102Accident · Minor injuriesData collectionFinal reportMooney M20S · Farmington, NMthe pilot's failure to maintain airspeed resulting in a stall. A contributing factor was the pilot's diverted attention.NTSB DEN04CA101Accident · No injuriesData collectionFinal reportWhitlock Rotorway Exec 162F · Meeker, COaircraft control not maintained by the pilot. A contributing factor was the failure of the supercharger.NTSB ATL04LA199Accident · Minor injuriesLimited investigationFinal reportAdventura II · Naples, FLLoss of engine power for undetermined reasons and the pilot's improper landing flare which resulted in a hard landing and collapse of the main landing gear.NTSB ATL04LA152Accident · Serious injuriesLimited investigationFinal reportStein Skybolt Skybolt · Jasper, GAThe pilot's attempt to operate the airplane with known deficiencies in the equipment, and the fuel system contamination that resulted in fuel starvation to the engine. A factor was rough and uneven terrain.