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 MIA05LA108Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe inadequate maintenance inspection by maintenance personnel which resulted in damaged landing gear pulleys, resulting in the failure of the landing gear downlock to engage, and collapse of the main landing gear during landing.NTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB SEA05LA077Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tupelo, MSA loss of engine power due to the inadequate in-flight planning and the pilot's failure to refuel the airplane resulting in fuel exhaustion.NTSB ATL05FA061Accident · No injuriesField investigationFinal reportCanadair CL-600 · Tupelo, MSThe inadequate design of the microphone jack assembly Supplemental Type Certificate by production design personnel resulting in the aft restriction of the control column at rotation airspeed, aborted takeoff, and collapse of the nose gear on the overrun.NTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB MIA05LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Avon, MSThe pilot's failure to maintain airspeed while maneuvering at a low altitude, resulting in an inadvertent stall/mush, and impact with terrain.NTSB MIA05LA059Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Brookhaven, MSThe pilot's inadequate compensation for wind and his failure to maintain control of the airplane during landing, which resulted in the airplane ground looping.NTSB ANC05LA033Accident · 2 fatalLimited investigationFinal reportTwente Pitts Model 12 · Marion, MSThe pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…NTSB ANC05LA029Accident · No injuriesLimited investigationFinal reportBeech A36 · Bay St. Louis, MSThe pilot's failure to use the manual emergency landing gear extension mechanism during the approach to land, which resulted in the electrically actuated main landing gear collapsing during the landing roll. A factor associated with the accident is an…NTSB MIA05CA051Accident · No injuriesData collectionFinal reportRobinson R22 · Gulf Port, MSThe student pilot's inadequate flare and his failure to maintain rotor rpm which resulted in a hard landing. Also causal was the instructor's inadequate supervision of the flight.NTSB ATL05FA038Accident · 1 fatalField investigationFinal reportAerospatiale AS350-D · Falkner, MSThe pilot's improper decision to attempt VFR flight into known instrument flight conditions and failure to maintain altitude clearance resulted in an in-flight collision with trees and the ground.NTSB MIA05CA041Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Holly Springs, MSThe failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.NTSB MIA05FA035Accident · 2 fatalField investigationFinal reportCessna 195 · Kilmichael, MSThe pilot's ostentatious display, flying at low altitude, resulting in collision with a static wire power line, in-flight loss of control, and collision with terrain. A factor in the accident was sun glare.NTSB MIA05CA047Accident · No injuriesData collectionFinal reportCessna TR182 · Vicksburg, MSThe pilot's failure to extend the landing gear which resulted in a wheels up landing. A contributing factor is the pilot's failure to complete the checklist.NTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB MIA05CA006Accident · No injuriesData collectionFinal reportSchweizer 269C · Diamond Head, MSThe pilot's inadvertent loss of tail rotor effectiveness during takeoff to a hover and aborted landing in a grass area resulting in the grass catching fire from the engine exhaust and the helicopter being consumed by fire.NTSB MIA04LA129Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Starkville, MSThe operator's inadequate maintenance inspections and the pilot's inadequate preflight inspection, which resulted in the helicopter being operated with a contaminated fuel system, that resulted in fuel starvation, and the loss of engine power.NTSB MIA04CA130Accident · No injuriesData collectionFinal reportLemuel May Leza-Lockwood Aircam · Ashland, MSThe pilot's inadequate preflight planning/preparation for his failure to assure that the fuel shutoff valves located in both engine compartments were turned on and also the failure of the pilot to have a checklist to outline preflight items.NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.NTSB MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.NTSB MIA04CA090Accident · No injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. A-21 · Starkville, MSThe pilot's inadequate preflight planning and preparation and his delayed decision to return to the airport leading to an off airport landing as a result of deteriorating weather conditions. A finding in the investigation was the windshield that fogged up.NTSB ATL04CA108Accident · No injuriesData collectionFinal reportSawyer Skybolt · Philadelphia, MSThe pilot's failure to see and avoid a guy wire which resulted in an in-flight collision.NTSB ATL04IA098Incident · No injuriesIncident investigationFinal reportCessna 208B · Tunica, MSThe pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.NTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.NTSB MIA04CA057Accident · No injuriesData collectionFinal reportBeech V35B · Bay St. Louis, MSThe failure of the pilot to complete the landing checklist and extend the landing gear resulting in a gear up landing and damage to the airplane.NTSB MIA04FA023Accident · 3 fatalField investigationFinal reportBeech G35 · Okolona, MSThe pilot's intentional low altitude maneuver and buzzing resulting in collision with trees, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the pilot's ostentatious display.NTSB MIA04FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Olive Branch, MSThe student pilot's failure to maintain airspeed (Vso), which resulted in an inadvertent stall/spin, an uncontrolled descent, and an impact with terrain. A factor in the accident was his failure to follow the airplane's operating checklist and retract the…NTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.NTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.NTSB MIA03LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Ocean Springs, MSThe failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.NTSB MIA03CA148Accident · No injuriesData collectionFinal reportCessna 172S · Olive Branch, MSThe student pilot's improper landing flare/touchdown and inadequate recovery from a bounced landing which resulted in a hard landing and damage to the airplane.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.NTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…NTSB MIA03LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Olive Branch, MSThe pilot's operation of the airplane with known deficiencies (water contamination of the fuel) resulting in loss of engine power shortly after takeoff and damage to airframe during the subsequent forced landing.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB MIA03CA108Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Baxterville, MSThe pilot's decision to continue the takeoff at a low airspeed which resulted in a stall, an uncontrolled descent, and an impact with terrain.NTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.NTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.NTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.NTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.NTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.NTSB MIA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Leesburg, MSThe pilot's improper use of flaps, resulting in the degradation of climb performance and collision with the ground.NTSB ATL03LA038Accident · No injuriesLimited investigationFinal reportBeech 200 · Jackson, MSThe failure of the landing gear system for undetermined reasons.NTSB MIA03LA014Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · Foxworth, MSThe pilots failure to properly recover from a stalled/mush/high sink rate condition during an approach and attempted aborted landing into a gusting crosswind, resulting in a hard touchdown, bounced landing, loss of directional control and in-flight collision…NTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.