NTSB investigations, NY
44 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 1 |
| 2026 | 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\" = 'NY' 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" = 'NY' 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 ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.NTSB ERA22LA305Accident · No injuriesClass 4 · LimitedFinal reportDuffy Russell A Slingshot · Shirley, NYThe pilot’s failure to maintain adequate airspeed during landing leading to an aerodynamic stall and subsequent impact with the ground.NTSB ERA22LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Ballston Spa, NYThe flight instructor’s and student pilot’s inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA310Accident · Serious injuriesClass 3 · LimitedFinal reportLiteflite PTY Dragonfly Model C · Middletown, NYThe improper installation of the carburetor, which resulted in a momentary total loss of engine power during initial climb. Contributing was the pilot’s failure to maintain control of the airplane following the initial power loss.NTSB ERA21LA260Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 8KCAB · Argyle, NYThe pilot’s failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA21FA239Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 1-35 · Wurtsboro, NYThe pilot’s low-altitude release from tow for reasons that could not be determined, and his subsequent exceedance of the glider’s critical angle of attack while returning to the runway, which resulted in an aerodynamic stall and impact with terrain.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB GAA18CA015Accident · Minor injuriesData collectionFinal reportThomas G Parkhurst Kitfox IV · Sidney, NYThe pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin.NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.NTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.NTSB ERA17FA115Accident · 2 fatalField investigationFinal reportRyan Navion · Westhampton Beach, NYThe flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…NTSB ERA15LA269Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Dunkirk, NYThe pilot's failure to maintain control of the airplane while attempting to close an open cabin door, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA15LA184Accident · Serious injuriesLimited investigationFinal reportCessna 162 · Shelter Island, NYThe pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.NTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.NTSB ERA14LA418Accident · Serious injuriesLimited investigationFinal reportLorenz Stephen Kitfox Series 5 · Greene, NYThe pilot’s failure to attain adequate airspeed during the initial climb, 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 lack of experience in the…NTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.NTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB 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.NTSB 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.NTSB ERA13LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Inlet, NYA loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA12LA528Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Dansville, NYThe pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.NTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.NTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ERA10LA206Accident · 2 fatalLimited investigationFinal reportCenter Charles C X-5 · Ghent, NYThe pilot's failure to maintain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident was the pilot's impairment.NTSB ERA09LA451Accident · Serious injuriesLimited investigationFinal reportEngle David TWO Place · Manlius, NYThe pilot's failure to maintain adequate airspeed during climbout, resulting in an aerodynamic stall.NTSB ERA09CA434Accident · Serious injuriesData collectionFinal reportLet L13 · Sparta, NYThe student pilot's failure to maintain airspeed resulting in an aerodynamic stall.NTSB 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.NTSB ERA09LA233Accident · 1 fatalLimited investigationFinal reportCurtiss Wright P-40N · Mastic Beach, NYThe pilot's failure to maintain adequate airspeed while performing aerobatics at low altitude.NTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…NTSB NYC08LA322Accident · 1 fatalLimited investigationFinal reportNagel SAL 2/3 P51 · Schenectady, NYThe pilot's failure to maintain adequate airspeed during the initial climb, which led to an aerodynamic stall.NTSB NYC08LA281Accident · 1 fatalLimited investigationFinal reportRoberto P. Garcia Nieuport 24bis · Rhinebeck, NYThe pilot's failure to maintain control of the airplane while maneuvering, resulting in an aerodynamic stall and spin.NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.