NTSB investigations, MS
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 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 CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…NTSB CEN21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Columbus, MSThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB CEN20LA353Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT602 · Inverness, MSThe pilot’s decision to move the power control lever into beta during flight, which resulted in the power control lever and associated linkage becoming stuck in the beta position.NTSB CEN20CA223Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182J · Olive Branch, MSThe student pilot's improper landing flare and the flight instructor's inadequate supervision, which resulted in a hard landing.NTSB CEN20LA123Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Baxterville, MSThe failure of the No. 1 cylinder intake valve due to inadequate valve seating.NTSB CEN20CA106Accident · No injuriesData collectionFinal reportKitfox 57 Super Sport · Kosciusko, MSThe pilot's lifting off with the airplane at a high of angle of attack, which resulted in aerodynamic stall.NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB CEN20LA036Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7ECA · Starkville, MSThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision not to visually confirm the remaining fuel onboard during the intermediate stop.NTSB ERA20LA047Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Potts Camp, MSThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB CEN19LA334Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Columbus, MSA total loss of engine power control for undetermined reasons.NTSB CEN19TA335Accident · Minor injuriesClass 3Final reportVans RV 4 · De Soto, MSA total loss of engine power due to fuel exhaustion.NTSB CEN19LA244Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Walls, MSThe improper fuel servicing of the airplane, which resulted in water contamination of the airplane's fuel supply and a subsequent loss of engine power.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 CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.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 CEN19LA149Accident · No injuriesClass 3 · LimitedFinal reportChistov Challenger · Raymond, MSA total loss of engine power for undetermined reasons.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 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 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 CEN19TA112Accident · Minor injuriesClass 3Final reportPiper PA28 · Aberdeen, MSThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a collision with a fence and impact with terrain during the attempted aborted landing.NTSB ERA19LA016Accident · Serious injuriesLimited investigationFinal reportSa300 Starduster · Byhalia, MSThe pilot's failure to maintain a proper approach path, which resulted a collision with trees short of the runway.NTSB ERA19LA008Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Stonewall, MSThe fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a fractured camshaft and a total loss of engine power.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.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 ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…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 ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB WPR18LA029Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rolling Fork, MSAn uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.NTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.NTSB ERA17LA314Accident · No injuriesClass 3 · LimitedFinal reportRudder Dwight K Kitfox IV 1200 Spdst · Raymond, MSA total loss of engine power during initial climb for undetermined reasons.NTSB ERA17LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT 402A · Shaw, MSThe pilot’s decision to attempt takeoff at high gross weight, in high density altitude conditions, and with insufficient runway length. Contributing to the accident was the pilot’s inadequate preflight planning.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 GAA17CA492Accident · Minor injuriesData collectionFinal reportCessna 182 · Quitman, MSThe student pilot’s failure to maintain directional control during takeoff in gusting wind conditions after passing a large hill.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 GAA17CA164Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prentiss, MSThe pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB ERA17LA005Accident · No injuriesLimited investigationFinal reportPiper PA28 · Laurel, MSA total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies.NTSB ERA16LA328Accident · No injuriesClass 3 · LimitedFinal reportNorth American T28 · Greenwood, MSA total loss of engine power for undetermined reasons.NTSB GAA16CA414Accident · No injuriesData collectionFinal reportCessna 150 · New Albany, MSThe pilot's failure to maintain an appropriate pitch attitude during landing, which resulted in an initial nose wheel contact, followed by a nose gear collapse, and the airplane came to rest in a nose down position.NTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.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 ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…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 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 GAA16CA025Accident · No injuriesData collectionFinal reportDonham Timothy J RV 6A · Grenada, MSThe pilot's loss of directional control during landing, which resulted in a runway excursion.