Fatal NTSB investigations
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WPR26FA121Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Mojave, CAOn March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB GAA26WA124Accident · 1 fatalClass 5 · ForeignThrush S2R · La Lima, HondurasNTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB CEN26FA132Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T210M · Deerfield, ILOn March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of…NTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA108Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-8 · Hurricane, UTOn February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…NTSB CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…NTSB GAA26WA118Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Wesselsbron, South AfricaNTSB GAA26WA117Accident · 3 fatalClass 5 · ForeignRobinson R44 · Amaranka, RussiaNTSB GAA26WA111Accident · 1 fatalClass 5 · ForeignAir Tractor AT-802 · Long Taan, MalaysiaNTSB WPR26FA103Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 210B · Camarillo, CAOn February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…NTSB ERA26FA115Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185 · Everglades City, FLOn February 15, 2026, about 1155 eastern standard time, a Cessna A185F, N7574N, was substantially damaged when it was involved in an accident near Everglades City, Florida. The pilot was seriously injured, and the passenger was fatally injured. The airplane…NTSB ERA26FA114Accident · 1 fatalClass 3 · FieldPreliminary reportTailwind W-8 · Poplar Grove, ILOn February 14, 2026, about 1600 central standard time, an experimental, amateur-built Tailwind W-8 airplane, N9424H, was destroyed when it was involved in an accident near Poplar Grove, Illinois. The pilot was fatally injured. The airplane was operated as a…NTSB CEN26FA115Accident · 4 fatalClass 3 · FieldPreliminary reportEpic E1000 · Steamboat Springs, COOn February 13, 2026, about 0019 mountain standard time, an Epic E1000 airplane, N98FK, was substantially damaged when it was involved in an accident near Steamboat Springs, Colorado. The pilot and three passengers were fatally injured. The airplane was…NTSB CEN26FA114Accident · 2 fatalClass 3 · FieldPreliminary reportBeech A36 · Murchison, TXOn February 11, 2026, about 1726 central standard time, a Beech A36 airplane, N3215U, sustained substantial damage when it was involved in an accident near Murchison, Texas. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was…NTSB WPR26FA101Accident · 1 fatalClass 3 · FieldPreliminary reportSonex Onex · Caldwell, IDOn February 6, 2026, about 0945 mountain standard time, a Sonex Onex airplane, N362DZ, was destroyed when it was involved in an accident near Caldwell, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA26WA102Accident · 1 fatalClass 5 · ForeignBeech 200 · Normanton, AustraliaNTSB GAA26WA101Accident · 3 fatalClass 5 · ForeignCessna 210 · Goolwa, AustraliaNTSB ERA26FA106Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22 · Lexington, SCOn February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally…NTSB CEN26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportRobert G Elves Tarragon (Tarr) · Shawmut, AZOn February 6, 2026, at 1532 mountain standard time, a Tarragon airplane, N35RR, was substantially damaged when it was involved in an accident near Shawmut, Arizona. The pilot was fatally injured and the passenger received serious injuries. The airplane was…NTSB WPR26FA098Accident · 2 fatalClass 3 · FieldPreliminary reportBell 407 · Flagstaff, AZOn February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…NTSB WPR26FA097Accident · 1 fatalClass 3 · FieldPreliminary reportSocata TB21 · Prescott, AZOn February 4, 2026, about 1950 mountain standard time, a Socata TB21, N967WM, was destroyed when it was involved in an accident near Prescott, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB DCA26WA113Accident · 2 fatalClass 5 · ForeignEmbraer EMB-110P1 · Les Cayes, HaitiNTSB GAA26WA088Accident · 2 fatalClass 5 · ForeignCirrus SR20 · Greater Manchester, United KingdomNTSB GAA26WA085Accident · 5 fatalClass 3 · ForeignLearjet 45XR · Sawantwadi, IndiaNTSB DCA26WA105Accident · 15 fatalClass 5 · ForeignBeech 1900 · Santander, ColombiaNTSB WPR26FA091Accident · 2 fatalClass 3 · FieldPreliminary reportN126c CCX-1865 · Montour, IDOn January 27, 2026, about 1100 mountain standard time, an amateur-built, experimental CCX-1865 Carbon Cub, N126C, was substantially damaged when it was involved in an accident near Montour, Idaho. The pilot and pilot-rated passenger were fatally injured. The…NTSB GAA26WA087Accident · 2 fatalClass 5 · ForeignHughes 269C · Paekakariki Hill, New ZealandNTSB GAA26WA086Accident · 2 fatalClass 5 · ForeignVans RV-8A · Norwell, AustraliaNTSB GAA26WA082Accident · 3 fatalClass 5 · ForeignCessna 172 · Comunidad Wichimi, EcuadorNTSB CEN26FA098Accident · 6 fatalClass 2 · FieldPreliminary reportBombardier CL-600-2B16 · Bangor, MEOn January 25, 2026, at 1944 eastern standard time (EST), a Bombardier CL-600-2B16 (Challenger 650) airplane, N10KJ, sustained substantial damage when it was involved in an accident near Bangor, Maine. The pilot, copilot, and 4 passengers were fatally…NTSB GAA26WA091Accident · 1 fatalClass 5 · ForeignCessna 172 · Caracaraí,, BrazilNTSB CEN26FA093Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Holly Springs, MSOn January 18, 2026, about 1640 central standard time, a Piper PA28-140 airplane, N6711J, was destroyed when it was involved in an accident near Holly Springs, Mississippi. The flight instructor and student pilot were fatally injured. The airplane was…NTSB GAA26WA074Accident · 3 fatalClass 5 · ForeignRobinson R44 · Rio de Janeiro, BrazilNTSB DCA26WA108Accident · 10 fatalClass 5 · ForeignATR ATR42 · Makassar, IndonesiaNTSB GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaNTSB GAA26WA073Accident · 1 fatalClass 3 · ForeignAir Tractor AT602 · Lucas do Rio Verde, BrazilNTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title…NTSB GAA26WA067Accident · 2 fatalClass 5 · ForeignRobinson R44 · Bardymsky Municipal District, RussiaNTSB ERA26FA084Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Provincetown, MAOn January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26FA074Accident · 4 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Superior, AZOn January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter…NTSB GAA26WA068Accident · 1 fatalClass 5 · ForeignPiper PA20 · Bloemfontein, South AfricaNTSB CEN26FA071Accident · 1 fatalClass 3 · FieldPreliminary reportLancair Legacy · Fredericksburg, TXOn December 30, 2025, about 1623 central standard time, a Lancair Legacy RG airplane, N618AM, was destroyed when it was involved in an accident near Fredericksburg, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26FA077Accident · 2 fatalClass 3 · FieldPreliminary reportEnstrom 280 · Hammonton, NJOn December 28, 2025, at 1124 eastern standard time, an Enstrom F-28A helicopter, N520H, and an Enstrom 280C helicopter, N280MG, collided in midair near Hammonton, New Jersey. The private pilots onboard each of the helicopters were fatally injured. Both…NTSB GAA26WA059Accident · 1 fatalClass 5 · ForeignCessna 170 · Rio de Janeiro, BrazilNTSB WPR26FA069Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-32-260 · Rio Linda, CAOn December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was…NTSB WPR26FA068Accident · 1 fatalClass 3 · FieldPreliminary reportBeech K35 · Summer Lake, OROn December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal…NTSB GAA26WA060Accident · 8 fatalClass 3 · ForeignDassault FALCON50 · Ankara, TürkiyeNTSB 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…