Final NTSB investigations

20,417 cases where the phase of flight was Approach.

Cases, newest first

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.\"completionStatus\" = 'Completed'
    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 WPR25LA251Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Kalispell, MTThe pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.Aug 11, 2025 · N860CA · DestroyedNTSB CEN25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Ozark, ARThe pilot’s failure to maintain clearance from a tree which resulted in the right wing impacting the tree and a subsequent collision with trees and terrain. Contributing to the accident was the pilot’s decision to operate the airplane at a low altitude over…Aug 9, 2025 · N95356 · Substantial damageNTSB CEN25LA311Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Monee, ILThe student pilot’s failure to maintain airspeed and altitude resulting in a collision with the ground during the base to final turn.Aug 6, 2025 · N65818 · Substantial damageNTSB ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 25, 2025 · N29110 · Substantial damageNTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.Jul 24, 2025 · N5204C · Substantial damageNTSB ERA25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T337G · Pembroke Pines, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power to one of the airplane’s two engines. Contributing to the outcome was the pilot’s loading of the airplane beyond its maximum gross…Jul 14, 2025 · N289 · Substantial damageNTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.Jul 13, 2025 · N88220 · Substantial damageNTSB ERA25LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · St. Augustine, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 11, 2025 · N8503G · Substantial damageNTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.Jun 30, 2025 · N124GH · Substantial damageNTSB CEN25LA225Accident · No injuriesClass 3 · LimitedFinal reportTecnam P2010 · Temple, TXThe loss of engine power due to a failed muffler flame tube assembly which resulted in an exhaust blockage.Jun 26, 2025 · N258CM · 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 ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.Jun 25, 2025 · N97438 · Substantial damageNTSB DCA25LA241Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Barlow Bend, ALThe airplane’s encounter with unanticipated turbulence during descent, resulting in a serious injury to a flight attendant.Jun 18, 2025 · N8685B · No damageNTSB CEN25LA211Accident · No injuriesClass 4 · LimitedFinal reportCessna U206 · Falun, WIThe pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.Jun 18, 2025 · N932DB · Substantial damageNTSB DCA25LA238Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Fort Myers, FLThe airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.Jun 16, 2025 · N28478 · No damageNTSB CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…Jun 16, 2025 · N1UC · Substantial damageNTSB ANC25LA051Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s failure to maintain clearance from trees during a go-around with a tailwind.Jun 14, 2025 · N3846M · Substantial damageNTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.Jun 13, 2025 · N78720 · Substantial damageNTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.Jun 10, 2025 · N15PM · Substantial damageNTSB ERA25LA273Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · New Port Richey, FLThe pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.Jun 9, 2025 · N9166Z · Substantial damageNTSB CEN25LA196Accident · Minor injuriesClass 4 · LimitedFinal reportGallow Daniel A Kitfox Classic IV · Waupaca, WIThe pilot’s failure to maintain adequate air speed during final approach, which resulted in an aerodynamic stall and impact with terrain.Jun 5, 2025 · N755SD · Substantial damageNTSB ERA25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172F · Vero Beach, FLA total loss of engine power for reasons that could not be determined.Jun 2, 2025 · N5200F · Substantial damageNTSB 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 CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…May 26, 2025 · N7175D · Substantial damageNTSB ERA25LA210Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV-12 · Abingdon, VAThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.May 24, 2025 · N813JC · Substantial damageNTSB CEN25LA172Accident · No injuriesClass 4 · LimitedFinal reportGolden Circle Air T-Bird · Dallas Center, IAThe pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.May 5, 2025 · N7192M · Substantial damageNTSB CEN25LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe disconnected throttle control that resulted in a loss of engine power due to improper maintenance.May 4, 2025 · N75775 · Substantial damageNTSB WPR25FA146Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Grass Valley, CAAn improperly tightened B-nut fitting at the fuel flow divider, which resulted in a fuel leak and loss of engine power due to fuel starvation, and the inadequate maintenance inspection, which failed to detect and correct the discrepancy.May 1, 2025 · N52156 · Substantial damageNTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.Apr 28, 2025 · N501MS · Substantial damageNTSB ERA25LA189Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBC · Weyers Cave, VAA total loss of engine power on approach due to carburetor ice.Apr 26, 2025 · N9117L · Substantial damageNTSB ERA25LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Lakin, WVThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.Apr 23, 2025 · N591R · Substantial damageNTSB WPR25LA138Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.Apr 19, 2025 · N5786S · Substantial damageNTSB ERA25LA183Accident · Serious injuriesClass 4 · LimitedFinal reportFrank Lowell C Pietenpol · Taylorsville, NCThe pilot’s failure to maintain control of the airplane during an attempted go around in gusty tailwind conditions, which resulted in an aerodynamic stall and impact with terrain.Apr 18, 2025 · N497AR · Substantial damageNTSB ERA25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Kingston, OHThe pilot’s exceedance of the airplanes’ critical angle of attack resulting in a stall at an altitude too low to recover.Apr 13, 2025 · N6653F · Substantial damageNTSB ERA25LA172Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Folkston, GAThe pilot’s failure to maintain control of the airplane during a go-around.Apr 10, 2025 · N179ST · Substantial damageNTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…Apr 8, 2025 · N6561F · Substantial damageNTSB CEN25LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Ault, COThe flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.Apr 7, 2025 · N8282V · Substantial damageNTSB ERA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Chamblee, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during approach due to fuel exhaustion.Mar 21, 2025 · N5QV · Substantial damageNTSB WPR25LA115Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Cavalon · Murrieta, CAThe student pilot’s failure to maintain adequate airspeed during an approach and subsequent descent into terrain. Contributing to the accident was the student pilot’s failure to perform a go-around maneuver.Mar 20, 2025 · N157P · Substantial damageNTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.Mar 20, 2025 · N969SS · DestroyedNTSB WPR25LA113Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E-55 · Van Nuys, CAAn in-flight collision with a bird during an approach to land.Mar 16, 2025 · N994WY · Substantial damageNTSB CEN25LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Rusk, TXThe pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.Mar 16, 2025 · N52243 · Substantial damageNTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.Feb 26, 2025 · N849DB · Substantial damageNTSB ANC25LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKA total loss of engine power for undetermined reasons.Feb 21, 2025 · N2447J · Substantial damageNTSB ERA25LA129Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC135T2 · Philadelphia, PAThe sUAS operator’s failure to see and avoid a helicopter, resulting in a midair collision between the helicopter and the sUAS.Feb 17, 2025 · N405TJ · 2 aircraft · Substantial damageNTSB ERA25LA115Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Hampton, NHThe pilot’s failure to maintain adequate airspeed while maneuvering to land, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.Feb 11, 2025 · N77989 · Substantial damageNTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.Feb 9, 2025 · N4185N · Substantial damageNTSB WPR25LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Shafter, CAA total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.Feb 9, 2025 · N8535N · Substantial damageNTSB WPR25LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Ramona, CAAn in-flight collision with a bird in the airport traffic pattern.Feb 2, 2025 · N5268K · Substantial damageNTSB ANC25LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 182F · Anchorage, AKThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.Feb 2, 2025 · N3206U · Substantial damage