Fatal NTSB investigations

710 cases where the sequence of events included Aerodynamic stall/spin.

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.\"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.

NTSB WPR22FA239Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Lind, WAThe pilot's exceedance of the airplane's critical angle of attack during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.Jul 3, 2022 · N602GH · Substantial damageNTSB WPR22FA235Accident · 1 fatalClass 3 · FieldFinal reportBeech V35B · Vancouver, WAThe pilot’s decision to execute a steep turn to final approach, which resulted in an exceedance of the airplane’s critical angle of attack and an accelerated stall. Contributing to the accident was the improper positioning on base leg and the pilot’s…Jun 28, 2022 · N444PM · DestroyedNTSB WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.Jun 24, 2022 · N934JH · Substantial damageNTSB WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…Jun 18, 2022 · N13AR · DestroyedNTSB 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…Jun 2, 2022 · N7641R · Substantial damageNTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…May 30, 2022 · N44508 · DestroyedNTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.May 28, 2022 · N4421M · Substantial damageNTSB CEN22FA214Accident · 1 fatalClass 3 · FieldFinal reportCessna 152 · Wauwatosa, WIThe student pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall from which the student pilot could not recover.May 26, 2022 · N4978B · Substantial damageNTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…May 20, 2022 · N76075 · DestroyedNTSB CEN22FA203Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe student pilot’s decision to operate the airplane after consuming alcohol, which led to an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and a subsequent loss of control at a low altitude.May 17, 2022 · N6409L · Substantial damageNTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · DestroyedNTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.Apr 28, 2022 · N37888 · DestroyedNTSB WPR22FA160Accident · 1 fatalClass 3 · FieldFinal reportCessna 337 · Sylmar, CAThe pilot’s loss of airplane control while troubleshooting a landing gear issue, which resulted in an aerodynamic stall/spin at an altitude too low to recover. Contributing to the accident was the pilot’s impairment from alcohol consumption.Apr 20, 2022 · N143JB · Substantial damageNTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Mar 31, 2022 · N789RB · Substantial damageNTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Mar 19, 2022 · N1410F · Substantial damageNTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.Feb 24, 2022 · N6129V · DestroyedNTSB WPR22FA087Accident · 2 fatalClass 3 · FieldFinal reportBeech K35 · Salem, ORThe airplane’s excessive nose-up pitch attitude during landing for undetermined reasons.Jan 29, 2022 · N9530R · Substantial damageNTSB ERA22FA095Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Jacksonville, FLThe pilot’s failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s likely distraction due to the opening of the baggage door.Dec 26, 2021 · N3707H · Substantial damageNTSB 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.Dec 11, 2021 · N9YY · Substantial damageNTSB CEN22FA031Accident · 4 fatalClass 3 · FieldFinal reportBritten-Norman BN-2A · Beaver Island, MIThe pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Nov 13, 2021 · N866JA · Substantial damageNTSB 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.…Nov 12, 2021 · N984LD · DestroyedNTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.Nov 8, 2021 · N3284F · Substantial damageNTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.Nov 5, 2021 · N8924Y · Substantial damageNTSB CEN22FA029Accident · 1 fatalClass 3 · FieldFinal reportVans RV · Harrison, MIThe pilot’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during landing approach, which resulted in an aerodynamic stall.Nov 5, 2021 · N16TG · DestroyedNTSB ERA22FA024Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Holly Ridge, NCThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall/mush during takeoff and initial climb. Contributing to the accident was the pilot’s loading the airplane near its maximum allowable gross weight and near its aft cg…Oct 21, 2021 · N3933H · Substantial damageNTSB WPR22FA012Accident · 1 fatalClass 3 · FieldFinal reportRockwell 112 · Three Points, AZThe pilot’s failure to maintain proper airspeed while maneuvering, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane entering an aerodynamic stall.Oct 17, 2021 · N112LS · Substantial damageNTSB CEN22LA001Accident · 2 fatalClass 3 · LimitedFinal reportTandem Air-Bike · Warrensburg, MOThe improper judgment of both pilots to attempt a flight while impaired by drugs/medications and their failure to maintain control of the aircraft, which resulted in an aerodynamic stall and impact with terrain.Oct 3, 2021 · UNREG · DestroyedNTSB ERA21FA377Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Lansing, WVThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees and terrain after takeoff, which resulted in an aerodynamic stall and loss of control. Also causal was the pilot’s decision to operate the airplane outside of…Sep 26, 2021 · N3342L · Substantial damageNTSB CEN21LA396Accident · 1 fatalClass 3 · LimitedFinal reportMonnett Moni · Tulsa, OKAn aerodynamic stall/spin and loss of control for reasons that could not be determined based on the available information.Sep 6, 2021 · N983JV · Substantial damageNTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.Aug 22, 2021 · N70643 · Substantial damageNTSB CEN21FA377Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Fort Worth, TXThe pilot’s 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 inadequate preflight planning, which resulted in an exceedance of the airplane’s…Aug 21, 2021 · N1472E · Substantial damageNTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.Aug 20, 2021 · N8262P · DestroyedNTSB 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.Jul 30, 2021 · N8520G · Substantial damageNTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…Jul 16, 2021 · N112TW · DestroyedNTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.Jul 1, 2021 · N2388L · Substantial damageNTSB ERA21FA274Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · St. Augustine, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during the landing approach.Jun 29, 2021 · N25513 · DestroyedNTSB CEN21FA290Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe canopy moving fully open during flight, which resulted in the pilot’s distraction and a subsequent aerodynamic stall/spin and loss of control.Jun 24, 2021 · N9261L · DestroyedNTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.Jun 18, 2021 · N1300Q · DestroyedNTSB ERA21FA257Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-402B · Kinston, NCThe pilot’s decision to conduct low-level aerobatic maneuvers in an airplane not approved for aerobatic flight, which resulted in an aerodynamic stall and spin, a loss of control, and an impact with terrain.Jun 18, 2021 · N402SJ · DestroyedNTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…Jun 15, 2021 · N8054Y · DestroyedNTSB ERA21FA239Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 1-35 · Wurtsboro, NYThe pilot’s low-altitude release from tow for reasons that could not be determined, and his subsequent exceedance of the glider’s critical angle of attack while returning to the runway, which resulted in an aerodynamic stall and impact with terrain.Jun 6, 2021 · N2878H · Substantial damageNTSB CEN21FA252Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 NG · Darlington, INA loss of control while practicing an aerodynamic stall, which resulted in a spin and impact with terrain.Jun 6, 2021 · N853L · DestroyedNTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.May 27, 2021 · N831HC · DestroyedNTSB CEN21FA209Accident · 4 fatalClass 3 · FieldFinal reportMitsubishi MU2B · Hattiesburg, MSThe pilot’s failure to maintain control of the airplane during the night instrument approach which resulted in an inadvertent aerodynamic stall from which the pilot was unable to recover.May 5, 2021 · N322TA · DestroyedNTSB CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.Apr 24, 2021 · N587CD · DestroyedNTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.Apr 21, 2021 · N53331 · Substantial damageNTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…Apr 17, 2021 · N707PH · Substantial damageNTSB ERA21FA142Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8E · Jupiter, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane, resulting in an unsecured engine cowl that…Feb 28, 2021 · N2960K · Substantial damageNTSB ERA21WA118Accident · 6 fatalClass 5 · ForeignBeech 95 · Porto Nacional, BrazilJan 24, 2021 · PT-LYG · Substantial damageNTSB CEN21LA096Accident · 2 fatalClass 3 · LimitedFinal reportExpress CT · Grand Prairie, TXThe pilot’s loss of airplane control during the departure turn, which resulted in an aerodynamic stall and impact with terrain.Dec 21, 2020 · N772BM · Destroyed