NTSB investigations
3,840 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 CEN25FA296Accident · 1 fatalClass 3 · FieldPreliminary reportHelms Richard Lancair IVP · Greenwood, INOn July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR25FA224Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Pacific Grove, CAOn July 26, 2025, about 2237 Pacific daylight time, a Beech 95-B55, N8976R, was substantially damaged when it was involved in an accident near Pacific Grove, California. The pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB ANC25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dillingham, AKOn July 25, 2025, about 0916 Alaska daylight time, a Piper J3C-65 airplane, N5050R, was substantially damaged when it was involved in an accident near Dillingham, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA217Accident · No injuriesClass 5 · ForeignKaman K-Max · Siviez, SwitzerlandNTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB GAA25WA244Accident · 2 fatalClass 3 · ForeignProMecc Aerosapce Freccia FG · Azzano Mella, ItalyNTSB CEN25LA279Accident · No injuriesClass 4 · LimitedFinal reportDyke Delta JD-2 · Oshkosh, WIThe pilot’s failure to maintain control of the airplane while landing with a tailwind.NTSB ERA25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Juan, PRThe student pilot’s excessing pitch attitude during takeoff, which resulted in a loss of aircraft control and aerodynamic stall.NTSB CEN25FA270Accident · 2 fatalClass 3 · FieldPreliminary reportVan's RV-14 · Lowell, MIOn July 21, 2025, about 1627 eastern daylight time, a Van’s Aircraft RV-14A airplane, N21KL, was destroyed when it was involved in an accident near Lowell, Michigan. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was operated…NTSB ERA25FA272Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA46-500TP · Lititz, PAOn July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The…NTSB CEN25LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lansing, MIThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing in a crosswind condition.NTSB CEN25LA256Accident · Minor injuriesClass 4 · LimitedFinal reportFarrington Twinstar · Greencastle, INThe pilot’s failure to maintain pitch control during takeoff. Contributing to the accident was the pilot’s inexperience in the accident gyroplane.NTSB CEN25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportScott Vincin Just Acft Highlander · Mancos, COThe airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.NTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.NTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.NTSB CEN25LA238Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Joliet, ILThe pilot’s failure to maintain directional control during the crosswind landing.NTSB ANC25LA065Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 180J · King Salmon, AKOn July 5, 2025, about 1430 Alaska daylight time, a Cessna 180J airplane, N52009, was substantially damaged when it was involved in an accident near King Salmon, Alaska. The pilot and two passengers were seriously injured and one passenger sustained minor…NTSB CEN25LA237Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pecos, TXThe pilot’s failure to maintain aircraft control during gusty wind conditions.NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB ANC25LA067Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 690B · Fairbanks, AKThe pilot’s failure to maintain control during takeoff resulting in a gear-up landing on the runway. Contributing to the accident was the pilot’s momentary distraction from within the airplane.NTSB WPR25FA197Accident · 1 fatalClass 3 · FieldPreliminary reportEvolution Revolt · Mount Vernon, WAOn July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally…NTSB CEN25LA229Accident · 1 fatalClass 3 · LimitedPreliminary reportRans S-14 · Guthrie, OKOn June 30, 2025, about 2054 central daylight time, a Rans S-14 airplane, N981CS, was substantially damaged when it was involved in an accident near Guthrie, Oklahoma. The non-certificated pilot was fatally injured. The airplane was operated as a Title 14…NTSB ANC25LA060Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-22-150 · Chinitna Bay, AKOn June 30, 2025, about 1630 Alaska daylight time, a Piper PA 22-150 airplane, N3609Z, was substantially damaged when it was involved in an accident near Chinitna Bay, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA199Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Tukwila, WAThe pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.NTSB GAA25WA195AccidentClass 5 · ForeignCessna 172 · Chartres, FranceNTSB ERA25LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Kelleys Island, OHThe pilot’s failure to maintain control of the airplane while taking off in gusting crosswind conditions.NTSB ERA25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Mount Gilead, OHThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB CEN25LA223Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Unionville, MOThe pilot’s failure to maintain airplane control during a go-around.NTSB ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.NTSB CEN25LA219Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Charleston, MOThe pilot’s loss of control during the spray pass, which resulted in impact with vegetation and terrain.NTSB CEN25LA213Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC130 · Clay Township, MIThe pilot’s failure to maintain control of the helicopter during landing.NTSB ERA25FA231Accident · 2 fatalClass 3 · FieldPreliminary reportPitts S2 · Broadway, NCOn June 20, 2025, at 0900 eastern daylight time, a Pitts Aerobatics S-2B, N79AV, was destroyed when it was involved in an accident near Broadway, North Carolina. The private pilot and the commercial pilot-rated passenger were fatally injured. The airplane was…NTSB ERA25FA230Accident · 2 fatalClass 3 · FieldFinal reportMooney M20F · Beverly, MAThe pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…NTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB ERA25FA228Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 58 · Tabor City, NCOn June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB CEN25FA198Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Waterman, ILOn June 7, 2025, about 1459 central daylight time, an Aeronca 7AC airplane, N1846E, sustained substantial damage when it was involved in an accident near Waterman, Illinois. The pilot was fatally injured, and the passenger was seriously injured. The airplane…NTSB ERA25LA219Accident · No injuriesClass 4 · LimitedFinal reportFred L Wellman CH 750 Cruzer · Medina, OHThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in a runway excursion.NTSB CEN25LA200Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gibson, ARThe pilot’s loss of control during takeoff due to an encounter with a sudden wind shift.NTSB CEN25FA184Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell Commander 114A · Hankamer, TXOn May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…NTSB CEN25FA183Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 II · Miami, TXOn May 23, 2025, about 0718 central daylight time, a Robinson Helicopter Company R44 II helicopter, N1195P, was destroyed when it was involved in an accident near Miami, Texas. The student pilot was fatally injured. The helicopter was operated as a Title 14…NTSB ERA25LA203Accident · Serious injuriesClass 3 · LimitedFinal reportSeamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…NTSB CEN25FA178Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Broomfield, COOn May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…NTSB ERA25FA202Accident · 1 fatalClass 3 · FieldPreliminary reportHarteveld Drew J Chinook Plus 2 · Pittstown, NJOn May 16, 2025, about 1642 eastern daylight time, an experimental, amateur-built Chinook Plus 2, N3300K, was destroyed when it was involved in an accident near Pittstown, NJ. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB CEN25LA172Accident · No injuriesClass 4 · LimitedFinal reportGolden Circle Air T-Bird · Dallas Center, IAThe pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.NTSB ERA25LA197Accident · No injuriesClass 4 · LimitedFinal reportArlie L Raber III Challenger 1 · Crestview, FLThe pilot’s decision to take off despite having problems controlling the airplane due to his physical stature.NTSB WPR25FA147Accident · 2 fatalClass 3 · FieldPreliminary reportPaul Berkovitz Vans RV-10 · Simi Valley, CAOn May 3, 2025, about 1350 Pacific daylight time, an experimental amateur-built Van’s RV-10, N626PB, was destroyed when it was involved in an accident near Simi Valley, California. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB CEN25LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182P · Kentwood, LAOn May 3, 2025, about 1530 central daylight time, a Cessna 182P, N9415M, was substantially damaged when it was involved in an accident near Kentwood, Louisiana. The pilot sustained serious injuries, and the passenger sustained minor injuries. The airplane was…