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 CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.NTSB CEN20LA397Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montgomery City, MOThe pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.NTSB CEN20CA396Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Jacksonville, TXThe student pilot’s failure to maintain control of the airplane during the landing approach and the exceedance of the airplane’s critical angle of attack at low altitude resulting in an aerodynamic stall. Contributing was the instructor pilot’s failure to…NTSB ANC20CA097Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Arctic Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a rock damaging the empennage.NTSB WPR20LA324Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47E · Lake Abert, ORThe pilot’s failure to maintain clearance from an object during the takeoff ground roll due to inadequate monitoring of the environment.NTSB CEN20CA395Accident · No injuriesClass 4 · Data collectionFinal reportBell 407 · Fort Worth, TXThe flight instructor’s delay in rolling the throttle to the fly position during a practice autorotation maneuver that resulted in a hard landing.NTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.NTSB ANC20LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA22 · Homer, AKThe total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the corrosion of the fuel tank filler necks, which resulted in water intrusion into the fuel tanks.NTSB WPR20LA330Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.NTSB WPR20LA304Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Seeley Lake, MTThe noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.NTSB ERA20LA315Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Steinhatchee, FLThe failure of the air traffic controller to provide hazardous weather information to the pilot, resulting in the flight’s encounter with strong updraft conditions, an inflight loss of airplane control, and an in-flight breakup. Contributing was the pilot’s…NTSB CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.NTSB CEN20LA389Accident · 2 fatalClass 3 · LimitedFinal reportChampion 8KCAB · Groton, SDThe pilot’s loss of airplane control during a low-altitude aerobatic maneuver.NTSB CEN20CA393Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain directional control upon landing.NTSB ANC20CA094Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Kiana, AKThe pilot’s improper decision to perform a takeoff from an unsuitable surface, which resulted in a loss of control and nose over.NTSB WPR20LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA30 · Homer, AKThe pilot’s improper flare which resulted in a hard bounced landing and runway excursion.NTSB WPR20LA308Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Billings, MTThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC20CA096Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chitina, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.NTSB WPR20LA309Accident · No injuriesClass 4 · LimitedFinal reportBird CK · Enterprise, ORThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR20LA303Accident · 2 fatalClass 3 · LimitedFinal reportNavion B · Van Nuys, CAThe pilot’s failure to maintain control of the airplane during an abrupt turn after takeoff at a low altitude, which resulted in an aerodynamic stall.NTSB WPR20CA307Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC11-160 · Big Creek, IDThe pilot’s failure to maintain directional control during the landing roll with a gusting wind, which resulted in a runway excursion and impact with a tree.NTSB WPR20CA305Accident · No injuriesClass 4 · Data collectionFinal reportDiamond DA20 · Fillmore, UTThe student pilot's improper landing flare and delayed remedial action to abort the landing, which resulted in a loss of aircraft control, runway excursion and impact with terrain.NTSB ERA20LA316Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Melbourne, FLA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA20LA313Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Jackson, TNThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN20CA391Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Ozark, ARThe pilot's failure to maintain clearance from a wire during final approach to landing.NTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB ERA20LA312Accident · 1 fatalClass 3 · LimitedFinal reportQuad City Challenger · Sweetwater, TNA loss of control for reasons that could not be determined based on the available information.NTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.NTSB ERA20CA317Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA25 · Destin, FLThe pilot's failure to manage the available fuel supply which resulted in fuel starvation and a total loss of engine power.NTSB ANC20CA092Accident · No injuriesClass 4 · Data collectionFinal reportHelio H 295 · Fairbanks, AKThe pilot’s decision to initiate a right turn immediately after departure and his failure to maintain a proper crosswind correction, which resulted in a collision with terrain.NTSB WPR20LA331Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Randle, WAThe pilot's failure to maintain clearance from a tree while conducting an external load operation.NTSB ERA20LA327Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · Weston, FLA total loss of engine power because of the overheating and failure of the connecting rod bearings due to a lack of lubrication for reasons that could not be determined.NTSB WPR20CA302Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Snohomish, WAThe solo student pilot's improper landing flare, which resulted in a bounced landing and his subsequent improper go-around, which resulted in an impact with terrain.NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.NTSB ANC20CA090Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Palmer, AKThe pilot’s excessive airspeed during landing and improper application of the brakes, which resulted in a runway overrun.NTSB WPR20CA300Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Stuart Island, WAThe pilot’s improper approach airspeed and landing flare, which resulted in a hard, bounced landing and nose over.NTSB WPR20CA299Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 182 · Coeur d'Alene, IDThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion and a collision with trees and terrain.NTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.NTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.NTSB CEN20LA384Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Bonham, TXThe loss of engine power due to a disconnected fuel injector line that was not properly tightened during recent maintenance.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB CEN20CA388Accident · No injuriesClass 4 · Data collectionFinal reportMaule MX7 · Brazoria, TXThe pilot’s failure to maintain airplane control during a go-around from unsuitable terrain.NTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.NTSB ANC20LA089Accident · No injuriesClass 3 · LimitedFinal reportEurocopter AS 350 · Fort Greely, AKFailure of the door lock due to interference between the door and a cargo box.NTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.NTSB ERA20LA308Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA 1 · Newnan, GAThe flight instructor’s inadequate preflight fuel planning, which resulted in an interruption of the fuel supply to the engine and a subsequent a total loss of engine power due.NTSB CEN20LA440Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · San Antonio, TXThe pilot’s failure to fly a stabilized approach which resulted in a hard landing and loss of control.NTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB CEN20LA383Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Henderson, TXThe pilot’s failure to maintain proper airspeed, resulting in an aerodynamic stall after takeoff.