NTSB investigations, MS
26 cases where the defining event was Loss of control in flight.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\" = 'MS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240')
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" = 'MS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 CEN26LA317Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Natchez, MSThe pilot’s failure to complete a preflight weight and balance calculation, which resulted in a center of gravity beyond the forward limit, and adversely affected the helicopter’s controllability during takeoff.NTSB CEN26FA093Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Holly Springs, MSOn January 18, 2026, about 1640 central standard time, a Piper PA28-140 airplane, N6711J, was destroyed when it was involved in an accident near Holly Springs, Mississippi. The flight instructor and student pilot were fatally injured. The airplane was…NTSB CEN25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Grenada, MSThe pilot’s loss of airplane control while landing in gusty wind conditions resulting in a hard landing and collapse of the nose landing gear.NTSB CEN24LA352Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Clarksdale, MSThe pilot’s failure to maintain control during takeoff in gusting crosswind conditions.NTSB CEN24LA118Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182P · Charleston, MSThe pilot’s failure to attain/maintain aircraft control during an approach for landing that resulted in an impact with terrain.NTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.NTSB WPR23FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-325 · Tupelo, MSThe pilot's exceedance of the airplane's critical angle of attack while maneuvering after takeoff for reasons that could not be determined, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN21FA209Accident · 4 fatalClass 3 · FieldFinal reportMitsubishi MU2B · Hattiesburg, MSThe pilot’s failure to maintain control of the airplane during the night instrument approach which resulted in an inadvertent aerodynamic stall from which the pilot was unable to recover.NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN19TA205Accident · Serious injuriesClass 3Final reportBeech 23 · Vaiden, MSThe pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…NTSB ERA18FA174Accident · 1 fatalField investigationFinal reportCessna 172 · Diamondhead, MSThe student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA15FA147Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kosciusko, MSThe pilot's decision to make a low pass over a lake near trees and his subsequent failure to maintain airplane control while maneuvering at a low altitude to avoid trees, which resulted in an inadvertent cross-control aerodynamic stall from which he was…NTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.NTSB ERA14LA312Accident · Minor injuriesLimited investigationFinal reportRaytheon C90A · Houston, MSThe pilot’s failure to maintain a stabilized approach and his subsequent failure to maintain airplane control during the landing flare, which resulted in touchdown off the side of the runway and collision with a ditch.NTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.NTSB ERA12CA570Accident · Serious injuriesData collectionFinal reportFly Hard Trike Skycycle Sting RAY · Gulfport, MSThe pilot’s failure to maintain aircraft control after an unexpected wind gust/turbulence encounter during landing.NTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…NTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.NTSB ERA10LA120Accident · 2 fatalLimited investigationFinal reportSteele Samuel D RV-4 · Picayune, MSThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. Contributing to the accident was the overweight and aft-center-of-gravity condition of the airplane at takeoff.NTSB ERA10LA025Accident · Serious injuriesLimited investigationFinal reportArgence Enas A. Christen Eagle · Hernando, MSThe pilot's failure to maintain adequate airspeed during a return to the airport, which resulted in an aerodynamic stall and spin.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB ERA09CA285Accident · No injuriesData collectionFinal reportRichard Rank KitFox 4 · Madison, MSThe pilot’s failure to maintain aircraft control during an aborted formation takeoff.NTSB MIA08CA078Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Columbus, MSThe failure of the pilot to maintain airspeed while maneuvering.