Fatal NTSB investigations, MS
30 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 3 |
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\" = 'MS' 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\" = '470' 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" = 'MS' 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" = '470' 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 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 CEN19FA138Accident · 1 fatalClass 2 · FieldFinal reportChampion 7GCAA · Schlater, MSThe pilot's failure to maintain the proper airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a stall.NTSB CEN19FA119Accident · 3 fatalClass 2 · FieldFinal reportRockwell International NA-265-65 · New Albany, MSAn unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.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 ERA18FA088Accident · 1 fatalField investigationFinal reportAir Tractor AT-802 · Greenwood, MSThe pilot's failure to maintain clearance from a tree for reasons that could not be determined based on the available evidence.NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.NTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.NTSB ERA17FA131Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Minter City, MSThe pilot's incapacitation for reasons that could not be determined, which resulted in collision with trees and terrain.NTSB ERA16FA185Accident · 4 fatalField investigationFinal reportBeech A36TC · Tupelo, MSA preexisting stress rupture that initiated at a spot weld in the turbocharger v-band exhaust clamp, which resulted in the failure of the clamp and separation of the exhaust tailpipe, an in-flight fire, and subsequent impact with terrain.NTSB ERA16LA028Accident · 3 fatalLimited investigationFinal reportSchumacher Lancair Super ES · Pascagoula, MSThe pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather.NTSB ERA15FA173Accident · 2 fatalField investigationFinal reportBell Helicopter Textron 206 L-1 · Saucier, MSA loss of engine power for reasons that could not be determined due to postaccident fire damage.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 ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…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 ERA13FA055Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Jackson, MSThe pilot's inadequate preflight inspection, which resulted in his failure to note the water in the fuel tank due to condensation, which subsequently shut down the engine in flight. Contributing to the accident was the pilot's self-induced pressure to…NTSB ERA12FA433Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · New Site, MSThe pilot's decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.NTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…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 ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…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 ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB ERA10LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Canton, MSThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin.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 ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB ERA09LA316Accident · 2 fatalLimited investigationFinal reportRick Campbell Zenith-STOL CH801 · Gallman, MSA total loss of engine power due to fuel starvation as a result of the flightcrew's improper fuel management.NTSB ERA09LA128Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Philadelphia, MSThe pilot's improper preflight weather planning and his continued VFR flight into IMC conditions resulting in an in-flight collision with trees.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.