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 ERA23LA349Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Leonardtown, MDA loss of engine power during an approach to landing for undetermined reasons.Aug 24, 2023 · N955LS · Substantial damageNTSB DCA23WA437IncidentClass 5 · ForeignEmbraer 190 · Alice Springs, AustraliaAug 24, 2023 · VH-UYN · No damageNTSB WPR23LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Santa Rosa, CAThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel exhaustion.Aug 19, 2023 · N3282L · Substantial damageNTSB DCA23WA416Accident · 10 fatalClass 5 · ForeignRaytheon 390 · Elmina, MalaysiaAug 17, 2023 · N28JV · DestroyedNTSB DCA23WA413Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomAug 9, 2023 · G-NPTHNTSB CEN23LA351Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft F21 · Holliday, TXA loss of engine power for reasons that could not be determined, which resulted in impact with terrain.Aug 7, 2023 · N2005J · Substantial damageNTSB ENG23LA033Incident · No injuriesClass 3 · LimitedFinal reportAirbus A320 · Jacksonville, FLThe loss of both Integrated Drive Generators (IDG) due to worn fixed cylinder block bores, which caused the IDGs to be tripped offline and caused the airplane to enter an emergency electrical configuration.Aug 3, 2023 · N649JB · No damageNTSB CEN23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Philadelphia, PAThe pilot receiving instruction’s failure to maintain control during a go-around. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.Aug 3, 2023 · N860TW · Substantial damageNTSB WPR23FA299Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport SportCruiser · Van Nuys, CAThe misalignment of the carburetor piston slides, which resulted in a partial loss of engine power, and the flight instructor’s failure to maintain control of the airplane during an emergency landing, leading to an aerodynamic stall and impact with terrain.Aug 2, 2023 · N384SC · DestroyedNTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.Aug 1, 2023 · N31PB · Substantial damageNTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.Jul 30, 2023 · N8675W · Substantial damageNTSB CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.Jul 30, 2023 · N967DT · Substantial damageNTSB CEN23FA333Accident · 2 fatalClass 3 · FieldFinal reportRotorway 162F · Oshkosh, WIThe failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.Jul 29, 2023 · N193AZ · 2 aircraft · DestroyedNTSB GAA23WA230Accident · 2 fatalClass 5 · ForeignCessna 172 · Trujillo, PeruJul 28, 2023 · OB-1334 · DestroyedNTSB DCA23WA410IncidentClass 5 · ForeignBoeing 737 · Rio De Janeiro, BrazilJul 28, 2023 · PR-GXM · No damageNTSB WPR23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Eastsound, WAThe pilot’s improper in-flight fuel management, which led to fuel starvation and a total loss of engine power.Jul 27, 2023 · N6201M · Substantial damageNTSB ERA23LA316Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Maiden, NCThe flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.Jul 27, 2023 · N6194Q · Substantial damageNTSB CEN23LA330Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cortland, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing.Jul 27, 2023 · N30632 · Substantial damageNTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Jul 24, 2023 · N279WN · No damageNTSB CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.Jul 23, 2023 · N365B · Substantial damageNTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.Jul 23, 2023 · N17043 · Substantial damageNTSB WPR23LA278Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS-355E Twin Star · Farmington, UTThe premature failure of one of the No. 2 engine compressor bleed valve, which resulted in a partial loss of power to that engine.Jul 19, 2023 · N102UM · Substantial damageNTSB ERA23LA300Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46 · Vineyard Haven, MAThe pilot’s incapacitation due to a sudden in-flight cardiac event, which resulted in a gear-up landing.Jul 15, 2023 · N444RR · Substantial damageNTSB GAA23WA234Accident · No injuriesClass 5 · ForeignCessna 172 · Kohnan, JapanJul 14, 2023 · JA10AZ · Minor 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 WPR23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · San Rafael, CAThe total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.Jul 9, 2023 · N4922G · Substantial damageNTSB WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…Jul 8, 2023 · N819KR · DestroyedNTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.Jul 8, 2023 · N4743M · Substantial damageNTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.Jul 7, 2023 · N15RP · DestroyedNTSB GAA23WA198Accident · 1 fatalClass 4 · ForeignPiper 23 · Thirsk, United KingdomJul 6, 2023 · G-BKJW · DestroyedNTSB CEN23LA271Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Siloam Springs, ARThe pilot’s failure to maintain clearance from power lines while on final approach to land.Jun 30, 2023 · N739GU · Substantial damageNTSB CEN23LA268Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity Velocity XL · Tahlequah, OKA total loss of engine power for undetermined reasons.Jun 27, 2023 · N340XL · Substantial damageNTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.Jun 26, 2023 · N26DX · Substantial damageNTSB GAA23WA175AccidentForeign investigationPiper PA28 · Bournemouth, United KingdomJun 26, 2023 · G-AVLGNTSB CEN23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Hot Springs, ARThe pilot’s improper preflight fuel planning and inflight fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent failure to maintain adequate airspeed during the forced landing, which resulted in the…Jun 26, 2023 · N3138T · Substantial damageNTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.Jun 24, 2023 · N285MG · Substantial damageNTSB CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.Jun 24, 2023 · N4008Q · Substantial damageNTSB GAA23WA214Accident · No injuriesClass 5 · ForeignBell 206B · Thetford Mines, CanadaJun 23, 2023 · N717LM · Substantial damageNTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.Jun 21, 2023 · N10BR · Substantial damageNTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.Jun 21, 2023 · N308ED · Substantial damageNTSB GAA23WA181Accident · No injuriesClass 5 · ForeignCessna 310 · Derby, AustraliaJun 20, 2023 · VH-DAW · Substantial damageNTSB CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.Jun 17, 2023 · N7509X · Substantial damageNTSB CEN23LA240Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC-65 · Sibley, IAThe pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.Jun 15, 2023 · N23679 · Substantial damageNTSB 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 ENG24WA001IncidentClass 5 · ForeignDe Havilland DHC8 · Timaru, New ZealandJun 13, 2023 · ZK-NEM · No damageNTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.Jun 12, 2023 · N88GJ · Substantial damageNTSB DCA23WA318IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomJun 12, 2023 · G-FDZX · No damageNTSB GAA23WA166Accident · No injuriesClass 5 · ForeignBeech A36 · Teresina, Pi, BrazilJun 11, 2023 · PT-DLO · Substantial damageNTSB CEN23LA237Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Pratt, KSFuel exhaustion due to the pilot’s inadequate preflight planning.Jun 11, 2023 · N85RB · Substantial damageNTSB DCA23WA314Incident · No injuriesClass 5 · ForeignBoeing 717 · Cambridge, AustraliaJun 6, 2023 · VH-NXM · No damage