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 MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB MIA90LA149Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Crowder, MSFatigue failure of a bolt which secures the mixture and throttle bellcranks to the bellcrank support assembly.NTSB MIA90LA138Accident · Minor injuriesLimited investigationFinal reportSpezio Sport DAL-1 · Columbus, MSFailure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall and subsequent loss of control. A related factor was: the lack of a stall warning system installed in the aircraft.NTSB MIA90LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, MSThe student pilot landed long and delayed applying power during the ground roll of the touch-and-go landing.NTSB MIA90LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Leland, MSFailure of the pilot to see-and-avoid the power lines.NTSB MIA90LA123Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Biloxi, MSThe passenger's intentional act of jumping in the air with his arm raised while under the main rotor.NTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB MIA90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jackson, MSThe pilot's improper compensation for the cross-wind.NTSB MIA90LA099Accident · No injuriesLimited investigationFinal reportCessna P210N · Natchez, MSThe late extension of the landing gear by the pilot.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.NTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.NTSB MIA90LA057Accident · No injuriesLimited investigationFinal reportBeech 400 · West Point, MSThe pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.NTSB MIA90FA046Accident · 1 fatalField investigationFinal reportCessna 172N · Meridian, MSIn flight loss of control by the pilot while flying in instrument meteorological conditions. Contributing factor(s) was: the pilot's apprehension toward instrument flying and the adverse weather conditions that existed at the time.NTSB MIA90FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Columbia, MSSuicide. The pilot's emotional state of distress was a related factor.NTSB MIA90LA011Accident · No injuriesLimited investigationFinal reportBeech 58P · Jackson, MSThe pilot's misunderstanding of the landing gear emergency extension procedure, which resulted in his inadvertent partial retraction of the gear and failure to land with the gear in the down and locked position. Loss of electrical power was a factor.NTSB MIA89LA255Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Lexington, MSFatigue failure of the linear actuator lug. A related factor was: trees in the emergency landing area.NTSB MIA89IA247Incident · No injuriesIncident investigationFinal reportBeech G18S · Jackson, MSFailure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.NTSB MIA89LA241Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Booneville, MSLoss of engine power for an unknown reason. Trees in the emergency landing area were a factor.NTSB MIA89LA238Accident · No injuriesLimited investigationFinal reportCessna 177 · Woodville, MSImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.NTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.NTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB MIA89LA224Accident · No injuriesLimited investigationFinal reportBeech 18 · Greenwood, MSInadvertent wheels up landing by the pilot.NTSB MIA89LA221Accident · Serious injuriesLimited investigationFinal reportContinental Copters Tomcat MK6C · Quitman, MSFailure of the tail boom attachment.NTSB MIA89FA219Accident · 2 fatalField investigationFinal reportCessna 177RG · Janice, MSThe in flight loss of control by the non instrument rated pilot after encountering instrument meteorological conditions resulting in the airplane spiraling into a wooded area.NTSB MIA89LA215Accident · No injuriesLimited investigationFinal reportCessna 188 · Canton, MSThe pilot's attempted flight in known adverse weather conditions. Factors related to the accident were: adverse weather conditions and the presence of the parked aircraft near the runway.NTSB MIA89LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ackerman, MSThe pilot's selection of the wrong runway and his improper inflight planning/decision which resulted in a situation from which he could neither go-around nor stop on the remaining runway. The thunderstorms, inoperative (disrepaired) wind sock, and rough…NTSB MIA89LA206Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Ms State Univ, MSImproper in-flight planning/decison by the pilot. Contributing factors were: failure of the tow vehicle driver to use/maintain the proper speed, the pilot's lack of total flying experience, and high vegetation (uncut hay).NTSB MIA89LA204Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Greenwood, MSFailure of a main rotor blade pitch change horn and/or attaching bolt(s).NTSB MIA89LA203Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schlater, MSInadequate preflight planning/preparation by the pilot which resulted in the selection of the wrong runway. The tailwindand dirt bank were considered to be contributing factors.NTSB MIA89LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Forest, MSFailure of the pilot to maintain runway alignment and partial loss of power from water in the fuel. Contributing factors were: uneven runway, pilot's improper recovery from a bounced landing, a gusty crosswind condition, and trees.NTSB MIA89LA196Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Minter City, MSFailure of the pilot to see and avoid the powerline. The power line was a contributing factor.NTSB MIA89LA182Accident · No injuriesLimited investigationFinal reportCessna T188C · Hollandale, MSThe failure of the turbocharger due to an improperly installed retaining nut. The soft/wet terrain was a contributing factor.NTSB MIA89FA178Accident · 1 fatalField investigationFinal reportBeech A36 · Shelby, MSFailure of the pilot to maintain adequate airspeed while maneuvering back to the runway which resulted in an inadvertentstall. Contributing factors were: failure of the pilot to insure the cabin door (on the passenger's side) was properlyclosed and secured…NTSB MIA89LA171Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Picayune, MSInadequate preflight by the pilot and his miscalculation of fuel, which resulted in fuel starvation from lack of fuel; and the pilot's failure to see-and-avoid the power lines during the forced landing. The power lines were a contributing factor.NTSB MIA89LA168Accident · No injuriesLimited investigationFinal reportBeech A24R · Gulfport, MSFailure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.NTSB MIA89FA164Accident · Serious injuriesField investigationFinal reportAir Tractor AT-401 · Clarksdale, MSThe pilot failed to maintain airspeed resulting in the airplane stalling and descending out of control.NTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.NTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB MIA89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Olive Branch, MSFuel exhaustion caused by the pilot exceeding the fuel endurance of the airplane.NTSB MIA89LA120Accident · No injuriesLimited investigationFinal reportCessna 172M · Columbia, MSThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. A factor related to the accident was: the gusty/crosswind condition.NTSB MIA89LA114Accident · Minor injuriesLimited investigationFinal reportDyar KIT FOX · Purvis, MSFailure of the engine's rear piston. Factors related to the accident were: the pilot's lack of altitude for a forced landing and trees in the emergency landing area.NTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.NTSB MIA89LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and ditch were contributing factors.NTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.NTSB MIA89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Rose Hill, MSLoss of electrical power for an undetermined reason and fuel starvation from improper use of the fuel selector. Factors related to the accident were: night and adverse weather conditions.NTSB MIA89LA062Accident · No injuriesLimited investigationFinal reportCessna 210L · Greenwood, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.