NTSB investigations, 2019

97 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 year(c.\"eventDate\") = 2019
    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 CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.Jul 14, 2019 · N2863J · Substantial damageNTSB GAA19CA406Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, MOThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a subsequent hard landing.Jul 11, 2019 · N2467G · Substantial damageNTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.Jul 10, 2019 · N4245J · Substantial damageNTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.Jul 6, 2019 · N796AB · Substantial damageNTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2019 · N420NG · Substantial damageNTSB GAA19CA407Accident · No injuriesData collectionFinal reportCessna 172 · Montville, METhe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during a low-altitude climbing turn, which resulted in an aerodynamic stall.Jul 3, 2019 · N1516E · 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 GAA19CA439Accident · Minor injuriesData collectionFinal reportCessna 172 · Manteo, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 30, 2019 · N78658 · Substantial damageNTSB GAA19CA429Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · Coward, SCThe noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Jun 28, 2019 · UNREG · Substantial damageNTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.Jun 26, 2019 · N1361Z · 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 · DestroyedNTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…Jun 22, 2019 · N256TA · DestroyedNTSB ERA19FA196Accident · 1 fatalClass 3 · FieldFinal reportTrella T-21 · Endicott, NYA partial loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack during an attempted return to the runway, which resulted in an aerodynamic stall/spin at an altitude that…Jun 17, 2019 · N450C · Substantial damageNTSB GAA19CA339Accident · No injuriesData collectionFinal reportAir Tractor AT502 · San Benito, TXThe pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 13, 2019 · N103CK · Substantial damageNTSB CEN19FA164Accident · 2 fatalClass 3 · FieldFinal reportQuicksilver Sport 2S · Henderson, LAThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s diminished reaction times and flying performance…Jun 12, 2019 · N7551V · Substantial damageNTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 8, 2019 · N7247B · Substantial damageNTSB GAA19CA331Accident · Minor injuriesData collectionFinal reportCessna 150 · Lee's Summit, MOThe student pilot’s exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 7, 2019 · N704HS · Substantial damageNTSB WPR19FA159Accident · 1 fatalClass 3 · FieldFinal reportTitan Titan II · Summerville, ORThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and impact with terrain.Jun 5, 2019 · N4362V · DestroyedNTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jun 1, 2019 · N2689K · Substantial damageNTSB GAA19CA337Accident · No injuriesData collectionFinal reportVans RV10 · Fort Drum, FLThe pilot's failure to maintain the proper airspeed during approach, which resulted in an aerodynamic stall.May 25, 2019 · N702CL · Substantial damageNTSB GAA19CA287Accident · No injuriesData collectionFinal reportJihlavan Airplanes Sro KP5 · East Haddam, CTThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.May 25, 2019 · N235KP · Substantial damageNTSB GAA19CA283Accident · No injuriesData collectionFinal reportRockwell S2R · Grangeville, IDThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.May 24, 2019 · N5569X · Substantial damageNTSB CEN19FA148Accident · 2 fatalClass 2 · FieldFinal reportCessna S550 · Greenfield, INThe pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.May 22, 2019 · N311G · DestroyedNTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.May 19, 2019 · N1888D · Substantial damageNTSB GAA19CA271Accident · No injuriesData collectionFinal reportAyres S 2R · Stuttgart, ARThe pilot's exceedance of the airplane's critical angle of attack while maneuvering during an agricultural application flight, which resulted in an aerodynamic stall.May 17, 2019 · N5675X · Substantial damageNTSB WPR19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Boulder City, NVThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.May 7, 2019 · N423EB · Substantial damageNTSB CEN19FA138Accident · 1 fatalClass 2 · FieldFinal reportChampion 7GCAA · Schlater, MSThe pilot's failure to maintain the proper airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a stall.May 7, 2019 · N7665S · Substantial damageNTSB WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.May 6, 2019 · N825PW · DestroyedNTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 6, 2019 · N734DX · Substantial damageNTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.May 6, 2019 · N5542U · DestroyedNTSB GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.May 5, 2019 · N96974 · DestroyedNTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.May 5, 2019 · N999CR · Substantial damageNTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…May 5, 2019 · N102SN · Substantial damageNTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.Apr 21, 2019 · N25TX · DestroyedNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.Apr 8, 2019 · N118LS · DestroyedNTSB GAA19CA194Accident · Minor injuriesData collectionFinal reportCessna 172 · Clemson, SCThe pilot's failure to maintain directional control during the landing roll and his exceedance of the airplane's critical angle of attack when it inadvertently became airborne, which resulted in an aerodynamic stall.Apr 2, 2019 · N54222 · Substantial damageNTSB GAA19CA177Accident · Minor injuriesData collectionFinal reportChampion 7EC · Fayetteville, ARThe pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.Mar 24, 2019 · N815PB · Substantial damageNTSB WPR19FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech 50 · Riverside, CAThe pilot’s failure to maintain airspeed and control of the airplane following a loss of right engine power for reasons that could not be determined based on the available information.Mar 16, 2019 · N800DC · Substantial damageNTSB CEN19FA099Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Lakeway, TXA partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…Mar 14, 2019 · N8620B · Substantial damageNTSB GAA19CA158Accident · No injuriesData collectionFinal reportPiper PA18 · Wyndmere, NDThe pilot's exceedance of the airplane's critical angle of attack during an uncoordinated turn while maneuvering at low altitude, which resulted in an aerodynamic stall.Mar 7, 2019 · N726 · Substantial damageNTSB ERA19FA107Accident · 2 fatalField investigationFinal reportCessna 172 · Mansfield, MAThe flight instructor's failure to maintain airplane control during initial climb after a touch-and-go landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Feb 23, 2019 · N224TA · Substantial damageNTSB WPR19TA085Accident · Serious injuriesClass 3Final reportPiper PA46 · Aurora, ORThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing during a simulated power-off approach and landing, which resulted in an aerodynamic stall and loss of control and the flight instructor’s failure to adequately…Feb 6, 2019 · N997MA · Substantial damageNTSB ERA19LA094Accident · 1 fatalLimited investigationFinal reportAirborne Windsports Edge X · Ocala, FLThe noncertificated pilot's exceedance of the aircraft's critical angle of attack, which resulted in an aerodynamic stall.Feb 2, 2019 · N123NY · Substantial damageNTSB WPR19LA062Accident · 1 fatalClass 2 · LimitedFinal reportVans RV8 · Langley, WAThe 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 a loss of control at an altitude too low for recovery.Jan 12, 2019 · N800KE · Substantial damageNTSB ERA19LA080Accident · 2 fatalLimited investigationFinal reportBellanca 1730 · Soddy-Daisy, TNThe pilot's improper decision to attempt an aerobatic maneuver at low altitude, which led to an aerodynamic stall and spin from which the pilot could not recover.Jan 7, 2019 · N8849V · DestroyedNTSB GAA19CA127Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Casa Grande, AZThe pilot's failure to maintain yaw control and his exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jan 5, 2019 · N71155 · Substantial damage