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 CHI93LA374Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot-in-command's failure to maintain airspeed. Factors were his lack of total experience and his premature retraction of the flaps.Sep 21, 1993 · N757MT · Substantial damageNTSB CHI93LA375Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Spencer, IAthe pilot's to switch fuel tanks which resulted in fuel starvation. A factor related to the accident was the rough terrain on which the airplane was landed.Sep 20, 1993 · N5309Y · Substantial damageNTSB CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.Sep 20, 1993 · N80323 · Substantial damageNTSB BFO93LA179Accident · No injuriesLimited investigationFinal reportCessna 172 · North Kingstown, RIThe pilot inadvertently allowed the airplane to stall as he was maneuvering to avoid birds on final approach.Sep 19, 1993 · N9931Q · Substantial damageNTSB ATL93LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student pilot's inadequate compensation for wind conditions during the touch and go landing. Factors were the crosswind conditions, and the hidden obstruction (rock) in the grass adjacent to the runway.Sep 19, 1993 · N4794B · Substantial damageNTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.Sep 18, 1993 · N1842F · Substantial damageNTSB ATL93LA160Accident · 1 fatalLimited investigationFinal reportCornwell KR-2 · Covington, TNThe pilot's misjudged obstacle clearance on final approach. Factors were, the dark night, and the pilot's defective distant vision.Sep 18, 1993 · N289DC · Substantial damageNTSB SEA93LA217Accident · No injuriesLimited investigationFinal reportBeech G35 · Arlington, WAFracture of the left stabilizer spar.Sep 15, 1993 · N4641D · Substantial damageNTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…Sep 15, 1993 · N3084T · Substantial damageNTSB BFO93IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe operator maintenance personnel's failure to perform an adequate inspection of the airplane, which led to a worn aileron cable which separated in flight and caused a loss of control.Sep 15, 1993 · N870BX · Minor damageNTSB ANC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prudhoe Bay, AKFluid fuel contamination as a result of the pilot-in-commands improper preflight planning/preparation.Sep 13, 1993 · N3996Z · Substantial damageNTSB ANC93FA175Accident · 1 fatalField investigationFinal reportCessna 152 · Fairbanks, AKThe student pilot's failure to maintain control of the airplane due to spatial disorientation. Factors were the dark night and the inadequate surveillance of the operation by the club management.Sep 13, 1993 · N95277 · Substantial damageNTSB BFO93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tangier Island, VAFailure of the pilot to maintain control of the aircraft during a go-around. A factor related to the accident was: the crosswind condition.Sep 11, 1993 · N5347J · Substantial damageNTSB LAX93LA348Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Floriston, CAthe flight instructor's failure to maintain main rotor RPM after initiating a go-around from a pinnacle approach. A factor in the accident was the high density altitude condition.Sep 10, 1993 · N47NH · Substantial damageNTSB MIA93LA193Accident · Serious injuriesLimited investigationFinal reportLegrand Avid Flyer · Titusville, FLThe pilot-in-command's failure to maintain airspeed (vso) in a go-around, resulting in an in-flight loss of control (stall).Sep 9, 1993 · N2067V · DestroyedNTSB CHI93IA354Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · St. Louis, MOa failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.Sep 8, 1993 · N350SW · Minor damageNTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.Sep 6, 1993 · N34367 · Substantial damageNTSB BFO93LA160Accident · No injuriesLimited investigationFinal reportSmyth Sidewinder · Point Pleasant, WVThe pilot's failure to maintain a proper glidepath.Sep 6, 1993 · N2116B · DestroyedNTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.Sep 4, 1993 · N5523P · Substantial damageNTSB CHI93LA348Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Blakesburg, IAThe pilot's failure to maintain clearance with the fence post and his midjudging the airplane glidepath.Sep 3, 1993 · N6582V · Substantial damageNTSB ANC93FA167Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Sanona Creek, AKThe pilot's failure to maintain flying speed during a downwind turn for landing. Factors contributing to the accident were: the overweight condition of the airplane, and failure to assure that the airplane complied with all applicable airworthiness…Sep 2, 1993 · N4713A · DestroyedNTSB NYC93LA183Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Penn Yan, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with an obstacle and the ground. A factor is the pilot's diverted attention.Aug 30, 1993 · N60721 · Substantial damageNTSB LAX93LA376Accident · No injuriesLimited investigationFinal reportCessna 182G · Carson City, NV1) the pilot's failure to maintain an appropriate airspeed during an attempted go around, 2) his failure to retract the landing flaps, and 3) the resulting inadvertent entry into a stall/mush condition.Aug 30, 1993 · N2082R · Substantial damageNTSB DEN93LA106Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palisade, COPartial power loss during approach for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 29, 1993 · N522BK · Substantial damageNTSB NYC93LA180Accident · No injuriesLimited investigationFinal reportMooney M20J · Kelley'S Island, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's inadequate handling of the airplane.Aug 28, 1993 · N202WB · Substantial damageNTSB CHI93LA340Accident · No injuriesLimited investigationFinal reportRobinson R22 · Bethalto, ILthe pilot-in-command's not maintaining rotor RPM.Aug 27, 1993 · N9071S · Substantial damageNTSB NYC93LA173Accident · Serious injuriesLimited investigationFinal reportCameron Bieu/V-65 · Lewiston, NYThe pilot's failure to maintain adequate clearance, which resulted in an inflight collision with a light pole.Aug 26, 1993 · N75192 · Substantial damageNTSB FTW93LA246Accident · No injuriesLimited investigationFinal reportCessna T210N · Springdale, ARThe loss of engine power due to fuel starvation and the improper use of the fuel selector. Factors were the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.Aug 26, 1993 · N6142Y · Substantial damageNTSB BFO93FA147Accident · No injuriesField investigationFinal reportMooney M20B · Landover, MDFatigue failure of a propeller blade, which resulted in severe engine vibration and subsequent damage to the airplane. The lack of suitable terrain for a forced landing was a related factor.Aug 24, 1993 · N74580 · Substantial damageNTSB CHI93LA334Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Hinckley, ILthe failure of the cockpit canopy.Aug 22, 1993 · N422BG · Substantial damageNTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.Aug 21, 1993 · N51677 · 2 aircraft · Minor damageNTSB MIA93FA180Accident · 2 fatalField investigationFinal reportGlasair SH-2F · Ocala, FLThe pilot-in-command's failure to maintain airspeed (vso) during a forced landing, resulting in an in-flight loss of control (stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot-in-command's improper positioning…Aug 20, 1993 · N87CK · DestroyedNTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.Aug 18, 1993 · N2125S · Substantial damageNTSB NYC93LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's inadequate supervision resulting in a delayed go-around.Aug 18, 1993 · N60648 · Substantial damageNTSB NYC93LA161Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Morgantown, WVThe pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.Aug 18, 1993 · N3552R · Substantial damageNTSB DCA93RA060Accident · Serious injuriesClass 1 · ForeignDouglas DC-8-61 · Guantanamo Bay, CubaAug 18, 1993 · N814CK · DestroyedNTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.Aug 15, 1993 · N5226E · 2 aircraft · DestroyedNTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.Aug 15, 1993 · N4846V · Substantial damageNTSB MIA93LA174Accident · No injuriesLimited investigationFinal reportCessna 150F · Pembroke Pines, FLTotal loss of engine power caused by fuel exhaustion and inadequate preflight planning/preparation by the pilot-in-command. Contributing to the accident was the inaccurate fuel quantity gauges and the lack of suitable terrain for the forced landing.Aug 12, 1993 · N7873F · Substantial damageNTSB LAX93LA320Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Delano, CAthe pilot's inadequate preflight inspection and his failure to refuel the aircraft.Aug 11, 1993 · N300GW · Substantial damageNTSB SEA93LA172Accident · No injuriesLimited investigationFinal reportBeech 76 · Portland, ORJamming of the nose landing gear assembly and the pilot-in-command not maintaining the proper glidepath during the nose gear up landing.Aug 9, 1993 · N3692X · Substantial damageNTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.Aug 7, 1993 · N3233C · DestroyedNTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.Aug 7, 1993 · N90BP · DestroyedNTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.Aug 6, 1993 · N6381B · Substantial damageNTSB SEA93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yellow Pine, IDThe pilot's improperly planned approach and delayed remedial action. A factor related to the accident was: the proximity of mountainous terrain.Aug 2, 1993 · N9554H · Substantial damageNTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.Aug 2, 1993 · N49899 · Substantial damageNTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.Aug 1, 1993 · N5958J · 2 aircraft · DestroyedNTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.Aug 1, 1993 · N864R · Substantial damageNTSB ATL93LA138Accident · No injuriesLimited investigationFinal reportMolino PIK-20 · Jonesville, NCThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.Aug 1, 1993 · N3WX · Substantial damageNTSB DEN93LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pagosa Springs, COThe decision by the pilot in command to fly at an altitude insufficient for the surrounding terrain. Factors were: the pilot's attention being momentarily diverted and the airplane's climb performance being exceeded.Jul 30, 1993 · CGLIL · Destroyed