NTSB investigations, 2018
106 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\") = 2018
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") = 2018 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 CEN19LA049Accident · 2 fatalClass 2 · LimitedFinal reportBeech 58 · Sioux Falls, SDThe pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.NTSB ERA19FA066Accident · 1 fatalField investigationFinal reportEipper Quicksilver · Fredericksburg, VAThe pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB GAA19CA096Accident · No injuriesData collectionFinal reportBeech 36 · Hartford, WIThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.NTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.NTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA19FA036Accident · 1 fatalField investigationFinal reportTitan Tornado 1 · Louisa, VAThe pilot's failure to maintain airspeed and the airplane's exceedance of its critical angle of attack, which resulted in an aerodynamic stall and spin at a low altitude.NTSB WPR19TA018Accident · Serious injuriesFinal reportAudenried Kitfox S7 SuperSport · Flanigan, NVThe pilot's failure to maintain airspeed during a sharp turn at low altitude, which resulted in an aerodynamic stall.NTSB ERA19FA020Accident · 1 fatalField investigationFinal reportBowers Flybaby · Milton, FLA 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, which resulted in an aerodynamic stall at low altitude.NTSB WPR19FA007Accident · 2 fatalClass 2 · FieldFinal reportCessna T240 · Payson, AZThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.NTSB GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB WPR19TA009Accident · Serious injuriesFinal reportKreling Supercat · Three Rivers, MIThe pilot's failure to maintain the proper pitch attitude and adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…NTSB CEN18FA389Accident · 1 fatalClass 2 · FieldFinal reportVans RV 4 · Austin, ARThe pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.NTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…NTSB ERA18TA255Accident · Serious injuriesFinal reportCalvin Nate H Velocity STD RG E · Kingsport, TNThe pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.NTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA549Accident · Minor injuriesData collectionFinal reportAviat A1 · Bentonville, ARThe pilot’s exceedance of the airplane’s critical angle of attack during an attempted go-around after the airplane bounced, which resulted in an aerodynamic stall.NTSB ERA18FA244Accident · 2 fatalField investigationFinal reportCessna 335 · Lake Worth, FLThe pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.NTSB CEN18LA378Accident · Serious injuriesLimited investigationFinal reportPiper PA32 · Hereford, TXThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB WPR18FA253Accident · 1 fatalClass 2 · FieldFinal reportCommander 114 · Jean, NVThe pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.NTSB CEN18FA371Accident · 1 fatalField investigationFinal reportCessna 340A · Port Huron, MIThe pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…NTSB WPR18FA251Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Palo Alto, CAThe pilot’s failure to maintain aircraft control during a go-around due to his premature flap retraction, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…NTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…NTSB ERA18FA238Accident · 3 fatalField investigationFinal reportSchweizer SGS 2 32 · Morrisville, VTThe pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…NTSB ERA18FA235Accident · 1 fatalField investigationFinal reportAirtime Cygnet · Pensacola, FLThe student pilot's loss of aircraft control for undetermined reasons.NTSB ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.NTSB GAA18CA507Accident · Minor injuriesData collectionFinal reportVans RV10 · Spring Branch, TXThe pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…NTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.NTSB WPR18TA238Accident · Serious injuriesClass 3Final reportRans S14 · Brownsville, ORThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB WPR18FA229Accident · 2 fatalField investigationFinal reportJames E Causey Acroduster II · Phoenix, AZAn exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB CEN18LA344Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Addison, TXThe pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.NTSB CEN18FA339Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Bronson, MIThe pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.NTSB ERA18TA222Accident · Serious injuriesFinal reportGlobe GC1B · Wellington, FLThe partial loss of engine power during the initial climb due to a sticking intake valve on the No. 3 cylinder.NTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…NTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.NTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…NTSB GAA18CA470Accident · Minor injuriesData collectionFinal reportWalter C Smythe Tango XR · Mansfield, OHThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB WPR18FA211Accident · 5 fatalClass 2 · FieldFinal reportCessna 414 · Santa Ana, CAThe pilot’s failure to maintain adequate airspeed while maneuvering in the traffic pattern which resulted in an aerodynamic stall and subsequent spin at a low altitude, which the pilot was unable to recover from.NTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB GAA18CA469Accident · Minor injuriesData collectionFinal reportRans S7 · Kenai, AKThe pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.NTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…NTSB ERA18FA206Accident · 3 fatalField investigationFinal reportPiper PA60 · Greenville, METhe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.