OpenAirDocs.org

NTSB investigations, 2001

230 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\") = 2001
    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 NYC02FA044Accident · 1 fatalField investigationFinal reportRaytheon BE-23-B24R · Armonk, NYThe pilot's failure to maintain aircraft control.Dec 31, 2001 · N2173W · DestroyedNTSB IAD02FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Milford, CTThe pilot's failure to follow the published IFR approach procedure, which resulted in a premature descent and subsequent impact with water. A factor was the night, overwater visual conditions.Dec 30, 2001 · N7427J · Substantial damageNTSB ATL02FA026Accident · 1 fatalField investigationFinal reportMooney M20C · Gainesville, GAThe loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.Dec 29, 2001 · N6953V · DestroyedNTSB CHI02FA059Accident · 2 fatalField investigationFinal reportBorgman Smyth Sidewinder · Independence, KSThe pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.Dec 28, 2001 · N133G · Substantial damageNTSB CHI02LA055Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Elkhart, INThe pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.Dec 21, 2001 · N58797 · Substantial damageNTSB ATL02LA019Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Vero Beach, FLThe pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.Dec 21, 2001 · N3776Y · Substantial damageNTSB LAX02LA053Accident · No injuriesLimited investigationFinal reportCessna T210N · San Diego, CAThe pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.Dec 20, 2001 · N7AL · Substantial damageNTSB LAX02LA050Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Maria, CAInadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.Dec 17, 2001 · N7317X · Substantial damageNTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.Dec 14, 2001 · N210RE · DestroyedNTSB MIA02FA045Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Jacksonville, FLThe pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.Dec 13, 2001 · N7701J · DestroyedNTSB MIA02FA044Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Raleigh, NCthe pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…Dec 13, 2001 · N41003 · DestroyedNTSB FTW02LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Duncan, OKThe pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.Dec 13, 2001 · N127CA · Substantial damageNTSB FTW02TA051Accident · No injuriesFinal reportCessna T210K · San Antonio, TXthe failure of the right main landing gear downlock mechanism to engage for reasons undetermined.Dec 11, 2001 · N8299M · Substantial damageNTSB LAX02LA043Accident · 1 fatalLimited investigationFinal reportRominger Zic Zac Bird · Marina, CAthe failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.Dec 9, 2001 · N204ED · DestroyedNTSB LAX02LA042Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Banning, CAOn final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.Dec 7, 2001 · N102FC · Substantial damageNTSB NYC02LA034Accident · Serious injuriesLimited investigationFinal reportGillette Baby Ace · Spencerport, NYThe pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.Dec 5, 2001 · N916MG · Substantial damageNTSB LAX02LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Prescott, AZFuel starvation on final approach due to the pilot's fuel mismanagement, and his inattentiveness in following established prelanding procedures.Dec 2, 2001 · N7213P · Substantial damageNTSB MIA02LA038Accident · No injuriesLimited investigationFinal reportByrd KR-2S · Linden, NCThe pilot's failure to correct a condition where visual contact with the terrain was lost due to sunshine glare, resulting in collision with a tree during final approach for landing.Dec 1, 2001 · N366KR · DestroyedNTSB MIA02FA037Accident · 2 fatalField investigationFinal reportCessna 208B · Bessemer, ALThe poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…Dec 1, 2001 · N499BA · DestroyedNTSB LAX02LA035Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Banning, CAa loss of engine power due to a crack in the carburetor float and leaking portions of the carburetor that resulted in an overly rich mixture.Dec 1, 2001 · N31BN · Substantial damageNTSB CHI02LA044Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · St Paul, MNThe autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.Nov 30, 2001 · N9052Y · Substantial damageNTSB LAX02LA033Accident · No injuriesLimited investigationFinal reportBeech B95 · Henderson, NVthe loss of engine power in the left engine for undetermined reasons. A contributing factor was the check pilot's failure to completely configure the airplane for a single engine go-around in a timely way.Nov 29, 2001 · N2012C · Substantial damageNTSB LAX02LA030Accident · No injuriesLimited investigationFinal reportBeech C-99 · Flagstaff, AZThe pilot's failure to maintain adequate airspeed and his failure to maintain directional control. Contributing factors were the icing conditions, icing, and the improper use of the anti-ice/deicing equipment.Nov 29, 2001 · N228BH · Substantial damageNTSB MIA02LA033Accident · Minor injuriesLimited investigationFinal reportVernon D. Pitts RV-4 · Burgaw, NCThe loss of engine power for undetermined reasons.Nov 26, 2001 · N15VP · Substantial damageNTSB MIA02FA026Accident · 2 fatalField investigationFinal reportEnstrom 280FX · Tallassee, ALThe failure of the pilot to maintain a safe altitude above terrain and maintain a visual lookout resulting in the helicopter colliding with power transmission lines and crashing into a river. A factor in the accident was the power transmission lines not being…Nov 22, 2001 · N280XF · DestroyedNTSB MIA02LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Stuart, FLThe pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.Nov 20, 2001 · N590AM · Substantial damageNTSB MIA02LA023Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Memphis, TNThe inadvertent collision with birds while on final approach to land resulting in substantial damage to the airplane.Nov 20, 2001 · N277FE · Substantial damageNTSB FTW02LA034Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Benton, LAin-flight collision with trees while on final approach to land for an undetermined reason.Nov 14, 2001 · N202AT · DestroyedNTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.Nov 13, 2001 · N6134A · DestroyedNTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.Nov 10, 2001 · N9466K · Substantial damageNTSB LAX02LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Nogales, AZThe pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.Nov 10, 2001 · N10680 · Substantial damageNTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…Nov 10, 2001 · N4890J · DestroyedNTSB ATL02LA012Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA300/L · St. Augustine, FLThe pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…Nov 10, 2001 · N2XA · 2 aircraft · Minor damageNTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.Nov 9, 2001 · N43382 · Substantial damageNTSB DEN02LA010Accident · Minor injuriesLimited investigationFinal reportAgusta A119 · Ogden, UTimproper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.Nov 9, 2001 · N119RX · DestroyedNTSB MIA02LA015Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Gainesville, FLThe failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.Nov 8, 2001 · N177X · Substantial damageNTSB LAX02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Herald, CAThe pilot's delay initiating a go-around during a downwind approach to a short runway.Nov 8, 2001 · N9461P · Substantial damageNTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.Nov 1, 2001 · N7270E · DestroyedNTSB FTW02LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Wilton, ARthe pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.Oct 28, 2001 · N8305R · Substantial damageNTSB CHI02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lapeer, MIthe touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.Oct 28, 2001 · N6899C · Substantial damageNTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.Oct 28, 2001 · N4879L · DestroyedNTSB NYC02LA017Accident · Minor injuriesLimited investigationFinal reportBeech B95A · Pittstown, NJThe pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.Oct 26, 2001 · N919Q · Substantial damageNTSB CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.Oct 23, 2001 · N7235R · DestroyedNTSB FTW02LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Ozona, TXThe loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.Oct 20, 2001 · N8642Y · Substantial damageNTSB ANC02LA002Accident · Minor injuriesLimited investigationFinal reportEmbraer 120ER · Bethel, AKThe captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…Oct 17, 2001 · N120AX · Substantial damageNTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…Oct 16, 2001 · N7502K · Substantial damageNTSB FTW02LA008Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Dallas, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.Oct 9, 2001 · N690JP · Substantial damageNTSB FTW02LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Chickasha, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Oct 6, 2001 · N3862D · Substantial damageNTSB MIA02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Clarksville, TNThe failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…Oct 3, 2001 · N8402Y · Substantial damageNTSB FTW02FA003Accident · No injuriesField investigationFinal reportFokker F28 Mk 0100 · DFW Airport, TXThe collapse of the nose landing gear as a result of the failure of company maintenance personnel to follow the proper procedures for a towing the airplane with an unsafe nose landing gear indication. Contributing factors were the inadequate communication…Oct 3, 2001 · N1448A · Substantial damage