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 ANC06CA051Accident · Minor injuriesData collectionFinal reportLanford Antares MA-33 · Trapper Creek, AKThe non-certificated pilot's failure to maintain altitude/clearance during final approach for landing, which resulted in the airplane striking a tree, and an in-flight collision with terrain. A factor associated with the accident was the tree.NTSB MIA06LA105Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Marathon, FLThe pilot's failure to extend the landing gear prior to landing, which resulted in the propellers striking the runway, an aborted landing, and an in-flight collision with terrain.NTSB LAX06LA166Accident · No injuriesLimited investigationFinal reportMcKenzie Lancair IV-P Turbine · San Diego, CAThe collapse of the left main gear for undetermined reasons. A factor was the pilot's inadequate remedial action in response to the left main gear not locked warning light by not attempting to manually extend the gear to ensure it was fully down and locked.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB DEN06CA074Accident · No injuriesData collectionFinal reportCessna 182Q · Fort Bridger, WYthe pilot's failure to maintain aircraft control during the landing flare and touchdown. Contributing to the accident was the high, gusty crosswinds.NTSB NYC06CA111Accident · Serious injuriesData collectionFinal reportQuicksilver GT-400 · West Middlesex, PAThe pilot's failure to maintain adequate clearance from trees during the initial climb.NTSB LAX06LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Show Low, AZthe collapse of the air intake duct resulted in a loss of engine power. A factor was the uneven terrain in the landing area.NTSB LAX06CA165Accident · Minor injuriesData collectionFinal reportCessna 150M · Green Valley, AZthe failure of the certified flight instructor to retract the flaps to the proper go-around setting and to attain/maintain an adequate airspeed, which led to a stall/mush.NTSB DEN06CA073Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cody, WYthe pilot's failure to maintain clearance with a parked vehicle during the approach to land on a dirt road. Contributing factors were the pilot's improper decision to land near an unsuitable landing area, and the parked vehicle.NTSB CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB CHI06CA126Accident · No injuriesData collectionFinal reportHelmetag Glassair III · Aurora, ILThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the airport sign impacted during the runway excursion.NTSB ANC06CA050Accident · No injuriesData collectionFinal reportCessna 170B · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor associated with the accident was the snow on the runway.NTSB NYC06CA110Accident · Serious injuriesData collectionFinal reportHelo Werks HX-1 Wasp · Hampton Roads, VAThe inadvertent activation of the helicopter manufacturer's improperly located, unguarded fuel shutoff switch.NTSB NYC06CA109Accident · Serious injuriesData collectionFinal reportCessna 152 · Shamokin, PAThe pilot's failure to recover from a bounced landing, and her improper use of flaps during an aborted landing, which resulted in an in-flight collision with trees.NTSB DFW06CA119Accident · No injuriesData collectionFinal reportCessna 150G · Coleman, TXThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB ATL06CA075Accident · No injuriesData collectionFinal reportCessna C172S · Muscle Shoals, ALThe student pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB SEA06CA097Accident · No injuriesData collectionFinal reportRupp Rutan Defiant · Coeur d'Alene, IDThe pilot's failure to put the nose wheel landing gear down for landing.NTSB SEA06CA092Accident · No injuriesData collectionFinal reportCessna 182F · Canby, ORThe pilot's misjudgment of altitude resulting in an undershoot. A factor was the berm.NTSB NYC06CA108Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Chester, CTThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor in the accident was the pilot's inadequate preflight planning.NTSB LAX06CA162Accident · No injuriesData collectionFinal reportBeech BE23 · Kingman, AZthe student pilot's failure to attain/maintain a proper glide path, which resulted in an encounter with wake turbulence and subsequent hard landing.NTSB DFW06LA118Accident · Minor injuriesLimited investigationFinal reportEurocopter EC120B · Intracoastal, LAThe pilot's loss of control for undetermined reasons.NTSB DCA08WA014Accident · Minor injuriesForeign investigationBoeing B737-200 · Jakarta, IndonesiaNTSB CHI06CA125Accident · No injuriesData collectionFinal reportBangham Barracuda · Monett, MORupture of the hydraulic hose and deformation of the hydraulic cylinder piston rods for undetermined reasons, which resulted in a failure of the landing gear extension system. Contributing factors were the pilot's premature shutdown of the engine on short…NTSB SEA06CA091Accident · No injuriesData collectionFinal reportMurphy Renegade · Port Angeles, WAThe loss of engine power while in cruise flight for undetermined reasons. Trees were a factor.NTSB NYC06LA106Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Kings Park, NYLoss of engine power due to the failure of the number 3 connecting rod bearing. A contributing factor was the lack of suitable terrain for the emrgency landing.NTSB MIA06LA104Accident · Minor injuriesLimited investigationFinal reportChristopher Norris Glasair III · Daytona Beach, FLThe failure of the pilot to maintain airspeed while turning towards the runway after experiencing a partial loss of engine power, resulting in an uncontrolled descent, and in-flight collision with the runway. A factor in the accident was the failure of…NTSB LAX06LA161Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Fallbrook, CAFailure of the engine to transmission drive shaft forward coupling due to overheating from lack of lubrication. The cause of the lack of lubrication was a result of improper maintenance. A factor was the trees.NTSB LAX06CA163Accident · No injuriesData collectionFinal reportIndus T211 · Death Valley, CAthe pilot's failure to maintain an adequate airspeed during final approach, which resulted in an inadvertent stall/mush and collision with terrain.NTSB DCA06RA040Incident · No injuriesForeign investigationBoeing B727-200 · Banglore, IndiaNTSB CHI06IA127Incident · Minor injuriesIncident investigationFinal reportCorporate Jets BAE125-800A · Lincoln, NEThe pilot-in-command's failure to maintain control during the initial roll at onset of the stall due to his improper remedial action related to the stall recovery. A contributing factor was initiation of an intentional stall with residual wing ice…NTSB SEA06CA090Accident · No injuriesData collectionFinal reportCessna A188B · Minidoka, IDThe pilot's failure to abort the takeoff. A berm at the end of the runway was a factor.NTSB LAX06LA158Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26D · Aguila, AZThe pilot's failure to maintain control of the glider during takeoff-initial climb, which resulted in a broken tow rope, a spiral, and an in-flight collision with terrain. A factor associated with the accident is the pilot's failure to correct the spiral.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB ENG07WA003Accident · 113 fatalForeign investigationAirbus A320 · Sochi, RussiaNTSB DEN06WA072Accident · 2 fatalForeign investigationBeech C 24R · Albshausen, GermanyNTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.NTSB DCA06WA037Incident · No injuriesForeign investigationBoeing B737-800 · Skelleftea, SwedenNTSB CHI06LA124Accident · No injuriesLimited investigationFinal reportHughes 269B · Sullivan, OHFatigue failure of the fuselage-to-tail boom cluster fitting, and the secondary failure of the tail rotor drive shaft. An additional cause was the incomplete compliance with an applicable Airworthiness Directive. A factor was the ditch.NTSB ATL06CA073Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Rocky Point, NCThe pilot's inadequate visual lookout during a precautionary landing which resulted in an in-flight collision with a transmission wire.NTSB NYC06CA107Accident · No injuriesData collectionFinal reportCessna 172D · Lumberton, NJThe student pilot's failure to maintain aircraft control while landing, which resulted in an runway overrun and subsequent impact with terrain.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA06WA036Incident · No injuriesForeign investigationAirbus A-300-B4 · Toronto, CanadaNTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB LAX06LA155Accident · Serious injuriesLimited investigationFinal reportPartenavia P68 · Kaunakakai, HIthe pilot's failure to attain a proper climb rate and to maintain adequate clearance from the terrain during the initial climb in dark night conditions, which resulted in an in-flight collision with terrain.NTSB LAX06LA154Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2D24 · Las Vegas, NVThe failure of ground service personnel to properly set the parking brake on the lead baggage cart.NTSB LAX06FA156Accident · 2 fatalField investigationFinal reportRobinson R44 Raven II · Desert Center, CAa loss of control and the divergence of the main rotor blade system from its normal rotational path for undetermined reasons.NTSB LAX06CA157Accident · No injuriesData collectionFinal reportCessna 172S · Big Bear, CAthe pilot's failure to maintain wing clearance from a pole during taxi.NTSB DFW06WA114Accident · No injuriesForeign investigationPiper PA-28-181 · Amman, JordanNTSB DFW06LA121Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-802A · Jasper, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable landing for the pilot to execute the forced landing.