Fatal NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WPR26FA067Accident · 6 fatalClass 3 · FieldPreliminary reportBeechcraft B300 · Galveston, TXOn December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two…NTSB WPR26MA063Accident · 7 fatalClass 2 · MajorPreliminary reportCessna 550 · Statesville, NCOn December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…NTSB GAA26WA057Accident · 1 fatalClass 5 · ForeignLancair 360 · Mazarambroz, SpainNTSB CEN26FA064Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-30 · West Chicago, ILOn December 17, 2025, about 1349 central standard time, a Piper PA-30 airplane, N8693Y, was substantially damaged when it was involved in an accident near West Chicago, Illinois. The pilot and pilot-rated passenger were fatally injured. The airplane was…NTSB GAA26WA052Accident · 10 fatalClass 5 · ForeignCessna 650 · Toluca, MexicoNTSB GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandNTSB ERA26FA067Accident · 1 fatalClass 3 · FieldPreliminary reportAmerican Champion 8KCAB · Irvington, ALOn December 13, 2025, about 1145 central standard time, an American Champion Decathlon, N157WB, was destroyed when it was involved in an accident near Roy E. Ray Airfield (5R7), Bayou La Batre, Alabama. The commercial pilot was fatally injured. The airplane…NTSB GAA26WA063Accident · 1 fatalClass 5 · ForeignRobin DR400 · Le Havre, FranceNTSB WPR26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportHughes 369D · Pryor, OKOn December 5, 2025, about 0858 central standard time, a Hughes 369D, N161LA, was substantially damaged when it was involved in an accident near Pryor, Oklahoma. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB GAA26WA034Accident · 1 fatalClass 5 · ForeignVans RV7 · New South Wales, AustraliaNTSB GAA26WA041Accident · 2 fatalClass 5 · ForeignRobinson R44 · Malawa, PolandNTSB GAA26WA037Accident · 1 fatalClass 4 · ForeignCessna 172 · Nanaimo, CanadaNTSB WPR26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportAmerican AA-1A · High Rolls, NMOn November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB CEN26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · New Orleans, LAOn November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…NTSB CEN26FA050Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Monroe, WIOn November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…NTSB CEN26FA049Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-201 · Pittsfield, ILOn November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…NTSB GAA26WA043Accident · 1 fatalClass 5 · ForeignVulcanair P68 · Waterford Regional Airport, IrelandNTSB GAA26WA030Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Yame City, JapanNTSB ERA26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportJabiru USA Sport J230-SP · New Bavaria, OHOn November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…NTSB GAA26WA027Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Krivi Put, CroatiaNTSB GAA26WA025Accident · 1 fatalClass 5 · ForeignAir Tractor AT401 · Jaú, BrazilNTSB WPR26FA043Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172M · Poleta, CAOn November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously…NTSB WPR26FA040Accident · 2 fatalClass 3 · FieldPreliminary reportBeech B100 · Coral Springs, FLOn November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA022Accident · 4 fatalClass 5 · ForeignCessna TU206 · Bocoa, Vaupés, ColombiaNTSB GAA26WA044Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · Campo Novos dos Parecis, BrazilNTSB ERA26FA035Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Lebanon, TNOn November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was…NTSB ERA26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportExtra Flugzeugproduktions EA 300/SC · Keystone Heights, FLOn November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26MA024Accident · 14 fatalClass 1 · MajorPreliminary reportMcdonnell Douglas MD-11F · Louisville, KYOn November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…NTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB ERA26FA027Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20E · Ballston Spa, NYOn October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was…NTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaNTSB WPR26FA032Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Lincoln, MTOn October 24, 2025 at 2115 mountain daylight time, a Cirrus SR22T, N740TS, was destroyed when it was involved in an accident near Lincoln, Montana. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB GAA26WA014Accident · 1 fatalClass 5 · ForeignTextron 182T · Nuuk, GreenlandNTSB WPR26FA031Accident · 4 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Ekalaka, MTOn October 22, 2025, about 1830 mountain daylight time, a Robinson Helicopter Co. R66, N67GA, was substantially damaged when it was involved in an accident near Ekalaka, Montana. The pilot and 3 passengers were fatally injured. The helicopter was operated as…NTSB GAA26WA200Accident · 1 fatalClass 5 · ForeignBRM Aero Bristell NG5 · Bacani, Vaslui, RomaniaNTSB GAA26WA012Accident · 2 fatalClass 4 · ForeignPiper PA31T · San Cristóba, VenezuelaNTSB ERA26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus SR22 · Ruston, LAOn October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN26FA026Accident · 3 fatalClass 3 · FieldPreliminary reportRaytheon G58 · Carencro, LAOn October 21, 2025, at 1101 central daylight time, a Raytheon Aircraft Company G58 airplane, N16PV, was destroyed when it was involved in an accident near Carencro, Louisiana. The commercial pilot and two passengers sustained fatal injuries. The airplane was…NTSB DCA26WA017Accident · 2 fatalClass 3 · ForeignBoeing 747 · Hong Kong, Hong Kong SAR ChinaNTSB CEN26FA023Accident · 2 fatalClass 3 · FieldPreliminary reportJMB VL-3LSA-912 · Erie, COOn October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The…NTSB WPR26LA020Accident · 3 fatalClass 3 · LimitedPreliminary reportPiper PA-23-250 · Condon, MTOn October 17, 2025, about 1615 mountain daylight time, a Piper PA-23-250, N2345R, was substantially damaged when it was involved in an accident near Condon, Montana. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB CEN26FA022Accident · 1 fatalClass 3 · FieldPreliminary reportKitfox II · Spruce Pine, NCOn October 17, 2025, about 1154 eastern daylight time, a Kitfox II airplane, N8610X was destroyed when it was involved in an accident near Spruce Pine, North Carolina. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26FA002Accident · 3 fatalClass 3 · FieldPreliminary reportRaytheon Hawker 800XP · Bath, MIOn October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.…NTSB WPR26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35 · Austin, NVOn October 15, 2025, about 1447 Pacific daylight time, a Beech V35, C-FETM, was substantially damaged when it was involved in an accident near Austin, Nevada. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA26WA010Accident · 3 fatalClass 5 · ForeignCessna TU206 · Tecpan, GuatemalaNTSB ERA26FA011Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Dartmouth, MAOn October 13, 2025, at about 0815 eastern daylight time, a Socata TBM 700C2, N111RF, was substantially damaged when it was involved in an accident near Dartmouth, Massachusetts. The private pilot and the passenger were fatally injured and an automobile…NTSB ERA26FA010Accident · 2 fatalClass 3 · FieldPreliminary reportBeech C90 · Fort Worth, TXOn October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…NTSB GAA26WA008Accident · 1 fatalClass 5 · ForeignPiper PA28 · Pilanesberg, South Africa