NTSB investigations, MS
87 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 4 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 DFW08CA010Accident · No injuriesData collectionFinal reportEurocopter EC 130 · Bay St Louis, MSThe pilot's encounter with dynamic rollover as result of his inadequate preflight inspection.NTSB DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.NTSB DFW07LA171Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Marks, MSThe loss of control and hard landing as result of the loss of tail rotor effectiveness. A contributing factor was the prevailing dark night conditions.NTSB DFW07FA055Accident · 1 fatalField investigationFinal reportCessna 310 · Jackson, MSThe pilot's loss of control for undetermined reasons.NTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.NTSB DFW06CA194Accident · Serious injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Jackson, MSThe pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall and a subsequent loss of control.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB DFW06FA037Accident · 3 fatalField investigationFinal reportPiper PA-30 · Raymond, MSThe pilot's failure to maintain Vmc (velocity minimum control) on initial climb resulting in a loss of control. Contributing factors were the loss of engine power to the right engine and the prevailing gusty wind conditions.NTSB DFW05FA251Accident · 2 fatalField investigationFinal reportCessna 150M · Crystal Springs, MSThe pilot's failure to retract the flaps during the go-around and his failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the dark night conditions.NTSB MIA05FA139Accident · 3 fatalField investigationFinal reportMooney M20C · Natchez, MSThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and subsequent uncontrolled descent to ground impact. A contributing factor was the pilot's lack of experience in complex…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 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 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 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 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 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 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 ATL02LA146Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A · Indianola, MSThe pilot's failure to maintain airspeed which resulted in a stall and the subsequent uncontrolled collision with the ground while maneuvering for an aerial application run.NTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.NTSB MIA02FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Poplarville, MSThe pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…NTSB MIA02LA014Accident · 2 fatalLimited investigationFinal reportRans S-6 · Wyatte, MSthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with trees, while at a low altitude.NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB ATL01LA061Accident · No injuriesLimited investigationFinal reportConrad Menzel SA-300 Starduster · Jackson, MSThe pilot failure to maintain directional control during a crosswind landing.NTSB ATL01LA031Accident · Serious injuriesLimited investigationFinal reportSorrell SNS-2 Guppy · Raymond, MSThe failure of the rudder horn bracket, that resulted in the inflight loss of control.NTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.NTSB MIA00FA265Accident · 2 fatalField investigationFinal reportBeech 58P · Brookhaven, MSThe poor in-flight planning/decision by the pilot for flying a close-in downwind leg, improper aircraft handling by the pilot for his executing a 70-75 degree angle of bank turning base to final while circling to land, and inadvertent stall/mush of the…NTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.NTSB MIA00LA202Accident · 1 fatalLimited investigationFinal reportCessna A188B · Inverness, MSThe failure of the pilot to maintain airspeed while reversing course during an aerial application flight resulting in the aircraft stalling, descending, impacting a tree, and crashing to the ground.NTSB ATL00FA061Accident · 2 fatalField investigationFinal reportCessna 150G · Oxford, MSThe certified flight instructor's failure to maintain airspeed during climbout.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 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 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 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 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 MIA99LA022Accident · 1 fatalLimited investigationFinal reportFerguson Rans S-10 Sakota · Pisgah, MSThe pilot's failure to maintain aircraft control during a low altitude maneuver resulting in the aircraft's uncontrollable descent until impact with the terrain.NTSB MIA98LA214Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Monticello, MSthe pilot's failure to maintain control of the helicopter while maneuvering resulting in the main rotor blades striking the ground.NTSB ATL98FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Clinton, MSThe pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an…NTSB ATL98FA009Accident · 1 fatalField investigationFinal reportBeech B100 · Madison, MSthe pilot's failure to maintain control of the aircraft due to spatial disorientation. A related factor was: the instrument weather conditions.NTSB MIA97FA034Accident · 2 fatalField investigationFinal reportBeech D-45 · Poplarville, MSthe noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…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 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 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 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 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 MIA95LA182Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Goodman, MSThe pilot's failure to maintain flying airspeed which resulted in an aerodynamic stall.NTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.NTSB MIA94LA162Accident · 1 fatalLimited investigationFinal reportStolte Deuce · Prentiss, MSFailure of the pilot to maintain proper altitude while performing an aerobatic maneuver and recovering from a spin. Factors related to the accident were: the pilot's failure to follow procedures/directives, lack of formal training in aerobatic flight, and…NTSB MIA94LA004Accident · Serious injuriesLimited investigationFinal reportEhlers Lancair 320 · Bay St. Louis, MSThe pilot-in-command's failure to maintain airspeed resulting in an in flight loss of control (stall/spin) and subsequent in flight collision with trees and terrain.