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 ERA22LA263Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s loss of control during a go-around and the delayed remedial action initiated by the flight instructor, which resulted in a runway excursion and collision with trees.Jun 6, 2022 · N29501 · Substantial damageNTSB CEN22FA232Accident · 2 fatalClass 3 · FieldFinal reportCessna 182G · Kenedy, TXA loss of airplane control on final approach for reasons that could not be determined.Jun 6, 2022 · N2118R · DestroyedNTSB CEN22LA233Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Amarillo, TXThe loss of engine power due to a leak in the fuel control assembly. Contributing to the accident was the inadequate maintenance of the fuel control assembly.Jun 4, 2022 · N9087S · Substantial damageNTSB WPR22FA196Accident · 2 fatalClass 3 · FieldFinal reportBeech 19A · Oroville, CAThe pilot’s failure to maintain proper airspeed during a turn and his exceedance of the airplane’s critical angle of attack, which resulted in an accelerated stall. Contributing to the accident was the improper placement of the fuel selector, which resulted…Jun 2, 2022 · N7641R · Substantial damageNTSB CEN22LA251Accident · No injuriesClass 3 · LimitedFinal reportTrojan TA16 · Ray, MIA lack of lubrication and inadequate cooling, which resulted in internal damage to the engine and a subsequent total loss of engine power.Jun 2, 2022 · N36YR · Substantial damageNTSB CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.Jun 2, 2022 · N65497 · Substantial damageNTSB ERA22LA254Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Tredyffin, PAThe loosening of the throttle arm from the throttle body, which resulted in the pilot’s inability to control the engine, and a subsequent forced landing.Jun 1, 2022 · N432CP · Substantial damageNTSB CEN22LA220Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA-1B · River Falls, WIThe student pilot’s and flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 1, 2022 · N6298L · Substantial damageNTSB WPR22LA192Accident · 1 fatalClass 3 · LimitedFinal reportMaule MX-7-180C · Willits, CAAn uncommanded descent during a go-around maneuver for undetermined reasons.May 30, 2022 · N1043B · DestroyedNTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…May 30, 2022 · N44508 · DestroyedNTSB ANC22LA038Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Glacier View, AKThe pilot's failure to maintain adequate airspeed during the landing approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at an altitude too low to recover.May 29, 2022 · N4024Z · Substantial damageNTSB CEN22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Canyon Lake, TXThe pilot’s failure to retract the flaps during a go-around, which resulted in decreased climb performance and a subsequent collision with trees and terrain.May 28, 2022 · N3842Q · Substantial damageNTSB CEN22LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Princeton, MNThe pilot’s failure to maintain proper approach glide path, which resulted in a collision with trees.May 27, 2022 · N2899N · Substantial damageNTSB ANC22LA035Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-3 · Yakutat, AKThe pilot’s failure to determine the actual weight and balance of the airplane before departure, which resulted in the airplane being operated outside of the aft center of gravity limits and the subsequent aerodynamic stall on final approach. Contributing to…May 24, 2022 · N703TH · Substantial damageNTSB GAA22WA274AccidentClass 5 · ForeignBeech 90 · Le Bourget, FranceMay 23, 2022 · F-HHAM · No damageNTSB DCA22WA146IncidentClass 5 · ForeignAirbus A320 · Paris, FranceMay 23, 2022 · 9H-EMU · No damageNTSB WPR22FA184Accident · 1 fatalClass 3 · FieldFinal reportBruce R Prouse M24 Orion Plus · Cape Girardeau, MOThe pilot’s failure to maintain controlled flight, which resulted in a hard left roll, excessive blade flapping and a subsequent in-flight separation of the right horizontal stabilizer.May 22, 2022 · N590DM · Substantial damageNTSB ERA22LA241Accident · No injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik Sportstar · Lancaster, OHThe improper installation and subsequent failure of the pushrod O-rings, which resulted in failure of the No. 4 connecting rod due to oil starvation.May 21, 2022 · N503RK · Substantial damageNTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…May 20, 2022 · N76075 · DestroyedNTSB ANC22LA033Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Anchorage, AKA loss of engine power for reasons that could not be determined due to a lack of available evidence.May 17, 2022 · N927AP · Substantial damageNTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.May 15, 2022 · N17879 · Substantial damageNTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.May 11, 2022 · N8007P · DestroyedNTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.May 11, 2022 · N73670 · DestroyedNTSB CEN22LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Traverse City, MIThe failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.May 10, 2022 · N184NW · Substantial damageNTSB GAA22WA203Accident · No injuriesClass 5 · ForeignPiper PA28 · Kastrup, DenmarkMay 3, 2022 · UNREG · Substantial damageNTSB ERA22LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Toms River, NJLoss of engine power due to the throttle linkage becoming disconnected in flight due to improper maintenance.May 1, 2022 · N737LY · Substantial damageNTSB ERA22LA213Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV7 · Huntsville, ALThe pilot’s impairment due to the effects of ethanol, which resulted in a loss of airplane control and an impact with terrain on approach to landing.May 1, 2022 · N1218B · Substantial damageNTSB GAA22WA173Accident · 1 fatalClass 3 · ForeignRockwell 690 · Charallave, VenezuelaApr 30, 2022 · YV3502 · Substantial damageNTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.Apr 21, 2022 · N9263H · Substantial damageNTSB WPR22LA153Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glasair Super II · Oxnard, CAThe pilot’s failure to maintain airplane control while on final approach, which resulted in a collision with a runway approach light.Apr 16, 2022 · N90YY · Substantial damageNTSB ANC22FA030Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Gila Bend, AZThe student pilot’s failure to maintain control during the landing approach.Apr 15, 2022 · N7516G · Substantial damageNTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…Apr 13, 2022 · N928JP · Substantial damageNTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.Apr 8, 2022 · N248G · Substantial damageNTSB WPR22LA145Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 162 · Palo Alto, CAThe pilot’s failure to maintain pitch control during a go-around maneuver, which resulted in an aerodynamic stall and impact with the ground.Apr 6, 2022 · N6076C · Substantial damageNTSB DCA22WA107IncidentClass 5 · ForeignBoeing 777 · Paris, FranceApr 5, 2022 · F-GSQJ · No damageNTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.Apr 4, 2022 · N41XL · Substantial damageNTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.Apr 2, 2022 · N2656V · Substantial damageNTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.Apr 2, 2022 · N123LS · Substantial damageNTSB WPR22LA138Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Michael E Cozy Mark IV · Tucson, AZThe total loss of engine power during an approach due to clogged fuel filters, which resulted from an epoxide sealant used in manufacture of the airplane deteriorating and clogging the fuel filter.Mar 30, 2022 · N294MV · Substantial damageNTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.Mar 29, 2022 · N22LV · Substantial damageNTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.Mar 29, 2022 · N469SL · No damageNTSB CEN22LA162Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Slidell, LAThe flight instructor’s failure to adequately correct for a loss of directional control during a simulated single engine approach.Mar 29, 2022 · N4299C · Substantial damageNTSB ERA22LA167Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Winder, GAMaintenance personnel’s failure to detect the damaged aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and subsequent loss of airplane control.Mar 25, 2022 · N62283 · DestroyedNTSB CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.Mar 25, 2022 · N8869V · Substantial damageNTSB ANC22LA027Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Chitina, AKThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in a stall and impact with terrain.Mar 25, 2022 · N7074K · Substantial damageNTSB CEN22LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna L-19E · Sunflower, MSThe total loss of engine power for reasons that could not be determined.Mar 24, 2022 · N4583S · Substantial damageNTSB WPR22LA132Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Howe, IDThe pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.Mar 22, 2022 · N44DQ · Substantial damageNTSB DCA22WA221Occurrence · No injuriesClass 5 · ForeignBoeing 777 · Islamabad, PakistanMar 21, 2022 · SVA724 · No damageNTSB ANC22LA023Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 BA · Valdez, AKThe pilot's failure to maintain a proper approach path in flat light conditions, which resulted in landing short of the intended landing spot and impact with terrain.Mar 15, 2022 · N99676 · Substantial damageNTSB WPR22LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Lancaster, CAA total loss of engine power due to the pilot’s inadequate fuel management which resulted in fuel starvation and subsequent collision with a fence during landing.Mar 14, 2022 · N94001 · Substantial damage