OpenAirDocs.org

NTSB investigations, 2000

256 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\") = 2000
    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 DEN01IA036Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Salt Lake City, UTthe captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.Dec 30, 2000 · N909DA · Minor damageNTSB FTW01LA041Accident · No injuriesLimited investigationFinal reportBeech BE-60 · Addison, TXThe pilot's misjudged flare of the airplane resulting from restricted forward visibility. Factors were the pilot's continued flight into known adverse weather conditions, the icing conditions, and the iced windshield.Dec 25, 2000 · N53444 · Substantial damageNTSB DEN01LA034Accident · No injuriesLimited investigationFinal reportBarackman Vans RV-6 · Springfield, COTotal failure of the right hand flap control rod due to construction procedures/directives not being followed by the builder.Dec 24, 2000 · N3891P · Substantial damageNTSB DEN01FA033Accident · 2 fatalField investigationFinal reportBeech V35B · Albuquerque, NMthe pilot's failure to maintain aircraft control and the inadvertent stall. Factors contributing to the accident were the pilot's improper in-flight planning, his lack of recent flying experience, and the abrupt maneuver to correct to the proper runway.Dec 24, 2000 · N2174L · Substantial damageNTSB LAX01LA064Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Bakersfield, CAThe pilot's inadequate in-flight planning, fuel management, and inadequate remedial actions, which resulted in a total loss of engine power due to fuel starvation. The pilot made an off-field landing and collided with a fence.Dec 23, 2000 · N72970 · Substantial damageNTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…Dec 22, 2000 · N30EM · DestroyedNTSB LAX01LA063Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Wilcox, AZThe pilot's incapacitation that resulted from nausea during the final approach to landing. The pilot collapsed on the cyclic, which precipitated inadvertent contact between the main rotor blades and the ground. Factors were hilly terrain on a dark night,…Dec 22, 2000 · N288JB · Substantial damageNTSB LAX01LA062Accident · No injuriesLimited investigationFinal reportCessna 177RG · San Carlos, CAA loss of engine power for undetermined reasons during an extended downwind leg in the landing pattern.Dec 21, 2000 · N2102Q · Substantial damageNTSB CHI01LA050Accident · No injuriesLimited investigationFinal reportBeech 58 · Huntingburg, INThe proper touchdown point not obtained/maintained by the pilot. Factors were the snow covered runway, the ice contaminated windshield, and the airport snow removal performed by the driver of the vehicle.Dec 18, 2000 · N4558S · Substantial damageNTSB FTW01LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sunnyvale, TXThe flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.Dec 17, 2000 · N7187W · Substantial damageNTSB CHI01LA048Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Harrisburg, ILThe pilot not attaining the proper glidepath on the instrument approach. The pilot's decision not to fly to an alternate airport and his decision to continue the approach in weather conditions below the published minimums were contributing factors.Dec 15, 2000 · N45PM · Substantial damageNTSB LAX01FA055Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…Dec 10, 2000 · N739HB · DestroyedNTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…Dec 10, 2000 · N52KL · DestroyedNTSB NYC01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20J · Trenton, NJThe flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.Dec 9, 2000 · N201MP · Substantial damageNTSB LAX01FA049Accident · 1 fatalField investigationFinal reportBeech BE-55-D55 · Clifton, AZthe pilot's improper in-flight decision to attempt a landing on an unlit runway at night, and his failure to maintain the proper glide path and clearance from obstacles while on final approach, which resulted in the collision with a utility pole. A…Dec 1, 2000 · N7901R · DestroyedNTSB CHI01FA043Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Danville, ILThe pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…Nov 27, 2000 · N4541J · DestroyedNTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…Nov 23, 2000 · N3988R · DestroyedNTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.Nov 15, 2000 · N6232E · DestroyedNTSB ATL01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Everglades City, FLThe pilot's failure to maintain control of the aircraft during landing.Nov 15, 2000 · N2334J · Substantial damageNTSB LAX01LA039Accident · No injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105CBS-5 · Parumph, NVThe pilot's failure to verify the presence of wires near the remote landing site during the high reconnaissance, and his misjudgement of the clearance from the ground during the attempted hovering turn to avoid the wire obstacle. Factors were the dark night…Nov 14, 2000 · N911VH · Substantial damageNTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.Nov 13, 2000 · N2843Q · Substantial damageNTSB CHI01LA033Accident · Minor injuriesLimited investigationFinal reportSaab 340-B · Aberdeen, SDthe impact with the flock of snow geese.Nov 9, 2000 · N402XJ · Substantial damageNTSB ANC01LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Lime Village, AKThe pilot's failure to properly utilize carburetor heat. Factors in the accident were the presence of carburetor icing conditions, and unsuitable terrain for a forced landing.Nov 9, 2000 · N4803S · Substantial damageNTSB NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…Nov 8, 2000 · N675JM · Substantial damageNTSB DEN01LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roswell, NMthe flight instructor's failure to adequately preflight the airplane, which resulted in the loss of engine power due to fuel exhaustion. A contributing factor was the dark night light condition.Nov 7, 2000 · N95262 · Substantial damageNTSB LAX01FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Selma, CAThe pilot's improper decision to attempt a visual approach and landing in instrument meteorological conditions and his failure to follow instrument flight rules procedures.Nov 6, 2000 · N12273 · DestroyedNTSB LAX01LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Livermore, CAThe pilot's lack of familiarity with the airplane's fuel system. This lead to the pilot inadvertently switching the fuel selector handle to the "OFF" position and subsequently to a loss of engine power due to fuel starvation.Nov 4, 2000 · N9986W · Substantial damageNTSB MIA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.Nov 3, 2000 · N1519T · Substantial damageNTSB CHI01FA026Accident · 1 fatalField investigationFinal reportLuscombe 8A · Des Moines, IAThe pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…Nov 3, 2000 · N71134 · DestroyedNTSB LAX01LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Dayton Valley, NVThe pilot's failure to attain a proper glide path during the final approach resulting in an undershoot of the runway. Factors were the lack of runway lights and night lighting condition.Nov 1, 2000 · N8139A · Substantial damageNTSB DEN01LA012Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mesa Verde, COThe manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.Oct 30, 2000 · N613 · Substantial damageNTSB DEN01LA010Accident · No injuriesLimited investigationFinal reportOtero-Pitts PT1 · Albuquerque, NMA hard landing, which exceeded the design stress limits of the aircraft. Factors were the pilot's lack of experience in aircraft make and model and improper recovery from a bounced landing.Oct 30, 2000 · N47BS · Substantial damageNTSB CHI01LA027Accident · Minor injuriesLimited investigationFinal reportForney F1A · Austin, MNthe proper glide path not being maintained by the pilot which resulted in the proper touchdown point not being obtained during the approach. A factor to the accident was the rising embankment.Oct 30, 2000 · N3028G · Substantial damageNTSB DEN01LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Collins, COFailure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.Oct 28, 2000 · N238Z · Substantial damageNTSB CHI01FA025Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Gaylord, MIThe pilot not maintaining proper glideslope and localizer alignment during the precision instrument approach, the pilot continuing flight below the decision height, the pilot not performing a missed approach, and the pilot not maintaining altitude/clearance…Oct 25, 2000 · N15900 · DestroyedNTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.Oct 23, 2000 · N9375L · Substantial damageNTSB LAX01LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Half Moon Bay, CAA local windshear condition that exceeded the airplane's climb performance capability during landing approach and resulted in the runway overrun during an attempted go-around.Oct 22, 2000 · N5226K · Substantial damageNTSB NYC01LA020Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Shirley, NYThe pilot's improper in-flight decision to abort the glide toward the airport. A factor was the pilot's failure to comply with the published best glide speed.Oct 21, 2000 · N2055T · Substantial damageNTSB CHI01LA022Accident · Minor injuriesLimited investigationFinal reportBollinger BD-4 · Hedrick, IAthe pilot not obtaining/maintaining clearance from the fence. A factors was fence.Oct 21, 2000 · N108BC · Substantial damageNTSB LAX01FA018Accident · No injuriesField investigationFinal reportBeech C90 · Van Nuys, CAThe failure of the pilot of the other airplane to correctly set a new transponder code and an anomaly in ATC software that precluded the controller from manually overriding the resulting inhibition of displayed data. Factors in the accident were impaired…Oct 17, 2000 · N1801B · 2 aircraft · Substantial damageNTSB CHI01IA016Incident · No injuriesIncident investigationFinal reportBoeing B-727-61 · Wood Dale, ILInadequate overhaul of the flap segment that allowed for corrosion and debonding that resulted in the flap segment departing the airplane during the approach. Factors relating to this incident were insufficient information provided to the overhaul facility by…Oct 17, 2000 · N530KF · Minor damageNTSB ATL01LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172-B · Palatka, FLThe CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.Oct 13, 2000 · N7894X · Substantial damageNTSB FTW01LA002Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Andrews, TXThe hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.Oct 10, 2000 · N800SS · Substantial damageNTSB LAX01FA007Accident · 2 fatalField investigationFinal reportCessna P210N · Phoenix, AZThe failure of the pilot to operate the airplane according to the flight manual, resulting in fuel starvation and loss of engine power during a critical phase of flight. A factor was the lack of suitable terrain for a forced landing and the presence of…Oct 9, 2000 · N888MM · DestroyedNTSB NYC01FA005Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-26A · Edgartown, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.Oct 7, 2000 · N60BT · DestroyedNTSB LAX01FA004Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · San Dimas, CAThe pilots becoming lost and disoriented during an improperly conducted IFR approach, and subsequent missed approach, that led to a collision with rising mountainous terrain. Also causal was the local controller canceling the IFR approach when the pilot…Oct 7, 2000 · N222ES · DestroyedNTSB NYC01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Marshfield, MAThe pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.Oct 4, 2000 · N6096B · Substantial damageNTSB ATL01LA003Accident · 1 fatalLimited investigationFinal reportUniversity of Alabama MINI-500 · Tuscaloosa, ALThe loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.Oct 3, 2000 · N6165T · DestroyedNTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.Oct 1, 2000 · N9697D · Substantial damageNTSB FTW00LA271Accident · No injuriesLimited investigationFinal reportTemco Luscombe 11A · Hammond, LAthe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A contributory factor was the fuel cap leak, due to a worn seal.Sep 30, 2000 · N1689B · Substantial damage