OpenAirDocs.org

NTSB investigations, 2002

232 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\") = 2002
    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 ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.Dec 31, 2002 · N5338R · Substantial damageNTSB MIA03FA034Accident · 1 fatalField investigationFinal reportCessna 208B · Manteo, NCThe pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…Dec 25, 2002 · N1122Y · Substantial damageNTSB SEA03LA020Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1 · Chehalis, WAThe total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.Dec 23, 2002 · N5985L · Substantial damageNTSB FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.Dec 21, 2002 · N9096Q · Substantial damageNTSB NYC03LA031Accident · No injuriesLimited investigationFinal reportBell 206B · Odenton, MDThe pilot's failure to monitor his fuel supply which resulted in a power loss due to fuel exhaustion, and the pilot's misjudged flare, which resulted in a hard landing.Dec 18, 2002 · N651GA · Substantial damageNTSB CHI03FA041Accident · 1 fatalField investigationFinal reportCessna 208B · Rockford, ILThe pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.Dec 18, 2002 · N277PM · DestroyedNTSB OPS03IA001Incident · No injuriesIncident investigationFinal reportAirbus Industrie 330-301 · AganaThe pilot's initiation of a premature descent that was both below the nominal glideslope and steeper than normal. Contributing to the incident was the air traffic controller's failure to respond to the MSAW warning and issue a safety alert as required by FAA…Dec 17, 2002 · F-OHZO · Minor damageNTSB LAX03FA051Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Anaheim Hills, CAthe pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…Dec 16, 2002 · N6268P · DestroyedNTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.Dec 9, 2002 · N127YV · DestroyedNTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.Dec 6, 2002 · N241JG · DestroyedNTSB CHI03LA040Accident · No injuriesLimited investigationFinal reportCessna 172M · Moline, ILThe pilot's failure to maintain altitude clearance during a base to final turn on approach. Contributing factors to the accident were the night conditions and the trees.Dec 6, 2002 · N80213 · Substantial damageNTSB DEN03LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350BA · Monticello, UTthe pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.Dec 2, 2002 · N20840 · Substantial damageNTSB DEN03LA019Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-70 · Montrose, COthe unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.Nov 30, 2002 · N5303Z · No damageNTSB LAX03LA040Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Elko, NVThe pilot's inadequate in-flight planning/decision resulting in fuel exhaustion.Nov 27, 2002 · N224BD · Substantial damageNTSB IAD03FA019Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Bastian, VAThe pilot's failure to maintain an adequate altitude above terrain. Factors in the accident were the dark night conditions and the low cloud ceiling.Nov 27, 2002 · N31554 · Substantial damageNTSB LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…Nov 25, 2002 · N3242Q · DestroyedNTSB LAX03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Paula, CAThe pilot's failure to follow the checklist and switch the fuel selector to the fullest tank for landing, which resulted in fuel starvation and loss of engine power.Nov 24, 2002 · N2937M · Substantial damageNTSB ATL03LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.Nov 24, 2002 · N4264E · Substantial damageNTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.Nov 23, 2002 · N1152F · Substantial damageNTSB ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.Nov 20, 2002 · N58GH · Substantial damageNTSB NYC03FA021Accident · 2 fatalField investigationFinal reportMooney M10 · Fairfield, NJThe inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.Nov 16, 2002 · N9502V · 2 aircraft · Substantial damageNTSB MIA03FA016Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Climax, NCThe pilot's operation of the airplane at a low altitude during final approach that resulted in an in-flight collision with a tree, a witness reported pitch-up, and subsequent stall and in-flight collision with terrain.Nov 15, 2002 · N8162N · Substantial damageNTSB SEA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · La Grande, ORInadequate supervision and the premature raising of flaps before a positive climb was established.Nov 14, 2002 · N2208Y · Substantial damageNTSB NYC03FA020Accident · 1 fatalField investigationFinal reportCessna 210L · Rochester, NYA loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.Nov 14, 2002 · N2444S · DestroyedNTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.Nov 13, 2002 · N2165Y · DestroyedNTSB LAX03FA031Accident · Minor injuriesField investigationFinal reportCessna T210L · Pacoima, CAa loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.Nov 13, 2002 · N76TL · Substantial damageNTSB IAD03LA015Accident · No injuriesLimited investigationFinal reportBell 206L1 · Albany, KYThe pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.Nov 8, 2002 · N108AE · Substantial damageNTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.Nov 8, 2002 · N4835B · Substantial damageNTSB FTW03FA036Accident · 2 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Taos, NMThe pilot's inadvertent flight into mountain wave weather conditions while IMC, resulting in a loss of aircraft control.Nov 8, 2002 · N61RS · DestroyedNTSB CHI03LA019Accident · Minor injuriesLimited investigationFinal reportCessna 150M · New Town, NDThe pilot's failure to maintain terrain clearance and his inadequate in-flight planning/decision. Contributing factors are the pilot becoming lost/disoriented and night conditions.Nov 8, 2002 · N2995V · Substantial damageNTSB LAX03LA024Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Santa Ana, CAThe pilot's encounter with wake turbulence resulting in a loss of control. A related factor was insufficient separation by air traffic control.Nov 7, 2002 · N3373C · Substantial damageNTSB SEA03LA007Accident · 1 fatalLimited investigationFinal reportRiddell IV-P · Bozeman, MTThe loss of power for undetermined reason(s) and the pilot's failure to maintain the aircraft's flying speed above the power off stall speed in the landing configuration.Nov 5, 2002 · N41RJ · DestroyedNTSB LAX03LA022Accident · Minor injuriesLimited investigationFinal reportLewis Barnett J4B · Vacaville, CAAn in-flight loss of control for undetermined reasons.Nov 4, 2002 · N23152 · Substantial damageNTSB CHI03FA018Accident · 2 fatalField investigationFinal reportPiper PA-24 · Fond du Lac, WIThe pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.Nov 4, 2002 · N6606P · DestroyedNTSB FTW03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Big Spring, TXthe failure of both pilots to maintain visual separation with each other. Factors were the Cessna pilot's inability to listen to or make radio transmissions and the Piper pilot's nonstandard traffic pattern.Oct 29, 2002 · N1456A · 2 aircraft · Substantial damageNTSB ANC03LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Larson Bay, AKThe pilot's failure to maintain adequate clearance while landing, which resulted in an in-flight collision with a tree.Oct 29, 2002 · N5355D · Substantial damageNTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.Oct 27, 2002 · N192MB · Substantial damageNTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.Oct 25, 2002 · N41BE · DestroyedNTSB ATL03FA010Accident · 3 fatalField investigationFinal reportCessna R182 · Greensboro, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.Oct 25, 2002 · N4629S · DestroyedNTSB MIA03LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Palmas, PRThe pilot's failure to switch fuel tanks resulting in a partial loss of engine power due to fuel starvation during a go-around. Additionally, the pilot's failure to monitor airspeed and proper touchdown point during the emergency landing resulted in another…Oct 23, 2002 · N2838T · Substantial damageNTSB IAD03IA017Incident · No injuriesIncident investigationFinal reportCraig N. Moen RV-8 · Leesburg, VAA low-stress, high-cycle fatigue fracture of the right ignition timing rotor.Oct 22, 2002 · N184CM · No damageNTSB LAX03LA014Accident · Serious injuriesLimited investigationFinal reportCessna 210C · Riverside, CAthe pilot's failure to position the fuel selector to the tank containing fuel resulting in a loss of engine power due to fuel exhaustion.Oct 21, 2002 · N9788X · Substantial damageNTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.Oct 20, 2002 · N315CL · Substantial damageNTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.Oct 17, 2002 · N303CH · Substantial damageNTSB IAD03FA005Accident · 2 fatalField investigationFinal reportCessna 172N · Mount Sterling, KYThe failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.Oct 15, 2002 · N6413J · DestroyedNTSB CHI03LA008Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lake Elmo, MNThe pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…Oct 14, 2002 · N8161T · DestroyedNTSB FTW03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.Oct 10, 2002 · N520SU · Substantial damageNTSB CHI03LA007Accident · No injuriesLimited investigationFinal reportMadewell EAA-Biplane-P · Forest Lake, MNThe loss of engine power for undetermined reasons. A related factor was the swampy terrain.Oct 9, 2002 · N21WL · Substantial damageNTSB MIA03LA001Accident · 1 fatalLimited investigationFinal reportBowers Velocity SR6E · Valkaria, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.Oct 5, 2002 · N954PB · DestroyedNTSB CHI03LA005Accident · No injuriesLimited investigationFinal reportCessna 172L · Fish Lake, MNThe altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.Oct 5, 2002 · N713SX · Substantial damage