OpenAirDocs.org

NTSB investigations, 1998

238 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\") = 1998
    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 LAX99LA063Accident · Serious injuriesLimited investigationFinal reportRichard Young Harmon Rocket II · Esparto, CAThe owner's inadequate condition (annual) inspection, which failed to detect a loose fuel pump output line attachment fitting, which resulted in an in-flight fire. A factor in the hard landing and ground loop was the pilot's inability to see through the smoke…Dec 31, 1998 · N288M · DestroyedNTSB MIA99LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Knoxville, TNThe engines excessive fuel consumption for undetermined reasons and the pilot's failure to plan the flight with adequate fuel reserves resulting in engine failure due to fuel exhaustion.Dec 26, 1998 · N32679 · Substantial damageNTSB FTW99FA055Accident · 3 fatalField investigationFinal reportCessna 182P · Midland, TXThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.Dec 26, 1998 · N182FE · DestroyedNTSB MIA99LA053Accident · No injuriesLimited investigationFinal reportCessna 402B · San Juan, PRThe failure of the pilot to maintain directional control of the aircraft. The reason for the reported engine surging is undetermined.Dec 23, 1998 · N8203Q · Substantial damageNTSB NYC99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairfield, PAThe pilot's failure to properly use carburetor heat which resulted in carburetor ice and loss of engine power. Contributing factor were trees.Dec 19, 1998 · N82096 · Substantial damageNTSB MIA99LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe inadequate visual lookout of the pilot of the Cessna airplane and of the pilot of the glider resulting in the midair collision.Dec 19, 1998 · N9295H · 2 aircraft · Substantial damageNTSB MIA99IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Orlando, FLA discharged battery due to a loss of electrolyte, and the latent shorted failures of the No. 1 and 2 generator control unit (GCU) blocking diodes (CR910) for undetermined reasons. These failures resulted in an excessive current drawn from both GCUs, during…Dec 15, 1998 · N327DL · Minor damageNTSB IAD99LA024Accident · Serious injuriesLimited investigationFinal reportBell 47-G5 · Essex Junction, VTthe pilot's improper entry into the autorotation, which resulted in the loss of power and a low rotor rpm condition. Also causal was the pilot's improper execution of the autorotation which resulted in the hard landing. Factors in the accident were the…Dec 14, 1998 · N8103J · Substantial damageNTSB FTW99LA047Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Lufkin, TXThe inadvertent stall due to the pilot's improper recovery from a bounced landing.Dec 14, 1998 · N536RK · DestroyedNTSB MIA99LA044Accident · Serious injuriesLimited investigationFinal reportRockwell 114A · New Smyrna Bch, FLThe pilots failure to maintain adequate altitude clearance with the terrain during final approach, and the subsequent collision with high vegetation and a road sign.Dec 13, 1998 · N5913N · DestroyedNTSB ATL99LA033Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lantana, FLThe pilot's improper use of the flight controls during an attempted autorotation.Dec 10, 1998 · N2321X · Substantial damageNTSB MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.Dec 9, 1998 · N788SP · Substantial damageNTSB NYC99IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York, NYThe Cessna pilot's incorrect visual identification of the Boeing 737's altitude, and decision to take evasive action that was not required, which resulted in the two airplanes coming within 500 feet horizontally, and 0 feet vertically of one another.Dec 8, 1998 · GCPX · No damageNTSB FTW99FA044Accident · 1 fatalField investigationFinal reportBeech 58 · Newcastle, OKthe pilot's loss of control due to his inadvertent encounter with severe turbulence and wind shear during an instrument approach. Factors contributing to the accident were the severe turbulence and the wind shear.Dec 6, 1998 · N1826S · DestroyedNTSB LAX99LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Victorville, CAFuel starvation caused by the pilot's failure to select a tank containing fuel.Dec 5, 1998 · N8086P · Substantial damageNTSB CHI99FA047Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Waterford, MIthe pilot's descent below the decision height for the instrument approach.Dec 5, 1998 · N59902 · DestroyedNTSB ANC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Point Lay, AKFailure of the pilot to maintain a proper glidepath. Factors associated with this accident were the airport not having a VASI system installed, and the lack of visual perception for the pilot.Dec 3, 1998 · N3542H · Substantial damageNTSB CHI99LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mason, MIthe pilot's inattention to fuel management in that he failed to switch fuel tanks in a timely manner which resulted in fuel starvation. A factor related to the accident was the low altitude at which the loss of engine power occurred.Dec 1, 1998 · N36700 · Substantial damageNTSB CHI99LA037Accident · Serious injuriesLimited investigationFinal reportBeech BE-55 · Crystal, MNthe pilot failed to maintain the proper glidepath. A factor was the sunglare.Nov 23, 1998 · N5638S · Substantial damageNTSB LAX99FA036Accident · 2 fatalField investigationFinal reportCessna 172P · Scottsdale, AZthe failure of the solo student pilot in the other aircraft to acquire and maintain separation from this aircraft, which was departing the airport traffic pattern and had been issued as traffic by the local controller. Also causal was the failure of the pilot…Nov 21, 1998 · N99064 · 2 aircraft · DestroyedNTSB IAD99FA020Accident · 1 fatalField investigationFinal reportBurgess RV-6 · Edgewater, MDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's unfamiliarity with the geographic location and dark night conditions.Nov 21, 1998 · N956DB · DestroyedNTSB ATL99FA020Accident · Serious injuriesField investigationFinal reportCessna 172N · Concord, NCThe pilot's improper in-flight decision and his failure to maintain clearance during approach that resulted in collision with utility lines. Related factors were dark night, trees and low ceilings.Nov 17, 1998 · N92KK · Substantial damageNTSB LAX99LA033Accident · Serious injuriesLimited investigationFinal reportOld Hen Crow G1 · Tehachapi, CAThe failure of the pilot to maintain sufficient airspeed, which resulted in the aircraft entering a stall/mush flight condition that continued to impact. A factor in the accident was the pilot's lack of familiarity with the type of aircraft.Nov 16, 1998 · N6349T · DestroyedNTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.Nov 16, 1998 · N5806A · Substantial damageNTSB LAX99FA027Accident · 3 fatalField investigationFinal reportCessna 150L · Yerington, NVthe failure of the pilot to see and avoid the aircraft ahead, which was already established in the traffic pattern. The failure of both pilots announce their intentions on the Common Traffic Advisory Frequency was a factor in this accident.Nov 12, 1998 · N19281 · 2 aircraft · DestroyedNTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.Nov 10, 1998 · N4927P · No damageNTSB ATL99LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Statesboro, GAThe pilot's failure to use carburetor heat. Factors were conditions favorable for the formation of carburetor ice.Nov 9, 1998 · N8770S · Substantial damageNTSB SEA99LA012Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Rainier, WAThe pilot's failure to maintain clearance from objects in the approach path. Factors include the marked wires near the end of the runway.Nov 8, 1998 · N9755K · Substantial damageNTSB FTW99FA022Accident · 2 fatalField investigationFinal reportChallenger II · San Antonio, TXThe pilot's inadvertent stall. A factor was the pilot's lack of experience in type of vehicle.Nov 8, 1998 · UNREG · DestroyedNTSB FTW99FA021Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Conroe, TXThe pilot's inadequate in-flight planning/decision which resulted in a loss of engine power due to fuel exhaustion. Factors were the dark night light conditions prevailing for the ensuing forced landing and the pilot's lack of experience in the make and model…Nov 8, 1998 · N4726R · Substantial damageNTSB DEN99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Belen, NMThe pilot's inadequate preflight planning, resulting in fuel supply exhaustion.Nov 8, 1998 · N8883V · Substantial damageNTSB LAX99LA022Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Pioche, NVThe loss of tail rotor effectiveness, due to the installation of incorrect pitch links by the maintenance facility. A factor in the accident was the lack of an adequate quality assurance program in the maintenance facility.Nov 3, 1998 · N946L · Substantial damageNTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.Oct 31, 1998 · N99924 · Substantial damageNTSB CHI99LA013Accident · 1 fatalLimited investigationFinal reportC.B. Withun T-BIRD II · New Haven, MIthe improper installation of the propeller by the owner/pilot- mechanic and the pilot not maintaining the airplane's airspeed while approaching the trees along the airplane's flight path. A factor in this accident was the stall encountered by the pilot.Oct 29, 1998 · N72145 · DestroyedNTSB DEN99FA016Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hayden, COThe pilot not following instrument procedures and subsequently descended to minimums prematurely. Factors were the mountainous terrain and the falling snow.Oct 28, 1998 · N35533 · DestroyedNTSB MIA99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ormond Beach, FLThe pilot's failure to maintain Vmc speed, which resulted in a loss of control, and his improper operation of the throttle given the known full rich operating condition of the left engine. A sand-contaminated fuel control was a contributing factor.Oct 27, 1998 · N45SA · Substantial damageNTSB NYC99FA015Accident · 1 fatalField investigationFinal reportCessna 172N · Linden, NJThe pilot's failure to maintain clearance from the power lines. A factor was sunglare.Oct 25, 1998 · N6214F · DestroyedNTSB FTW99FA016Accident · 1 fatalField investigationFinal reportKolb Twinstar TA-2 · Bryan, TXThe pilot's loss of control as result of the partial separation of the elevator trim tab resulting in the inability to maintain aircraft control. A factor was the improper design and installation of the elevator trim tab.Oct 23, 1998 · N4281Z · DestroyedNTSB NYC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Mattituck, NYThe pilot's failure to maintain the airplane's directional control during a go-around.Oct 21, 1998 · N31869 · DestroyedNTSB FTW99LA010Accident · No injuriesLimited investigationFinal reportMooney M20A · Oklahoma City, OKThe loss of engine power due to fuel starvation as result of the pilot's improper placement of the fuel tank selector switch. A factor was the lack of suitable terrain for the pilot to execute the forced landing.Oct 18, 1998 · N6534B · Substantial damageNTSB SEA99LA003Accident · Minor injuriesLimited investigationFinal reportBeech 99 · Missoula, MTThe pilot-in-command's delayed remedial action in response to the co-pilot's improper landing flare, and the co-pilot's application of excessive (full nose-up) trim during the landing flare as taught in the operator's initial aircrew training program. Factors…Oct 17, 1998 · N299GL · Substantial damageNTSB FTW99LA013Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Russellville, ARThe pilot's failure to maintain clearance with the ground due to the pilot's improper use of the flaps and the ensuing inadvertent descent. Factors were the dark night conditions, the pilot's diverted attention, and the foggy windshield.Oct 17, 1998 · N90GN · Substantial damageNTSB CHI99LA008Accident · Minor injuriesLimited investigationFinal reportBeech 65-B80 · Brainerd, MNthe pilot's failure to maintain the proper glidepath and his diversion of attention during a critical phase of flight.Oct 17, 1998 · N138BA · Substantial damageNTSB MIA99LA010Accident · No injuriesLimited investigationFinal reportBeech C-90 · Meridian, MSThe pilot's inadvertent activation of the landing gear control handle during an attempted go-around, resulting in the retraction of the landing gear and subsequent on ground collision with terrain.Oct 14, 1998 · N438SP · Substantial damageNTSB SEA99LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Buhl, IDThe pilot's failure to follow the aircraft's recommended balked landing procedure, resulting in a stall. Factors include the pilot's failure to maintain directional control during the landing flare, the pilot's lack of total experience, and insufficient…Oct 12, 1998 · N6486J · Substantial damageNTSB LAX99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Payson, AZthe pilot's failure to maintain runway alignment during a go-around.Oct 12, 1998 · N1938M · Substantial damageNTSB NYC99LA008Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Hilltown, PAThe pilot's misjudgment of altitude/distance which resulted in an in-flight collision which trees.Oct 11, 1998 · N408KP · Substantial damageNTSB DEN99LA007Accident · No injuriesLimited investigationFinal reportCessna 210A · Provo, UTThe pilot's abrupt throttle control movement that caused the engine to flood, and his failure to follow emergency procedures contained in the Airplane Flight Manual. Factors were increasing the mixture control to full rich and switching the fuel pump to high…Oct 10, 1998 · N9449X · Substantial damageNTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.Oct 10, 1998 · N21491 · Substantial damageNTSB ANC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of a proper touchdown point. Factors associated with the accident were darkness, and the pilot's inadequate preflight planning.Oct 10, 1998 · N98900 · Substantial damage