NTSB investigations, MS
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MIA00LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Belzoni, MSThe pilot's failure to refuel prior to departure resulting in loss of engine power due to fuel exhaustion.NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.NTSB ATL00FA061Accident · 2 fatalField investigationFinal reportCessna 150G · Oxford, MSThe certified flight instructor's failure to maintain airspeed during climbout.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.NTSB MIA00LA150Accident · No injuriesLimited investigationFinal reportCessna 172H · Picayune, MSAn in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.NTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.NTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.NTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…NTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.NTSB ATL00LA015Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Iuka, MSThe separation of the nicopress fitting allowing a release of the rudder cable resulting in a loss of control during landing roll. A factor was the manufacturer's use of an improperly calibrated crimping tool.NTSB MIA00FA048Accident · 1 fatalField investigationFinal reportCessna U-3A · Brooksville, MSThe in-flight loss of control for undetermined reasons resulting in the collision with terrain.NTSB MIA00FA030Accident · 2 fatalField investigationFinal reportBell 212 · Philadelphia, MSThe failure of the pilot and company maintenance personnel during preflight and periodic inspections to identify the signs of fretting and looseness in the "red" main rotor blade pitch change horn to main rotor blade grip attachment, resulting in the…NTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.NTSB MIA00LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Olive Branch, MSThe private-rated student pilots inadvertent retraction of the main landing gear during a touch-and-go landing. Contributing to the accident was the flight instructors improper supervision of the dual student.NTSB ATL00LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Bay Springs, MSThe pilot's failure to maintain flying speed that resulted in a loss of control and stall. A factor was a stuck exhaust valve.NTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.NTSB MIA99FA269Accident · 1 fatalField investigationFinal reportPiper PA-31P · Louisville, MSThe pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.NTSB MIA99LA266Accident · No injuriesLimited investigationFinal reportCessna A188B · South Oxford, MSthe pilot's improper use of the brakes during the landing rollout.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB ATL99LA129Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Caledonia, MSThe failure of the fuel control gear train due to oil contamination. A factor was Inadequate maintenance.NTSB ATL99LA131Accident · Minor injuriesLimited investigationFinal reportHiller UH-12A · Satartia, MSThe pilot's failure to maintain control of the helicopter while on approach which resulted in the uncontrolled collision with the ground. A factor was the pilot's physiological condition.NTSB ATL99FA127Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Carthage, MSThe pilot-in-command's failure to maintain altitude clearance while maneuvering. A factor was the pine trees.NTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.NTSB ATL99LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, MSThe pilot's failure to switch the magneto switch to the both position before attempting a takeoff that resulted in the loss of engine power and resulted in the subsequent collision with trees.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.NTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.NTSB MIA99LA205Accident · No injuriesLimited investigationFinal reportCessna R172K · Pontotoc, MSa complete loss of engine power due to the failure of the oil pressure pump, resulting in oil starvation, a forced landing and subsequent nose over.NTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…NTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.NTSB ATL99LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Panther Burn, MSThe pilot's failure to maintain clearance that resulted in the in-flight collision with trees. A factor was his diverted attention following the failure of the DGPS.NTSB ATL99LA101Accident · No injuriesLimited investigationFinal reportCessna A188B · Glen Allan, MSThe improper installation of a nut and bolt assembly by a maintenance personnel that resulted in the in-flight loss of control of the left ailiron.NTSB MIA99LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Rolling Fork, MSImproper torqueing of the connecting rod bolts which resulted in the bolts being loose and rubbing in the dowel area which resulted in fatigue emanation and cracking and separation of the number 3 connecting rod after bolt failure.NTSB MIA99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jackson, MSThe loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.NTSB MIA99LA157Accident · Serious injuriesLimited investigationFinal reportCessna A-188B · Anguilla, MSThe pilot's inadequate management of the fuel supply which led to fuel exhaustion and subsequent loss of engine power.NTSB ATL99LA087Accident · No injuriesLimited investigationFinal reportCessna T188C · Bruce, MSThe loss of lubrication to the number 2 connecting rod due to the shifted bearing that resulted in the total loss of engine power.NTSB ATL99LA085Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Louisville, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB ATL99LA084Accident · No injuriesLimited investigationFinal reportCessna 195A · Tupelo, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop/swerve and subsequent nose over.NTSB ATL99FA081Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Vicksburg, MSThe pilot's failure to obtain and maintain flying speed that resulted in an inadvertent stall, and the collision with trees. A factor is the dark night.NTSB MIA99LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Picayune, MSThe failure of the pilot to recover from the bounced landing resulting in collapse of the nose landing gear. A finding in the accident was the crosswind weather condition that existed at the time of the accident.NTSB MIA99LA133Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Thomastown, MSAn in-flight loss of control caused by the main rotor severing the tail rotor drive shaft as a result of the pilot's cyclic pull-up into a tailwind for his second approach and landing. The loss of the tail rotor caused an uncontrollable descent and tree…NTSB MIA99LA131Accident · 1 fatalLimited investigationFinal reportPiper J-3C · Jackson, MSThe failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…NTSB ATL99LA055Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Bay Springs, MSThe fuel control drive bearing failure at the intermediate gear resulted in fuel starvation and the subsequent loss of engine power.NTSB MIA99LA088Accident · No injuriesLimited investigationFinal reportBeech K35 · Gulfport, MSA loss of engine power due to fuel starvation caused by an obstruction in the fuel vent system while maneuvering in IMC conditions, and the subsequent ditching into the Gulf of Mexico.NTSB MIA99LA083Accident · No injuriesLimited investigationFinal reportBeech A24R · Philadelphia, MSThe failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB ATL99LA043Accident · Minor injuriesLimited investigationFinal reportTrohoski VARI-EZE · Tupelo, MSThe pilot's improper flare and compensation for wind conditions upon landing. Factors in the accident were the pilot's inadequate recurrent training and lack of experience with the airplane.NTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.