NTSB investigations, 2018

106 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\") = 2018
    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 ERA18FA200Accident · 2 fatalField investigationFinal reportPiper PA24 · Palatka, FLThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and a loss of control.Jul 27, 2018 · N6427P · DestroyedNTSB GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.Jul 19, 2018 · N432W · Substantial damageNTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…Jul 19, 2018 · N9878R · DestroyedNTSB CEN18WA279Accident · 1 fatalForeign investigationCessna 150 · Tortola, British Virgin IslandsJul 18, 2018 · N66778 · Substantial damageNTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…Jul 17, 2018 · N24515 · Substantial damageNTSB CEN18FA267Accident · 2 fatalField investigationFinal reportKolb Twinstar · La Porte, TXThe pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.Jul 15, 2018 · N3135J · Substantial damageNTSB ERA18LA191Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Geneseo, NYThe pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow…Jul 13, 2018 · N291CP · Substantial damageNTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…Jul 12, 2018 · N50183 · Substantial damageNTSB CEN18FA265Accident · 1 fatalField investigationFinal reportRose Parrakeet A-1 · Rhome, TXThe pilot's exceedance of the airplane's critical angle of attack after takeoff, which resulted in an aerodynamic stall.Jul 12, 2018 · N14842 · DestroyedNTSB GAA18CA413Accident · No injuriesData collectionFinal reportBeech T34 · Dallas, TXThe 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.Jul 9, 2018 · N6849C · Substantial damageNTSB GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.Jul 5, 2018 · N6795Q · Substantial damageNTSB 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.Jul 5, 2018 · N75SY · Substantial damageNTSB GAA18CA394Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Louisburg, NCThe student pilot's distraction due to a previous runway excursion and navigational issues during the accident flight and his failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the downwind leg, which…Jul 5, 2018 · N902HB · Substantial damageNTSB CEN18LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Springhill, LAThe pilot’s exceedance of the airplane's critical angle of attack during an improper go-around procedure which resulted in an aerodynamic stall.Jul 3, 2018 · N689KC · Substantial damageNTSB WPR18FA186Accident · 1 fatalClass 3 · FieldFinal reportCessna 320 · Eagle Mountain, UTThe pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.Jun 28, 2018 · N320MF · DestroyedNTSB GAA18CA383Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Malin, ORThe pilot’s misjudgment of the approach and his subsequent exceedance of the airplane’s critical angle of attack during an agricultural application flight, which resulted in an aerodynamic stall and collision with power lines.Jun 27, 2018 · N151QC · Substantial damageNTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.Jun 21, 2018 · N9496D · Substantial damageNTSB ERA18LA172Accident · No injuriesLimited investigationFinal reportMooney M20J · Monroe, NCA loss of engine power for reasons that could not be determined based on the available information.Jun 19, 2018 · N201FD · Substantial damageNTSB GAA18CA358Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Spanish Fork, UTThe pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.Jun 16, 2018 · N992CT · Substantial damageNTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 16, 2018 · N81047 · DestroyedNTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.Jun 14, 2018 · N9098C · Substantial damageNTSB ANC18FA044Accident · 2 fatalClass 2 · FieldFinal reportPiper PA18 · Sitka, AKThe pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.Jun 9, 2018 · N1203A · Substantial damageNTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.Jun 6, 2018 · N710JT · Substantial damageNTSB 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…Jun 4, 2018 · VH-XMH · DestroyedNTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.May 28, 2018 · N269DW · Substantial damageNTSB WPR18FA150Accident · 2 fatalField investigationFinal reportMorrison Marvin E JR RV 6A · Petaluma, CAA partial loss of engine power during initial climb after takeoff due to a loose left magneto, and the pilot's decision to turn back to the airport and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and…May 27, 2018 · N4269Y · Substantial damageNTSB GAA18CA306Accident · No injuriesData collectionFinal reportLite Flight Dragonfly · Mint Hill, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.May 27, 2018 · N582DF · Substantial damageNTSB ERA18FA152Accident · 1 fatalField investigationFinal reportCessna 140 · Daytona Beach, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…May 22, 2018 · N89864 · DestroyedNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB ERA18FA149Accident · 1 fatalField investigationFinal reportTaylorcraft BC12 · Commerce, GAThe pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff.May 21, 2018 · N94909 · Substantial damageNTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…May 17, 2018 · N7750F · Substantial damageNTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.May 16, 2018 · N77273 · Substantial damageNTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.May 11, 2018 · N9216E · Substantial damageNTSB CEN18LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Orrville, OHThe pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.May 11, 2018 · N738XT · Substantial damageNTSB GAA18CA270Accident · No injuriesData collectionFinal reportJetson'S Aircam · Bumpass, VAThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around.May 9, 2018 · N334JS · Substantial damageNTSB GAA18CA257Accident · No injuriesData collectionFinal reportAeronca 7AC · Warrenton, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall.May 6, 2018 · N83581 · Substantial damageNTSB ERA18FA141Accident · 1 fatalField investigationFinal reportAeronca 7AC · Middletown, NYThe pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover.May 5, 2018 · N84396 · Substantial damageNTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.May 2, 2018 · N734QQ · Substantial damageNTSB GAA18CA237Accident · Minor injuriesData collectionFinal reportStinson 108 · Eliza Island, WAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.Apr 27, 2018 · N6933M · Substantial damageNTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.Apr 27, 2018 · N818TW · DestroyedNTSB CEN18FA147Accident · 2 fatalField investigationFinal reportNorth American SNJ 5 · Kingsville, TXThe pilot's failure to maintain airspeed during a steep turn after takeoff, resulting in an exceedance of the airplane's critical angle of attack and a subsequent accelerated stall at an altitude too low for recovery.Apr 25, 2018 · N12377 · DestroyedNTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Apr 22, 2018 · N6020Y · Substantial damageNTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.Apr 22, 2018 · N964TA · Substantial damageNTSB ERA18LA134Accident · 1 fatalLimited investigationFinal reportStanley Ernie Sigurd Kolb Mark · Collegedale, TNThe pilot's loss of airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to take off in the nonairworthy airplane in which he had no training and his lack of flight experience in the 17…Apr 20, 2018 · N9123R · DestroyedNTSB GAA18CA214Accident · No injuriesData collectionFinal reportCessna 170 · Big Lake, AKThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Apr 9, 2018 · N4133V · DestroyedNTSB 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.Mar 31, 2018 · N820TL · DestroyedNTSB WPR18FA112Accident · 1 fatalField investigationFinal reportMooney M20E · Marina, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.Mar 26, 2018 · N213EJ · DestroyedNTSB CEN18FA126Accident · 1 fatalField investigationFinal reportRans S-16 Shekari · Pierce, NEThe pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.Mar 21, 2018 · N741WT · Substantial damageNTSB ERA18LA097Accident · Minor injuriesLimited investigationFinal reportReilly Charles W Escapade · Palatka, FLThe interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.Mar 6, 2018 · N45DC · Substantial damageNTSB ERA18LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Pompano Beach, FLThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach…Mar 1, 2018 · N54476 · Substantial damage