Final NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DCA24LA174Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Hogansville, GAAn encounter with convectively induced turbulence during descent.NTSB ERA24LA201Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Beach City, OHA total loss of engine power due to the due to the pilot’s delayed application of carburetor heat.NTSB ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.NTSB ERA24LA193Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Greenville, SCThe pilot’s failure to extend the landing gear before landing.NTSB ERA24LA191Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TBM 850 · Raleigh, NCThe pilot’s decision to continue an unstabilized approach, which resulted in a bounced landing, and his failure to maintain proper airspeed and climb attitude after aborting the landing, which led to the airplane exceeding its critical angle of attack and…NTSB CEN24LA166Accident · No injuriesClass 4 · LimitedFinal reportRans S-6ES · Emporia, KSThe pilot’s failure to maintain control during the landing flare.NTSB CEN24LA165Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Olney, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB WPR24LA134Accident · No injuriesClass 3 · LimitedFinal reportBell 206L-3 · Tracy, CAA loss of collective control authority due to fatigue failure of the collective servo cylinder extension arms from corrosion pitting.NTSB WPR24LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Placerville, CAThe pilot’s loss of directional control during the landing roll.NTSB WPR24LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Challis, IDThe pilot’s failure to attain a proper touchdown point during landing which resulted in a runway excursion and subsequent nose over.NTSB ANC24FA029Accident · 2 fatalClass 3 · FieldFinal reportDouglas C54D · Fairbanks, AKA loss of power of the No. 1 engine for reasons that could not be determined, and the incorrect installation of a B-nut fitting in the propeller feathering system, which allowed engine oil to spray onto the exhaust system when the propeller was feathered…NTSB WPR24LA130Accident · No injuriesClass 3 · LimitedFinal reportJames E Davidson JR Rans S-7S Courier · Benson, AZThe pilot’s unintentional use of a winter-blend fuel that was susceptible to vaporization, which resulted in fuel starvation and a loss of engine power due to vapor lock. Contributing to the accident was the airplane’s undersized fuel lines, which limited the…NTSB ERA24LA190Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B24R · Lumberton Township, NJThe pilot/owner’s failure to ensure adequate maintenance of the airplane, which resulted in a partial loss of engine power during takeoff.NTSB ERA24LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Ridgeway, VAThe pilot's failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB ANC24LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Talkeetna, AKA degraded ignition system, which resulted in a total loss of engine power. Contributing to the accident was maintenance personnel’s inadequate inspection of the ignition system.NTSB WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.NTSB ANC24LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Marana, AZA total loss of engine power due to a failure of the No. 4 cylinder piston boss.NTSB ANC24LA026Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Paso Robles, CAThe flight instructor’s failure to maintain adequate airspeed during landing which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot receiving instructions failure to maintain runway alignment.NTSB ERA24LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Stoneville, NCThe student pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB DCA24FA164IncidentClass 2 · FieldFinal reportAirbus A330 · Queens, NYNonstandard crossing phraseology and ineffective coordination between local controller 1 (LC1) and local controller 2 (LC2) which resulted in degraded shared situation awareness, and a runway incursion.NTSB ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.NTSB CEN24FA160Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Hartsburg, MOThe pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…NTSB ANC24LA024Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction’s failure to maintain control of the weight-shift control aircraft, during takeoff, which resulted in collision with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA24LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Shelbyville, TNThe student pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ERA24LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna R172 · Rocky Mount, NCThe pilot and mechanic’s failure to identify and completely eliminate the water and debris contamination present in the airplane’s fuel system before embarking on the flight, which resulted in a total loss of engine power.NTSB ERA24LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Manassas, VAThe pilot’s failure to apply carburetor heat before reducing engine power during a prolonged descent while operating in environmental conditions conducive to the development of carburetor ice, which resulted in a total loss of engine power due to carburetor…NTSB CEN24LA171Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7ECA · Lakeport, TXThe student pilot’s failure to maintain adequate airspeed during the final approach, which resulted in an inadvertent aerodynamic stall. Contributing to the accident the flight instructor’s delayed remedial action.NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ANC24LA028Accident · No injuriesClass 4 · LimitedFinal reportTeam Rocket F1 · Payson, AZThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Holt, FLThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a hard landing and subsequent nose over of the airplane.NTSB CEN24LA159Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Chesterfield, MOThe student pilot’s failure to maintain control during takeoff. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Concord, NCFailure of a landing gear extension system hydraulic hose, which resulted in a landing with the landing gear retracted.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB CEN24LA162Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe rudder post’s failure due to corrosion fatigue. Contributing to the accident were the misalignment of the rudder hinge components, which produced mechanical binding and elevated localized stress, and a compromised the protective coating, which allowed…NTSB CEN24LA157Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Montmorenci, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN24LA156Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Monroe, LAThe student pilot’s failure to maintain directional control during the landing roll.NTSB ANC24LA030Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during takeoff in gusting wind conditions, which resulted in collision with an object.NTSB WPR24LA126Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Auburn, WAAn overstress fracture of the left main landing gear actuator, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB CEN24LA155Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · Sullivan, MOA bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB ERA24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportHaring Robert C Zenith CH601XLB · East Amherst, NYThe pilot’s failure to maintain directional control and his decision to continue the takeoff from the soft turf runway.NTSB CEN24LA154Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Council Bluffs, IAThe pilot's failure to maintain directional control during the takeoff with a direct gusting crosswind.NTSB WPR24FA123Accident · 1 fatalClass 3 · FieldFinal reportAyres S2R-G10 · Derner, CAThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.NTSB ERA24LA172Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Ceiba, PRThe pilots’ failure to ensure adequate clearance from the taxiway while performing a quick stop maneuver.NTSB ERA24LA171Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · South Kingstown, RIThe pilot’s failure to maintain clearance from the water while maneuvering at low altitude.