Final NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.\"completionStatus\" = 'Completed' 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."completionStatus" = 'Completed' 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 CEN21LA174Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Colby, KSThe pilot’s failure to remove the towbar from the nose landing gear before takeoff, which resulted in a sustained adverse yaw condition, and his failure to adequately monitor the fuel system while circling the airport, which resulted in fuel starvation and…NTSB ERA21LA151Accident · No injuriesClass 4 · LimitedFinal reportBeech Sierra · Augusta, METhe pilot’s improper landing flare, which resulted in a bounced landing, and a subsequent runway excursion. Also causal was the flight instructor’s delayed remedial action.NTSB CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21LA154Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Duson, LAThe uncertified pilot’s failure to maintain control of the helicopter when encountering a wind gust while hovering to land.NTSB WPR21LA125Accident · No injuriesClass 4 · LimitedFinal reportPhillip B Rolls Pitts 12-EH · Red Bluff, CAThe pilot's failure to maintain directional control during a landing, which resulted in a ground loop and subsequent nose over.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN21FA150Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1B · Berwyn, NEA loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.NTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.NTSB WPR21LA123Accident · Serious injuriesClass 3 · LimitedFinal reportAermacchi Impala MB-326M · Edwards, CAThe flight crew’s restricted rudder inputs while in an inverted spin that precluded spin recovery.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.NTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…NTSB WPR21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172G · Sisters, ORA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.NTSB ERA21FA148Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Purcellville, VAThe pilot's improper decision to depart from the short turf runway with a tailwind.NTSB ANC21LA023Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s selection of unsuitable terrain for taxi, which resulted in the airplane encountering a crevasse.NTSB WPR21LA121Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Lodi, CAA total loss of engine power during cruise flight due to a fatigue crack in the No. 3 cylinder connecting rod shaft resulting from either preignition or detonation, which resulted in a forced landing and impact with terrain.NTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB ANC21LA020Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R66 · Kodiak, AKAn impact with ocean waters for reasons that could not be determined based on the available information.NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB CEN21LA146Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Grand Haven, MIThe total loss of engine power for reasons that could not be determined.NTSB DCA21LA094AccidentClass 4 · LimitedFinal reportBell APT70 · Fort Benning, GAfailure of an electronic speed controller that resulted in a descent and impact with trees.NTSB ANC21LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · McGrath, AKThe pilot’s selection of an unsuitable landing surface.NTSB ERA21LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C · Panacea, FLThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack during short final approach, which resulted in an aerodynamic stall at low altitude.NTSB ERA21FA142Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8E · Jupiter, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane, resulting in an unsecured engine cowl that…NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.NTSB CEN21LA147Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Oshkosh, WIThe failure of the nose landing gear lower drag link for reasons that could not be determined based on available information, which resulted in the collapse of the nose landing gear.NTSB WPR21LA134Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Tucson, AZThe pilot’s distraction in the cockpit which interrupted his pre-landing checklist which resulted in his failure to configure the landing gear prior to touchdown.NTSB ERA21LA144Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Boynton Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA21FA140Accident · 3 fatalClass 3 · FieldFinal reportCessna R182 · Gainesville, GAThe pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.NTSB CEN21LA155Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Dunn, TXThe loss of rotor RPM for reasons that could not be determined based on available evidence.NTSB CEN21LA139Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Kaufman, TXThe pilot’s failure to maintain clearance from a power line during low-level maneuvering.NTSB ANC21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Lanai, HIA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB WPR21LA119Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Livermore, CAA total loss of engine power due to fuel starvation as a result of corrosion and rust in the fuel injection servo.NTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.NTSB ERA21LA141Accident · 1 fatalClass 3 · LimitedFinal reportSteinman Mark E Lancair 320 · Atlantic Ocean (Atlantic Ocean)The airplane’s impact with water for reasons that could not be determined.NTSB ERA21LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Winchester, VAThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB ERA21LA136Accident · Serious injuriesClass 4 · LimitedFinal reportTurcotte JR Robert L RV6 · North Hampton, NHThe pilot’s failure to maintain directional control during the landing in a crosswind condition, which resulted in a runway excursion.NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB ERA21LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot under instruction’s improper landing flare and attempted go-around which resulted in an aerodynamic stall, and subsequent loss of control. Contributing to the accident was the flight instructor’s delayed remedial action.