NTSB investigations, PA
32 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 1 |
| 2017 | 7 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
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.
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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.NTSB ERA22LA244Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7AC · Monongahela, PAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall.NTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.NTSB ERA21LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Philadelphia, PAThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.NTSB 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.NTSB 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.NTSB GAA18CA083Accident · No injuriesData collectionFinal reportMichael Adamczyk Zenith CH750 · Franklin, PAThe pilot’s excessive application of aft stick during takeoff, which resulted in an aerodynamic stall. Contributing to this accident was the pilot’s inexperience in the airplane.NTSB ERA17FA248Accident · 1 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PAA partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…NTSB ERA17FA223Accident · 1 fatalField investigationFinal reportSlip Stream Genesis · Linesville, PAThe pilot's failure to maintain airspeed during a climbing turn after takeoff and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery. Contributing to the accident was the…NTSB GAA17CA293Accident · No injuriesData collectionFinal reportPiper PA 34 · Tunkhannock, PAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing in crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA17CA177Accident · Serious injuriesData collectionFinal reportReupert Mark Avid Flyer · Reedsville, PAThe sport pilot's failure to maintain airplane control during takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB ERA17FA153Accident · 1 fatalField investigationFinal reportHoward DGA 15P · Monongahela, PAThe pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.NTSB ERA16LA224Accident · No injuriesLimited investigationFinal reportCessna 172P · Honesdale, PAThe pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…NTSB GAA15CA243Accident · No injuriesData collectionFinal reportCessna 172 · New Enterprise, PAThe pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA15LA311Accident · Serious injuriesLimited investigationFinal reportThomas A Siminski Zenith CH 750 · Allentown, PAA partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…NTSB ERA15FA298Accident · 1 fatalField investigationFinal reportMchugh Tony Kitfox Model 1 · Montrose, PAThe pilot's failure to maintain control of the airplane during final approach, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.NTSB GAA15CA099Accident · No injuriesData collectionFinal reportCessna 172 - R · State College, PAThe student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.NTSB ERA15FA171Accident · 2 fatalField investigationFinal reportPiper PA28 · West Chester, PAThe failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…NTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…NTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.NTSB ERA12CA352Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2CT · Duncansville, PAThe glider’s encounter with atmospheric lift conditions not sufficient to clear terrain, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to continue turning toward a ridgeline.NTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…NTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.NTSB ERA12FA120Accident · 1 fatalField investigationFinal reportCessna 441 · Nashville, PAThe pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB ERA09CA381Accident · Serious injuriesData collectionFinal reportThompson David Challenger · Waymart, PAThe pilot's failure to maintain adequate airspeed during approach to land resulting in a stall.NTSB 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.NTSB DCA08FA075Accident · No injuriesField investigationFinal reportDouglas MD-10 · Raymond, PAThe flight crew's failure to adequately monitor the airplane's airspeed during the holding pattern, leading to the onset of an aerodynamic stall and subsequent structural damage to the tail from buffet.NTSB NYC08FA189Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Philadelphia, PAThe flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.