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 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 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 ANC21LA081Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Kodiak, AKThe pilot’s improper landing flare, which resulted in a hard landing and nose over.NTSB WPR21LA328Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe pilot’s inability to maintain control of the airplane during taxi after it encountered the prop wash from a larger airplane that was conducting a high-power engine run on the same taxiway.NTSB ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…NTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.NTSB DCA21WA215IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB CEN21LA385Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Roads, LAA loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB CEN21FA376Accident · 1 fatalClass 3 · FieldFinal reportSocata TBM 700 · Urbana, OHThe pilot’s failure to arrest the airplane’s left roll and rapid descent for reasons that could not be determined based on the available evidence.NTSB GAA21WA217Accident · No injuriesClass 5 · ForeignEurocopter BO105 · Archerfield, AustraliaNTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.NTSB GAA21WA209Accident · 1 fatalClass 5 · ForeignAcroduster II · Marcoola, AustraliaNTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.NTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.NTSB GAA21WA208Accident · 1 fatalClass 5 · ForeignRockwell 690 · Thunder Bay, CanadaNTSB ERA21LA328Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Orlando, FLA total loss of engine power due to fuel starvation that resulted from improper maintenance of the fuel selector valve and fuel selector valve cover.NTSB CEN21LA379Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Industries DA-42 · Bellefontaine, OHThe improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…NTSB ANC21LA073Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Fairbanks, AKThe pilot’s unexpected encounter with supercooled liquid droplets (SLD), which resulted in a loss of control due to ice accumulation. Contributing to the accident were: (1) the pilot’s failure to maintain the minimum airspeed for flight in icing conditions,…NTSB WPR21LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Albuquerque, NMThe failure of the nose gear hydraulic flex line, which resulted in a loss of hydraulic fluid which prevented the main landing gear from fully extending and locking into place during landing.NTSB GAA21WA207AccidentClass 5 · ForeignCessna P210N · Marbach, GermanyNTSB ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.NTSB CEN21LA408Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Heavener, OKA total loss of engine power due to the failure of the No. 2 cylinder exhaust valve for reasons that could not be determined.NTSB CEN21LA372Accident · Serious injuriesClass 3 · LimitedFinal reportFlying K Enterprises Sky Raider · Augusta, KSA partial loss of engine power for reasons that could not determined based on available information.NTSB ANC21LA071Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-14 · Tyonek, AKThe pilot’s failure to maintain directional control and adequate airspeed during takeoff which resulted in a collision with a river. Contributing to the accident was the pilot’s improper decision to load the airplane above its maximum allowable gross weight.NTSB WPR21LA320Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · West Jordan, UTThe pilot receiving instruction’s improper application of forward cyclic in a low rotor rpm condition and the instructor’s delayed remediation, which resulted in an impact with terrain.NTSB DCA21WA207IncidentClass 5 · ForeignAirbus 321 · Guam (Pacific Ocean)NTSB CEN21LA375Accident · No injuriesClass 3 · LimitedFinal reportHaley Highlander · Waller, TXA loss of engine power due to fuel exhaustion.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB GAA21WA205Accident · No injuriesClass 5 · ForeignBeech 95 55 · Churchdown, United KingdomNTSB CEN21LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Greenville, ILThe pilot’s failure to maintain directional control during taxi which resulted in a ground loop.NTSB ANC21LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Soldotna, AKThe flight instructor's inadequate supervision of the pilot receiving instruction, which resulted in a loss of control during the landing touchdown and a left main landing gear collapse.NTSB WPR21LA318Accident · No injuriesClass 3 · LimitedFinal reportNorth American T-28B · Puyallup, WAA nose wheel shimmy during the landing roll for reasons that could not be determined from the available evidence, which led to a loss of directional control.NTSB WPR21LA317Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Piper Sport · Santa Monica, CAThe student pilot’s improper landing flare.NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB GAA21WA263Accident · No injuriesClass 5 · ForeignPiper PA-30 · Saint-Honorat, FranceNTSB GAA21WA256Accident · Minor injuriesClass 5 · ForeignCessna 152 · Peji, BoliviaNTSB GAA21WA222Incident · No injuriesClass 5 · ForeignSupermarine Spitfire · Newtownards, United KingdomNTSB GAA21WA202Accident · No injuriesClass 5 · ForeignRobin HR200 · Proudfootstown, IrelandNTSB ERA21LA367Accident · Minor injuriesClass 4 · LimitedFinal reportCollins Robert S Just Acft Highlander · Brasstown, NCFailure of the left main landing gear wheel lock nuts, which resulted in a wheel separation and nose over during landing.NTSB DCA21LA210Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD-11F · Phoenix, AZThe flight crew’s incorrect pitch attitude during go-around.NTSB ANC21LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rohn, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR21LA313Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 425 · Helena, MTA flameout of both engines due to fuel starvation for reasons that could not be determined due to the airplane’s damage.NTSB GAA21WA214Accident · Minor injuriesClass 5 · ForeignAir Tractor AT802 · Popple Depot-New Brunswick, CanadaNTSB CEN21LA387Accident · Minor injuriesClass 4 · LimitedFinal reportSix Chuter Skye Ryder · Harrison, MIThe pilot’s loss of control while maneuvering at low altitude, which resulted in impact with terrain.NTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.NTSB CEN21LA369Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Wheeling, ILA partial loss of engine power for reasons that could not be determined based on available information.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB ERA21LA325Accident · Minor injuriesClass 4 · LimitedFinal reportSilverlight Delta JET-II · Mulberry, FLThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent loss of directional control.NTSB ENG21WA035Incident · No injuriesClass 5 · ForeignAirbus A320 · Budapest, Hungary