OpenAirDocs.org

NTSB investigations, 1994

251 cases where the phase of flight was Approach.

Cases per year

19622026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 1994
    AND 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 NYC95DNC01Accident · No injuriesFinal reportWyman Scorpion II · Cornish Flat, NHPartial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.Dec 28, 1994 · N65562 · DestroyedNTSB LAX95FA062Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Holtville, CAthe pilot's becoming lost/disoriented during a night cross- country flight at a time the flight was in a critical low fuel state, and his failure to maintain aircraft control during a go-around from an aborted precautionary landing. Factors in the accident…Dec 28, 1994 · N4647R · DestroyedNTSB NYC95LA047Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Lancaster, NYThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel to return to the home airport after proceeding to an alternate airport and making a missed approach. Factors related to the accident were:…Dec 27, 1994 · N9457L · Substantial damageNTSB NYC95LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Huber Heights, OHThe pilot's inadequate inflight decision/planning, which resulted in fuel exhaustion and the loss of engine power. A factor is the pilot's inadequate preflight planning.Dec 27, 1994 · N201JT · Substantial damageNTSB FTW95LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oklahoma City, OKThe loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.Dec 22, 1994 · N2874R · Substantial damageNTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.Dec 22, 1994 · N7JD · Substantial damageNTSB NYC95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wheeling, WVThe student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.Dec 21, 1994 · N7175S · DestroyedNTSB MIA95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLIn flight planning decision delay by the pilot-in-command in that he failed to divert to an alternate airport before loss of engine power due to fuel exhaustion.Dec 21, 1994 · N82895 · Substantial damageNTSB SEA95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, WAThe pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.Dec 15, 1994 · N8388Y · Substantial damageNTSB DCA95MA006Accident · 15 fatalMajor investigationFinal reportBritish Aerospace Jetstream 3201 · Morrisville, NC1) the captain's improper assumption that an engine had failed, and 2) the captain's subsequent failure to follow approved procedures for engine failure, single-engine approach and go-around, and stall recovery. Contributing to the cause of the accident was…Dec 13, 1994 · N918AE · DestroyedNTSB FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.Dec 12, 1994 · N93290 · Substantial damageNTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.Dec 11, 1994 · N2VZ · DestroyedNTSB ATL95LA027Accident · Minor injuriesLimited investigationFinal reportAero Commander 500S · Millington, TNThe pilot's inadequate preflight of the aircraft, in that he did not ensure that there was adequate fuel for the flight, which resulted in fuel exhaustion.Dec 11, 1994 · N9171N · Substantial damageNTSB CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…Dec 9, 1994 · N5647D · DestroyedNTSB ATL95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Myrtle Beach, SCThe pilot's failure to properly pre-flight the airplane to ensure the left fuel tank cover was properly secured.Dec 8, 1994 · N8075S · Substantial damageNTSB NYC95LA041Accident · No injuriesLimited investigationFinal reportCessna T210M · Wadsworth, OHThe loss of engine power for undetermined reasons which resulted in a forced landing on unsuitable terrain.Dec 4, 1994 · N7614K · Substantial damageNTSB NYC95LA040Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Blairstown, NJThe pilot's failure to maintain the proper descent rate.Dec 4, 1994 · N858BG · Substantial damageNTSB LAX95LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Santa Paula, CAThe failure of both pilots to maintain an adequate visual lookout for other traffic in the pattern, and the other pilot's failure to effectively use the CTAF for position reports while in the pattern.Dec 4, 1994 · N6353L · 2 aircraft · Substantial damageNTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…Nov 29, 1994 · N9260L · DestroyedNTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.Nov 27, 1994 · N6556M · Substantial damageNTSB ATL95FA021Accident · 1 fatalField investigationFinal reportBeech 95B55 · Mableton, GAThe pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.Nov 27, 1994 · N8933M · Substantial damageNTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.Nov 22, 1994 · N2949Q · Substantial damageNTSB BFO95LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Bethel, MEthe flight instructor's failure to ensure adequate control of the airplane during a go-around. The gusty wind conditions were contributing factors.Nov 22, 1994 · N19735 · Substantial damageNTSB ATL95LA017Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec TS-11 Iskra · Shelby, NCThe pilot's failure to maintain landing approach speed, which resulted in a final approach stall. Factors were the night lighting conditions, and the pilot's failure to use the landing light.Nov 20, 1994 · N619R · DestroyedNTSB NYC95FA031Accident · 1 fatalField investigationFinal reportMooney M20J · Brewster, MAFailure of the pilot to maintain control of the airplane during a missed approach. A factor related to the accident was: the deteriorating weather condition with a low ceiling and rain.Nov 19, 1994 · N5681Y · DestroyedNTSB NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.Nov 19, 1994 · N402BK · DestroyedNTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.Nov 18, 1994 · N14315 · DestroyedNTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.Nov 17, 1994 · N731QH · Substantial damageNTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.Nov 11, 1994 · N4469D · Substantial damageNTSB CHI95FA035Accident · 1 fatalField investigationFinal reportSikorsky S-76A · Cameron, LAthe copilot's failure to maintain altitude and the pilot-in-command's inadequate supervision of the operation. Factors include the dark night and low ceiling, and the flightcrew's failure to set the proper altimeter setting.Nov 9, 1994 · N2620 · DestroyedNTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.Nov 8, 1994 · N1380F · Substantial damageNTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.Nov 7, 1994 · N1566X · Substantial damageNTSB LAX95FA029Accident · Serious injuriesField investigationFinal reportCessna 421A · Sparks, NVThe pilot's improper use of the fuel selector and subsequent fuel starvation.Nov 1, 1994 · N421WB · DestroyedNTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.Oct 31, 1994 · N7207C · DestroyedNTSB FTW95LA035Accident · Minor injuriesLimited investigationFinal reportCessna T-210M · Tyler, TXLoss of engine power due to inadequate fuel management and fuel starvation. A factor was the lack of suitable terrain available for the forced landing.Oct 29, 1994 · N533CA · Substantial damageNTSB FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.Oct 28, 1994 · N86781 · Substantial damageNTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.Oct 23, 1994 · N90875 · Substantial damageNTSB CHI95LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIinaccurate planning by the pilot which resulted in the failure to assure an adequate fuel supply to complete the flight. A factor associated with the accident was the lack of a suitable landing site for the forced landing.Oct 23, 1994 · N6464J · Substantial damageNTSB NYC95LA015Accident · No injuriesLimited investigationFinal reportCessna 172B · Honesdale, PAthe fuel selector was in the improper position, which resulted in a total loss of engine power, due to fuel starvation, a forced landing, and subsequent impact with a stone wall.Oct 21, 1994 · N7491E · Substantial damageNTSB CHI95FA018Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Sellersburg, INFailure of the pilot to follow IFR procedures by allowing the aircraft to deviate left of the ILS localizer course, by not maintaining the proper ILS glide path, and by continuing descent below the ILS decision height.Oct 20, 1994 · N40509 · DestroyedNTSB LAX95LA013Accident · No injuriesLimited investigationFinal reportStan G. Hallam RV-6 · Bridgeport, CAthe pilot's poorly planned approach, his failure to maintain the proper airspeed and descent rate, and his failure to perform the necessary remedial action.Oct 19, 1994 · N93SJ · Substantial damageNTSB NYC95LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Worthington, PAThe failure of the aileron control cable which resulted in the inflight loss of control and collision with trees.Oct 15, 1994 · N70751 · Substantial damageNTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.Oct 15, 1994 · N9238 · Substantial damageNTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.Oct 14, 1994 · N20TA · Substantial damageNTSB SEA95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, ORThe failure of the dual student to maintain a proper glidepath and the pilot-in-command's inadequate supervision.Oct 12, 1994 · N4334E · Substantial damageNTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.Oct 12, 1994 · N601AV · Substantial damageNTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.Oct 11, 1994 · N8413P · Substantial damageNTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.Oct 10, 1994 · N7327K · Substantial damageNTSB NYC95LA002Accident · No injuriesLimited investigationFinal reportCessna 185F · Rochester, MAThe pilot's inadeqaute calculation of fuel and inadeqaute inflight decision which resulted in fuel exhaustion and the loss of engine power.Oct 9, 1994 · N53074 · Substantial damageNTSB LAX95LA017Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · La Verne, CAan inadvertant entry into a settling with power condition and the flight instructor's inability to correct the situation due to an inadequate altitude above ground.Oct 8, 1994 · N5697D · Substantial damage