Final NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ANC25LA034Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182B · Girdwood, AKThe pilot's decision to land on an unsuitable landing surface, which resulted in a nose-over.NTSB WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB WPR25LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oakland, CAThe pilot’s failure to maintain directional control during takeoff roll with a left crosswind.NTSB ERA25LA172Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Folkston, GAThe pilot’s failure to maintain control of the airplane during a go-around.NTSB CEN25LA154Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Temple, TXThe failure of the left main landing gear down lock to engage and subsequent collapse of the left main landing gear.NTSB CEN25LA152Accident · No injuriesClass 4 · LimitedFinal reportCorben Junior ACE · Jeanerette, LAThe pilot’s failure to maintain airplane control during the landing roll.NTSB ANC25LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the lake and collided with terrain.NTSB WPR25LA135Accident · No injuriesClass 4 · LimitedFinal reportMartin Uav Vbat · Douglas, AZThe malfunction of the throttle servo which resulted in the complete loss of engine power.NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.NTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN25LA153Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Wausau, WIThe pilot’s failure to maintain directional control while landing in shifting wind conditions.NTSB CEN25LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Ault, COThe flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.NTSB CEN25LA150Accident · No injuriesClass 4 · LimitedFinal reportSilvaire 8F · Fairbury, NEThe pilot’s failure to maintain directional control while landing and the flight instructors delayed remedial action.NTSB WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.NTSB ERA25LA168Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Vero Beach, FLSeparation of the lower nose landing gear down lock link bolt, which resulted in a collapse of the nose landing gear during landing.NTSB ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.NTSB ERA25LA164Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Hickory, NCThe student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.NTSB ERA25LA161Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · Martinsville, VAThe pilot inadvertently turned off the fuel selector valve on takeoff which resulted in a loss of engine power.NTSB WPR25LA123Accident · No injuriesClass 4 · LimitedFinal reportPark Roderic B Kitfox IV · Marana, AZThe pilot’s failure to maintain clearance from an obstacle while performing an off-airport landing.NTSB ERA25LA207Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Winter Haven, FLThe pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.NTSB ANC25LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Manley Hot Springs, AKThe student pilot’s failure to maintain directional control during the landing roll on a snow and ice-covered runway, which resulted in a runway excursion and subsequent nose over.NTSB ERA25LA192Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Fort Myers, FLThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions, which resulted in the left wing impacting the runway.NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB ERA25LA162Accident · Serious injuriesClass 4 · LimitedFinal reportRuys Nicholas G RV-8 · Bennettsville, SCThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.NTSB ERA25LA160Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Chuluota, FLThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in a dynamic rollover.NTSB DCA25LA174Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican · Dixon, CAThe flight control system’s unanticipated transition to takeoff abort mode due to a software error in the autonomous flight control system, which resulted in a premature throttle reduction and hard landing.NTSB CEN25LA140Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Cash, ARThe pilot’s failure to maintain clearance from an excavator during low-altitude aerial application operations.NTSB ERA25LA159Accident · No injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · New Port Richey, FLMaintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.NTSB DCA25LA173Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Claveria, PhilippinesAn encounter with convective turbulence during cruise that was not detected in advance by cockpit weather radar or weather information services.NTSB CEN25LA165Accident · No injuriesClass 3 · LimitedFinal reportCessna T206 · Natchez, MSMaintenance personnel’s improper maintenance, which resulted in a loss of engine power due to fuel starvation as the result of a loose fuel line B-nut. Contributing to the accident was an inadequate 100-hour inspection performed after the recent maintenance.NTSB ANC25LA028Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Royal Kunia, HIImproper alteration of the crankshaft propeller flange at an unknown time, which resulted in an in-flight separation of the propeller assembly.NTSB WPR25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Madras, ORThe pilot’s loss of control during landing roll with gusty winds.NTSB WPR25LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · San Carlos, CAThe pilot's failure to maintain directional control during landing roll with crosswind conditions.NTSB CEN25LA137Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Rusk, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA121Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Tracy, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR25LA118Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Hobbs, NMThe student pilot’s loss of directional control during a hover, which resulted in an impact with terrain.NTSB CEN25LA143Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12-ET · Ruston, LAThe pilot’s improper fuel planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an autorotation.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA132Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Russellville, ARThe failure of the U.S. Army helicopter pilots to yield the right-of-way to the landing airplane, which resulted in the airplane encountering wake turbulence emitted from the three departing U.S. Army helicopters, a subsequent loss of directional control, and…NTSB ERA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Chamblee, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during approach due to fuel exhaustion.NTSB ERA25LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Anderson, SCThe pilots’ overcorrection during the landing roll which resulted in a loss of directional control and runway excursion. Contributing was the flight instructor’s inability to correct the pilot’s actions because due to brakes only being installed on the…NTSB WPR25LA115Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Cavalon · Murrieta, CAThe student pilot’s failure to maintain adequate airspeed during an approach and subsequent descent into terrain. Contributing to the accident was the student pilot’s failure to perform a go-around maneuver.NTSB ERA25LA152Accident · No injuriesClass 4 · LimitedFinal reportMaule M7 · Birdsboro, PAThe pilot’s decision to land with a quartering tailwind in shifting wind conditions, which resulted in a loss of control and nose-over.NTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB DCA25LA163Incident · No injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Orlando, FLThe captain’s failure to recognize that the airplane’s location did not agree with the assigned departure runway as required per the Southwest Airlines Airplane Operating Manual, and the captain’s plan continuation error when he missed several cues that would…NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.NTSB CEN25LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201T · Liberal, KSThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the prelanding checklist.NTSB ANC25LA026Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7CCM · Kenai, AKA total loss of engine power due to carburetor icing as a result of the pilot’s inadequate use of carburetor heat.NTSB WPR25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Henderson, NVThe pilot’s failure to maintain directional control during the landing, in gusting crosswind conditions.