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 MIA97LA001Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Jackson, MSthe pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.NTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…NTSB ATL96LA129Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A (Soloy) · Belmont, MSfailure of the aft universal joint of the tail rotor drive shaft, due to inadequate lubrication by company maintenance personnel. A factor relating to the accident was the pilot's delay in discontinuing the flight after noting a progressively worse tail rotor…NTSB ATL96LA126Accident · No injuriesLimited investigationFinal reportCessna 177 · Lyon, MSthe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, which resulted in a ground swerve. The gusty crosswind condition was a related factor.NTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…NTSB MIA96LA219Accident · Serious injuriesLimited investigationFinal reportFlightstar 2SL · Kiln, MSfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.NTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.NTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.NTSB MIA96LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Victoria, MSThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA96LA183Accident · No injuriesLimited investigationFinal reportRockwell S2R · Belzoni, MSfatigue failure of the #5 cylinder skirt, which resulted in debris that caused the oil scavenge pump to fail, oil starvation, cam drive seizure, loss of engine power, and a subsequent forced landing in a field of cotton.NTSB MIA96LA177Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Canton, MSfailure of the pilot to maintain sufficient altitude and/or clearance from the tower.NTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB MIA96LA155Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wayside, MSFailure of the pilot to maintain the proper descent rate at touchdown resulting in collapse of the right main landing gear.NTSB MIA96LA131Accident · No injuriesLimited investigationFinal reportCessna 210M · Meridian, MSprevious engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…NTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…NTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.NTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.NTSB ATL96FA027Accident · 2 fatalField investigationFinal reportPiper J-3-C65 · Belzoni, MSfailure of the student pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin and subsequent collision with the ground.NTSB MIA96LA041Accident · No injuriesLimited investigationFinal reportMckibben GN-1 Aircamper · Mayhew, MSThe pilot's improper planning/decision, and failure to verify the airplane's performance data. The airplane's lack of climb capability with the newly manufactured propeller was a related factor.NTSB MIA96FA035Accident · 3 fatalField investigationFinal reportAerospatiale TB-20 · Meridian, MSthe pilot's failure to maintain airspeed (VSO) while maneuvering during an ILS approach in instrument flight conditions. Factors related to the accident were: the pilot's failure to follow the published approach procedure, his failure to maintain a proper…NTSB MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.NTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.NTSB ATL96FA006Accident · 2 fatalField investigationFinal reportLuscombe 8E · Picayune, MSa worn left magneto distributor gear, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB MIA95LA236Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Union Church, MSinadequate maintenance lubrication and inspection of the main rotor head which resulted in the separation of a rod end bearing.NTSB ATL95FA173Accident · 2 fatalField investigationFinal reportCessna 310P · Lexington, MSthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain control of the aircraft. The weather was a factor.NTSB MIA95LA225Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU-2-22K · Picayune, MSThe pilot-in-command's disregard of a weather forecast and flight into known adverse weather condition (thunderstorm). The thunderstorm, and associated wind gusts, were factors.NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB MIA95LA217Accident · No injuriesLimited investigationFinal reportCessna 337D · Carthage, MSFailure of the normal brake system for undetermined reasons. Contributing to the accident was the failure of the pilot's seatback.NTSB MIA95LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lumberton, MSThe failure of the landing gear, steering system (rod end bolt) due to a bending overstress separation which resulted in loss of directional control.NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.NTSB MIA95LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Aberdeen, MSThe operator's and pilot's procedure of leaving the aircraft unattended with the engine running while loading agricultural chemicals into the aircraft. This resulted in the aircraft moving unattended and colliding with a ditch. Contributing to the accident…NTSB MIA95LA184Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Ruleville, MSThe pilot-in-command's failure to abort the takeoff when the aircraft accelerated slowly. Contributing to the accident was the over loading of the aircraft by ground personnel and the failure of the pilot-in-command to verify the loading of the aircraft.NTSB MIA95LA182Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Goodman, MSThe pilot's failure to maintain flying airspeed which resulted in an aerodynamic stall.NTSB MIA95LA181Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Lambert, MSUnsuitable terrain encountered during the forced landing. Contributing to the accident was the partial loss of engine power due to failure of the no. 4 cylinder intake valve rocker arm bosses.NTSB MIA95LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Winstonville, MSPoor preflight planning/preparation and clearance not maintained by the pilot in command.NTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.NTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB MIA95LA151Accident · No injuriesLimited investigationFinal reportBeech C24R · Houston, MSPartial loss of engine power due to a fuel injector being clogged with carbon. This resulted in a landing on unsuitable terrain.NTSB MIA95LA244Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and/or improper recovery from a bounced landing.NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB MIA95LA123Accident · Serious injuriesLimited investigationFinal reportBeech B95 · Leakesville, MSThe failure of the pilot-in-command to operate the aircraft in accordance with manufacturer's limitations resulting in fuel starvation and a total loss of power in both engines.NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.NTSB MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB MIA95LA096Accident · No injuriesLimited investigationFinal reportCessna 150K · Hattiesburg, MSThe failure of the pilot-in-command to perform a recovery from a bounced landing, resulting in a hard landing and subsequent collapsing of the nose gear.NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.NTSB MIA95LA080Accident · No injuriesLimited investigationFinal reportMooney M20E · Mclain, MSThe improper reassembly of the servo fuel injector during overhaul by maintenance personnel. This resulted in a total loss of engine power during cruise flight due to fuel starvation, forced landing, and subsequent on-ground collision with a fixed object…