Fatal NTSB investigations, NC
19 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2017 | 2 |
| 2019 | 2 |
| 2021 | 4 |
| 2023 | 1 |
| 2024 | 1 |
Where
Latest 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\" = 'NC' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'NC' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA23FA194Accident · 1 fatalClass 3 · FieldFinal reportHolland Travis E Velocity · Andrews, NCThe pilot’s failure to engage the turbocharger for takeoff and his improper decision to continue the takeoff with partial power, rather than reject the takeoff.NTSB ERA22FA024Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Holly Ridge, NCThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall/mush during takeoff and initial climb. Contributing to the accident was the pilot’s loading the airplane near its maximum allowable gross weight and near its aft cg…NTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.NTSB ERA21FA257Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-402B · Kinston, NCThe pilot’s decision to conduct low-level aerobatic maneuvers in an airplane not approved for aerobatic flight, which resulted in an aerodynamic stall and spin, a loss of control, and an impact with terrain.NTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.NTSB ERA20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Cameron, NCThe pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…NTSB ERA19FA200Accident · 2 fatalClass 2 · FieldFinal reportRans S6 · Fletcher, NCThe exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.NTSB ERA18LA048Accident · 1 fatalLimited investigationFinal reportCessna 150 · Castalia, NCThe pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…NTSB ERA17FA123Accident · 1 fatalField investigationFinal reportJordan Bruce C Pitts S2E · Apex, NCThe pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB ERA15FA340Accident · 3 fatalField investigationFinal reportBeech A36 · Kernersville, NCThe pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…NTSB ERA15LA231Accident · 1 fatalLimited investigationFinal reportBeech A36 · Siler City, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.NTSB ERA15FA023Accident · 1 fatalField investigationFinal reportBeech D95 · Bahama, NCThe pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…NTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.NTSB ERA12FA256Accident · 1 fatalField investigationFinal reportAnderson John H Avid Flyer MK 4 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed during an attempted go-around, which resulted in a low-altitude aerodynamic stall.NTSB ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.NTSB MIA08FA081Accident · 1 fatalField investigationFinal reportCirrus SR22 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the tailwind.NTSB NYC08MA090Accident · 6 fatalMajor investigationFinal reportRaytheon C90A · Mount Airy, NCThe pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…