Fatal 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.\"highestInjuryLevel\" = 'Fatal' 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."highestInjuryLevel" = 'Fatal' 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 CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB GAA24WA293Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanyNTSB GAA24WA281Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanyNTSB GAA24WA280Accident · 1 fatalClass 5 · ForeignGreat Lakes 2T-1A-2 · Gütersloh, GermanyNTSB ANC24FA089Accident · 1 fatalClass 3 · FieldFinal reportBell 206B · King Salmon, AKThe pilot’s decision to initiate the visual flight into instrument meteorological conditions, which resulted in his spatial disorientation, failure to maintain helicopter control and subsequent impact with water.NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Camden, COThe pilot’s failure to maintain adequate clearance from a power transformer that was mounted to a power pole during an aerial application flight.NTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB CEN24LA332Accident · 1 fatalClass 3 · LimitedFinal reportApex CROSS-5X · Columbus, NEThe non-certificated pilot’s failure to maintain control of the aircraft after takeoff.NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB WPR24FA289Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 421C · Fairview, OROn August 31, 2024, about 1030 Pacific daylight time, a Cessna 421C, N421GP was destroyed when it was involved in an accident near Fairview, Oregon. The two pilots and one person on the ground were fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA24WA274Accident · 1 fatalClass 5 · ForeignPiper 38 · Córdoba, SpainNTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB GAA24WA276Accident · 1 fatalClass 5 · ForeignBoeing E75 · Frohngau, GermanyNTSB ERA24FA362Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Waynesville, OHA loss of control on takeoff for undetermined reasons.NTSB WPR24FA288Accident · 2 fatalClass 3 · FieldPreliminary reportTextron T206H · Yellow Pine, IDOn August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA24WA270Accident · 1 fatalClass 4 · ForeignPiper PA18 · Defford, United KingdomNTSB GAA24WA272Accident · 1 fatalClass 5 · ForeignBeech 58 · Amatschonjoch, AustriaNTSB CEN24FA327Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Wayne, NEThe non-instrument-rated pilot’s encounter with instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN24FA326Accident · 1 fatalClass 3 · FieldFinal reportRans S19 · Crofton, NEThe non-instrument-rated pilot's decision to continue visual flight into an area of low cloud cover and precipitation which resulted in an inadvertent encounter with instrument meteorological conditions and a loss of control due to spatial disorientation.NTSB WPR24FA285Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Kent, WAThe pilot’s failure to properly configure the amphibious landing gear for a water landing, which resulted in a touchdown on the water with the wheels extended, noseover, and airplane submersion.NTSB CEN24FA325Accident · 1 fatalClass 3 · FieldPreliminary reportArrow Falcon Exporters OH-58A+ · Newton, TXOn August 23, 2024, about 1330 central daylight time, a restricted category Arrow Falcon Exporters OH-58A helicopter, N199BD was substantially damaged when it was involved in an accident near Newton, Texas. The pilot was fatally injured and one person on the…NTSB GAA24WA300Accident · 9 fatalClass 5 · ForeignCessna 208 · What Khao Din, ThailandNTSB GAA24WA282Accident · 2 fatalClass 5 · ForeignPartenavia P66 · LIAA (Identifier), ItalyNTSB WPR24FA284Accident · 1 fatalClass 3 · FieldPreliminary reportLockwood AIR CAM · Minden, NVOn August 20, 2024, about 0819 Pacific daylight time, an experimental amateur-built Lockwood Air Cam, N2412Y, was substantially damaged when in was involved in an accident at the Minden-Tahoe Airport, Minden, Nevada. The pilot was fatally injured, and the…NTSB GAA24WA266Accident · 2 fatalClass 3 · ForeignCessna 152 · Jamshedpur, IndiaNTSB CEN24FA320Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 550 · Odessa, TXOn August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane…NTSB GAA24WA268Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · La Riola, ArgentinaNTSB ERA24LA346Accident · 1 fatalClass 4 · LimitedFinal reportPiper J3 · Mooresburg, TNThe pilot’s intentional flight into a building as an act of suicide.NTSB GAA24WA271Accident · 5 fatalClass 5 · ForeignBeech C90 · Apiacas, BrazilNTSB GAA24WA322Accident · 1 fatalClass 5 · ForeignWassmer WA54 · Chartres, FranceNTSB GAA24WA253Accident · 1 fatalClass 5 · ForeignRobinson R-44 · Cairns, AustraliaNTSB GAA24WA260Accident · 1 fatalClass 5 · ForeignCessna 152 · Santa Fe, ArgentinaNTSB GAA24WA252Accident · 1 fatalClass 5 · ForeignCessna 337 · Deer Lake, CanadaNTSB GAA24WA251Accident · 7 fatalClass 5 · ForeignPiper PA31 · Cerro Castillo, ChileNTSB WPR24FA270Accident · 3 fatalClass 3 · FieldFinal reportCessna 182K · Augusta, MTThe non-instrument-rated pilot’s decision to continue a visual flight rules flight into a rugged mountain area in deteriorating weather conditions, which resulted in impact with terrain.NTSB GAA24WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Provincia de Neuquén, ArgentinaNTSB GAA24WA247Accident · 5 fatalClass 5 · ForeignAirbus Helicopters AS350 · NepalNTSB CEN24FA312Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Elkhart, ILAn off-airport landing in a soybean field for reasons that could not be determined. Contributing to the severity of the pilot’s injuries and airplane damage was a fire that occurred at an unknown time.NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…NTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…NTSB CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.NTSB GAA24WA250Accident · 3 fatalClass 5 · ForeignBeech 95A55 · Birigui, BrazilNTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB GAA24WA239Accident · 2 fatalClass 5 · ForeignBell 206 · Escuintia, GuatemalaNTSB CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB CEN24FA287Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206 · Nashua, IAOn July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…