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 CEN21FA252Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 NG · Darlington, INA loss of control while practicing an aerodynamic stall, which resulted in a spin and impact with terrain.NTSB ANC21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Chandalar Lake, AKThe pilot’s over application of the brakes, which resulted in a nose over.NTSB WPR21LA282Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J230-SP · Oceano, CAThe pilot’s failure to maintain directional control after landing fast and hard which damaged the right main landing gear wheel pant which lodged under the wheel.NTSB ERA21LA251Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Monticello, NYThe pilot’s inadequate preflight inspection which resulted in a failure of the right main landing gear tire on landing rollout, a subsequent loss of directional control, and landing gear collapse.NTSB ERA21LA244Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Sanford, METhe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB ERA21LA243Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J250-SP · Marietta, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Warwick, NYThe pilot’s failure to attain a proper touchdown point, which resulted in the airplane contacting the ground short of the runway.NTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.NTSB CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.NTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.NTSB CEN21LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 560XL · Aspen, COThe malfunction of the landing gear handle for reasons that could not be determined, which caused the right main landing gear to collapse during the landing roll.NTSB CEN21LA254Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Drew, MSA loss of control during takeoff for reasons that could not be determined.NTSB CEN21LA250Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · West Portsmouth, OHThe pilot’s improper use of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Justin, TXThe loss of engine power for undetermined reasons based upon the available information.NTSB CEN21LA256Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · San Angelo, TXInadequate maintenance of the left main landing gear strut, which resulted in a landing gear collapse.NTSB CEN21LA253Accident · No injuriesClass 4 · LimitedFinal reportSchweizer TH55A/269A · Monroe, LAThe pilot’s failure to maintain yaw control during landing which resulted in a loss of tail rotor effectiveness.NTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB WPR21LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Washington, CAA total loss of engine power during an enroute climb due to a stuck exhaust valve and multiple failed piston compression rings.NTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.NTSB ERA21FA237Accident · 1 fatalClass 3 · FieldFinal reportBeech A23 · Pinnacle, NCThe flight instructor’s mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Carlsbad, CAThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.NTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.NTSB WPR21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R182 · Minden, NVThe pilot receiving instruction’s failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.NTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.NTSB WPR21LA220Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24 · Paris, IDA total loss of engine power for reasons that could not be determined.NTSB WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.NTSB WPR21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Fields, ORThe pilot’s failure to maintain directional control during landingNTSB WPR21LA212Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Stanley, IDThe pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.NTSB WPR21FA211Accident · 2 fatalClass 3 · FieldFinal reportTextron 172S · Eden, UTThe flight instructor’s improper aeronautical decision-making, which led to an encounter with a downdraft at a low altitude in mountainous terrain and resulted in the instructor’s loss of airplane control and an impact with terrain.NTSB ERA21LA236Accident · Minor injuriesClass 4 · LimitedFinal reportMaxson Phil Zodiac CH601XL · Winder, GAPilot’s inadequate supervision of the pilot rated passenger’s actions, which led to a high descent rate and collision with obstacles.NTSB ERA21FA234Accident · 7 fatalClass 3 · FieldFinal reportCessna 501 · Smyrna, TNThe pilot’s loss of airplane control during climb due to spatial disorientation.NTSB CEN21LA247Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Flint, MIThe pilot’s failure to adequately monitor his fuel quantity during flight which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN21FA239Accident · 1 fatalClass 3 · FieldFinal reportPZL Warszawa-Okecie PZL-104 · Pearland, TXThe pilot’s loss of directional control during landing. Contributing to the severity of the accident was the presence of a drainage ditch between the runway and taxiway.NTSB ANC21LA043Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Cordova, AKAn encounter with mountain wave turbulence and windshear that exceeded the climb capability of the airplane and resulted in impact with terrain.NTSB WPR21LA225Accident · Serious injuriesClass 4 · LimitedFinal reportLindstrand Balloons 90A · Dayton, NVThe pilot’s failure to maintain control of the balloon due to an unexpected high surface wind and downdraft, which resulted in a hard landing.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB DCA21LA137Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-823 · Dallas/Fort Worth International Airport, TXThe captain’s decision to adjust his flight instruments while taxiing the airplane.NTSB CEN21LA241Accident · Serious injuriesClass 3 · LimitedFinal reportPipistrel Alpha Trainer · Fort Collins, COA partial loss of engine power due to the failure of the throttle control cable, which resulted in the loss of control of the dual carburetor system. The cable failure was a result of improper soldering at the throttle cable input terminal on the splitter…NTSB CEN21FA238Accident · 2 fatalClass 3 · FieldFinal reportLancair Evolution · McDermott, OHThe pilot’s failure to recognize and avoid airframe icing conditions, which resulted in a loss of airplane performance and a subsequent loss of control and in-flight break-up.NTSB ANC21LA044Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Perryville, AKThe airplane’s encounter with windshear on takeoff, which resulted in a loss of control and impact with the ground.NTSB WPR21LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Prescott, AZThe pilot’s delayed deployment of the landing gear, which resulted in the collapse of the main landing gear.NTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.NTSB CEN21LA243Accident · Serious injuriesClass 3 · LimitedFinal reportPhillips Ralph W Vans RV8 · San Angelo, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the installation of a reduced flow fitting in the fuel line to the carburetor by maintenance personnel.NTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.NTSB CEN21LA237Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Celina, OHA loss of engine power for undetermined reasons.NTSB ANC21LA042Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Birchwood, AKThe pilot's use of excessive braking during the landing roll, which resulted in a nose-over.NTSB WPR21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Hollister, CAThe improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.NTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.