NTSB investigations, 2009

114 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\") = 2009
    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 WPR09FA326Accident · 1 fatalField investigationFinal reportCessna 150 · South Lake Tahoe, CAA partial loss of engine power due to a malfunctioning carburetor and the pilot’s failure to maintain adequate airspeed while maneuvering to return to the runway. Contributing to the accident was the high density altitude.Jul 5, 2009 · N51172 · Substantial damageNTSB ERA09CA381Accident · Serious injuriesData collectionFinal reportThompson David Challenger · Waymart, PAThe pilot's failure to maintain adequate airspeed during approach to land resulting in a stall.Jul 5, 2009 · N10232 · Substantial damageNTSB CEN09CA414Accident · No injuriesData collectionFinal reportMooney M20 · Steamboat Springs, COThe pilot's improper pitch control during the go-around, which resulted in an aerodynamic stall.Jul 2, 2009 · N270SD · Substantial damageNTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.Jun 29, 2009 · N129TD · Substantial damageNTSB CEN09CA459Accident · Minor injuriesData collectionFinal reportCessna 172P · Usafa, COThe pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.Jun 27, 2009 · N52298 · Substantial damageNTSB CEN09LA385Accident · 1 fatalLimited investigationFinal reportSchendl Mustang II · West Union, OHThe pilot's failure to maintain adequate airspeed after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall/spin at a low altitude.Jun 25, 2009 · N152AS · Substantial damageNTSB WPR09CA310Accident · No injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot's failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall.Jun 24, 2009 · N226SE · Substantial damageNTSB CEN09CA381Accident · Minor injuriesData collectionFinal reportCessna 177B · Elyria, OHThe student pilot's failure to maintain aircraft control and adequate airspeed during the aborted landing, which resulted in an aerodynamic stall at a low altitude.Jun 23, 2009 · N34508 · Substantial damageNTSB CEN09CA372Accident · No injuriesData collectionFinal reportCessna 177 RG · Albuquerque, NMThe pilot's failure to maintain adequate airspeed while landing, resulting in an aerodynamic stall.Jun 22, 2009 · N1876Q · Substantial damageNTSB WPR09CA291Accident · No injuriesData collectionFinal reportClarke Colin A Glastar · Wenatchee, WAThe pilot’s failure to maintain adequate airspeed, resulting in an aerodynamic stall and loss of control.Jun 14, 2009 · N1935C · Substantial damageNTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.Jun 14, 2009 · N103MS · Substantial damageNTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.Jun 13, 2009 · N40908 · Substantial damageNTSB ERA09WA335Accident · 1 fatalForeign investigationPiper Aerostar 6 · Minga Guazu, ParaguayOn June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…Jun 9, 2009 · N601RP · Substantial damageNTSB ERA09CA319Accident · No injuriesData collectionFinal reportCessna A188B · Kingstree, SCThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Jun 3, 2009 · N9364R · Substantial damageNTSB ERA09CA320Accident · Serious injuriesData collectionFinal reportAB Sportine Aviacija LAK-17A · Middletown, NYThe pilot's failure to maintain control of the airplane while landing in gusty winds, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.May 31, 2009 · N391BA · Substantial damageNTSB CEN09LA331Accident · 1 fatalLimited investigationFinal reportGentry John K Chinook PL · Bridgeport, TXThe flight instructor and pilot's decision to take off with known control deficiencies with the aircraft which resulted in a loss of control.May 29, 2009 · N31773 · Substantial damageNTSB ERA09CA306Accident · Minor injuriesData collectionFinal reportCessna 152 · Lumberton, NJThe pilot's failure to maintain aircraft control during initial climb, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.May 25, 2009 · N49396 · Substantial damageNTSB WPR09FA258Accident · 4 fatalField investigationFinal reportCessna 320D · Fallon, NVThe pilot’s inadequate airspeed, which resulted in an aerodynamic stall.May 23, 2009 · N320KP · Substantial damageNTSB ERA09CA300Accident · No injuriesData collectionFinal reportTecnam P2002 · Stevensville, MDThe pilot's failure to maintain proper airspeed on final approach, which resulted in an aerodynamic stall.May 21, 2009 · N524LM · Substantial damageNTSB CEN09LA299Accident · Serious injuriesLimited investigationFinal reportNorthwing Apache Sport · Franklinton, LAThe pilot's failure to maintain airspeed which resulted in a stall. Contributing to the accident was the pilot's lack of flight experience in the weight-shift trike.May 13, 2009 · N61740 · Substantial damageNTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.May 9, 2009 · N1533Z · Substantial damageNTSB CEN09CA287Accident · Serious injuriesData collectionFinal reportPitts Aerobatics S-2B · Muskogee, OKInadequate supervision by the certified flight instructor, resulting in a delayed stall recovery attempt.May 9, 2009 · N6027V · Substantial damageNTSB ERA09LA281Accident · Serious injuriesLimited investigationFinal reportPolaris Motors 582 FIB · Lexington, SCThe non-certificated pilot's failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the non-certificated pilot’s lack of experience in the make and model airplane.May 4, 2009 · N171MB · Substantial damageNTSB CEN09LA278Accident · Serious injuriesLimited investigationFinal reportGlasflugel H201B · Meadow Lake Airport, COA programming anomaly within the winch's computer aided launch control system, which incorrectly limited the maximum winch speed during launch of the glider.May 4, 2009 · N17TD · Substantial damageNTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · DestroyedNTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.May 2, 2009 · N20GH · Substantial damageNTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.Apr 30, 2009 · N739RH · Substantial damageNTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.Apr 29, 2009 · N4603E · Substantial damageNTSB ERA09LA263Accident · 1 fatalLimited investigationFinal reportKeeley/Tidd MK-1 · Demopolis, ALThe pilot's failure to maintain adequate airspeed following a complete loss of engine power resulting in a stall while maneuvering to land. The reason for the loss of engine power was undetermined.Apr 24, 2009 · N91MK · Substantial damageNTSB ERA09CA259Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS8-18 · Fairfield, PAThe pilot's failure to maintain adequate airspeed while turning on to final approach, which resulted in an aerodynamic stall.Apr 23, 2009 · N818FM · Substantial damageNTSB CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.Apr 22, 2009 · N232PE · DestroyedNTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.Apr 18, 2009 · N5174X · Substantial damageNTSB ERA09LA250Accident · 1 fatalLimited investigationFinal reportGladstone Kitfox · Dubre, KYThe pilot's failure to maintain airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall.Apr 18, 2009 · N191KF · Substantial damageNTSB ERA09CA255Accident · Serious injuriesData collectionFinal reportMartin Edward H Fire Star II · Church Hill, TNThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.Apr 18, 2009 · N582EF · Substantial damageNTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.Apr 17, 2009 · N46326 · Substantial damageNTSB ANC09LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nunapitchuk, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.Apr 10, 2009 · N43551 · Substantial damageNTSB CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.Apr 8, 2009 · N2489S · No damageNTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.Apr 7, 2009 · N8998L · Substantial damageNTSB ERA09LA233Accident · 1 fatalLimited investigationFinal reportCurtiss Wright P-40N · Mastic Beach, NYThe pilot's failure to maintain adequate airspeed while performing aerobatics at low altitude.Apr 5, 2009 · N740RB · DestroyedNTSB WPR09CA178Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Monterey, CAThe pilot's inadequate compensation for the wind conditions and failure to attain/maintain an adequate airspeed, which resulted in an aerodynamic stall.Apr 4, 2009 · N224RA · Substantial damageNTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Mar 27, 2009 · N373E · Substantial damageNTSB CEN09CA228Accident · Minor injuriesData collectionFinal reportRemos Remos GX · St. Charles, MOThe pilot's failure to maintain a proper glide path and airspeed during a simulated emergency approach. Contributing to the accident was the flight instructor's delayed remedial action.Mar 22, 2009 · N446RA · Substantial damageNTSB WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…Mar 19, 2009 · N6383W · Substantial damageNTSB ERA09LA203Accident · Serious injuriesLimited investigationFinal reportWayne O Robinson S6S Rans · Cartersville, GAThe pilot's failure to maintain airspeed following a partial loss of engine power during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was chafed wires in the ignition system.Mar 19, 2009 · N312RW · Substantial damageNTSB CEN09FA220Accident · No injuriesField investigationFinal reportCessna E162 · El Dorado, KSThe failure of the Ballistic Recovery System to disconnect due to twisted attachment straps.Mar 19, 2009 · N162CE · Substantial damageNTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.Mar 14, 2009 · N3937T · Substantial damageNTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.Mar 9, 2009 · N262MX · Substantial damageNTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.Mar 7, 2009 · N933WF · Substantial damageNTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.Mar 4, 2009 · N3352B · Substantial damageNTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.Feb 28, 2009 · N3463X · Substantial damage