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 GAA23WA081AccidentClass 5 · ForeignBeech 1900 · Winnipeg, CanadaFeb 23, 2023 · C-FJXO · Substantial damageNTSB ERA23LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Buckhannon, WVA total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.Feb 18, 2023 · N6597X · Substantial damageNTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaFeb 18, 2023 · VH-?? · No damageNTSB DCA23LA179Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-823 · Sarasota, FLThe local controller’s failure to prioritize and properly monitor the runway and airport environment along with his erroneous assumption that ROU 1633 would depart from runway 14 before AAL2172 arrived to land on the same runway, which resulted in a loss of…Feb 17, 2023 · N976NN · 2 aircraft · No damageNTSB CEN23LA107Accident · No injuriesClass 3 · LimitedFinal reportMooney M20 · Lakeway, TXA total loss of engine power due to detonation and preignition in the No. 6 cylinder.Feb 12, 2023 · N304MA · Substantial damageNTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilFeb 9, 2023 · PR-PLF · Substantial damageNTSB WPR23LA104Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Gladewater, TXThe loss of engine power for undetermined reasons.Feb 5, 2023 · N123JV · Substantial damageNTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…Jan 29, 2023 · N621EW · Substantial damageNTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.Jan 27, 2023 · N4758C · Substantial damageNTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.Jan 20, 2023 · N71SN · Substantial damageNTSB WPR23LA087Accident · No injuriesClass 4 · LimitedFinal reportRaytheon BE-200 · Poplar, MTThe pilot’s failure to maintain adequate airspeed and descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.Jan 18, 2023 · N200EJ · Substantial damageNTSB WPR23FA092Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Modesto, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…Jan 18, 2023 · N4765G · Substantial damageNTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Jan 17, 2023 · N963MA · Substantial damageNTSB ANC23LA012Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 208B · Kualapuu, HIThe pilot’s failure to maintain adequate altitude during a circling approach procedure in dark night visual meteorological conditions, which resulted in a collision with terrain.Jan 16, 2023 · N236KA · Substantial damageNTSB DCA23WA174AccidentClass 5 · ForeignATR ATR72 · Pokhara, NepalJan 15, 2023 · 9N-ANC · DestroyedNTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.Jan 14, 2023 · N9393H · Substantial damageNTSB WPR23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Agua Caliente Springs, CAThe pilot’s failure to maintain aircraft control during an aborted approach, which resulted in a collision with terrain.Jan 12, 2023 · N2875K · Substantial damageNTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.Jan 12, 2023 · N22859 · Substantial damageNTSB ERA23LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Somerville, TNBased on available evidence, the reason for the damage to the airplane’s propeller and engine cowling could not be determined.Jan 10, 2023 · N5841W · Substantial damageNTSB CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Jan 10, 2023 · N9283Q · Substantial damageNTSB GAA23WA057Incident · No injuriesClass 5 · ForeignRobinson R44 · Hamilton Island, AustraliaJan 8, 2023 · UNKN · No damageNTSB ERA23FA103Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Suffolk, VAThe pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…Jan 7, 2023 · N592FL · DestroyedNTSB DCA23WA135Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Miyazaki, JapanJan 7, 2023 · JA307J · No damageNTSB CEN23FA074Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fayetteville, ARThe pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.Jan 6, 2023 · N673V · DestroyedNTSB CEN23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Council Bluffs, IAThe partial loss of engine power for reasons that could not be determined.Jan 5, 2023 · N71494 · Substantial damageNTSB ERA23LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Old Bridge, NJThe pilot’s failure to maintain adequate clearance from trees during the landing approach.Jan 1, 2023 · N8282K · Substantial damageNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaDec 26, 2022 · N600 · DestroyedNTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.Dec 19, 2022 · N8137P · Substantial damageNTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaDec 14, 2022 · N5EQ · DestroyedNTSB ERA23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Rockingham, NCThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Dec 13, 2022 · N498DS · Substantial damageNTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.Dec 13, 2022 · N231GZ · Substantial damageNTSB WPR23LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna TP206A · Maricopa, AZA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s improper fuel management.Dec 8, 2022 · N30WL · Substantial damageNTSB WPR23LA061Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter EC 130 B4 · Waimea, HIThe pilot's loss of helicopter control on approach to land due to entering a vortex ring state condition, which resulted in a hard landing.Dec 8, 2022 · N130WS · Substantial damageNTSB GAA23WA043Accident · Minor injuriesClass 4 · ForeignPiper PA25 · Ponta Grossa, BrazilDec 5, 2022 · PT-WBH · Substantial damageNTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.Dec 5, 2022 · N99345 · DestroyedNTSB DCA23LA090Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Taneytown, MDAn encounter with turbulence during descent.Dec 3, 2022 · N85356 · No damageNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB WPR23FA047Accident · 2 fatalClass 3 · FieldFinal reportGreg Hobbs Lightning · Torrance, CAThe failure of the pilot to maintain control of the airplane while performing a slip maneuver on final approach. Contributing was the failure of the pilot to fly a stabilized approach.Nov 30, 2022 · N60MY · Substantial damageNTSB CEN23FA050Accident · 2 fatalClass 3 · FieldFinal reportCessna 170 · Gage, OKThe non-certificated pilots’ loss of airplane control, resulting in an impact with terrain during final approach. Contributing to the accident was the airplane owner’s impairment due to his use of ethanol and depressant medications, in combination with his…Nov 28, 2022 · N2710D · DestroyedNTSB ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.Nov 27, 2022 · N201RF · Substantial damageNTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.Nov 25, 2022 · N361LX · Substantial damageNTSB ERA23LA068Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Manassas, VAA total loss of engine power for reasons that could not be determined based on the available evidence.Nov 21, 2022 · N7261F · Substantial damageNTSB DCA23WA071IncidentClass 5 · ForeignAirbus A320 · Marrakech, MoroccoNov 18, 2022 · G-MIDT · 2 aircraft · No damageNTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…Nov 15, 2022 · N247DH · Substantial damageNTSB ERA23LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 175 · Gilford, NHThe pilot’s decision to continue the approach to land in conditions where he was unable to see in front of the airplane due to sun glare, which resulted in in a collision a building.Nov 10, 2022 · N7223M · DestroyedNTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.Nov 9, 2022 · N234PM · DestroyedNTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · DestroyedNTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.Nov 5, 2022 · N700YZ · Substantial damageNTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.Nov 5, 2022 · N51AL · Substantial damageNTSB ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…Nov 3, 2022 · N84R · Destroyed