OpenAirDocs.org

NTSB investigations

20,992 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.\"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 ERA23LA257Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 402 · Charlotte Amalie, CBAn in-flight collision with a bird while entering the traffic pattern.Jun 4, 2023 · N7037E · Minor damageNTSB CEN23LA224Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Oklahoma City, OKA loss of engine power during approach for landing for undetermined reasons.Jun 4, 2023 · N9169Q · Substantial damageNTSB CEN23LA214Accident · No injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey LSA · Detroit, MIA loss of engine power due to fuel exhaustion that resulted from the pilots’ inadequate preflight planning.Jun 1, 2023 · N316SR · Substantial damageNTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, 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.May 26, 2023 · N201MM · Substantial damageNTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandMay 25, 2023 · VH-IKJ · No damageNTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.May 24, 2023 · N60372 · Substantial damageNTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.May 19, 2023 · N442TM · Substantial damageNTSB GAA23WA162AccidentClass 5 · ForeignPiper PA18 · Oldenburg, GermanyMay 18, 2023 · D-EJIM · DestroyedNTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.May 18, 2023 · N6840F · Substantial damageNTSB CEN23FA190Accident · 1 fatalClass 3 · FieldFinal reportBeech E-90 · Winslow, ARThe pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…May 17, 2023 · N522MJ · DestroyedNTSB ANC23LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Point Thomson, AKThe pilot’s inadvertent descent below the published minimum descent altitude, while operating in flat light conditions, which resulted in controlled flight into terrain.May 17, 2023 · N34WM · Substantial damageNTSB DCA23WA291Incident · No injuriesClass 5 · ForeignAirbus A320-233 · Monterrey, MexicoMay 11, 2023 · N518VL · Minor damageNTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.May 9, 2023 · N416AG · DestroyedNTSB GAA23WA147Accident · 2 fatalClass 5 · ForeignCessna 182 · Shell, EcuadorMay 8, 2023 · HC-CJL · Substantial damageNTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.May 6, 2023 · N6798T · DestroyedNTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.May 5, 2023 · N180LR · Substantial damageNTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.May 1, 2023 · N2038Y · Substantial damageNTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.Apr 30, 2023 · N575ND · Substantial damageNTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.Apr 30, 2023 · N1113B · Substantial damageNTSB ERA23FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 177B · Watkinsville, GAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an in-flight overload separation of the right wing during the uncontrolled descent.Apr 26, 2023 · N123DS · DestroyedNTSB ERA23LA206Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · West Palm Beach, FLThe loss of engine power due to fuel exhaustion.Apr 24, 2023 · N7555X · Substantial damageNTSB GAA23WA129Accident · 1 fatalClass 5 · ForeignLancair 360 · Taurages, LithuaniaApr 21, 2023 · LY-BRS · Substantial damageNTSB CEN23LA161Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Flint Township, MIThe pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.Apr 20, 2023 · N419W · Substantial damageNTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.Apr 19, 2023 · N4166C · Substantial damageNTSB CEN23FA160Accident · Serious injuriesClass 3 · FieldFinal reportAero Vodochody L-139 · Bridgeport, TXThe pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…Apr 19, 2023 · N1390A · Substantial damageNTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.Apr 18, 2023 · N349VR · Substantial damageNTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.Apr 18, 2023 · N734GB · Substantial damageNTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.Apr 16, 2023 · N38C · Substantial damageNTSB ERA23LA196Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Gilford, NHThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with the runway.Apr 15, 2023 · N5400S · Substantial damageNTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…Apr 14, 2023 · N7542V · Substantial damageNTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.Apr 13, 2023 · N412RS · Substantial damageNTSB WPR23FA153Accident · 2 fatalClass 3 · FieldFinal reportMullins David J JR Glastar · Cal-Nev-Ari, NVThe pilot's failure to maintain sufficient altitude for undetermined reasons while maneuvering to land in dark night conditions, which resulted in collision with terrain.Apr 11, 2023 · N8488 · Substantial damageNTSB ERA23LA191Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Danbury, CTThe flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Apr 10, 2023 · N757YM · Substantial damageNTSB WPR23LA150Accident · No injuriesClass 3 · LimitedFinal reportCompagnie Daher TBM 700 · Ashland, ORThe pilot’s failure to maintain adequate airspeed during an attempted go around, which resulted in a runway excursion and impact with terrain.Apr 7, 2023 · N6924G · DestroyedNTSB GAA23WA197AccidentClass 5 · ForeignPiper PA-31-350 · Archerfield, AustraliaApr 7, 2023 · VH-HJE · Substantial damageNTSB ERA23LA187Accident · Serious injuriesClass 4 · LimitedFinal reportLewis/Urmston RV 4 200 · Cedar Key, FLThe pilot’s inadequate compensation for gusting wind conditions while landing, which resulted in a loss of directional control.Apr 7, 2023 · N8DU · Substantial damageNTSB ERA23FA182Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Jesup, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control while maneuvering for a visual landing in low ceiling and low visibility conditions. Contributing to the…Apr 6, 2023 · N911TK · Substantial damageNTSB DCA23WA229Occurrence · No injuriesClass 5 · ForeignAirbus A320 · Sao Paulo, BrazilMar 30, 2023 · PT-MZL · 2 aircraft · No damageNTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.Mar 30, 2023 · N56793 · Substantial damageNTSB GAA23WA114Accident · Serious injuriesClass 5 · ForeignPiper PA-28-140 · Scottsdene, South AfricaMar 28, 2023 · ZS-JNN · Substantial damageNTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.Mar 22, 2023 · N669YK · Substantial damageNTSB GAA23WA105Accident · No injuriesClass 4 · ForeignPiper PA25 · Corupa, BrazilMar 21, 2023 · PT-BII · Substantial damageNTSB GAA23WA104Accident · 4 fatalClass 4 · ForeignRobinson R44 · Sao Paulo, BrazilMar 17, 2023 · PR-PGC · Substantial damageNTSB DCA23WA476Incident · No injuriesClass 4 · ForeignBoeing 787 · Dubai, United Arab EmiratesMar 10, 2023 · AC9-FG · No damageNTSB DCA23WA475IncidentClass 4 · ForeignBoeing 737 · Dubai, QatarMar 10, 2023 · AC9-FG · No damageNTSB ERA23FA142Accident · 4 fatalClass 3 · FieldFinal reportPiper J3C · Winter Haven, FLThe failure of both flight crews to see and avoid each other while operating in the airport environment.Mar 7, 2023 · N10510 · 2 aircraft · Substantial damageNTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.Mar 5, 2023 · N8149R · DestroyedNTSB DCA23LA196Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Dallas, TXThe flight’s encounter with convective turbulence.Mar 2, 2023 · N366FR · No damageNTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.Feb 28, 2023 · N945HS · Substantial damageNTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.Feb 24, 2023 · N929DR · Destroyed