NTSB investigations, MS

152 cases where the phase of flight was Approach.

Cases per year

19642026
NTSB investigations, MS per year, 1964–2026: 152 cases
19644
19653
19663
19676
19682
19694
19703
19715
19724
19731
19744
19751
19762
19776
19784
19794
19804
19817
19821
19834
19843
19855
19862
19874
19883
19893
19904
19921
19931
19941
19955
19963
19972
19981
19994
20002
20011
20022
20031
20041
20054
20071
20095
20111
20133
20141
20151
20161
20171
20181
20193
20201
20213
20221
20231
20242
20251

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 = 500)
  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 CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.May 31, 2025 · N177LS · Substantial damageNTSB CEN25LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150L · Meridian, MSThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate verification of his student’s preflight planning.Dec 6, 2024 · N5321Q · Substantial damageNTSB CEN24LA118Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182P · Charleston, MSThe pilot’s failure to attain/maintain aircraft control during an approach for landing that resulted in an impact with terrain.Feb 20, 2024 · N14YY · DestroyedNTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.Jun 14, 2023 · UNREG · Substantial damageNTSB CEN22LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna L-19E · Sunflower, MSThe total loss of engine power for reasons that could not be determined.Mar 24, 2022 · N4583S · Substantial damageNTSB CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.Sep 9, 2021 · N5233P · Substantial damageNTSB CEN21FA209Accident · 4 fatalClass 3 · FieldFinal reportMitsubishi MU2B · Hattiesburg, MSThe pilot’s failure to maintain control of the airplane during the night instrument approach which resulted in an inadvertent aerodynamic stall from which the pilot was unable to recover.May 5, 2021 · N322TA · DestroyedNTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.Feb 25, 2021 · UNREG · Substantial damageNTSB CEN20LA353Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT602 · Inverness, MSThe pilot’s decision to move the power control lever into beta during flight, which resulted in the power control lever and associated linkage becoming stuck in the beta position.Aug 20, 2020 · N604MG · Substantial damageNTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.Jul 6, 2019 · N994CP · DestroyedNTSB CEN19TA205Accident · Serious injuriesClass 3Final reportBeech 23 · Vaiden, MSThe pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.Jul 4, 2019 · N7618R · Substantial damageNTSB CEN19LA149Accident · No injuriesClass 3 · LimitedFinal reportChistov Challenger · Raymond, MSA total loss of engine power for undetermined reasons.May 22, 2019 · N638DC · DestroyedNTSB ERA19LA016Accident · Serious injuriesLimited investigationFinal reportSa300 Starduster · Byhalia, MSThe pilot's failure to maintain a proper approach path, which resulted a collision with trees short of the runway.Oct 12, 2018 · N503CM · Substantial damageNTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.Oct 11, 2017 · N7566D · Substantial damageNTSB ERA17LA005Accident · No injuriesLimited investigationFinal reportPiper PA28 · Laurel, MSA total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies.Oct 1, 2016 · N499TG · Substantial damageNTSB ERA15CA256Accident · No injuriesData collectionFinal reportCessna 170 · Raymond, MSThe flight instructor's inadequate preflight inspection of the fuel system resulting in a total loss of engine power due to fuel contamination.Jun 30, 2015 · N4027V · Substantial damageNTSB ERA14LA392Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Itta Bena, MSA total loss of engine power during maneuvering due to an obstruction from air intake filter material being ingested into the carburetor, which resulted in a forced landing.Aug 16, 2014 · N36236 · Substantial damageNTSB ERA13CA392Accident · Minor injuriesData collectionFinal reportCessna 172L · McComb, MSThe pilot’s failure to maintain adequate airspeed during approach to landing, which resulted in an aerodynamic stall and subsequent loss of control.Aug 30, 2013 · N7892G · Substantial damageNTSB ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 20, 2013 · N117HB · Substantial damageNTSB ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…Jun 12, 2013 · N7045G · Substantial damageNTSB 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.Apr 10, 2011 · N100TK · Substantial damageNTSB 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.Nov 8, 2009 · N9368G · Substantial damageNTSB 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.Sep 24, 2009 · N4340D · Substantial damageNTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.Sep 1, 2009 · N33PX · Substantial damageNTSB 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.Jun 2, 2009 · N1399X · Substantial damageNTSB 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.Mar 21, 2009 · N4057U · Substantial damageNTSB DFW08LA018Accident · No injuriesLimited investigationFinal reportCessna 150K · Flora, MSLoss of engine power due to fuel contamination. A contributing factor was the lack of suitable terrain for the forced landing.Oct 20, 2007 · N6157G · Substantial damageNTSB 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.Oct 1, 2005 · N45339 · DestroyedNTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.Jul 16, 2005 · N2614D · Substantial damageNTSB 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.Apr 18, 2005 · N6645G · Substantial damageNTSB 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…Feb 10, 2005 · N6742S · Substantial damageNTSB 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.Dec 4, 2004 · N3570J · Substantial damageNTSB 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.Apr 13, 2003 · N757AZ · Substantial damageNTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.Jun 7, 2002 · N697MA · Substantial damageNTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.Jan 8, 2002 · N48031 · Substantial damageNTSB ATL01LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Picayune, MSThe pilot's inflight fuel planning /decision that resulted in fuel starvation and a loss of engine power. A factor was the failure of the fuel transfer pump.Jun 4, 2001 · N18PF · Substantial damageNTSB MIA00LA272Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Gulfport, MSa loss of power on both engines, during a simulated engine out approach, resulting in a forced landing and the subsequent on ground impact with a pole.Sep 27, 2000 · N9713R · Substantial damageNTSB 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…Sep 9, 2000 · N58PB · DestroyedNTSB MIA99FA269Accident · 1 fatalField investigationFinal reportPiper PA-31P · Louisville, MSThe pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.Sep 27, 1999 · N100EE · DestroyedNTSB 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.Sep 11, 1999 · N212W · Substantial damageNTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.Sep 7, 1999 · N584SD · Substantial damageNTSB MIA99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jackson, MSThe loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.Jun 5, 1999 · N78HR · Substantial damageNTSB MIA99LA010Accident · No injuriesLimited investigationFinal reportBeech C-90 · Meridian, MSThe pilot's inadvertent activation of the landing gear control handle during an attempted go-around, resulting in the retraction of the landing gear and subsequent on ground collision with terrain.Oct 14, 1998 · N438SP · Substantial damageNTSB 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.Nov 13, 1997 · N500ML · DestroyedNTSB MIA97LA203Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Bay St. Louis, MSThe pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…Jul 2, 1997 · N5054R · Substantial damageNTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.Jun 12, 1996 · N39018 · Substantial damageNTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…Apr 7, 1996 · N310MA · Substantial damageNTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.Jan 7, 1996 · N424WA · Substantial damageNTSB 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…Dec 6, 1995 · N33AS · DestroyedNTSB MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.Dec 4, 1995 · N12245 · Substantial damage