NTSB investigations, MS
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…NTSB ERA12CA128Accident · No injuriesData collectionFinal reportMitsubishi MU-2B-20 · Picayune, MSThe pilot's excessive rate of descent during the landing flare/touchdown, which resulted in a hard landing.NTSB ERA12CA079Accident · No injuriesData collectionFinal reportBeech C-45G · Lyman, MSThe collapse of the right main landing gear during landing due to an encounter with soft terrain.NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.NTSB ERA12CA029Accident · No injuriesData collectionFinal reportCessna 180H · Houston, MSThe pilot did not maintain directional control during the landing roll.NTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…NTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.NTSB ERA11CA407Accident · No injuriesData collectionFinal reportCessna 180J · Schlater, MSThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB ERA11LA370Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holly Springs, MSThe pilot's incorrect positioning of the fuel tank selector before takeoff, which resulted in a loss of engine power due to fuel starvation during takeoff initial climb.NTSB OPS11IA673Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145EP · Gulfport, MSthe Gulfport control tower local controller cleared two aircraft for takeoff from runways with intersecting departure flight paths without ensuring the first aircraft had passed the flight path intersection prior to clearing the second aircraft for takeoff.NTSB ERA11CA341Accident · Minor injuriesData collectionFinal reportCessna 182K · Bentonia, MSThe pilot’s loss of control on the ground during engine start, which resulted in a collision with nearby equipment. Contributing to the accident was the pilot’s improper engine start procedure and improper securing of the seat.NTSB ERA11LA298Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Greenwood, MSA partial loss of engine power during low-altitude maneuvering for undetermined reasons.NTSB DCA11FA052Accident · No injuriesField investigationFinal reportBoeing 737 · Greenville, MSThe failure of a utility pipe beneath the ramp surface, which caused a localized void in the soil and resulting reduction in the load bearing capability of the ramp.NTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.NTSB ERA11LA224Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Greenwood, MSThe pilot did not obtain the proper touchdown point as a result of his decision to shut down the engine and to deploy the landing gear and flaps before the landing was assured. Contributing to the accident was his decision to overfly a closer suitable airport…NTSB ERA11LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe airplane's overweight condition due to the pilot's improper weight and balance calculation that resulted in the airplane's inability to maintain altitude.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB ERA10LA499Accident · Serious injuriesLimited investigationFinal reportBell OH-58A · Taylorsville, MSA total loss of engine power while maneuvering at low altitude for undetermined reasons.NTSB DCA10LA083Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170 100 SE · Summit, MSthe abrupt maneuver that was appropriately initiated to comply with the TCAS resolution advisory caused by the momentary projected loss of separation from converging traffic. Contributing to the accident was a passenger's decision to disregard the seatbelt…NTSB ERA10LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Canton, MSThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin.NTSB ERA10LA376Accident · No injuriesLimited investigationFinal reportBeech K35 · Philadelphia, MSA throttle control malfunction during landing for undetermined reasons, resulting in a runway overrun.NTSB ERA10LA306Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lucedale, MSThe partial separation of the No. 3 cylinder due to improper torquing of the cylinder hold-down bolts by maintenance personnel during installation of the cylinder.NTSB ERA10LA120Accident · 2 fatalLimited investigationFinal reportSteele Samuel D RV-4 · Picayune, MSThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. Contributing to the accident was the overweight and aft-center-of-gravity condition of the airplane at takeoff.NTSB ERA10LA059Accident · No injuriesLimited investigationFinal reportCessna A188B · Ripley, MSThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to water in the fuel.NTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.NTSB ERA10LA025Accident · Serious injuriesLimited investigationFinal reportArgence Enas A. Christen Eagle · Hernando, MSThe pilot's failure to maintain adequate airspeed during a return to the airport, which resulted in an aerodynamic stall and spin.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB ERA09LA431Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502 · Minter City, MSThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, resulting in an aerodynamic stall.NTSB ERA09CA428Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Dundee, MSThe pilot's failure to maintain aircraft control during takeoff.NTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.NTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.NTSB ERA09LA346Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Magee, MSA total loss of engine power after takeoff for undetermined reasons.NTSB ERA09LA316Accident · 2 fatalLimited investigationFinal reportRick Campbell Zenith-STOL CH801 · Gallman, MSA total loss of engine power due to fuel starvation as a result of the flightcrew's improper fuel management.NTSB ERA09CA294Accident · No injuriesData collectionFinal reportCessna R182 · Collins, MSThe pilot’s failure to maintain clearance from an antenna during a low-altitude aerial observation flight. Contributing to the accident was the sun glare.NTSB ERA09CA285Accident · No injuriesData collectionFinal reportRichard Rank KitFox 4 · Madison, MSThe pilot’s failure to maintain aircraft control during an aborted formation takeoff.NTSB ERA09CA265Accident · Minor injuriesData collectionFinal reportCessna 172E · Como, MSThe pilot's inadequate recovery from a bounced landing.NTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.NTSB ERA09LA208Accident · No injuriesLimited investigationFinal reportCessna 150E · Columbia, MSA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight fuel planning.NTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.NTSB ERA09CA195Accident · No injuriesData collectionFinal reportCessna 172P · Cleveland, MSThe inadvertent encounter with a bird in flight.NTSB ERA09LA128Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Philadelphia, MSThe pilot's improper preflight weather planning and his continued VFR flight into IMC conditions resulting in an in-flight collision with trees.NTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.NTSB NYC08CA303Accident · No injuriesData collectionFinal reportCessna 172 · Newton, MSThe pilot's failure to maintain aircraft control while landing.NTSB MIA08LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksdale, MSThe mechanic’s failure to torque check the axle-to-spring gear attachment bolts per the manufacturer's Annual/100-Hour Airframe Inspection Checklist, resulting in fatigue failure of the bolts.NTSB MIA08CA170Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Satartia, MSThe pilot's inadequate visual lookout resulting in the in-flight collision with a 40-foot-tall antenna.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.NTSB NYC08CA279Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Tunica, MSThe pilot's failure to maintain clearance from the power lines during low-altitude maneuvers.