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 CEN21LA450Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Caddo Mills, TXThe missing vertical stabilizer hardware, which resulted in a severe uncommanded yawing motion that necessitated an emergency landing, during which the airplane nosed over and sustained substantial damage to the vertical stabilizer.NTSB CEN21LA373Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · New Albany, MSThe pilot’s delayed decision to abort the landing that resulted in a collision with a fence post. Contributing to the accident was the failure of the alternator drive belt during cruise flight for unknown reasons and the subsequent inoperative electrical…NTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.NTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.NTSB ERA21LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Reading, PAThe captain’s improper decision to continue an unstabilized approach despite several go-around calls by the pilot monitoring, which resulted in a runway excursion and substantial damage to the pressure vessel.NTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.NTSB CEN21LA452Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mineral Point, WIThe pilot’s failure to see and avoid a wire during an aerial application flight, resulting in a collision with the wire.NTSB CEN21LA339Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · West Liberty, IAThe pilot’s failure to see and avoid a wire while maneuvering at low altitude during an aerial application flight, resulting in a collision with the wire.NTSB ERA21LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rochester, NYThe pilot’s excessive speed and improper landing flare which resulted in abnormal runway contact, porpoising, and substantial damage.NTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…NTSB ERA21LA294Accident · No injuriesClass 4 · LimitedFinal reportTurbine Cubs Of Wyoming PA-18 Super CUB · Dinwiddie, VAThe pilot’s failure to maintain control while taxiing on soft ground, which resulted in a nose-over.NTSB CEN21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Brenham, TXThe pilot’s failure to maintain control of the airplane during takeoff from a rough field.NTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.NTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.NTSB ANC21LA062Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · King Salmon, AKThe pilot’s exceedance of the floatplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR21LA281Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Cascade, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.NTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions for reasons that could not be determined based on the available evidence.NTSB CEN21FA327Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8F · Comstock, TXImpact with terrain for reasons that could not be determined based on the available information.NTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.NTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…NTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.NTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB ANC21LA061Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Skwentna, AKA partial loss of engine power due to detonation/preignition damage to the No. 2 cylinder. The reason for the detonation/preignition damage could not be determined based on the available evidence.NTSB ANC21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Skwentna, AKThe pilot’s use of excessive braking which resulted in a nose-over.NTSB WPR21LA271Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Riverside, CAA total loss of engine power for reasons that could not be determined from available evidence.NTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.NTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.NTSB ERA21LA290Accident · 1 fatalClass 3 · LimitedFinal reportCameron 0-105 · Piermont, NHThe balloon pilot’s delay in relighting the burner, which resulted in a hard landing and his ejection from the balloon.NTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.NTSB ERA21LA288Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Canada DHC-1 Chipmunk X · Lebanon, TNA total loss of engine power during the initial climb for reasons that could not be determined based on the available evidence.NTSB CEN21LA324Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Rhinelander, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.NTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.NTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.NTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.NTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…NTSB WPR21LA267Accident · No injuriesClass 4 · LimitedFinal reportJust JA30 Superstol · May, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop and collision with terrain.NTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.NTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.NTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.NTSB ANC21LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech F35 · Yakutat, AKThe pilot’s failure to ensure adequate runway distance for landing.NTSB ANC21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Rampart, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose over.NTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…NTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.NTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.