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 WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…Jul 21, 2014 · N66255 · Substantial damageNTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.Jul 19, 2014 · N6467Q · DestroyedNTSB ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jul 12, 2014 · N41716 · Substantial damageNTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.Jul 6, 2014 · N79ZR · Substantial damageNTSB ERA14FA328Accident · 2 fatalField investigationFinal reportCessna 150J · Topping, VAThe pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.Jul 6, 2014 · N50824 · Substantial damageNTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jul 5, 2014 · N508CT · Substantial damageNTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.Jul 1, 2014 · N91331 · DestroyedNTSB CEN14FA325Accident · 1 fatalField investigationFinal reportDoyle James E Skybolt · Midlothian, TXThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in an inverted spin and subsequent collision with terrain.Jun 28, 2014 · N619PD · Substantial damageNTSB WPR14LA263Accident · 1 fatalLimited investigationFinal reportKnell ASC Spirit · Lehi, UTThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.Jun 22, 2014 · N127JK · Substantial damageNTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…Jun 10, 2014 · N5524L · DestroyedNTSB ERA14FA282Accident · 2 fatalField investigationFinal reportLiberty Aerospace XL-2 · Merritt Island, FLThe failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…Jun 10, 2014 · N516XL · DestroyedNTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.Jun 9, 2014 · N9454L · DestroyedNTSB CEN14FA266Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Stevens Point, WIThe pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.Jun 1, 2014 · N176FD · Substantial damageNTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.May 31, 2014 · N6275G · Substantial damageNTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.May 26, 2014 · N4493 · Substantial damageNTSB ERA14FA255Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Fountain, FLThe pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…May 25, 2014 · N43113 · Substantial damageNTSB CEN14FA249Accident · 4 fatalField investigationFinal reportRaytheon G36 · Silver City, NMThe airplane’s encounter with a strong tailwind and/or windshear, which resulted in an inadvertent stall. Contributing to the accident was the pilot’s continuation of the unstable approach, long landing, and delayed decision to conduct a go-around.May 23, 2014 · N536G · DestroyedNTSB WPR14FA181Accident · 1 fatalField investigationFinal reportAero Tek Zuni · Aguila, AZThe pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.May 3, 2014 · N22DA · Substantial damageNTSB CEN14WA535Accident · 2 fatalForeign investigationAlpi Pioneer · Evora, PortugalOn April 30, 2014, at 1851 coordinated universal time, an Alpi Aviation Pioneer 300J airplane, Portuguese registered CS-UOV, impacted terrain after a low pass near the Evora Airport (LPEV), Evora, Portugal. The two pilots were fatally injured and the airplane…Apr 30, 2014 · CS-UOV · DestroyedNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…Apr 19, 2014 · N594T · Substantial damageNTSB WPR14FA165Accident · 1 fatalField investigationFinal reportWilliams Myron G Bowers FLY Baby 1A · Mariposa, CAThe partial loss of engine power due to an improperly maintained carburetor and the pilot's subsequent failure to maintain aircraft control.Apr 11, 2014 · N6054Q · Substantial damageNTSB CEN14FA173Accident · 1 fatalField investigationFinal reportWorthington Donald Wayne Sonerai II LT · Highlands Ranch, COThe pilot’s loss of control during a forced landing following a loss of engine power for reasons that could not be determined due to postimpact fire damage.Mar 29, 2014 · N63917 · DestroyedNTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.Mar 22, 2014 · N702H · Substantial damageNTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.Mar 11, 2014 · N62PT · DestroyedNTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…Mar 9, 2014 · N76856 · DestroyedNTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…Mar 8, 2014 · N724HP · Substantial damageNTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.Feb 24, 2014 · N7745C · Substantial damageNTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…Feb 22, 2014 · N36638 · DestroyedNTSB CEN14FA084Accident · 3 fatalField investigationFinal reportPiper PA 24-250 · Collbran, COThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.Dec 12, 2013 · N8037P · Substantial damageNTSB CEN14FA057Accident · 2 fatalField investigationFinal reportCessna 152 · Spring, TXThe flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.Nov 18, 2013 · N555UF · Substantial damageNTSB ANC13FA095Accident · 1 fatalField investigationFinal reportZenith 701 · Big Lake, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he could not recover.Sep 9, 2013 · N701MG · Substantial damageNTSB ANC13FA093Accident · 1 fatalField investigationFinal reportCessna 170B · Glennallen, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and impact with the ground.Sep 6, 2013 · N170BN · Substantial damageNTSB ANC13FA091Accident · 1 fatalField investigationFinal reportPiper PA-18A · Nikolai, AKThe pilot’s improper decision to load the airplane beyond its allowable takeoff weight and center of gravity limits, which resulted in a loss of control during the initial climb. Contributing to the accident was the external load and the downwind takeoff.Aug 31, 2013 · N4581A · DestroyedNTSB ANC13FA090Accident · 2 fatalField investigationFinal reportChampion 7ECA · Sutton, AKThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and collision with terrain. Contributing to the accident was the pilot’s use of marijuana, which likely degraded his psychomotor…Aug 29, 2013 · N9624S · Substantial damageNTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…Aug 18, 2013 · N9201R · Substantial damageNTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…Aug 16, 2013 · N19UA · Substantial damageNTSB CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.Aug 16, 2013 · N2070K · Minor damageNTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…Aug 12, 2013 · N3226C · Substantial damageNTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.Aug 9, 2013 · N13622 · DestroyedNTSB CEN13FA416Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-65 · Flushing, MIThe student pilot’s failure to maintain airspeed during the landing approach, which led to a stall/spin, and the flight instructor’s failure to monitor the approach and provide remedial action before the stall.Jul 17, 2013 · N36466 · DestroyedNTSB ERA13LA320Accident · 1 fatalLimited investigationFinal reportThompson Bruce D Sonerai II · Pulaski, TNThe pilot's failure to maintain airspeed during a near-vertical climb after takeoff, which resulted in an aerodynamic stall and subsequent collision with terrain.Jul 16, 2013 · N788T · DestroyedNTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…Jul 7, 2013 · N93PC · DestroyedNTSB CEN13LA401Accident · 1 fatalLimited investigationFinal reportJDT 1600R · Chesaning, MIThe failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…Jul 6, 2013 · UNREG · DestroyedNTSB ERA13FA309Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Ocean City, MDThe pilot's failure to terminate the intentional aerobatic spin at an altitude adequate to prevent impacting the water. Contributing to the accident was the pilot's loss of situational awareness due to target fixation during the prolonged aerobatic maneuver.Jun 30, 2013 · N116RL · DestroyedNTSB WPR13FA298Accident · 2 fatalField investigationFinal reportAyers Less Drag Special · Oxnard, CAA loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the pilot’s failure to maintain adequate airspeed, which resulted in an…Jun 29, 2013 · N130LD · Substantial damageNTSB WPR13FA288Accident · 1 fatalField investigationFinal reportBeech J35 · Helena, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.Jun 24, 2013 · N8255D · Substantial damageNTSB ERA13FA295Accident · 2 fatalField investigationFinal reportRockwell International 690B · McClellanville, SCThe pilot’s loss of airplane control during high-altitude maneuvering and his subsequent failure to recover airplane control. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot and his failure to perform remedial…Jun 20, 2013 · N727JA · DestroyedNTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.Jun 12, 2013 · N15GG · DestroyedNTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 8, 2013 · N7147R · Substantial damage