OpenAirDocs.org

NTSB investigations, 1992

291 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\") = 1992
    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 DEN93FA021Accident · 3 fatalField investigationFinal reportCessna 210 · Aurora, COCollision with terrain when the pilot inadvertently flew into fog while conducting a visual approach. Factors were: inaccurate weather evaluation by the pilot and lack of familiarity with the geographic area.Dec 31, 1992 · N7469E · DestroyedNTSB FTW93FA061Accident · 3 fatalField investigationFinal reportBeech C24R · Tulsa, OKThe pilot's disregard of and descent below the published decision height. Factors were his failure to maintain proper glide path and localizer alignment.Dec 29, 1992 · N3809Q · DestroyedNTSB MIA93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Jacksonville, FLThe pilot-in-command's failure to attain an adequate climb rate during the missed approach in IMC conditions. Contributing to the accident was the pilot's spatial disorientation.Dec 28, 1992 · N3620M · DestroyedNTSB MIA93LA037Accident · Serious injuriesLimited investigationFinal reportBunn, Richard B. Swearingen SX300 · Montgomery, ALThe pilot in command's decision to operate the aircraft with known fuel leaks and his failure to monitor fuel quantity en route which resulted in loss of engine power due to fuel exhaustion.Dec 27, 1992 · N336SX · DestroyedNTSB CHI93LA058Accident · No injuriesLimited investigationFinal reportBeech 90 · Dixon, ILThe instructor pilot not maintaining directional control following engine shut down and not performing remedial action of a power reduction to regain directional control, as prescribed by his company's training manual, once the airplane began to yaw/turn to…Dec 27, 1992 · N56KA · Substantial damageNTSB ATL93LA043Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Smithville, TNThe failure of the pilot to follow pilot manual procedures by slipping the aircraft with inadequate fuel available, which resulted in fuel starvation. Factors were the inadequate fuel supply on the aircraft and the failure of the pilot to refuel.Dec 27, 1992 · N7479E · Substantial damageNTSB NYC93LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Bowling Green, KYThe pilot's inadequate inflight planning and decision which resulted in fuel exhaustion and the loss of engine power.Dec 26, 1992 · N2325Y · Substantial damageNTSB MIA93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Tarpon Springs, FLThe pilot's failure to maintain the minumum descent altitude (mda) while on a non-precision instrument approach. Factors which contributed to the accident were: the flight service station (fss) specialist's failure to provide the published notice to airmen…Dec 26, 1992 · N5343T · DestroyedNTSB ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.Dec 25, 1992 · N2603Z · Substantial damageNTSB CHI93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Kokomo, INFailure to maintain aircraft control, and spatial disorientation of the pilot.Dec 23, 1992 · N9206B · Substantial damageNTSB NYC93LA050Accident · Serious injuriesLimited investigationFinal reportBeech F-35 · Collegeville, PAThe pilot's failure to follow the before landing check list in the pilot operators handbook in not selecting the fullest fuel tank for landing, which resulted in fuel starvation and subsequent engine failure.Dec 22, 1992 · N4266B · Substantial damageNTSB FTW93LA053Accident · No injuriesLimited investigationFinal reportCessna 210L · Allen, TXThe pilot's improper fuel tank selection and the subsequent loss of engine power due to fuel starvation. A factor was the lack of suitable terrain.Dec 22, 1992 · N4629Q · Substantial damageNTSB ATL93FA039Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Phenix City, ALThe pilot's failure to maintain control of the aircraft in instrument meteorological conditions. A factor was the pilots lack of total experience in instrument flight conditions.Dec 21, 1992 · N9319C · DestroyedNTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.Dec 19, 1992 · N18942 · Substantial damageNTSB SEA93GA041Accident · 8 fatalFinal reportCessna 550 · Billings, MTThe pilot-in-command's failure to follow established vortex avoidance procedures, as published in the airman's information manual, to provide his own wake turbulence separation.Dec 18, 1992 · N6887Y · DestroyedNTSB ATL93LA035Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Savannah, GAThe pilot's poor preflight and inflight planning.Dec 16, 1992 · N38037 · Substantial damageNTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.Dec 14, 1992 · N7285R · DestroyedNTSB CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.Dec 14, 1992 · N17CH · Substantial damageNTSB NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.Dec 13, 1992 · N210PQ · Substantial damageNTSB SEA93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Twin Falls, IDThe pilot's failure to maintain the ILS glide path.Dec 12, 1992 · N856M · Substantial damageNTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.Dec 12, 1992 · N8819Z · Substantial damageNTSB BFO93FA016Accident · 1 fatalField investigationFinal reportBeech C-45G · Elkridge, MDFailure of the pilot to properly secure the cargo, which allowed a shift in the center of gravity during a missed approach maneuver and resulted in subsequent loss of aircraft control and flying speed. A factor related to the accident was failure of the pilot…Dec 10, 1992 · N7770B · DestroyedNTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.Dec 7, 1992 · N58131 · Substantial damageNTSB FTW93LA047Accident · No injuriesLimited investigationFinal reportHiller UH12B · Justin, TXFailure of the main rotor system for undetermined reasons. A factor was the lack of suitable terrain at the pilot's disposal.Dec 2, 1992 · N1048P · Substantial damageNTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.Nov 30, 1992 · N244JH · Substantial damageNTSB ANC93LA017Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Huslia, AKThe failure of the pilot to maintain proper glidepath due to loss of visual cues over snow covered terrain in shadow of setting sun. Factors relating to the accident were the reduced light of dusk and the reduction of visual perception of the pilot in civil…Nov 28, 1992 · N69MA · Substantial damageNTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.Nov 27, 1992 · N5520B · Substantial damageNTSB ATL93FA028Accident · 1 fatalField investigationFinal reportBeech 58 · West Columbia, SCThe pilot's continued operation with known deficient equipment, his improper descent, and his failure to perform a missed approach. A factor was the operator's inadequate surveillance of the pilot's procedures and the maintenance of the airplane.Nov 25, 1992 · N9321Q · DestroyedNTSB CHI93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brookfield, WISpatial disorientation, and failure to maintain proper glidepath.Nov 21, 1992 · N1892J · DestroyedNTSB SEA93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vancouver, WAThe pilot's inability to see birds due to darkness.Nov 17, 1992 · N4324R · Substantial damageNTSB FTW93LA038Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Joshua, TXThe pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.Nov 16, 1992 · N9614S · DestroyedNTSB CHI93LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Makoti, NDThe pilot not maintaining a proper glidepath during his approach to landing.Nov 15, 1992 · N7057W · Substantial damageNTSB LAX93LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Mariposa, CAThe pilot's failure to maintain a sufficient airspeed margin while on final approach, and, after encountering a down draft, his failure to correct the resulting descent rate and maintain a glide path which would maintain obstacle clearance.Nov 14, 1992 · N5187M · Substantial damageNTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.Nov 12, 1992 · N15609 · Substantial damageNTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.Nov 11, 1992 · N91868 · 2 aircraft · Substantial damageNTSB SEA93FA020Accident · 1 fatalField investigationFinal reportCessna T210R · Boise, IDProper altitude was not maintained. Factors to the accident were: fog, dark night conditions, and improper IFR procedures.Nov 10, 1992 · N7381U · DestroyedNTSB ANC93LA015Accident · No injuriesLimited investigationFinal reportBell 206B III · Elf Point Camp, AKThe pilot misjudged clearance and dragged an external load longline cable while landing.Nov 10, 1992 · N21424 · Substantial damageNTSB BFO93FA003Accident · 1 fatalField investigationFinal reportCessna 310R · Summersville, WVThe pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.Nov 8, 1992 · N711RG · DestroyedNTSB LAX93LA027Accident · No injuriesLimited investigationFinal reportBeech 36TC · Sedona, AZThe pilot's poorly planned approach and delay in executing the appropriate remedial action. Contributing to this accident was the pilot's failure to maintain the proper glidepath and encountering a downdraft.Nov 3, 1992 · N67434 · DestroyedNTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.Nov 1, 1992 · N3722Z · Substantial damageNTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.Oct 31, 1992 · N250TJ · DestroyedNTSB ATL93LA019Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rives, TNThe pilot's failure to follow instrument procedures while conducting an instrument approach which resulted in the collision with trees; the pilot descended below the minimum descent altitude.Oct 31, 1992 · N101KH · Substantial damageNTSB FTW93LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Lubbock, TXThe partial power loss due to a disconnected throttle cable. A factor was the lack of suitable terrain at the pilot's disposal.Oct 27, 1992 · N75077 · Substantial damageNTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.Oct 24, 1992 · N16221 · Substantial damageNTSB FTW93LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Commerce, TXThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's evasive maneuver to avoid an undetermined object.Oct 24, 1992 · N7878U · DestroyedNTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.Oct 19, 1992 · N1ZB · DestroyedNTSB LAX93FA014Accident · Serious injuriesField investigationFinal reportCessna T337G · Fullerton, CAThe pilot's failure to maintain control of the aircraft during a circle to land maneuver in reduced visibility conditions. A factor in the accident was his distraction while reconfiguring the aircraft for a go around which led to an inadvertent entry into a…Oct 18, 1992 · N9SQ · DestroyedNTSB LAX93LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe pilot's inadequate planned approach to the runway, and, his improper use of the flight controls which resulted in an inadvertent accelerated stall/spin.Oct 17, 1992 · N1176S · Substantial damageNTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.Oct 14, 1992 · N330RJ · DestroyedNTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.Oct 12, 1992 · N111JC · Destroyed