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 GAA21WA117AccidentClass 5 · ForeignCessna 172 · Guatemela, GuatemalaMay 18, 2021 · TG-AER · Substantial damageNTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.May 18, 2021 · N521CT · DestroyedNTSB GAA21WA140Accident · No injuriesClass 5 · ForeignCessna 310 · Ribeirão Preto, BrazilMay 13, 2021 · PT-IIM · Substantial damageNTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.May 13, 2021 · N5170K · Substantial damageNTSB CEN21FA215Accident · No injuriesClass 3 · FieldFinal reportSwearingen SA226TC · Englewood, COThe Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…May 12, 2021 · N280KL · 2 aircraft · Substantial damageNTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.May 11, 2021 · N47AF · Substantial damageNTSB ERA21LA220Accident · No injuriesClass 4 · LimitedFinal reportDouglas K Thompson Justaircraft Superst · Brunswick, METhe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of directional control during the approach and landing.May 10, 2021 · N184DT · Substantial damageNTSB GAA21WA114Accident · 2 fatalClass 5 · ForeignLegacy 2000 · Oberramsern, SwitzerlandMay 8, 2021 · HB-YMS · Substantial damageNTSB WPR21LA183Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Mesa, AZA tail rotor blade strike to an undetermined object while practicing approaches to unimproved terrain.May 5, 2021 · N6068S · Substantial damageNTSB CEN21FA209Accident · 4 fatalClass 3 · FieldFinal reportMitsubishi MU2B · Hattiesburg, MSThe pilot’s failure to maintain control of the airplane during the night instrument approach which resulted in an inadvertent aerodynamic stall from which the pilot was unable to recover.May 5, 2021 · N322TA · DestroyedNTSB ENG21WA030IncidentClass 5 · ForeignDe Havilland DHC6 · Wallis & Futuna, Wallis & FutunaMay 3, 2021 · F-OCQZ · No damageNTSB ERA21LA202Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Martinsville, VAThe pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.May 2, 2021 · N1089D · Substantial damageNTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.May 1, 2021 · N125WC · DestroyedNTSB WPR21LA179Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30B · Corvallis, ORThe pilot’s failure to maintain airplane control during a simulated engine out landing which resulted in impact with terrain.Apr 29, 2021 · N125RJ · Substantial damageNTSB ERA21LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · Hyannis, MAThe flight instructor’s failure to confirm the position of the left engine’s auxiliary fuel boost pump switch during a simulated engine out procedure, which resulted in an excess amount of fuel in the engine and subsequent partial loss of power during a…Apr 26, 2021 · N2714B · Substantial damageNTSB ANC21LA033Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Anchorage, AKThe pilot’s mismanagement of fuel which resulted in fuel starvation and total loss of engine power during a go-around. Contributing to the accident was the improperly marked fuel quantity gauges that failed to indicate a fuel quantity takeoff limitation.Apr 26, 2021 · N77219 · Substantial damageNTSB CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.Apr 24, 2021 · N587CD · DestroyedNTSB ANC21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Tyonek, AKThe pilot’s loss of directional control while dragging the surface of an ice- and snow-covered lake in gusting wind conditions, which resulted in an impact with a tree.Apr 21, 2021 · N180RJ · Substantial damageNTSB CEN21LA193Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · McKinney, TXA total loss of engine power for reasons that could not be determined based on the available information.Apr 18, 2021 · N2973R · Substantial damageNTSB ERA21LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Venice, FLA total loss of engine power for reasons that could not be determined based on the available information.Apr 17, 2021 · N60457 · Substantial damageNTSB WPR21LA176Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV4 · Oljato-Monument Valley, UTThe pilot’s failure to maintain airplane control while compensating for a downdraft during landing, which resulted in the airplane touching down short of the runway on soft terrain and nosing over.Apr 15, 2021 · N345DL · Substantial damageNTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.Apr 12, 2021 · N7242F · Substantial damageNTSB ENG21WA024Incident · No injuriesClass 5 · ForeignBAE ATP · Ronaldsway, Isle of ManApr 9, 2021 · SE-LPS · No damageNTSB GAA21WA079Accident · No injuriesClass 5 · ForeignPiper PA28 · Roskilde, DenmarkApr 8, 2021 · OY-JEC · Minor damageNTSB ERA21LA172Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics Phantom II · McBee, SCThe pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.Apr 4, 2021 · UNREG · Substantial damageNTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…Apr 1, 2021 · N7274F · Substantial damageNTSB ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.Mar 29, 2021 · N1968P · Substantial damageNTSB DCA21LA109Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer EMB-145LR · Charlotte, NCan encounter with convective turbulence during descent.Mar 28, 2021 · N650AE · No damageNTSB CEN21LA168Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Justin, TXThe total loss of engine power due to carburetor icing.Mar 27, 2021 · N42769 · Substantial damageNTSB CEN21LA167Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Bridgeport, TXThe pilots’ failure to maintain adequate airspeed during a simulated power-off approach in gusting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and loss of control.Mar 26, 2021 · N3953N · Substantial damageNTSB CEN21LA164Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons Z-90 · Celina, TXThe malfunction of the balloon’s envelope venting system during landing in high wind, which resulted in the balloon being dragged along the ground, substantially damaging the envelope.Mar 20, 2021 · N4505B · Substantial damageNTSB WPR21LA184Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Las Vegas, NVA total loss of engine power due to fuel exhaustion.Mar 18, 2021 · N2548R · Substantial damageNTSB DCA21WA100IncidentClass 5 · ForeignBoeing 737 · Tijuana, MexicoMar 16, 2021 · XA-AMM · No damageNTSB DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachMar 15, 2021 · N789AN · No damageNTSB WPR21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172G · Sisters, ORA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.Mar 4, 2021 · N4456L · Substantial damageNTSB GAA21WA137Accident · No injuriesClass 4 · ForeignPiper PA-30 · Courcelles-sur-Viosnes, FranceMar 2, 2021 · N7977Y · Substantial damageNTSB ERA21LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C · Panacea, FLThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack during short final approach, which resulted in an aerodynamic stall at low altitude.Feb 28, 2021 · NC7014H · Substantial damageNTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.Feb 27, 2021 · N6135T · Substantial damageNTSB ANC21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Lanai, HIA total loss of engine power for reasons that could not be determined based on the available evidence.Feb 26, 2021 · N680DS · Substantial damageNTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.Feb 25, 2021 · UNREG · Substantial damageNTSB GAA21WA030Accident · No injuriesClass 5 · ForeignCessna 172 · Bloemfontein, South AfricaFeb 21, 2021 · ZS-SUI · Substantial damageNTSB GAA21WA027Accident · 3 fatalClass 5 · ForeignPiper PA-28-140 · Ilopango, El SalvadorFeb 20, 2021 · N95207 · DestroyedNTSB ERA21FA133Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32RT · Vinemont, ALA loss of engine power for reasons that could not be determined.Feb 20, 2021 · N10KV · DestroyedNTSB ERA21LA132Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Indian Head, MDThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a total loss of engine power. Contributing was the flight instructor’s mismanagement of the precautionary landing approach.Feb 17, 2021 · N8428J · Substantial damageNTSB ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.Feb 10, 2021 · N8183C · Substantial damageNTSB ERA21LA124Accident · 2 fatalClass 3 · LimitedFinal reportCessna 441 · Belvidere, TNThe pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.Feb 7, 2021 · N44776 · DestroyedNTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.Feb 4, 2021 · N8107S · Substantial damageNTSB GAA21WA028Incident · No injuriesClass 5 · ForeignTextron 172S · Kitakyushu, JapanFeb 3, 2021 · JA393ANTSB ERA21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Leicester, MAThe pilot’s failure to maintain the minimum airspeed for flight in icing conditions, which resulted in a loss of elevator control during approach due to ice accumulation.Feb 2, 2021 · N221ST · Substantial damageNTSB DCA21WA078Incident · No injuriesClass 5 · ForeignBoeing 737 · Sydney, AustraliaJan 27, 2021 · Vh-XMO · No damage