NTSB investigations, MS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MIA95LA073Accident · Serious injuriesLimited investigationFinal reportRoy Long EZ · Columbus, MSThe pilot's inadequate preflight inspection of the fuel system. This resulted in a total loss of engine power in cruise flight, due to fuel contamination, forced landing, and subsequent in- flight collision with trees and terrain.NTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.NTSB MIA95LA058Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Natchez, MSInadequate preflight of the helicopter by the pilot for his failure to separate the dolly before attempting flight.NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.NTSB MIA95LA015Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Madison, MSThe pilots improper use of brakes during a precautionary landing.NTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.NTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…NTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.NTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.NTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.NTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.NTSB MIA94LA188Accident · Minor injuriesLimited investigationFinal reportPiper J5C · Yazoo City, MSPartial blockage of the carburetor by a wasp nest, which was not visible during preflight, and which resulted in the loss of power.NTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB MIA94LA162Accident · 1 fatalLimited investigationFinal reportStolte Deuce · Prentiss, MSFailure of the pilot to maintain proper altitude while performing an aerobatic maneuver and recovering from a spin. Factors related to the accident were: the pilot's failure to follow procedures/directives, lack of formal training in aerobatic flight, and…NTSB MIA94LA159Accident · 1 fatalLimited investigationFinal reportHruby Cayuse · Bay St. Louis, MSThe pilot-in-command's attempt to continue the takeoff when the engine was not producing full power and his attempt to reverse course to return to the airport without sufficient altitude to complete the turn.NTSB MIA94LA108Accident · No injuriesLimited investigationFinal reportCessna 170 · Olive Branch, MSFailure of the pilot-in-command to apply carburetor heat before reducing engine power to descend resulting in the partial loss of engine power due to carburetor ice. Contributing to the accident was the unsuitable terrain encountered during the forced landing…NTSB MIA94FA085Accident · 1 fatalField investigationFinal reportDaffron, Harold C. Varieze · Oxford, MSPoor planning/decision by the pilot-in-command for failure to perform high and low speed taxi tests before the flight after repairs and modification of the airplane. Additionally, failure or malfunction of the flight control system for undetermined reasons,…NTSB MIA94LA073Accident · No injuriesLimited investigationFinal reportCessna 150L · Ocean Springs, MSThe loss of engine power for undetermined reasons.NTSB MIA94FA069Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Vicksburg, MSFailure of the pilot-in-command to maintain the proper glidepath while on a straight in approach resulting in the inflight collision with trees short of the runway. Contributing to the accident was the dark night condition.NTSB MIA94FA064Accident · 2 fatalField investigationFinal reportCessna T210M · Prentiss, MSA total loss of engine power due to the number five piston crown structure sustaining detonation/pre-ignition damage for undetermined reasons. The number two connecting rod and rod bolts failed due to an oil distress event. This resulted in a subsequent…NTSB MIA94FA058Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pontotoc, MSThe pilot in command's failure to maintain altitude while manuevering resulting in the aircraft colliding with trees and then the ground.NTSB MIA94LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Raymond, MSThe pilot-in-command's delay in identifying carburetor ice and improper use of carburetor heat.NTSB MIA94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vicksburg, MSThe pilot did not maintain the proper glidepath. Failure of the electrical system and inadequate maintenance by company maintenance personnel were factors in the accident.NTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.NTSB MIA94LA027Accident · 1 fatalLimited investigationFinal reportThompson Bushby Mustang II · Madison, MSAn engine failure for undetermined reasons.NTSB MIA94LA004Accident · Serious injuriesLimited investigationFinal reportEhlers Lancair 320 · Bay St. Louis, MSThe pilot-in-command's failure to maintain airspeed resulting in an in flight loss of control (stall/spin) and subsequent in flight collision with trees and terrain.NTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.NTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…NTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB MIA93LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rome, MSLoss of engine power for an undetermined reason. A factor related to the accident was: failure of the pilot to use all available runway for takeoff.NTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.NTSB MIA93LA169Accident · No injuriesLimited investigationFinal reportAyres S2R-T15 · Louise, MSThe pilot in commands decision to takeoff from a road with a left quartering tailwind which resulted in his loosing directional control and the aircraft colliding with a utility pole.NTSB MIA93LA165Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Columbus, MSThe pilot-in-command's improper decision to turn the fuel selector off prematurely during his attempted landing.NTSB MIA93FA156Accident · 1 fatalField investigationFinal reportMooney M20-J · Jackson, MSA power loss for undetermined reasons during takeoff, the failure of the pilot-in-command to abort the takeoff, and his improper decision to turn back to the airport when there was suitable terrain ahead for the forced landing.NTSB MIA93LA151Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Magee, MSInstallation of an incorrect oil filter adapter plate stud which secures the plate to the accessory case.NTSB MIA93LA136Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Laurel, MSA ruptured center bellows seal in the fuel servo and/or a plugged fuel injector due to contamination (rust) from the fuel servo. Factors related to the accident were: improper servicing of the aircraft, and people and trees in the emergency landing area.NTSB MIA93LA134Accident · No injuriesLimited investigationFinal reportCessna 182P · Corinth, MSFailure of the engine over terrain unsuitable for a forced landing. Contributing to the accident was the failure of the no. 5 piston for undetermined causes.NTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB MIA93LA130Accident · 2 fatalLimited investigationFinal reportSmith FW2C80TD · Lucedale, MSThe pilot in command's operation of the aircraft in a manner which exceeded design limitations which resulted in inflight failure and separation of the wings.NTSB MIA93LA107Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Starkville, MSThe pilot-in-command's failure to refuel the airplane, resulting in a total loss of engine power due to fuel exhaustion, resulting in a forced landing and in-flight collision with trees and terrain.NTSB MIA93LA101Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Iuka, MSThe pilot's improper recovery from a bounced landing and the subsequent loss of control due to a stall/mush condition. Contributing to the accident was the pilot's lack of total experience.NTSB MIA93LA099Accident · 1 fatalLimited investigationFinal reportKojima, Jun Lewis Cavalier · Dekalb, MSFailure of the pilot-in-command to maintain adequate airspeed resulting in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command in the type operation.NTSB MIA93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Walls, MSThe pilot-in-command's delay in aborting the landing.NTSB MIA93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Madison, MSInduction air control/system partial failure, induction air control/system leak, and the lack of suitable terrain for the forced landing.NTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.NTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.NTSB MIA93LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Pascagoula, MSLoss of engine power due to undetected foreign matter contamination of the engine fuel control. The lack of a suitable landing area was a facotr in the accident.NTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…NTSB MIA93LA017Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Wiggins, MSThe pilot in command's failure to maintain directional control on landing roll out, resulting in an on ground loss of control (ground loop) and subsequent nose over.