OpenAirDocs.org

NTSB investigations, MO

463 cases where the phase of flight was Approach.

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\" = 'MO' 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 CEN26LA044Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR20 · Chesterfield, MOOn November 11, 2025, about 1750 central standard time, a Cirrus SR20, N866CD, was substantially damaged when it was involved in an accident near Chesterfield, Missouri. The pilot and copilot received minor injuries. The airplane was operated as a Title 14…Nov 11, 2025 · N866CD · Substantial damageNTSB CEN25LA250Accident · No injuriesClass 3 · LimitedPreliminary reportGame Composites GB1 Gamebird · Tarkio, MOOn July 12, 2025, about 0830 central daylight time, a Game Composites GB-1 Gamebird airplane, N588AF, was substantially damaged, and a Vans RV-8, N931KZ, sustained minor damage, when they were involved in an accident near the Gould Peterson Municipal Airport…Jul 12, 2025 · N588AF · 2 aircraft · Substantial damageNTSB CEN25LA223Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Unionville, MOThe pilot’s failure to maintain airplane control during a go-around.Jun 25, 2025 · N670P · DestroyedNTSB CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.Sep 15, 2023 · N853HT · DestroyedNTSB CEN23LA415Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Moberly, MOThe flight instructor’s inadequate fuel management that resulted in fuel starvation and a total loss of engine power during an approach for landing.Sep 11, 2023 · N4219T · Substantial damageNTSB CEN23LA296Accident · Minor injuriesClass 3 · LimitedFinal reportMagni M24 · Mineral Point, MOThe inflight loss of the engine’s air filter which collided with the propeller which resulted in a vibration.Jul 11, 2023 · N123PS · Substantial damageNTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.Jul 20, 2022 · N1228Z · Substantial damageNTSB WPR22FA184Accident · 1 fatalClass 3 · FieldFinal reportBruce R Prouse M24 Orion Plus · Cape Girardeau, MOThe pilot’s failure to maintain controlled flight, which resulted in a hard left roll, excessive blade flapping and a subsequent in-flight separation of the right horizontal stabilizer.May 22, 2022 · N590DM · Substantial damageNTSB CEN22LA116Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C35 · Shell Knob, MOThe pilot’s failure to maintain airplane control that resulted in an aerodynamic stall during approach and impact with terrain.Feb 8, 2022 · N1908D · DestroyedNTSB CEN21LA014Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA32R · Kimberling City, MOThe pilot’s inadequate preflight inspection, which resulted in his inadvertent departure with the tow bar connected to the nose wheel, and the low approach while returning to the airport, which allowed the tow bar to contact trees.Oct 10, 2020 · N3445Q · DestroyedNTSB CEN20LA397Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montgomery City, MOThe pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.Sep 16, 2020 · N4744M · Substantial damageNTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…Jan 16, 2020 · N6630D · Substantial damageNTSB CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.Sep 25, 2019 · N52WL · Substantial damageNTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.Jul 21, 2019 · N300SN · Substantial damageNTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…Sep 21, 2018 · N7152S · Substantial damageNTSB CEN18LA095Accident · Serious injuriesLimited investigationFinal reportHenderson Thorp T 18 · Troy, MOThe pilot's failure to maintain adequate clearance from trees while landing in crosswind conditions.Feb 8, 2018 · N600HH · Substantial damageNTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 6, 2017 · N679EA · DestroyedNTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.Apr 24, 2017 · N787TV · Substantial damageNTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.Feb 6, 2017 · N246CA · Substantial damageNTSB CEN17LA097Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Ozark, MOThe pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.Jan 26, 2017 · N4213B · Substantial damageNTSB CEN17LA062Accident · No injuriesLimited investigationFinal reportPiper PA22 · Piedmont, MOThe pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.Dec 28, 2016 · N5499Z · Substantial damageNTSB GAA16CA357Accident · Minor injuriesData collectionFinal reportBeech 23 · Maryville, MOThe pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.Jul 2, 2016 · N8704M · Substantial damageNTSB CEN15LA361Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookfield, MOThe pilot's failure to visually check the quantity of fuel in the fuel tanks in accordance with the Preflight checklist, which resulted in a loss of engine power due to fuel exhaustion and the subsequent forced landing.Aug 11, 2015 · N8896U · Substantial damageNTSB CEN15LA237Accident · No injuriesLimited investigationFinal reportPiper PA-22 · St. Charles, MOA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.May 19, 2015 · N118U · Substantial damageNTSB DCA15CA108Accident · No injuriesData collectionFinal reportEmbraer EMB 145LR · Springfield, MOan in-flight collision with a bird.Mar 20, 2015 · N625AE · Substantial damageNTSB CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…Mar 7, 2015 · N356AM · DestroyedNTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…Nov 30, 2014 · N6629V · Substantial damageNTSB CEN15LA066Accident · Minor injuriesLimited investigationFinal reportMD Helicopter MD 900 · Highlandville, MOThe pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.Nov 27, 2014 · N902LC · Substantial damageNTSB CEN14CA459Accident · No injuriesData collectionFinal reportPiper PA 32R-301T · Sedalia, MOThe loss of engine power due to fuel starvation.Aug 25, 2014 · N532DR · Substantial damageNTSB CEN14LA324Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Maryland Heights, MOThe loss of left engine power for reasons that could not be determined due to impact and fire damage.Jun 26, 2014 · N1552T · DestroyedNTSB CEN14FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kirksville, MOA loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.Nov 6, 2013 · N408DM · DestroyedNTSB CEN14TA020Accident · Minor injuriesFinal reportBell OH-58A · Jefferson City, MOThe loss of engine power for reasons that could not be determined because postaccident examinations of the engine did not reveal any anomalies that would have precluded normal operation.Oct 26, 2013 · N283MP · Substantial damageNTSB CEN13CA268Accident · Minor injuriesData collectionFinal reportHook Zodiac CH-650 · Gainesville, MOThe pilot misjudged the landing approach, which resulted in the airplane hitting a tree.May 2, 2013 · N914AR · Substantial damageNTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.Oct 25, 2012 · N55620 · Substantial damageNTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.Sep 20, 2012 · N34722 · Substantial damageNTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.Sep 15, 2012 · N436KS · Substantial damageNTSB CEN12CA656Accident · Minor injuriesData collectionFinal reportFairchild PT-19A · Cape Girardeau, MOThe pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.Sep 13, 2012 · N19GP · Substantial damageNTSB CEN12CA279Accident · No injuriesData collectionFinal reportBalloon Works Firefly 7-15 · Hallsville, MOThe pilot’s failure to maintain clearance from power lines during landing.May 6, 2012 · N9079S · Substantial damageNTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.Dec 8, 2011 · N7138K · Substantial damageNTSB CEN11LA514Accident · No injuriesLimited investigationFinal reportEvens RV4 · Monroe City, MOA total loss of engine power for undetermined reasons.Jul 25, 2011 · N20JE · Substantial damageNTSB CEN10CA197Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Creve Couer, MOThe pilot's failure to go-around during a simulated engine failure and the instructor pilot's delay in remedial actions.Apr 8, 2010 · N1957C · Substantial damageNTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Sep 6, 2009 · N9129A · Substantial damageNTSB CEN09CA468Accident · No injuriesData collectionFinal reportCorvus Carone MK 1 · Lee's Summit, MOA loss of engine power for undetermined reasons.Jul 23, 2009 · N51299 · Substantial damageNTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.Jul 8, 2009 · N20VV · Substantial damageNTSB CEN09CA228Accident · Minor injuriesData collectionFinal reportRemos Remos GX · St. Charles, MOThe pilot's failure to maintain a proper glide path and airspeed during a simulated emergency approach. Contributing to the accident was the flight instructor's delayed remedial action.Mar 22, 2009 · N446RA · Substantial damageNTSB CEN09CA175Accident · No injuriesData collectionFinal reportGates Learjet 35A · Kansas City, MOThe copilot's failure to maintain control of the airplane during the go-around. Contributing to the accident was the flight crew's delayed decision to perform a go-around.Feb 24, 2009 · N465NW · Substantial damageNTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.Jun 20, 2008 · N3150U · Substantial damageNTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.Apr 18, 2008 · N56895 · DestroyedNTSB CHI08LA006Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Festus, MOThe pilot's inadequate aircraft preflight, fuel system water contamination and fuel starvation which resulted in a loss of engine power during landing approach. An additional cause was the emergency landing procedure not followed by the pilot following a loss…Oct 8, 2007 · N43246 · Substantial damageNTSB CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.Sep 29, 2007 · N9583L · Substantial damage