Fatal NTSB investigations
709 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 51 |
|---|---|
| 2009 | 49 |
| 2010 | 43 |
| 2011 | 53 |
| 2012 | 47 |
| 2013 | 38 |
| 2014 | 48 |
| 2015 | 39 |
| 2016 | 38 |
| 2017 | 37 |
| 2018 | 49 |
| 2019 | 39 |
| 2020 | 30 |
| 2021 | 32 |
| 2022 | 30 |
| 2023 | 32 |
| 2024 | 29 |
| 2025 | 13 |
| 2026 | 12 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR27FA012Accident · 2 fatalClass 3 · FieldInvestigation openGugger David RV-7A · Petaluma, CANTSB WPR26FA330Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · San Diego, CAOn September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…NTSB WPR26FA329Accident · 4 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · Fresno, CAOn September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…NTSB WPR26FA320Accident · 2 fatalClass 3 · FieldPreliminary reportMooney M20C · Mount Hood, OROn August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26FA281Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Chandler, AZOn July 28, 2026, about 1949 mountain standard time, a Piper PA-28-180, N9062J, was destroyed when it was involved in an accident near Chandler, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26FA197Accident · 1 fatalClass 3 · FieldPreliminary reportFokker DR1 Replica · Frankston, TXOn May 26, 2026, about 0810 central daylight time, an experimental Fokker DR1 airplane, N54517, was destroyed when it was involved in an accident near Frankston, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA198Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Woodlake, CAOn May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…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 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 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 ERA25FA332Accident · 1 fatalClass 3 · FieldPreliminary reportCzech Sport Sportcruiser · Fryeburg, MEOn September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…NTSB CEN25FA339Accident · 1 fatalClass 3 · FieldPreliminary reportRans S-12 Airaile · Concordia, KSOn August 24, 2025, about 1926 central daylight time, a Rans S-12 Airaile airplane, N2757A, was substantially damaged when it was involved in an accident near Concordia, Kansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA257Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 140 · Shelter Cove, CAOn August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…NTSB WPR25FA225Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20J · Nampa, IDOn August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA248Accident · 1 fatalClass 3 · FieldPreliminary reportRobert Fidler Lancair 320/360 · Zeeland, MIOn June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB CEN25FA224Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Capron, ILOn June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…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 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 ERA25FA163Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Midvale, OHOn April 1, 2025, about 1704 eastern daylight time, a Cessna 310Q, N8242Q, was substantially damaged when it was involved in an accident near Midvale, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB 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 ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB CEN25FA014Accident · 1 fatalClass 3 · FieldPreliminary reportRans S12 · Church Point, LAOn October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code…NTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.NTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB GAA24WA270Accident · 1 fatalClass 4 · ForeignPiper PA18 · Defford, United KingdomNTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…NTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…NTSB WPR24FA226Accident · 2 fatalClass 3 · FieldFinal reportChampion 7GCBC · Eatonville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.NTSB WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN24FA215Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Clinton, MIThe flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…NTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…NTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…NTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…