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 MIA93LA003Accident · 2 fatalLimited investigationFinal reportMcilraith Steen Skybolt · Hattiesburg, MSA loss of control for undetermined reasons.NTSB MIA92LA185Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Picayune, MSThe pilot in command's failure to maintain airspeed (vso) while conducting slow flight at a low altitude. This resulted in an in flight loss of control (stall) and subsequent in flight collision with trees.NTSB MIA92LA184Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Poplarville, MSA reported loss of engine power for undetermined reasons resulting in a forced landing and in flight collision with trees.NTSB MIA92LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Belzoni, MSCollapse of the right main landing gear tire due to undetermined reasons.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB MIA92FA174Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Inverness, MSThe failure of the pilot in command to maintain airspeed above stall airspeed resulting in the aircraft stalling and entering a spin from which it descended uncontrolled to the ground.NTSB MIA92LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Hernando, MSThe failure of the pilot in command to compensate for the crosswind condition, resulting in a ground loop. Contributing to the accident was the pilot's lack of experience in the type of aircraft.NTSB MIA92LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Long Beach, MSImproper collective and cyclic control input by the pilot-in-command during the forced landing following total loss of engine power due to undetermined reasons.NTSB MIA92FA173Accident · 2 fatalField investigationFinal reportBeech BE-A23-19 · Picayune, MSThe failure of the pilot in command to place the fuel selector on the fullest tank, resulting in an engine failure due to fuel starvation over unsuitable terrain.NTSB MIA92LA169Accident · No injuriesLimited investigationFinal reportCessna 425 · Greenwood, MSFailure of the pilot-in-command to maintain his descent rate resulting in an undershoot. Contributing to the accident was the chip detector failure due to improper quality control by the manufacturer.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB MIA92LA102Accident · Minor injuriesLimited investigationFinal reportBell 47-D-1 · Fayette, MSThe pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.NTSB MIA92FA099Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Aberdeen, MSThe pilot-in-command's decision to initiate a turn back to the airport at a low altitude following loss of engine power.NTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.NTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.NTSB MIA92LA097Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Church Hill, MSThe pilot's failure to clear his engine during descent resulting in the spark plugs becoming fouled which resulted in loss of engine power.NTSB MIA92LA076Accident · Minor injuriesLimited investigationFinal reportAero Mercantil Gavilan 358 EL-1 · Columbus, MSFatigue failure of the crankshaft due to improper engine assembly by the manufacturer.NTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.NTSB MIA92LA054Accident · 1 fatalLimited investigationFinal reportSmith/Davis DA-2A · Holly Springs, MSThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB MIA92LA015Accident · No injuriesLimited investigationFinal reportRockwell 685 · Tupelo, MSThe pilot in commands failure to insure that adequate fuel was placed on the aircraft for the flight resulting in loss of power in both engines due to fuel exhaustion.NTSB MIA92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tylertown, MSOil fouling of the windshield due to a loose engine oil seal. A factor was the pilot's preexisting vision impairment.NTSB MIA91LA220Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Bay Springs, MSTotal loss of engine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encountered during the forced landing.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB MIA91LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Yazoo City, MSSeparation of the right main landing gear during take off due to failure of the bolts which secure the gear to the airframe. Contributing to the accident was the failure of the pilot to abort the takeoff.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.NTSB MIA91LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Tunica, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The quartering crosswind and soft terrain were related factors.NTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.NTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.NTSB MIA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Meridian, MSLoss of power from the right engine due to undetermined reasons. The failure of the propeller to feather was a factor in the accident.NTSB MIA91LA185Accident · 1 fatalLimited investigationFinal reportDonald R. Lee AIR Command · Quitman, MSThe pilot in commands failure to maintain control resulting in an uncontrolled descent and an in flight collision with terrain.NTSB MIA91LA184Accident · No injuriesLimited investigationFinal reportCessna 120 · Pocahontas, MSPartial loss of engine power due to undetermined reasons and in-flight collision with a power line during an emergency descent for a forced landing.NTSB MIA91LA170Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Falcon, MSIn flight encounter with weather, high density altitude. Contributing to the accident was aircraft gross weight which was exceeded.NTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.NTSB MIA91LA177Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Bay Saint Louis, MSLoss of control in flight due to premature flare by the pilot resulting in inadvertent stall/mush, and failure of the pilot to recover from the bounced landing.NTSB MIA91LA167Accident · No injuriesLimited investigationFinal reportSwearingen SA227-TT · Tupelo, MSThe improper installation of the nose steering actuator arming valve by a mechanic which resulted in failure of the actuator and on ground loss of directional control by the pilot during landing rollout.NTSB MIA91LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Doddsville, MSPoor planning decision by the pilot for failure to take into account the temperature extremes and what effect this would have on the ground roll distance. Contributing to the accident was his lack of total experience in the type of operation.NTSB MIA91LA163Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Greenville, MSLoss of engine power due to a cracked cylinder and the pilot's inadvertent stall.NTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.NTSB MIA91LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Yazoo City, MSPoor planning decision by the student pilot, improper fuel calculations, resulting in fuel exhaustion due to an inadequate fuel supply. Contributing to the accident was overconfidence in his own personal ability by the student pilot.NTSB MIA91LA108Accident · Minor injuriesLimited investigationFinal reportGlassair SH-2TD · Bay St. Louis, MSThe loss of power due to vapor lock of the fuel system on takeoff. Contributing to the cause of the accident was the improper decision of the pilot-in-command to attempt to take off with known deficiencies in the airplane.NTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB MIA91LA097Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hattiesburg, MSOn ground encounter with a wind gust and failure of the pilot to maintain directional control of the airplane during the landing roll, resulting in the collision with a ravineNTSB MIA91LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greenwood, MSFailure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…NTSB MIA91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Inverness, MSThe student pilot's failure to refuel the airplane. Factors were: uel exhaustion, the pilot's lack of total aeronautical experience, and soft terrain.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.NTSB MIA90LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Hattiesburg, MSFailure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.