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 LAX93LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Turlock, CAThe pilot's poorly planned approach and his failure to maintain airspeed.May 29, 1993 · N12857 · DestroyedNTSB FTW93FA165Accident · 4 fatalField investigationFinal reportFairchild SA-226T · Santa Fe, NMThe pilot's poorly planned circling approach, and his failure to maintain an adequate altitude. Factors which contributed to the accident were: the dark night and a lack of visual reference.May 26, 1993 · N241DT · DestroyedNTSB FTW93FA163Accident · No injuriesField investigationFinal reportMBB BK 117 A-4 · Lafayette, LACyclic control rod movement was restricted due to improper installation of the lateral cyclic control rod by company maintenance personnel.May 25, 1993 · N401PH · Substantial damageNTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.May 23, 1993 · N4321D · Substantial damageNTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…May 22, 1993 · N693JS · Substantial damageNTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.May 22, 1993 · N1497V · Substantial damageNTSB BFO93LA095Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Johnson City, NYImproper planning/decision by the flight crew. Factors related to the accident were: the downdraft on final approach, the terrain conditions (cliff & obstructions) near the approach end of the runway, and the lack of relative experience for each of the pilots.May 21, 1993 · N17870 · Substantial damageNTSB MIA93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot-in-command's failure to initiate a climb.May 20, 1993 · N93137 · Substantial damageNTSB FTW93FA158Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Weatherford, TXTotal loss of engine power with cause undetermined. A factor was the lack of suitable terrain.May 17, 1993 · N4924Z · Substantial damageNTSB MIA93FA121Accident · 2 fatalField investigationFinal reportBell 47-G · Parker, FLthe misjudgement of the distance by the nonrated pilot-in-command and subsequent collision with a tree. Contributing to the accident was the lack of helicopter experience of the pilot-in-command.May 16, 1993 · N970B · DestroyedNTSB LAX93FA215Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe pilot prematurely raising the airplane's flaps at an airspeed insufficient to maintain flight which resulted in an inadvertent stall mush condition. A factor in this accident was the darkness of the night.May 16, 1993 · N26075 · No damageNTSB CHI93DEP01Accident · No injuriesFinal reportBryant Mustang II · Kenosha, WIThe pilot-in-command's not maintaining control of the aircraft.May 16, 1993 · N90YP · DestroyedNTSB DEN93LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Durango, COAn inadvertent stall. A factor was: downdrafts and the pilot's continued flight into known adverse weather.May 13, 1993 · N773JB · DestroyedNTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.May 11, 1993 · N435BW · Substantial damageNTSB SEA93LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Kapowsin, WAAn undetermined loss of engine power.May 8, 1993 · N9534H · Substantial damageNTSB MIA93LA116Accident · No injuriesLimited investigationFinal reportBeech A23A · Fort Myers, FLTotal loss of engine power due to fuel exhaustion and poor preflight planning/preparation by the pilot in command. Contributing to the accident was the pilot's failure to request winds aloft during the weather briefing.May 4, 1993 · N2312W · Substantial damageNTSB LAX93GA195Accident · 2 fatalFinal reportMooney M20J · Sedona, AZUndetermined.May 1, 1993 · N201GK · DestroyedNTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.May 1, 1993 · N6783G · DestroyedNTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.Apr 30, 1993 · N50963 · Substantial damageNTSB ATL93LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Arden, NCThe loss of engine power, and the pilot's premature flare during landing, which resulted in a landing stall. Factors were the high obstructions (trees) trees near the landing site, and the uphill terrain conditionsApr 29, 1993 · N2971J · Substantial damageNTSB FTW93IA141Incident · No injuriesIncident investigationFinal reportCommander 114B · Oklahoma City, OKThe pilot of the pitts, N51ST, misunderstanding of the tower's instructions and clearance, and his failure to see and avoid the Commander 114B, N194A.Apr 28, 1993 · N194A · 2 aircraft · Minor damageNTSB DEN93FA047Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inflight encounterwith a microburst at an altitude insufficient to effect recovery.Apr 26, 1993 · N14816 · Substantial damageNTSB FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springApr 24, 1993 · N6147N · DestroyedNTSB DEN93IA044Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Denver, COThe pilot-in-command's failure to maintain adequate separation from the Boeing 757, and his failure to stay above the probable path of the Boeing's wake vortices, which resulted in the vortex encounter. Factors related to the accident were: the crosswind, and…Apr 24, 1993 · N905UA · No damageNTSB NYC93LA089Accident · No injuriesLimited investigationFinal reportBoeing E75 · Zanesville, OHImproper use of the throttle by the pilot.Apr 23, 1993 · N181RF · Substantial damageNTSB LAX93LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Needles, CAthe total loss of engine power due to the failure of the magneto in the ignition system. The magneto failure resulted from the operator's lack of voluntary compliance with the manufacturers suggested overhaul cycle.Apr 23, 1993 · N6292D · Substantial damageNTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damageNTSB CHI93LA145Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Port Huron, MIfailure of the landing gear actuator cable.Apr 22, 1993 · N654N · Substantial damageNTSB NYC93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Melville, NYThe pilot's improper inflight planning and decision, which resulted in fuel exhaustion and the subsequent forced landing.Apr 19, 1993 · N601MS · Substantial damageNTSB ATL93LA078Accident · 2 fatalLimited investigationFinal reportDobbs VAN'S Aircraft RV-6 · Kingston, TNThe pilot's inadequate compensation for gusty wind conditions. A factor was the wind gust of 20-25 knots.Apr 19, 1993 · N316DD · Substantial damageNTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.Apr 18, 1993 · N9298T · Substantial damageNTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.Apr 17, 1993 · N94142 · DestroyedNTSB ATL93LA074Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Concord City, NCThe failure of the pilot to maintain control of the aircraft and his delayed decision to execute a go around. A factor in the accident was the strong gusty wind condition.Apr 16, 1993 · N44BG · Substantial damageNTSB LAX93LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Flagstaff, AZThe pilot's poor aircraft handling techniques, his failure to correctly configure the carburetor heat control during the go around, and, his failure to maintain an adequate airspeed which resulted in an inadvertent stall mush condition. Factors in the…Apr 15, 1993 · N3443E · Substantial damageNTSB NYC93GA082Accident · Minor injuriesFinal reportBell 206B · Lucasville, OHLoss of tail rotor effectiveness which resulted in the loss of aircraft control. A factor which contributed to the accident were unfavorable winds.Apr 14, 1993 · N72HP · DestroyedNTSB FTW93LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Houston, TXFuel exhaustion induced power loss and the pilot's failure to refuel. A factor was the existing night conditionsApr 13, 1993 · N6099G · Substantial damageNTSB NYC93FA080Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Lapeer, NYThe pilot's improper inflight decision to continue flight into known icing conditions. Factors which contributed to the accident were: the pilot's failure to obtain updated weather information prior to departure, the icing conditions, and the degraded…Apr 12, 1993 · N292SP · DestroyedNTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.Apr 10, 1993 · N7DZ · Substantial damageNTSB NYC93LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Durham, NHImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.Apr 10, 1993 · N8228G · Substantial damageNTSB MIA93LA097Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Bartow, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor.Apr 10, 1993 · N2218M · Substantial damageNTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.Apr 8, 1993 · N71654 · Substantial damageNTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.Apr 7, 1993 · N29AP · DestroyedNTSB SEA93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Casper, WYFuel exhaustion, and the pilot in command's poor inflight decision. Factors include an inadequate preflight by the pilot in command.Apr 6, 1993 · N5541P · Substantial damageNTSB SEA93FA088Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-35 · Casper, WYFailure of the pilot to maintain proper altitude during the night IFR approach in instrument meteorological conditions (IMC).Apr 6, 1993 · N96JP · DestroyedNTSB NYC93LA069Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Leesburg, VAImproper use of the fuel selectors, which resulted in fuel starvation and loss of power in both engines. Darkness was a related factor.Apr 5, 1993 · N777EV · Substantial damageNTSB CHI93LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Northwood, NDThe flight instructor's inadequate supervision of the flight.Apr 5, 1993 · N108ND · Substantial damageNTSB NYC93LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Doylestown, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing was the lack of total experience.Apr 4, 1993 · N5338W · Substantial damageNTSB LAX93LA162Accident · No injuriesLimited investigationFinal reportPiper J3 · Buckeye, AZThe pilot's inadequate visual look-out and failure to maintain clearance from the wires. Lack of experience in the geographical (airport) area was a factor.Apr 3, 1993 · N30503 · Substantial damageNTSB DEN93LA037Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Eckert, COThe pilot-in-command's failure to maintain adequate clearance from the truck during the landing. Factors which contributed to the accident were: the pilot's poor judgement in attempting the operation, and the driver's poor judgement in not vacating all…Apr 2, 1993 · N8210Y · Substantial damageNTSB MIA93LA093Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Panacea, FLThe pilot's inadeqaute compensation for wind conditions. The downdraft was a factor.Mar 28, 1993 · N51600 · Substantial damage