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 NYC99LA139Accident · No injuriesLimited investigationFinal reportAero Commander 500S · Windsor Locks, CTHydraulic system contamination which prevented normal landing gear extension. A factor was the misjudged landing flare by the flying pilot.Jun 12, 1999 · N33PG · Substantial damageNTSB MIA99LA174Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Seneca, SCThe PIC's improper fuel management resulting in loss of engine power during approach to landing due to fuel starvation and the subsequent collision with trees and a residence during an emergency landing. Contributing to the accident was the PIC's failure to…Jun 12, 1999 · N6407N · Substantial damageNTSB MIA99LA171Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lantana, FLThe poor in-flight planning by the pilot during the approach for a precautionary landing following a power interruption during the downwind leg, resulting in a go-around. A Contributing factor to the accident was the total loss of engine power during the…Jun 10, 1999 · N1578M · Substantial damageNTSB LAX99LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Weaverville, CAthe pilot's failure to follow prescribed procedures and directives for the particular airport.Jun 10, 1999 · N5577E · Substantial damageNTSB MIA99LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chapel Hill, NCThe failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.Jun 5, 1999 · N68762 · DestroyedNTSB MIA99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jackson, MSThe loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.Jun 5, 1999 · N78HR · Substantial damageNTSB LAX99LA211Accident · 1 fatalLimited investigationFinal reportCessna 150G · Rimrock, AZThe pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…Jun 5, 1999 · N2675J · Substantial damageNTSB LAX99LA206Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · St. David, AZThe pilot's failure to maintain an adequate reference approach airspeed for the existing gusty wind conditions, and, his improper (uncoordinated) use of the pitch and power controls to arrest the resulting high sink rate.Jun 3, 1999 · N234TT · Substantial damageNTSB DEN99LA095Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXInadequate remedial action by the pilot in command (CFI) after the student failed to maintain control of the aircraft during the final stages of a visual approach to land. Factors were gusting crosswinds and the flight instructor's lack of total instructional…Jun 3, 1999 · N4273E · Substantial damageNTSB LAX99LA203Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Reno, NVFuel starvation resulting from the pilot's inattentive monitoring and management of the fuel system.May 31, 1999 · N37MJ · Substantial damageNTSB LAX99LA204Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZThe failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.May 30, 1999 · N66018 · 2 aircraft · Substantial damageNTSB FTW99FA153Accident · 2 fatalField investigationFinal reportMooney M20B · Mesquite, TXThe failure by both pilots to maintain visual lookout. A factor was the inadequate radio communications maintained by both pilots while in the traffic pattern.May 29, 1999 · N74706 · 2 aircraft · DestroyedNTSB LAX99LA205Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZFuel exhaustion due to an inadequate fuel supply, and the pilot's inadequate in-flight planning fuel consumption calculations.May 28, 1999 · N9270C · Substantial damageNTSB SEA99LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, WAThe student pilot's inadequate recovery from a bounced landing, and his subsequent improper execution of the go-around procedure, resulting in collision with trees off the departure end of the runway. Factors included the student pilot's lack of total…May 27, 1999 · N5120D · Substantial damageNTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).May 27, 1999 · N2716C · DestroyedNTSB CHI99FA163Accident · 4 fatalField investigationFinal reportCessna 421B · Jefferson City, MOthe pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.May 27, 1999 · N34TM · DestroyedNTSB LAX99LA198Accident · No injuriesLimited investigationFinal reportCessna 150L · Paso Robles, CAthe pilot's failure to maintain aircraft control and the resulting intentional off-airport landing. Inadequate recurrent training and recent flight experience were factors in this accident.May 26, 1999 · N1371Q · Substantial damageNTSB CHI99FA165Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Elkhart, KSThe pilot's inadequate in-flight planning/decision and his inadvertent flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was the poor weather…May 25, 1999 · N400MJ · DestroyedNTSB ANC99LA064Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Anchorage, AKAn in-flight collision with a bird.May 25, 1999 · N72GC · Substantial damageNTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.May 23, 1999 · N6017P · Substantial damageNTSB LAX99LA193Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Merced, CAThe pilot's improper/inadequate use of the rudders during the attempted recovery from a bounced landing and his subsequent failure to maintain directional control of the aircraft.May 22, 1999 · N93J · Substantial damageNTSB FTW99FA143Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Rose Bud, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.May 22, 1999 · N95754 · Substantial damageNTSB NYC99LA114Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Columbus, OHthe failure of the pilot to follow the procedures in the Pilot's Operating Handbook, and the use of tip tanks for level flight only, which resulted in fuel starvation. A factor was the pilot's lack of familiarity with the airplane.May 21, 1999 · N7355R · Substantial damageNTSB DEN99LA082Accident · No injuriesLimited investigationFinal reportRich RV3-A · Bountiful, UTThe pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.May 21, 1999 · N4461V · Substantial damageNTSB ATL99LA095Accident · No injuriesLimited investigationFinal reportAircraft Parts & Dev. A-9B · Hartsell, ALThe pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.May 21, 1999 · N9082A · Substantial damageNTSB LAX99LA187Accident · No injuriesLimited investigationFinal reportCessna 150J · Alderpoint, CAThe pilot's inadequate compensation for the existing turbulent, gusty wind conditions during the approach. Contributing factors were the pilot's delayed go-around maneuver, the gusty and turbulent winds, and the tree.May 20, 1999 · N51096 · Substantial damageNTSB FTW99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taylor, TXThe pilot's failure to maintain a proper glide path, which resulted in a collision with a wire. A factor was the dark night condition.May 20, 1999 · N6558C · Substantial damageNTSB MIA99LA156Accident · 2 fatalLimited investigationFinal reportChampion Glastar · Mableton, GAAn in-flight loss of control for undetermined reasons, resulting in an in-flight collision with trees and the ground.May 19, 1999 · N75419 · DestroyedNTSB LAX99LA186Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · San Luis Obispo, CAThe student's inadvertent and uncoordinated application of forward cyclic during an autorotation flare, which resulted in a loss of main rotor rpm; and the flight instructor's inadequate supervision.May 19, 1999 · N8558N · Substantial damageNTSB DEN99LA078Accident · No injuriesLimited investigationFinal reportBell/Mason RV-6 · Albuquerque, NMThe loss of aircraft control for undetermined reasons. Factors were the sudden wind shift and wind gusts weather condition.May 14, 1999 · N107BB · Substantial damageNTSB DEN99FA077Accident · No injuriesField investigationFinal reportCessna 172Q · Greeley, COFailure of both the pilot receiving instruction and the flight instructor to maintain a visual lookout. A factor was the failure of the other pilot to maintain a visual lookout.May 13, 1999 · N96299 · 2 aircraft · Minor damageNTSB MIA99LA155Accident · 1 fatalLimited investigationFinal reportAero Commander 500B · Atlantic Ocean (Atlantic Ocean)an in-flight collision with water for undetermined reasons, due to the wreckage never being recovered from the water.May 12, 1999 · N6138X · DestroyedNTSB SEA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Salem, ORThe pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…May 9, 1999 · N7483L · Substantial damageNTSB NYC99LA109Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Phillipsburg, OHFuel starvation to the engine due to the pilot's failure to switch fuel tanks.May 9, 1999 · N722B · Substantial damageNTSB LAX99LA174Accident · No injuriesLimited investigationFinal reportCessna T303 · San Diego, CAThe pilot-in-command's inaccurate fuel consumption calculations that resulted in fuel exhaustion and the subsequent ditching.May 8, 1999 · N3303S · Substantial damageNTSB LAX99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.May 8, 1999 · N48845 · Substantial damageNTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.May 8, 1999 · N7001P · Substantial damageNTSB NYC99LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Oswego, NYThe pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.May 3, 1999 · N2716P · Substantial damageNTSB DEN99FA071Accident · 3 fatalField investigationFinal reportMooney M20E · Cedar City, UTThe pilot's inadequate fuel consumption calculations. Factors were the loss of engine power due to fuel exhaustion and the obscuring weather conditions.May 3, 1999 · N5594Q · DestroyedNTSB FTW99LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Claremore, OKThe pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.May 2, 1999 · N3732C · DestroyedNTSB ATL99LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Murfreesboro, TNThe pilot's misjudgment of altitude and distance to the runway.May 2, 1999 · N6382B · Substantial damageNTSB CHI99LA141Accident · Minor injuriesLimited investigationFinal reportBarrett Bensen B-8 · Mt. Pleasant, MIthe inadequate rotor rpm by the pilot.May 1, 1999 · N4659T · Substantial damageNTSB FTW99LA130Accident · No injuriesLimited investigationFinal reportCessna 210A · Bay City, TXThe pilot's inadequate management of fuel and his failure to follow the pre-landing checklist resulting in the loss of engine power as a result of fuel starvation. Factors were the pilot's physiological condition and the lack of suitable terrain for the…Apr 30, 1999 · N9404X · Substantial damageNTSB DEN99LA070Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…Apr 30, 1999 · N59235 · DestroyedNTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 172N · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.Apr 29, 1999 · N739FX · 2 aircraft · Substantial damageNTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.Apr 28, 1999 · N8426J · Substantial damageNTSB ATL99LA076Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth MINI-NIMBUS · Groveland, FLThe pilot's inability to locate a thermal and the in-flight encounter with a down draft.Apr 28, 1999 · N100GG · Substantial damageNTSB ANC99LA052Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Juneau, AKThe failure of the engine driven fuel pump for undetermined reasons. Factors associated with this accident were the low altitude at which the failure occurred resulting in task overload of the pilot, and landing the amphibious airplane in the swampy terrain…Apr 27, 1999 · N93311 · Substantial damageNTSB DEN99LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Wendover, UTThe pilot's improper preflight/in-flight planning and decision making, resulting in fuel supply exhaustion. A factor was the closed runway condition.Apr 26, 1999 · N906DS · Substantial damageNTSB LAX99FA161Accident · 2 fatalField investigationFinal reportCessna 210 · Hayward, CAThe pilot's inadequate preflight planning and his failure to verify fuel consumption during flight that resulted in fuel exhaustion and subsequent collision with obstacles and the ground.Apr 24, 1999 · N9512T · Destroyed