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 CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.Dec 16, 2020 · N449JP · Substantial damageNTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…Nov 26, 2020 · N87LW · Substantial damageNTSB WPR21FA025Accident · 2 fatalClass 3 · FieldFinal reportLancair 235 · Cordes Lakes, AZThe pilot’s exceedance of the airplane’s critical angle of attack during an aerobatic maneuver, which resulted in an aerodynamic stall and spin and a loss of control. Contributing to the accident was the pilot’s lack of aerobatic experience in the accident…Oct 24, 2020 · N25NL · Substantial damageNTSB WPR21LA011Accident · 1 fatalClass 3 · LimitedFinal reportRans S-7 · Spirit Lake, IDThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 6, 2020 · N55893 · Substantial damageNTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.Sep 24, 2020 · N9045Z · Substantial damageNTSB WPR20LA303Accident · 2 fatalClass 3 · LimitedFinal reportNavion B · Van Nuys, CAThe pilot’s failure to maintain control of the airplane during an abrupt turn after takeoff at a low altitude, which resulted in an aerodynamic stall.Sep 11, 2020 · N37C · DestroyedNTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.Sep 8, 2020 · N4166Z · Substantial damageNTSB CEN20LA357Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Dell, ARThe pilot’s failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and collision with terrain.Aug 21, 2020 · N759FA · Substantial damageNTSB 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.Aug 7, 2020 · N290MH · Substantial damageNTSB WPR20LA245Accident · 1 fatalClass 3 · LimitedFinal reportCessna 337 · Ennis, MTThe pilot-in-command’s failure to maintain sufficient airspeed while attempting an evasive maneuver from a boxed canyon, which resulted in an aerodynamic stall/spin and impact with mountainous terrain. Contributing to the accident was the pilot-in-command’s…Jul 30, 2020 · N337V · Substantial damageNTSB CEN20LA309Accident · 1 fatalClass 3 · LimitedFinal reportCessna A188 · Corsica, SDThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control.Jul 27, 2020 · N53163 · DestroyedNTSB WPR20LA238Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA32R · West Jordan, UTThe pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…Jul 25, 2020 · N7677C · Substantial damageNTSB CEN20LA306Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Grant, NEThe pilot’s exceedance of the airplane’s critical angle of attack 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. Contributing to the accident was the pilot’s…Jul 25, 2020 · N502KJ · Substantial damageNTSB WPR20LA196Accident · 2 fatalClass 3 · LimitedFinal reportKostrazewa Andre Sonex Light Sport · Centerville, UTThe pilot flying’s exceedance of the airplane’s critical angle of attack during an attempted forced landing, which resulted in an aerodynamic stall and impact with terrain. The reason for the attempted forced landing could not be determined.Jun 25, 2020 · N620AK · DestroyedNTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.Jun 16, 2020 · N879JA · Substantial damageNTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…Jun 7, 2020 · N595KF · Substantial damageNTSB WPR20LA157Accident · 1 fatalClass 3 · LimitedFinal reportCub Crafters CCK-1865 · Valley Center, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control.Jun 1, 2020 · N303KP · Substantial damageNTSB 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.May 20, 2020 · N883PJ · DestroyedNTSB ERA20LA179Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Land O Lakes, FLThe partial loss of engine power due to a contaminated fuel system and the pilot’s improper decision to attempt a takeoff with a known deficiency in engine power.May 12, 2020 · N711JA · DestroyedNTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.Apr 18, 2020 · N756TH · DestroyedNTSB ERA20LA149Accident · 1 fatalClass 3 · LimitedFinal reportPipistrel Italia Sinus 912 LSA · Marathon, FLThe pilot’s loss of control of the motorized glider, which resulted in an aerodynamic stall and collision with a residential home and postimpact fire. The reason for the loss of control could not be determined due to the condition of the wreckage.Apr 9, 2020 · N6263R · DestroyedNTSB ERA20LA145Accident · 1 fatalClass 3 · LimitedFinal reportSchempp Hirth Standard Cirrus · Groveland, FLThe pilot’s exceedance of the glider’s critical angle of attack following his premature termination of the tow for reasons that could not be determined, which resulted in an aerodynamic stall/spin during a turn back to the departure airport.Apr 7, 2020 · N271BL · Substantial damageNTSB WPR20LA118Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar 2 · La Center, WAA loss of control for reasons that could not be determined based on the available information.Apr 6, 2020 · N90KL · Substantial damageNTSB ERA20FA124Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Sterling, MAA total loss of engine power during takeoff due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Mar 11, 2020 · N1572H · Substantial damageNTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.Mar 3, 2020 · N157SF · DestroyedNTSB ERA20FA101Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Bartow, FLThe pilot’s exceedance of the airplane's critical angle of attack and subsequent aerodynamic stall and spin at low altitude due to a possible distraction in the cockpit for which the reason was undetermined.Feb 13, 2020 · N1149T · Substantial damageNTSB ERA20FA097Accident · 1 fatalClass 3 · FieldFinal reportAviastroitel AC 4C · Front Royal, VAThe pilot's exceedance of the glider’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control.Feb 9, 2020 · N912ES · Substantial damageNTSB CEN20FA076Accident · 1 fatalClass 3 · FieldFinal reportBeech 33 · Granbury, TXThe 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.Feb 8, 2020 · N6665U · Substantial damageNTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.Jan 25, 2020 · N55455 · DestroyedNTSB CEN20FA022Accident · 9 fatalClass 3 · FieldFinal reportPilatus PC12 · Chamberlain, SDThe pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…Nov 30, 2019 · N56KJ · DestroyedNTSB ERA20FA043Accident · 1 fatalClass 3 · FieldFinal reportBushby Bushby Mustang M II · Milton, FLThe pilot’s failure to maintain control of the airplane on takeoff, which resulted in an aerodynamic stall.Nov 24, 2019 · N24GL · Substantial damageNTSB 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.Nov 7, 2019 · N220MT · DestroyedNTSB ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.Nov 4, 2019 · N714LK · DestroyedNTSB ERA20FA022Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Ocala, FLThe pilot’s failure to maintain control of the airplane due to an acute medical event and/or his use of impairing medications.Oct 31, 2019 · N959CM · DestroyedNTSB ERA20FA020Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Colonia, NJThe pilot’s failure to maintain airspeed during a circling instrument approach procedure, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall and spin.Oct 29, 2019 · N959MJ · DestroyedNTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…Oct 25, 2019 · N201BJ · Substantial damageNTSB ERA20FA019Accident · 2 fatalClass 3 · FieldFinal reportMooney M20A · Summit Point, WVThe pilot’s decision to conduct a practice stall maneuver at low altitude, which resulted in inadequate altitude remaining in which to recover before impacting terrain.Oct 24, 2019 · N8354E · DestroyedNTSB ERA20FA013Accident · 1 fatalClass 3 · FieldFinal reportSportine Aviacija LAK17B · Tamaqua, PAThe pilot's exceedance of the glider's critical angle of attack while climbing in thermal lift, which resulted in an aerodynamic stall/spin.Oct 18, 2019 · N830DK · Substantial damageNTSB ERA20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Cameron, NCThe pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…Oct 14, 2019 · N4332J · Substantial damageNTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…Oct 5, 2019 · N326CW · DestroyedNTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.Oct 3, 2019 · N700AQ · Substantial damageNTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…Sep 8, 2019 · N73000 · Substantial damageNTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe 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 at an altitude too low for recovery.Sep 7, 2019 · N5502S · DestroyedNTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Aug 20, 2019 · N3631Z · DestroyedNTSB 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.Aug 7, 2019 · N43FD · Substantial damageNTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.Aug 7, 2019 · N213DT · DestroyedNTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 24, 2019 · N8910U · Substantial damageNTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.Jul 20, 2019 · N7013M · Substantial damageNTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.Jul 1, 2019 · N1094K · Substantial damageNTSB ERA19FA200Accident · 2 fatalClass 2 · FieldFinal reportRans S6 · Fletcher, NCThe exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.Jun 26, 2019 · N661PF · Destroyed