NTSB investigations, 2012
88 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 80 |
|---|---|
| 2009 | 114 |
| 2010 | 75 |
| 2011 | 115 |
| 2012 | 88 |
| 2013 | 77 |
| 2014 | 87 |
| 2015 | 90 |
| 2016 | 91 |
| 2017 | 95 |
| 2018 | 106 |
| 2019 | 97 |
| 2020 | 62 |
| 2021 | 68 |
| 2022 | 79 |
| 2023 | 69 |
| 2024 | 59 |
| 2025 | 48 |
| 2026 | 30 |
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 year(c.\"eventDate\") = 2012
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 year(c."eventDate") = 2012 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 WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.NTSB CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB CEN13FA060Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Burlington, WIThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.NTSB ANC13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Akiachak, AKThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and the pilot’s failure to maintain adequate airspeed during the subsequent forced landing, which resulted in an inadvertent stall.NTSB WPR13FA036Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Waterville, WAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.NTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB WPR13FA022Accident · 2 fatalField investigationFinal reportBehne Glasair III · Byron, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.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 ERA13LA024Accident · Serious injuriesLimited investigationFinal reportCashmer Philip M Sonex · Crossville, TNThe pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…NTSB ERA13LA015Accident · Serious injuriesLimited investigationFinal reportVelline'S Breezy RLU-1 · Madison, GAThe pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…NTSB WPR13LA007Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH25M · Kamuela, HIThe pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.NTSB ANC12LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Talkeetna, AKThe flight instructor's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an inadvertent stall.NTSB ERA12FA565Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Brownsboro, ALThe pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.NTSB CEN12LA636Accident · 1 fatalLimited investigationFinal reportJDT Mini-Max 1500R · Cameron, MOThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall and spin at a low altitude.NTSB WPR12LA418Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Nampa, IDAn uncommanded bank after takeoff followed by an aerodynamic stall. The reason for the uncommanded bank could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA634Accident · 1 fatalLimited investigationFinal reportNorth Wing Design Apache Sport · Vermillion, SDThe pilot’s failure to maintain control of the weight-shift-control aircraft during initial climb, which resulted in an aerodynamic stall/spin.NTSB ERA12FA561Accident · 2 fatalField investigationFinal reportHall Don H RV-7 · Cumming, GAThe pilot’s failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB CEN12CA656Accident · Minor injuriesData collectionFinal reportFairchild PT-19A · Cape Girardeau, MOThe pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.NTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.NTSB CEN12CA625Accident · No injuriesData collectionFinal reportBeech 35 · Geary, OKThe student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…NTSB CEN12FA616Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Kingsland, TXThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power resulting from an engine intake valve that became stuck open. Contributing to the accident was the pilot’s decision to operate the airplane when a required maintenance…NTSB DCA12IA141Incident · No injuriesIncident investigationFinal reportDe Havilland DHC8 · Soldotna, AKan in-flight loss of control due to the flight crew's inattention to airspeed, pitch attitude, and engine power during the climb leading to an aerodynamic stall. Contributing to the incident was the flight crew's failure to recognize and properly recover from…NTSB CEN12FA606Accident · Serious injuriesField investigationFinal reportCessna 421B · Fort Worth, TXThe pilot's failure to maintain airplane control on takeoff, which resulted in an inadvertent stall. Contributing to the accident were the unlatched nose cargo door, the pilot’s diverted attention, and the pilot's mental ability to handle the emergency…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 CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.NTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.NTSB CEN12LA540Accident · Minor injuriesLimited investigationFinal reportJames H Berard RV-6A · Westfield, INThe pilot’s failure to maintain control of the airplane after takeoff.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.NTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB ERA12FA465Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Berlin, MDPilot incapacitation of unknown origin, which resulted in the airplane’s loss of control and an inadvertent aerodynamic stall/spin.NTSB CEN12LA448Accident · Serious injuriesLimited investigationFinal reportChapman Mark A Trike · Marlboro, OHThe student pilot’s failure to maintain adequate airspeed during a turn, which resulted in an aerodynamic stall.NTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB CEN12LA407Accident · Serious injuriesLimited investigationFinal reportFields Mike Hawk SSC · Evansville, INThe operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.NTSB WPR12FA280Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Kooskia, IDThe pilot's decision to attempt a takeoff with a gusty tailwind, which resulted in his loss of airplane control during the initial climb and an aerodynamic stall/spin.NTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.NTSB ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.