OpenAirDocs.org

NTSB investigations, MS

410 cases where the phase of flight was Maneuvering.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 450)
  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.

NTSB CEN25LA165Accident · No injuriesClass 3 · LimitedFinal reportCessna T206 · Natchez, MSMaintenance personnel’s improper maintenance, which resulted in a loss of engine power due to fuel starvation as the result of a loose fuel line B-nut. Contributing to the accident was an inadequate 100-hour inspection performed after the recent maintenance.Mar 27, 2025 · N27DV · Substantial damageNTSB CEN23FA144Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Oxford, MSAn in-flight collision with trees and terrain for undetermined reasons.Mar 29, 2023 · N43414 · DestroyedNTSB CEN22LA428Accident · No injuriesClass 4 · LimitedFinal reportBeech C90A · Tupelo, MSThe uncertificated pilot’s criminal act of stealing the airplane and later performing an off-airport landing that resulted in an impact with terrain.Sep 3, 2022 · N342ER · Substantial damageNTSB ERA22FA376Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Glendora, MSThe collision with terrain for reasons that could not be determined.Aug 19, 2022 · N602PB · Substantial damageNTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.Aug 4, 2021 · N7197C · DestroyedNTSB CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.Mar 5, 2021 · N41068 · Substantial damageNTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…Dec 29, 2020 · N103SU · DestroyedNTSB CEN19LA334Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Columbus, MSA total loss of engine power control for undetermined reasons.Sep 27, 2019 · N801BF · Substantial damageNTSB ERA18FA088Accident · 1 fatalField investigationFinal reportAir Tractor AT-802 · Greenwood, MSThe pilot's failure to maintain clearance from a tree for reasons that could not be determined based on the available evidence.Feb 26, 2018 · N581LA · Substantial damageNTSB WPR18LA029Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rolling Fork, MSAn uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.Nov 7, 2017 · N93PH · Substantial damageNTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.Aug 16, 2017 · N6082B · Substantial damageNTSB ERA17FA131Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Minter City, MSThe pilot's incapacitation for reasons that could not be determined, which resulted in collision with trees and terrain.Mar 19, 2017 · N2049D · DestroyedNTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.Jun 10, 2016 · N67RH · Substantial damageNTSB ERA15FA173Accident · 2 fatalField investigationFinal reportBell Helicopter Textron 206 L-1 · Saucier, MSA loss of engine power for reasons that could not be determined due to postaccident fire damage.Mar 30, 2015 · N50KH · DestroyedNTSB ERA15FA147Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kosciusko, MSThe pilot's decision to make a low pass over a lake near trees and his subsequent failure to maintain airplane control while maneuvering at a low altitude to avoid trees, which resulted in an inadvertent cross-control aerodynamic stall from which he was…Mar 8, 2015 · N7698S · Substantial damageNTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.Jul 1, 2014 · N91331 · DestroyedNTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.May 23, 2013 · N9996N · Substantial damageNTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.Feb 17, 2013 · UNREG · Substantial damageNTSB ERA12CA275Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Ruleville, MSThe pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Apr 9, 2012 · N51037 · Substantial damageNTSB 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.Jul 26, 2011 · N8525L · Substantial damageNTSB ERA11LA298Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Greenwood, MSA partial loss of engine power during low-altitude maneuvering for undetermined reasons.May 13, 2011 · N660KP · Substantial damageNTSB 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.Dec 13, 2010 · N361DS · Substantial damageNTSB ERA10LA499Accident · Serious injuriesLimited investigationFinal reportBell OH-58A · Taylorsville, MSA total loss of engine power while maneuvering at low altitude for undetermined reasons.Sep 24, 2010 · N132HD · Substantial damageNTSB 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.Jul 29, 2010 · N9046D · Substantial damageNTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.Oct 25, 2009 · N57PH · DestroyedNTSB 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.Oct 21, 2009 · N24EA · Substantial damageNTSB 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.Jul 31, 2009 · N60237 · Substantial damageNTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.Jul 8, 2009 · N113DW · Substantial damageNTSB 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.May 14, 2009 · N7392S · Substantial damageNTSB 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.Aug 22, 2008 · N1520X · Substantial damageNTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.Aug 17, 2008 · N4015P · Substantial damageNTSB NYC08CA279Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Tunica, MSThe pilot's failure to maintain clearance from the power lines during low-altitude maneuvers.Aug 13, 2008 · N61267 · Substantial damageNTSB MIA08CA078Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Columbus, MSThe failure of the pilot to maintain airspeed while maneuvering.Mar 14, 2008 · N7302C · Substantial damageNTSB DFW08CA010Accident · No injuriesData collectionFinal reportEurocopter EC 130 · Bay St Louis, MSThe pilot's encounter with dynamic rollover as result of his inadequate preflight inspection.Oct 11, 2007 · N997PT · Substantial damageNTSB DFW07LA187Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Cary, MSThe total loss of engine power due to a power turbine failure. Contributing to the accident were the lack of suitable terrain available to pilot for the forced landing and the low altitude.Aug 20, 2007 · N1027V · Substantial damageNTSB DFW07LA154Accident · Minor injuriesLimited investigationFinal reportWsk-Pzl Mielic M-18A · Tunica, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 11, 2007 · N4305T · Substantial damageNTSB DFW07CA081Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Arcola, MSThe pilot's failure to maintain clearance from trees while maneuvering during aerial application.Feb 23, 2007 · N8063K · Substantial damageNTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.Oct 18, 2006 · N401MS · Substantial damageNTSB DFW06LA195Accident · 1 fatalLimited investigationFinal reportCessna A188B · Sumrall, MSThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the partial loss of engine power and the low altitude.Aug 4, 2006 · N86188 · Substantial damageNTSB DFW06LA103Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Meridian, MSThe pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.Apr 15, 2006 · N5003E · DestroyedNTSB 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.Apr 5, 2006 · N3887P · DestroyedNTSB 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.Feb 18, 2005 · N9114W · Substantial damageNTSB 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…Feb 12, 2005 · N20GT · DestroyedNTSB 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.Nov 25, 2004 · N195DD · DestroyedNTSB 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.Oct 16, 2004 · N119DM · DestroyedNTSB 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.Sep 15, 2004 · N3832U · DestroyedNTSB 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.Apr 24, 2004 · N75812 · Substantial damageNTSB 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.Nov 21, 2003 · N4214D · DestroyedNTSB 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.Apr 27, 2003 · N2371U · Substantial damageNTSB MIA02LA143Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, MSThe failure of the pilot to maintain clearance with a transmission wire resulting in the collision and substantial damage.Aug 2, 2002 · N4723Q · Substantial damage