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 ERA23LA074Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Newnan, GAThe flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.NTSB ERA23FA070Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Charlotte, NCThe inadequate inspections of the forward left control rod end attachment hardware to the stationary swashplate by the pilot and by maintenance personnel, resulting in an eventual loosening and backing out of the hardware and subsequent loss of helicopter…NTSB CEN23LA052Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Del Rio, TXThe pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.NTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.NTSB ERA23LA068Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Manassas, VAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB DCA23LA067Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320 · Red Oak, IAMultiple bird strikes during descent.NTSB CEN23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Saint Joseph, MOThe pilot lost control of the airplane while on the ground due to temporary incapacitation.NTSB CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.NTSB ANC23LA006Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Bethel, AKThe total loss of engine power during cruise flight due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB ERA23FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Winston-Salem, NCContamination and/or misalignment of the regulator section of the right engine’s fuel servo, which resulted in excessive idle fuel flow and a total loss of engine power. Also causal was the pilot's failure to land immediately on the nearest runway at the…NTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.NTSB WPR23LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Las Vegas, NVThe student helicopter pilot’s failure to follow the tower controller’s landing instructions, which resulted in a midair collision.NTSB WPR23FA034Accident · 4 fatalClass 2 · FieldFinal reportTextron 208B · Snohomish, WAThe pilot’s improper recovery following a departure from controlled flight after an intentional aerodynamic stall, which resulted in an exceedance of airspeed limitations, airframe overstress, and a subsequent inflight breakup.NTSB ERA23LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 402 · Mashpee, MAThe airplane’s impact with a bird while enroute.NTSB ERA23LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Manassas, VAAn engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…NTSB WPR23LA032Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Salt Lake City, UTThe pilot’s inadvertent attempt to takeoff on a left side of runway, rather than the centerline of runway, which resulted in a collision with runway edge lights during the night time takeoff.NTSB ERA23FA060Accident · 1 fatalClass 3 · FieldFinal reportDetrick Donald G Detrick DA-2 · Oak Hill, FLThe student pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a tree.NTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…NTSB ERA23LA066Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot’s failure to appropriately use carburetor heat, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.NTSB ERA23LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lancaster, OHA loss of engine power during initial climb for undetermined reasons.NTSB ERA23LA058Accident · No injuriesClass 3 · LimitedFinal reportAntonov AN2 · Opa-Locka, FLThe pilot's failure to properly configure the cowl flaps and oil cooler shutters, which resulted in a total loss of engine power due to overheating of the engine. Contributing to the accident was the pilot's decision to operate the airplane in with an…NTSB WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.NTSB ERA23LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 310J · Fulton, NYThe pilots failure to slow the airplane down prior to turning off the runway, which resulted in damage to the airplane’s fuselage structure in the vicinity of the nose landing gear.NTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.NTSB CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…NTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.NTSB WPR23LA043Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Kapolei, HIThe pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.NTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.NTSB WPR23LA030Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s improper decision to takeoff from an unimproved airstrip with insufficient takeoff distance which, resulted in a runway overrun and collision with vegetation.NTSB ERA23LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 175 · Gilford, NHThe pilot’s decision to continue the approach to land in conditions where he was unable to see in front of the airplane due to sun glare, which resulted in in a collision a building.NTSB DCA23LA050Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Miami, FLAn encounter with convective turbulence during descent.NTSB ANC23FA004Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to fly at low altitude, which resulted in a collision with a cable.NTSB ERA23LA055Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Allentown, PAThe flight instructor’s decision to remove the nosewheel chock while the engine was still operating.NTSB CEN23LA033Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Bridgeport, TXThe pilot’s loss of control due to a wind gust during landing.NTSB CEN23LA032Accident · No injuriesClass 4 · LimitedFinal reportMulholland Robert A Vans RV-7 · Englewood, COAn encounter with windshear during the initial climb after takeoff, which resulted in a loss of control. Contributing to the accident was the pilot’s improper decision to takeoff with a tailwind.NTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.NTSB ERA23LA051Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Virus SW · Cross City, FLThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent deployment of the ballistic parachute recovery system.NTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.NTSB CEN23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Murdo, SDThe pilot’s failure to maintain directional control during takeoff with strong gusty surface winds.NTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.NTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.NTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.NTSB CEN23LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesquite, TXThe student pilot’s failure to maintain directional control while taking off from a touch and go landing.NTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.NTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB ERA23LA063Accident · No injuriesClass 3 · LimitedFinal reportHagerty Glasair Super IIS-TD · Jasper, GAThe loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.NTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.