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 CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.Jun 21, 2001 · N5659V · Substantial damageNTSB SEA01LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Port Townsend, WAAn improper decision by the pilot to initiate an evasive maneuver toward the ground at low altitude, resulting in a hard landing. A factor was the aircraft's low altitude.Jun 20, 2001 · N19218 · Substantial damageNTSB CHI01LA179Accident · Serious injuriesLimited investigationFinal reportCessna T310P · St. Cloud, MNthe fuel starvation. Fuel management by the pilot was an additional cause. The muddy terrain was a contributing factor.Jun 20, 2001 · N5883M · Substantial damageNTSB MIA01LA166Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe failure of the pilot to maintain aircraft altitude control while on downwind leg of the landing pattern, resulting in an uncontrolled descent and in-flight collision with the terrain.Jun 19, 2001 · N23672 · DestroyedNTSB LAX01FA212Accident · 1 fatalField investigationFinal reportSchultz Lancair IV-P · Flagstaff, AZthe builder's failure to install a fuel compartment vent in the right wing, affecting the total available fuel capacity, and resulting in the loss of engine power due to fuel starvation. A contributing factor was the pilot's intentional flight with a known…Jun 16, 2001 · N424E · Substantial damageNTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.Jun 16, 2001 · N75238 · Substantial damageNTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.Jun 14, 2001 · N1525Q · Substantial damageNTSB MIA01FA162Accident · 1 fatalField investigationFinal reportBeech C90 · Fort Lauderdale, FLthe pilot's failure to properly plan fuel consumption and to perform an en route refueling, resulting in a total loss of engine power due to fuel exhaustion while on downwind leg for landing at eventual destination, causing an emergency descent and collision…Jun 14, 2001 · YV2466P · DestroyedNTSB LAX01FA207Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Stockton, CAa loss of engine power for undetermined reasons. Also causal was the inadequate supervision of the flight by the CFI for allowing a simulated emergency maneuver to continue below an altitude which would not allow for recovery contingencies.Jun 14, 2001 · N70SL · DestroyedNTSB FTW01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Magnolia, TXthe pilot's failure to maintain clearance over the wires while on final approach.Jun 11, 2001 · N210BK · Substantial damageNTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.Jun 8, 2001 · N64429 · Substantial damageNTSB MIA01FA151Accident · 3 fatalField investigationFinal reportMooney M-20J · Monroe, NCThe pilot in command’s failure to maintain airspeed while maneuvering to avoid objects, resulting in a stall/mush and collision with the terrain during uncontrolled descent. Contributing to the accident was the improper approach to land and his failure to…Jun 6, 2001 · N4780H · DestroyedNTSB ATL01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Blakely, GAThe pilot's inadequate in-flight decision to go-around after a reported loss of right brake pressure during the landing roll resulted in the in-flight collision with trees.Jun 5, 2001 · N9890P · DestroyedNTSB ATL01LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Picayune, MSThe pilot's inflight fuel planning /decision that resulted in fuel starvation and a loss of engine power. A factor was the failure of the fuel transfer pump.Jun 4, 2001 · N18PF · Substantial damageNTSB ANC01LA065Accident · No injuriesLimited investigationFinal reportCessna 170B · Sand Point, AKThe pilot's inadequate compensation for wind conditions while on approach, and the inadvertent stall of the airplane while attempting a go-around. A factor associated with the accident was a crosswind.Jun 4, 2001 · N4659C · Substantial damageNTSB DEN01LA109Accident · Serious injuriesLimited investigationFinal report2001 Mcgirl Questair Venture · Ogden, UTan in-flight fire, which originated from a fuel leak of unknown origin.Jun 1, 2001 · N5QV · DestroyedNTSB ANC01LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Wasilla, AKAn undershoot due to the pilot's failure to maintain a proper glide path during a VFR final approach to landing. A factor in the accident was a downdraft.May 31, 2001 · N8054X · DestroyedNTSB DEN01LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Elizabeth, COthe loss of engine power during approach for an undetermined reason. A contributing factor was the high density altitude.May 30, 2001 · N83GT · Substantial damageNTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.May 27, 2001 · N761DL · Substantial damageNTSB LAX01LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Pauma Valley, CAThe pilot's intentional flight into instrument meteorological conditions and failure to maintain clearance from terrain during an approach for landing under visual flight rules.May 27, 2001 · N8287G · Substantial damageNTSB IAD01LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-310 · Uniontown, OHFuel exhaustion due to the pilot's failure to perform fuel calculations. A factor was the inboard fuel tank probes not being within the manufacturer's resistance limits, which resulted in inaccurate fuel gauges.May 22, 2001 · N35WT · Substantial damageNTSB LAX01LA188Accident · No injuriesLimited investigationFinal reportWright Avid Flyer · Show Low, AZthe pilot's failure to maintain control of the airplane during a go-around, which resulted in an in-flight collision with terrain and a nose down. A contributing factor was the turbulence.May 20, 2001 · N214DW · Substantial damageNTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.May 19, 2001 · N4053F · Substantial damageNTSB NYC01FA127Accident · Serious injuriesField investigationFinal reportBeech C90 · Islip, NYThe pilot’s failure to activate the fuel transfer pumps in accordance with the check list, which resulted in fuel exhaustion.May 18, 2001 · N270TC · Substantial damageNTSB FTW01LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Houston, TXthe failure of the pilot to maintain control of the helicopter following an inadvertent deactivation of the hydraulic system, during final approach. A contributory factor was the unguarded hydraulic cut-off switch.May 18, 2001 · N311TV · Substantial damageNTSB ATL01LA053Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Fort Lauderdale, FLThe pilot's failure to pre-flight adequate fuel for the flight.May 15, 2001 · N1013V · Substantial damageNTSB FTW01FA117Accident · 2 fatalField investigationFinal reportConvair BT-13A · Odessa, TXthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in a loss of control while performing a go-around. A contributing factor to the accident was the gusty tailwind condition.May 14, 2001 · N66791 · DestroyedNTSB LAX01LA176Accident · No injuriesLimited investigationFinal reportLeonard Walters Avid Magnum · Lake Shasta, CAA loss of control on final approach due to encountering a strong wind gust and downdraft.May 13, 2001 · N21911 · Substantial damageNTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.May 13, 2001 · N8246M · DestroyedNTSB NYC01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26E · New Milford, CTthe student pilot's improper decision to fly northeast of the airport with winds from the southwest, and his subsequent diverted attention to the glider's proximity to the airport while he searched for thermals, which resulted in an off airport landing.May 12, 2001 · N33907 · Substantial damageNTSB NYC01LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ithaca, NYThe pilot's failure to follow the published instrument approach procedure.May 12, 2001 · N36127 · Substantial damageNTSB SEA01LA088Accident · No injuriesLimited investigationFinal reportMaule Air M-7-235 · Everett, WAA system failure for undetermined reasons while on final approach. The pilot's failure to maintain control of the aircraft was a factor.May 11, 2001 · N5669S · Substantial damageNTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…May 9, 2001 · N47GM · DestroyedNTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.May 6, 2001 · N8664U · Substantial damageNTSB LAX01LA174Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Adelanto, CAThe pilot's stall/mush as a result of his inadequate airspeed and improperly planned final approach.May 5, 2001 · N7605 · Substantial damageNTSB DEN01FA094Accident · 1 fatalField investigationFinal reportCessna 208B · Steamboat Spngs, COan inadvertent stall during an instrument approach, which resulted in a loss of control. Contributing factors were the pilot's attention being diverted by an abnormal indication, conditions conducive to airframe icing, and the pilot's lack of total experience…May 5, 2001 · N948FE · DestroyedNTSB FTW01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Patterson, LAthe pilot's failure to maintain control during the go-around. A contributing factor was the wind gust.May 4, 2001 · N5247R · Substantial damageNTSB ANC01LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Chefornak, AKThe pilot's inadvertent stall/mush during the final phase of the landing approach. A factor associated with the accident is a crosswind.May 3, 2001 · N4089W · Substantial damageNTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.Apr 29, 2001 · N12891 · Substantial damageNTSB DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.Apr 28, 2001 · N40555 · Substantial damageNTSB FTW01FA104Accident · 1 fatalField investigationFinal reportCessna 402B · Del Rio, TXthe loss of control due to a jammed trim tab, which resulted from the failure of maintenance personnel to properly secure the trim tab actuator rod when installing a replacement elevator.Apr 26, 2001 · N80Q · DestroyedNTSB DEN01LA091Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Columbus, NMThe impact with terrain following an inadvertent stall/mush by the pilot during a go-around. A contributing factor was a dust devil.Apr 26, 2001 · N6671V · Substantial damageNTSB SEA01LA077Accident · No injuriesLimited investigationFinal reportCessna 172S · Renton, WAA Canadian goose which crossed the aircraft's flight path and impacted the left wing during the aircraft's final approach.Apr 24, 2001 · N435SP · Substantial damageNTSB NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.Apr 22, 2001 · N3117T · Substantial damageNTSB MIA01LA134Accident · No injuriesLimited investigationFinal reportDavid G. Holmes Bensen Gyrocopter · Troy, ALThe failure of the pilot to maintain airspeed during the approach resulting in a hard landing. A contributing factor in the accident was the loss of engine power during final approach due to undetermined reasons.Apr 22, 2001 · N218DH · Substantial damageNTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.Apr 21, 2001 · N286FT · Substantial damageNTSB SEA01LA074Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hagerman, IDThe pilot's failure to maintain proper runway alignment during an attempted go-around, resulting in an inflight collision with a wind sock. Factors were a short runway/landing area condition, the pilot's excessive airspeed on final approach, and the wind sock.Apr 17, 2001 · N440PS · Substantial damageNTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.Apr 17, 2001 · N888SM · DestroyedNTSB NYC01LA098Accident · Minor injuriesLimited investigationFinal reportFobes CGS Hawk Plus · West Middlesex, PAThe partial loss of engine power, for undetermined reasons. Factors included the headwinds on base leg, and the unsuitable terrain for a forced landing.Apr 8, 2001 · UNREG · DestroyedNTSB DEN01FA082Accident · 2 fatalField investigationFinal reportSandell Zenith CH 200 · Canon City, COthe pilot in command inadvertently allowing the airplane to stall/spin. Contributing factors were the pilot's total lack of experience in airplane make/model, and high wind conditions.Apr 8, 2001 · N49DE · Destroyed