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 ERA21FA233Accident · 4 fatalClass 3 · FieldFinal reportBhi H60 Helicopters UH-60A · Leesburg, FLThe failure of the water tank snorkel support structure, which allowed the snorkel to contact the main rotor blades. Contributing to the accident was insufficient Federal Aviation Administration oversight of the supplemental type certificate process for the…NTSB ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.NTSB CEN21LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Indianapolis, INThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR21FA203Accident · 1 fatalClass 3 · FieldFinal reportDassault Mirage F-1 · Las Vegas, NVThe pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…NTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.NTSB ERA21FA229Accident · 1 fatalClass 3 · FieldFinal reportMunson Roger J RV-8 · Van Cleve, KYA loss of engine power due to loss of engine oil pressure.NTSB CEN21LA236Accident · No injuriesClass 4 · LimitedFinal reportBerry TX-11C · Longmont, COThe pilot’s loss of directional control when his foot became stuck on a protruding bolt in the airplane’s floorboard.NTSB WPR21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Mesquite, NVThe pilot’s failure to maintain airplane control during the landing roll, which resulted in a nosed over.NTSB WPR21LA205Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Ventura, CAThe partial loss of engine power, during cruise flight, due to the formation of carburetor ice, which resulted in a forced landing to an open field where the airplane nosed over.NTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.NTSB CEN21FA230Accident · 1 fatalClass 3 · FieldFinal reportSub-Sonex JSX-2 · Shreveport, LAThe pilot’s failure to maintain clearance with the water while performing aerobatics, resulting in the airplane’s impact into a lake. Contributing was the pilot’s decision to perform aerobatics at low altitude.NTSB ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.NTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.NTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.NTSB WPR21LA207Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Phoenix, AZThe pilot's failure to maintain directional control after an encounter with a windshear during the landing roll, which resulted in a runway excursion.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB DCA21LA133Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILthe failure of the flight crew of N8686A to provide sufficient clearance while taxiing past N289CT, which was stopped.NTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.NTSB ERA21LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPilatus B4-PC11 · Sterling, MAThe pilot’s misjudged approach angle which resulted in impact with trees and terrain.NTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.NTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.NTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.NTSB WPR21LA202Accident · No injuriesClass 4 · LimitedFinal reportGoodsell Lynn A Classic 4 · Richmond, UTThe pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.NTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.NTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.NTSB CEN21LA225Accident · 1 fatalClass 3 · LimitedFinal reportBell OH58A · Ulysses, KSThe pilot’s failure to maintain clearance from a power line during the aerial application flight, which resulted in collision with the power line and subsequent impact with terrain.NTSB CEN21LA223Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-502A · Clayton, LAThe pilot’s loss of airplane control resulting in an aerodynamic stall while executing a steep turnaround during an aerial application flight.NTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.NTSB WPR21LA197Accident · No injuriesClass 4 · LimitedFinal reportStearman 4E · Porterville, CAThe pilot’s loss of directional control while landing, which resulted in a landing gear collapse.NTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.NTSB CEN21FA220Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · St. Louis, MIThe pilot’s failure to maintain adequate visual lookout to ensure clearance from the radio tower and its guy wires. Contributing to the accident was the pilot’s unnecessary use of his mobile device during the flight, which diminished his attention/monitoring…NTSB WPR21LA198Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Paris, IDThe pilot's improper flare which resulted in a bounced landing, loss of directional control and collision with terrain.NTSB CEN21LA232Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Whitewater, WIAn inflight instrument malfunction for reasons that could not be determined based on available information, which led to the pilot’s decision to activate the airframe parachute system.NTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…NTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.NTSB WPR21LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Lake Arrowhead, CAA total loss of engine power due to a malfunction of the fuel flow manifold valve.NTSB ERA21LA223Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 XL · McKenzie, TNThe improper installation and inspection of the propeller, which resulted in an in-flight separation of the propeller assembly.NTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Daytona Beach, FLBoth pilots’ failure to maintain control during the landing flare and the flight instructor’s failure to maintain control during an attempted go-around, in gusting quartering headwind conditions, which resulted in the exceedance of the airplane’s critical…NTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.NTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB WPR21LA221Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Truckee, CAThe pilot’s improper flare during a landing attempt in crosswind conditions, which resulted in a bounced landing and impact with the ground.NTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.NTSB ERA21LA255Accident · No injuriesClass 4 · LimitedFinal reportPage Joseph E Vans RV-4 · Martinsburg, WVThe pilot’s improper landing flare in variable crosswind conditions, which resulted in a hard landing.