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 DCA20CA071Accident · Serious injuriesClass 4 · Data collectionFinal reportBombardier CL-600-2D24 · Waynesville, NCAn encounter with severe convective turbulence associated with a strong sheared environment associated with the jet stream.NTSB WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB WPR20CA089Accident · Minor injuriesData collectionFinal reportCessna 208 · Eureka, CAThe pilot's delayed response to initiate a go-around during a night visual approach over water after the airplane entered instrument meteorological conditions, which resulted in a loss of forward visibility and subsequent impact with the water.NTSB DCA20IA081Incident · No injuriesClass 3 · IncidentFinal reportAerospatiale AS350BA · Johnson Valley, CAthe failure of the small UAS remote pilot to give way to the helicopter, resulting in an inflight collision. Contributing to the incident was the sUAS remote pilot’s failure to assess and mitigate the risks of operations in close proximity to other aircraft.…NTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.NTSB ANC20FA017Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32R · Tuntutuliak, AKThe pilot's continued visual flight rules flight into reduced visibility, including likely flat light and/or white out conditions, which resulted in a controlled flight into terrain. Contributing to the accident were the operator’s inadequate operational…NTSB ANC20CA018Accident · No injuriesData collectionFinal reportCessna 172 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain while maneuvering at low altitude.NTSB ANC20LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Hooper Bay, AKThe pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility…NTSB WPR20CA088Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's failure to maintain directional control and the flight instructor's inadequate remediation during a short-field takeoff, which resulted in impact with a parked airplane.NTSB DCA20CA077Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 747 412 · Los Angeles, CAAn unavoidable collision with a garbage dumpster that had blown into the path of the airplane during the takeoff roll.NTSB CEN20CA074Accident · No injuriesData collectionFinal reportPiper PA32 · Kingfisher, OKThe pilot's improper continuation of a landing in which he landed too far down the runway at too high a speed, which resulted in a loss of directional control and a runway excursion.NTSB ERA20CA103Accident · No injuriesData collectionFinal reportPiper PA28RT · Fort Myers, FLThe fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.NTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.NTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeNTSB CEN20LA073Accident · No injuriesClass 3 · LimitedFinal reportHiller UH 12E · Dinosaur, COFailure of a S4 compressor blade due to a fatigue crack that likely initiated at a corrosion pit. Contributing to the accident was maintenance personnel’s failure to detect the corrosion pits during maintenance.NTSB ERA20CA093Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.NTSB ANC20CA016Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Big Lake, AKThe pilot's failure to apply full carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power, a forced landing, and impact with a tree.NTSB CEN20TA071Accident · Minor injuriesClass 3Final reportBeech 60 · Big Spring, TXA total loss of engine power in both engines due to fuel exhaustion, which resulted in a landing short of the runway.NTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.NTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.NTSB WPR20CA085Accident · No injuriesData collectionFinal reportCessna 180 · Eloy, AZThe pilot's failure to maintain directional control while landing in crosswind conditions, which resulted in a ground-loop.NTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.NTSB CEN20LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Woody Creek, COWater trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.NTSB WPR20CA084Accident · No injuriesData collectionFinal reportCessna 150 · Prescott, AZThe pilot's improper approach and landing flare, which resulted in a stall and a subsequent hard, bounced landing.NTSB WPR20CA080Accident · No injuriesClass 4 · Data collectionFinal reportMerwin Kitfox · Goodyear, AZThe tail wheel mechanism detachment for reasons that could not be determined due to the lack of available evidence which resulted in the loss of directional control on landing.NTSB ERA20LA221Accident · No injuriesClass 3 · LimitedFinal reportGulfstream 150 · San Juan, PRThe pilot’s loss of control during landing on a wet runway after encountering standing water.NTSB ERA20LA089Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Summerland Key, FLThe pilot's failure to remove the flight control gust lock before takeoff, which resulted in an inability to rotate, aborted takeoff, and subsequent runway overrun. Contributing to the accident was a missing piece of the flight control gust lock, which did…NTSB ERA20FA086Accident · 2 fatalClass 3 · FieldFinal reportMustang II · Senoia, GAThe pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.NTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.NTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.NTSB CEN20LA066Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Charlotte, TXThe pilot's failure to maintain clearance from a powerline during landing.NTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.NTSB WPR20CA074Accident · Minor injuriesData collectionFinal reportPiper PA-18 Replica · Jean, NVThe pilot's inadvertent application of the brakes during the landing roll, which resulted in a nose-over.NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.NTSB CEN20LA068Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Minot, NDThe pilot's failure to maintain clearance from fencing around the landing pad during landing, which resulted in the tail rotor contacting the fence.NTSB ERA20LA084Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Tallahassee, FLThe pilot's improper fuel planning, resulting in fuel exhaustion and a total loss of engine power in cruise flight.NTSB CEN20CA064Accident · Serious injuriesData collectionFinal reportGuimbal Cabri G2 · Independence, IAThe student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB WPR20CA071Accident · No injuriesData collectionFinal reportCessna 172 · Sun River, ORThe pilot's failure to maintain directional control during the landing roll on a runway with icy patches, which resulted in impact with a snowbank and a subsequent nose-over.NTSB ERA20LA094Accident · Serious injuriesClass 3 · LimitedFinal reportAirborne America AX9-140 · Homestead, FLThe pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…NTSB WPR20CA070Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · Gold Canyon, AZThe pilot's failure to maintain directional control during an aborted takeoff, which resulted in collision with a barricade.NTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.NTSB WPR20LA068Accident · No injuriesClass 3 · LimitedFinal reportCessna 172Q · Big Timber, MTA loss of engine power during climbout for undetermined reasons.NTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.