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 ERA25FA187Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20TN · Sparta, TNOn April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB ERA25LA184Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Zolfo Springs, FLThe pilot’s failure to maintain control of the airplane during the takeoff. Contributing was the flight instructor’s lack of remedial action.NTSB GAA25WA182Accident · 1 fatalClass 3 · ForeignTecnam P2008 · Amreli, IndiaNTSB WPR25LA139Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Oakland, CAThe pilot’s failure to maintain airplane control during takeoff with a left quartering crosswind.NTSB GAA25WA150Accident · 1 fatalClass 5 · ForeignAyres S2R · SãO José Do Rio Claro, BrazilNTSB ERA25LA183Accident · Serious injuriesClass 4 · LimitedFinal reportFrank Lowell C Pietenpol · Taylorsville, NCThe pilot’s failure to maintain control of the airplane during an attempted go around in gusty tailwind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25FA173Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 310R · Boca Raton, FLOn April 11, 2025, at 1023 eastern daylight time, a Cessna 310R, N8930N, was destroyed when it was involved in an accident near Boca Raton, Florida. The two pilots and the passenger were fatally injured, and one person on the ground sustained minor injuries.…NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB ERA25LA172Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Folkston, GAThe pilot’s failure to maintain control of the airplane during a go-around.NTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN25FA144Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 210L · Raceland, LAOn April 2, 2025, at 2030 central daylight time, a Cessna 210L airplane, N1574P, was destroyed when it was involved in an accident near Raceland, Louisiana. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA133Accident · 1 fatalClass 4 · ForeignPiper PA32 · Rondonopolis, BrazilNTSB GAA25WA130Accident · 2 fatalClass 5 · ForeignCessna 152 · Lingayen, PhilippinesNTSB ERA25FA158Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22 · Franklin Township, NJOn March 30, 2025, about 1034 eastern daylight time, a Cirrus SR22, N319TM, was substantially damaged when it was involved in an accident near Franklin Township, New Jersey. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB CEN25FA141Accident · 1 fatalClass 3 · FieldPreliminary reportSocata TBM700A · Brooklyn Park, MNOn March 29, 2025, about 1221 central daylight time, a Socata TBM700A airplane, N721MB, was destroyed when it was involved in an accident near Brooklyn Park, Minnesota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA154Accident · 1 fatalClass 3 · FieldPreliminary reportAero SP Z O O AT-4 LSA · Zellwood, FLOn March 22, 2025, about 0925 eastern daylight time, a Aero SP Z O O AT-4 LSA, N8548U, was substantially damaged when it was involved in an accident near Zellwood, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Grenada, MSThe pilot’s loss of airplane control while landing in gusty wind conditions resulting in a hard landing and collapse of the nose landing gear.NTSB ERA25LA147Accident · Serious injuriesClass 4 · LimitedFinal reportChampion 7AC · Palmetto, FLThe flight instructor’s inability to overpower control inputs made by the student pilot during initial climb, which resulted in the airplane impacting powerlines and the ground.NTSB CEN25LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Rusk, TXThe pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.NTSB ERA25FA143Accident · 2 fatalClass 3 · FieldFinal reportRaytheon A36 · Greenville, NCThe pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).NTSB CEN25FA119Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 525 · Mesquite, TXOn March 13, 2025, about 0733 central daylight time, a Cessna 525A airplane, N525CZ, was destroyed when it was involved in an accident near Mesquite, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB GAA25WA114Accident · 1 fatalClass 5 · ForeignCessna 150 · Peruibe, BrazilNTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB GAA25WA100Accident · No injuriesClass 5 · ForeignGrumman AA5 · Zell am See, AustriaNTSB CEN25FA104Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Uvalde, TXOn February 27, 2025, about 1319 central standard time, a Robinson Helicopter Company (RHC) R44 helicopter, N144SG, sustained substantial damage when it was involved in an accident near Uvalde, Texas. The commercial pilot and the passenger sustained fatal…NTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.NTSB ERA25LA126Accident · Serious injuriesClass 3 · LimitedPreliminary reportEurocopter Deutschland EC 135 P2+ · Hampstead, NCOn February 24, 2025, about 1945 eastern standard time, a Eurocopter Deutschland GMBH EC 135P2+, N930NH, was destroyed when it was involved in an accident near Hampstead, North Carolina. The pilot, flight paramedic, and flight nurse were seriously injured.…NTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.NTSB ERA25LA115Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Hampton, NHThe pilot’s failure to maintain adequate airspeed while maneuvering to land, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.NTSB GAA25WA086Accident · 1 fatalClass 5 · ForeignBell 206L-4 · Bentong Helicopter Landing Site, MalaysiaNTSB ANC25MA018Accident · 10 fatalClass 1 · MajorFinal reportTextron 208B · Nome, AKThe National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…NTSB DCA25WA118Accident · 20 fatalClass 5 · ForeignBeech 1900 · Juba, SudanNTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB GAA25WA142Accident · Serious injuriesClass 3 · ForeignPilatus PC6 · Maripasoula, French GuianaNTSB WPR25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Rock Springs, WYOn January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.NTSB GAA25WA055Accident · Serious injuriesClass 5 · ForeignPiper PA18 · Fassberg, GermanyNTSB GAA25WA049Accident · 1 fatalClass 5 · ForeignRockwell International 112TCA · Fife, United KingdomNTSB WPR25LA068Accident · No injuriesClass 4 · LimitedFinal reportRemos Remos G-3/600 · Brawley, CAThe flight instructor’s lack of remedial action to the student pilot’s inadequate landing flare, which resulted in a hard landing and a loss of directional control.NTSB ERA25LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Southport, NCThe pilot’s loss of aircraft control due to spatial disorientation, and the flight instructor’s inadequate supervision, which resulted in the subsequent overstress of the airplane during recovery.NTSB GAA25WA042Accident · 1 fatalClass 5 · ForeignChampion 8KCAB · Vélez-Málaga, SpainNTSB GAA25WA045Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Santiago, ChileNTSB WPR25LA058Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Los Alamitos, CAThe student pilot’s failure to maintain directional control during a run-on landing and the flight instructor’s excessive correction which resulted in impact with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA25FA065Accident · 1 fatalClass 3 · FieldPreliminary reportTruitt James B Vans RV-8A · Fort Blackmore, VAOn December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB ERA25LA063Accident · No injuriesClass 4 · LimitedFinal reportHoltz Rodney R Challenger II · Concord, NHThe pilot’s failure to maintain directional control and eventual stall/mush of the airplane while trying to secure an open door in flight.NTSB GAA25WA092Accident · Minor injuriesClass 5 · ForeignMD Helicopter 500 · Uppsala, SwedenNTSB GAA25WA028Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · Langtora, SwedenNTSB GAA25WA289Accident · No injuriesClass 4 · ForeignBombardier N/A · Hannover, GermanyNTSB ERA25LA046Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Mariner · Parrottsville, TNThe pilot’s failure to maintain control of the helicopter during a precautionary, off-airport landing to sloping terrain.