NTSB investigations, CA
70 cases where the defining event was Aerodynamic stall/spin.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 5 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 4 |
| 2018 | 8 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 6 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241')
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '241') 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 · FieldPreliminary reportVans RV7A · Petaluma, CAOn October 7, 2026, about 1038 Pacific daylight time, an experimental amateur built Vans RV-7A, N425DG, was destroyed when it was involved in an accident near Petaluma, California. The pilot and flight instructor were fatally injured. The airplane was…NTSB 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 WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CANTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.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 WPR25LA115Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Cavalon · Murrieta, CAThe student pilot’s failure to maintain adequate airspeed during an approach and subsequent descent into terrain. Contributing to the accident was the student pilot’s failure to perform a go-around maneuver.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 WPR24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Santa Ynez, CAThe pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…NTSB ANC24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Huasna, CAThe pilot’s failure to maintain adequate airspeed during a low altitude maneuver, resulting in a loss of control.NTSB WPR23LA333Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Three Rocks, CAThe airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.NTSB WPR23FA247Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · Murrieta, CAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the loss of control was the pilot’s sudden retraction of the flaps.NTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.NTSB WPR23FA110Accident · 2 fatalClass 3 · FieldFinal reportWillman Loren LOREN'S Aircam · Grass Valley, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB WPR22FA332Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Galt, CAThe certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.NTSB WPR22FA196Accident · 2 fatalClass 3 · FieldFinal reportBeech 19A · Oroville, CAThe pilot’s failure to maintain proper airspeed during a turn and his exceedance of the airplane’s critical angle of attack, which resulted in an accelerated stall. Contributing to the accident was the improper placement of the fuel selector, which resulted…NTSB WPR22LA145Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 162 · Palo Alto, CAThe pilot’s failure to maintain pitch control during a go-around maneuver, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB WPR22FA033Accident · 2 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Randsburg, CAThe pilot’s improper landing approach, which failed to account for wind conditions, and his exceedance of the airplane’s critical angle of attack following an overshoot of the runway extended centerline, resulting in an accelerated aerodynamic stall.…NTSB WPR21FA298Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Banning, CAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.NTSB WPR21LA123Accident · Serious injuriesClass 3 · LimitedFinal reportAermacchi Impala MB-326M · Edwards, CAThe flight crew’s restricted rudder inputs while in an inverted spin that precluded spin recovery.NTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.NTSB WPR20LA257Accident · 1 fatalClass 3 · LimitedFinal reportSportine Aviacija LAK17 · Lake Port, CAThe pilot’s exceedance of the glider’s critical angle of attack during flight, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR20LA152Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR20 · Santa Maria, CAThe pilot’s exceedance of the airplane’s critical angle of attack during a steep and descending turn to final approach, which resulted in an aerodynamic stall and loss of control.NTSB WPR20FA019Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Upland, CAThe 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 GAA19CA528Accident · Minor injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Lakeport, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting, variable wind conditions, which resulted in a loss of airplane control and subsequent impact with water.NTSB WPR19FA212Accident · 2 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Camarillo, CAThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.NTSB WPR18FA251Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Palo Alto, CAThe pilot’s failure to maintain aircraft control during a go-around due to his premature flap retraction, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…NTSB WPR18FA211Accident · 5 fatalClass 2 · FieldFinal reportCessna 414 · Santa Ana, CAThe pilot’s failure to maintain adequate airspeed while maneuvering in the traffic pattern which resulted in an aerodynamic stall and subsequent spin at a low altitude, which the pilot was unable to recover from.NTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.NTSB ANC18LA042Accident · Minor injuriesLimited investigationFinal reportGippsaero PTY GA10 · Mojave, CAThe flight crew's inappropriate decision, without authorization or consultation from the manufacturer's chief design engineer, to introduce flaps in the landing configuration into the entry spin testing, which resulted in an unrecoverable spin and impact with…NTSB WPR18FA116Accident · 2 fatalField investigationFinal reportRagle RV6A · Santa Paula, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and subsequent spin.NTSB WPR18LA069Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Skyforest, CAThe pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA096Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox · Upper Lake, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the approach to land, which resulted in an aerodynamic stall.NTSB WPR17FA200Accident · 2 fatalField investigationFinal reportRaytheon G36 · Benicia, CAThe pilot's failure to maintain adequate airspeed which caused the airplane to exceed its critical angle of attack and led to an aerodynamic stall.NTSB WPR17FA066Accident · 4 fatalField investigationFinal reportCessna T310Q · Riverside, CAThe pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…NTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.NTSB WPR17LA032Accident · Minor injuriesLimited investigationFinal reportHoskins Lonnie F Velocity XL RG · Petaluma, CAThe pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…NTSB WPR16LA167Accident · Minor injuriesClass 3 · LimitedFinal reportSiai-Marchetti SF260 · Fullerton, CAThe failure of the pilot to set the flaps to the proper takeoff setting before takeoff, resulting in an aerodynamic stall during takeoff and loss of control.NTSB WPR16FA157Accident · 1 fatalField investigationFinal reportArion Lightning LS-1 · Van Nuys, CAThe pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological…NTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.NTSB WPR16LA136Accident · Serious injuriesLimited investigationFinal reportRans S6 · Bridgeport, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering and his improper decision to maneuver low over a home, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB WPR16FA067Accident · 2 fatalField investigationFinal reportFlight Design Ctls · Springville, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…NTSB WPR15FA238Accident · 1 fatalField investigationFinal reportAviat A 1 · Compton, CAThe pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…NTSB WPR15CA118Accident · No injuriesData collectionFinal reportChristopher Jon Brown Stol CH750 · Palmdale, CAThe pilot's failure to maintain airplane control when he exceeded the airplane's critical angle of attack during climb out which resulted in a loss of airspeed and subsequent aerodynamic stall.NTSB WPR15GA030Accident · 1 fatalFinal reportHawker Hawker Hunter MK.58 · Oxnard, CAThe pilot's failure to maintain adequate airspeed during the approach for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at an altitude too low for recovery.NTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.