NTSB investigations, 2013

77 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\") = 2013
    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 ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Jun 5, 2013 · N9807M · Substantial damageNTSB ERA13WA296Accident · 1 fatalForeign investigationExtra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, RussiaJun 2, 2013 · RA-0327G · Substantial damageNTSB WPR13CA261Accident · No injuriesData collectionFinal reportBeech A23-24 · La Grande, ORThe pilot’s failure to maintain airplane control and the flight instructors failure to monitor the pilot during a simulated emergency landing.Jun 1, 2013 · N650VX · Substantial damageNTSB CEN13WA311Accident · 1 fatalForeign investigationSaab 91C · Söderhamn, SwedenOn June 1, 2013, at 1215 universal coordinated time, a SAAB model 91C (Safir) airplane, Swedish registration SE-KVC, collided with terrain shortly after takeoff from the Söderhamn Airport (ESNY), near Söderhamn, Sweden. A postimpact fire destroyed the…Jun 1, 2013 · SE-KVZ · Substantial damageNTSB ERA13LA254Accident · Serious injuriesLimited investigationFinal reportFleming Eldridge E Sonex · Naples, FLThe pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…May 26, 2013 · N634SX · Substantial damageNTSB WPR13CA242Accident · No injuriesData collectionFinal reportCessna 182R · Alpine, WYThe pilot’s inadequate flare and loss of aircraft control during landing.May 25, 2013 · N9760H · Substantial damageNTSB ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…May 23, 2013 · N8225T · Substantial damageNTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.May 18, 2013 · N81788 · Substantial damageNTSB ERA13CA235Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jacksonville, NCThe student pilot's failure to maintain adequate airspeed during the go-around attempt, which resulted in an aerodynamic stall and collision with the ground.May 9, 2013 · N4518F · Substantial damageNTSB ERA13FA227Accident · 2 fatalField investigationFinal reportNewgent, Barry S6S · Suffolk, VAThe pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…May 4, 2013 · N388KB · DestroyedNTSB ERA13FA225Accident · 1 fatalField investigationFinal reportGrumman G-44 · Catskill, NYThe pilot’s misjudgment of the airplane’s altitude above the water and early flare for a landing on water with a glassy condition, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.May 2, 2013 · N8AS · DestroyedNTSB ERA13FA215Accident · 1 fatalField investigationFinal reportSchweizer SGS 2-32 · Shirley, NYThe pilot’s failure to maintain airspeed during final approach, which resulted in a stall. Contributing to the accident was the pilot’s likely impairment due to an over-the-counter sedating antihistamine.Apr 27, 2013 · N9857E · Substantial damageNTSB CEN13LA244Accident · 1 fatalLimited investigationFinal reportDean Leslie N Highlander · Bryan, OHThe pilot's failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.Apr 27, 2013 · N58LD · Substantial damageNTSB ERA13LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Inlet, NYA loss of engine power for reasons that could not be determined during postaccident examination.Apr 23, 2013 · N18JP · Substantial damageNTSB ERA13FA209Accident · 2 fatalField investigationFinal reportCessna 210E · Williamsburg, VAThe pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.Apr 19, 2013 · N111BK · Substantial damageNTSB ERA13FA201Accident · 1 fatalField investigationFinal reportSchoonover John D KIT FOX IV 1200 · St. Lucie, FLThe pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…Apr 14, 2013 · N117S · Substantial damageNTSB ERA13LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · New Castle, VAThe pilot's failure to abort the takeoff after recognizing that the airplane was not accelerating properly, which led to an aerodynamic stall. The reason for the lack of acceleration could not be determined because postaccident examinations did not reveal any…Apr 7, 2013 · N92804 · Substantial damageNTSB ERA13FA168Accident · 3 fatalField investigationFinal reportPiper PA-31T · Fort Lauderdale, FLThe pilot's failure to maintain airplane control following an emergency, the nature of which could not be determined because of crash and fire damage, which resulted in an aerodynamic stall.Mar 15, 2013 · N63CA · DestroyedNTSB WPR13FA141Accident · 1 fatalField investigationFinal reportMaule M5 · Woodinville, WAThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.Mar 9, 2013 · N17PR · Substantial damageNTSB ANC13FA027Accident · 3 fatalField investigationFinal reportCessna 182B · Nikolai, AKThe pilot’s failure to maintain adequate airspeed while maneuvering inside a box canyon and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot’s visual…Mar 4, 2013 · N2343G · Substantial damageNTSB ANC13LA026Accident · Serious injuriesLimited investigationFinal reportIsaak Paul G Isaak Super CUB · Sterling, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Feb 28, 2013 · N130Z · Substantial damageNTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…Feb 14, 2013 · N104DR · Substantial damageNTSB CEN13CA153Accident · No injuriesData collectionFinal reportCessna 177RG · Herington, KSThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall.Feb 8, 2013 · N88NG · Substantial damageNTSB DCA13IA058Incident · Minor injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Bowman, GAthe captain's inappropriate climb speed, his failure to monitor airspeed during the level off, and his inappropriate response to multiple stall warnings.Feb 7, 2013 · N261PS · Minor damageNTSB WPR13FA115Accident · 2 fatalField investigationFinal reportBeech E90 · Casa Grande, AZThe pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin.Feb 6, 2013 · N555FV · DestroyedNTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.Jan 19, 2013 · N143E · Substantial damageNTSB WPR13FA083Accident · 1 fatalField investigationFinal reportLuscombe 8A · Oceano, CAThe pilot’s failure to maintain airplane control and his improper decision to begin a low-level maneuver at an altitude that was not sufficient for recovery before ground impact. Contributing to the accident was the pilot’s impairment from marijuana use.Jan 3, 2013 · N45923 · Substantial damage