NTSB investigations
3,841 cases where the defining event was Loss of control in flight.
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 ANC26LA042Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-14 · Nenana, AKNTSB WPR26FA189Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-32-300 · Empire, NVOn May 17, 2026, about 0738 PDT, a Piper PA-32-300, N8502N, was substantially damaged when it was involved in an accident near Empire, Nevada. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA208Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Akron, OHOn May 14, 2026, at 1545 eastern daylight time, a Piper PA-28-180, N7188W, was destroyed when it was involved in an accident near Akron, Ohio. The flight instructor and student pilot were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA205Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185F · Avon, MEOn May 12, 2026, about 1058 eastern daylight time, a Cessna A185F airplane, N61368, was substantially damaged when it was involved in an accident near Avon, Maine. The pilot was fatally injured. The airplane was owned by the state of Maine and operated as a…NTSB CEN26FA184Accident · 1 fatalClass 3 · FieldPreliminary reportNorth American F-51D · Mound, LAOn May 12, 2026, at 1519 central daylight time, a North American F-51D airplane, N251CS, was destroyed when it was involved in an accident at the Vicksburg Tallulah Regional Airport (TVR), Mound, Louisiana. The pilot was fatally injured. The airplane was…NTSB CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB CEN26FA172Accident · 2 fatalClass 3 · FieldPreliminary reportBeechcraft F33A · Minneapolis, MNOn April 25, 2026, about 1151 central daylight time, a Beechcraft F33A airplane, N8032X was destroyed when it was involved in an accident near Minneapolis, Minnesota. The pilot and passenger were fatally injured. The airplane was operated under Title 14 Code…NTSB ANC26LA031Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Lapeer, MIThe flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…NTSB CEN26LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sherman, TXThe pilot's failure to maintain airplane control during recovery from a bounced landing.NTSB WPR26FA160Accident · 4 fatalClass 3 · FieldPreliminary reportMooney M20J · Union, SCOn April 17, 2026, about 1750 eastern daylight time, a Mooney M20J, N1151H, was destroyed when it was involved in an accident near Union, South Carolina. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA168Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mount Blanco, TXThe pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.NTSB WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.NTSB ERA26FA166Accident · 2 fatalClass 3 · FieldInvestigation openNorth American AT-6D · Bronson, FLNTSB ERA26FA165Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 58 · New Market, TNOn April 13, 2026, about 1308 eastern daylight time, a Beechcraft 58 multi-engine airplane, N2063G, was destroyed when it was involved in an accident near New Market, Tennessee. The flight instructor and the commercial pilot were fatally injured. The airplane…NTSB ERA26LA159Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172M · Lakeland, FLOn April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…NTSB CEN26LA154Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28F · Oelwein, IAThe pilot's failure to maintain directional control during the hover taxi with a quartering tailwind.NTSB ERA26LA153Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron T206H · Fort Myers, FLOn March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title…NTSB GAA26WA134Incident · 1 fatalClass 5 · ForeignAir Tractor AT502B · Cruz Alta, BrazilNTSB ERA26LA147Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA24-180 · Leonardtown, MDThe pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.NTSB CEN26LA134Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Sonora, TXThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.NTSB ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Monroe, NCThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA26WA111Accident · 1 fatalClass 5 · ForeignAir Tractor AT-802 · Long Taan, MalaysiaNTSB ERA26LA119Accident · No injuriesClass 4 · LimitedFinal reportTabor W Coates AR-1 · Kissimmee, FLThe pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control.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 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 WPR26LA094Accident · Minor injuriesClass 3 · LimitedPreliminary reportEnstrom F28C · Leeds, UTOn February 2, 2026, at about 1301 mountain standard time, an Enstrom F-28C helicopter, registration N5692Y, was substantially damaged near Leeds, Utah. The pilot and passenger sustained minor injuries. At the time of the accident, the helicopter was being…NTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.NTSB 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 DCA26WA108Accident · 10 fatalClass 5 · ForeignATR ATR42 · Makassar, IndonesiaNTSB CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB 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 ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB GAA26WA059Accident · 1 fatalClass 5 · ForeignCessna 170 · Rio de Janeiro, BrazilNTSB WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.NTSB CEN26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe flight instructor’s inadequate supervision during the approach and delayed remedial action, which resulted in a loss of control.NTSB GAA26WA057Accident · 1 fatalClass 5 · ForeignLancair 360 · Mazarambroz, SpainNTSB ERA26LA070Accident · Minor injuriesClass 3 · LimitedPreliminary reportHoltaway Robert F Velocity V-TWIN · Nashua, NHOn December 17, 2025, at 1410 eastern standard time, an experimental amateur-built Velocity V-Twin airplane, N22EU, was substantially damaged when it was involved in an accident near Nashua, New Hampshire. The pilot received minor injuries. The airplane was…NTSB 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 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 GAA26WA089Accident · Minor injuriesClass 5 · ForeignCessna 172 · Dhana Airfield, IndiaNTSB WPR26LA055Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Eureka, MTThe pilot’s failure to maintain directional control during landing in crosswind conditions. Contributing to the accident was the pilot's lack of recent flight experience.NTSB 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 ERA26LA060Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters Carbon Cub FX2 · Okeechobee, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB CEN26LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Downers Grove, ILThe pilot’s failure to maintain airplane control during an attempted go-around.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 GAA26WA043Accident · 1 fatalClass 5 · ForeignVulcanair P68 · Waterford Regional Airport, Ireland