OpenAirDocs.org

NTSB investigations

20,992 cases where the phase of flight was Approach.

Cases, newest first

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 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 FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.Apr 3, 1998 · N21LL · DestroyedNTSB MIA98LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingsport, TNThe dual student's failure to maintain adequate airspeed which resulted in a stall mush. Contributing to the accident were the flight instructor's inadequate supervision and the night conditions.Mar 31, 1998 · N9233H · DestroyedNTSB SEA98LA052Accident · No injuriesLimited investigationFinal reportBeech S35 · Medford, ORthe pilot's inadequate fuel management. Factors were the pilot's diverted attention and soft terrain in the forced landing area.Mar 24, 1998 · N3MG · Substantial damageNTSB MIA98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe total loss of engine power due to fuel starvation.Mar 24, 1998 · N8490W · Substantial damageNTSB SEA98LA050Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Seattle, WALoss of engine power due to a restricted fuel system filter.Mar 22, 1998 · N5245P · Substantial damageNTSB LAX98TA123Accident · No injuriesFinal reportBell 206B · Santa Clarita, CAThe failure of the pilot to maintain adequate clearance with the wires. Additional factors in this accident are the position of the sun at that time of the day, which made it difficult to see the wires, and the lack of markings or poles for that series of…Mar 20, 1998 · N3186L · Substantial damageNTSB NYC98LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Lockport, NYThe pilot's misjudgment of altitude and distance during a forced landing in the traffic pattern. A factor in the accident was the carburetor icing conditions.Mar 17, 1998 · N704GP · Substantial damageNTSB LAX98LA115Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · San Luis Obispo, CAThe student pilot's inadvertent pulling of the mixture, instead of the carburetor heat, while preparing for the approach, and the flight instructor's inadequate supervision.Mar 15, 1998 · N4079M · Substantial damageNTSB SEA98LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mcminnville, ORDisconnection of the throttle cable at the throttle-to-carburetor adapter plate and the failure of the student pilot to shut the aircraft's engine down once a safe landing was assured. Factors contributing to the accident were the soft terrain and overloading…Mar 14, 1998 · N757CZ · Substantial damageNTSB LAX98LA114Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Truckee, CAThe failure of the pilot to maintain control of the aircraft due to spatial disorientation. A factor was the dark night.Mar 14, 1998 · N345RD · DestroyedNTSB MIA98FA101Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Advance, NCThe pilot's improper planned visual approach and glide path in diminished visual conditions due to sun-glare and his delayed go-around resulting in the aircraft colliding with trees on final approach.Mar 12, 1998 · N7826N · Substantial damageNTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.Mar 11, 1998 · N2438L · Substantial damageNTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.Mar 11, 1998 · N13012 · Substantial damageNTSB CHI98LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Edgeley, NDThe pilot's inadequate in-flight planning/decision making which resulted in a delayed go-around and his not maintaining aircraft control. A factor was the crosswind.Mar 8, 1998 · N9882K · Substantial damageNTSB MIA98LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Titusville, FLloss of engine power for undetermined reason(s), which resulted in a forced landing. Factors relating to the accident were: the lack of suitable terrain and obstructions in the emergency landing area.Mar 5, 1998 · N8342E · Substantial damageNTSB NYC98FA071Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Presque Isle, METhe pilot's failure to follow the published instrument approach procedure and his descent below the minimum descent altitude. Contributing factors were the night conditions, low ceilings, and fog.Mar 1, 1998 · N777HM · DestroyedNTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.Mar 1, 1998 · N84561 · Substantial damageNTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.Feb 28, 1998 · N1173N · Substantial damageNTSB NYC98LA070Accident · No injuriesLimited investigationFinal reportCessna 320F · Lincoln, METhe pilot's failure to maintain adequate altitude which resulted in left main landing gear contacting a snowbank during the landing approach.Feb 27, 1998 · N6189Q · Substantial damageNTSB FTW98LA134Accident · Minor injuriesLimited investigationFinal reportBurchinal A4D-2 · Fort Worth, TXA total hydraulic system failure for an undetermined reason.Feb 27, 1998 · N21NB · Substantial damageNTSB CHI98LA098Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Mason City, IAthe accumulation of airframe ice during flight, and failure of the pilot to attain a proper flare for landing. Factors relating to the accident were: the adverse weather (icing) condition; and the pilot's limited forward visibility, due to ice on the…Feb 27, 1998 · N108RS · Substantial damageNTSB MIA98LA088Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Chapel Hill, NCfailure of the pilot to maintain directional control of the aircraft during a go-around, followed by his failure to maintain airspeed while maneuvering to avoid trees, which resulted in a stall and collision with the terrain. The pilot's lack of recent night…Feb 26, 1998 · N4356V · Substantial damageNTSB FTW98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Dallas, TXThe nose gear collapsed for an undetermined reason. A factor was the total electrical failure due to the separation of the alternator output lugs resulting from inadequate maintenance.Feb 24, 1998 · N9254X · Substantial damageNTSB ANC98LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kongiganak, AKThe pilot misjudged distance/altitude and airspeed, and his delay initiating a go-around. Related factors were the downdraft and snowbank.Feb 24, 1998 · N81844 · Substantial damageNTSB MIA98LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Covington, GAthe pilot's inadequate preflight planning/preparation and/or improper fuel management, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Soft/wet terrain in the emergency landing area was a related factor.Feb 23, 1998 · N1734U · Substantial damageNTSB LAX98LA092Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Williams, CAThe pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.Feb 23, 1998 · N948B · Substantial damageNTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.Feb 22, 1998 · N54172 · Substantial damageNTSB ATL98LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fayetteville, NCfuel system contamination (rubber shavings), which led to blockage of a fuel line, fuel starvation, loss of engine power, and a collision with terrain.Feb 22, 1998 · N1404T · Substantial damageNTSB DCA98MA023Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 727-223 · Chicago, ILthe failure of the flight crew to maintain a proper pitch attitude for a successful landing or go-around. Contributing to the accident were the divergent pitch oscillations of the airplane, which occurred during the final approach and were the result of an…Feb 9, 1998 · N845AA · Substantial damageNTSB CHI98LA092Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe pilot's improper raising of flaps and not maintaining directional control of the aircraft during the go-around sequence.Feb 8, 1998 · N18766 · Substantial damageNTSB NYC98LA065Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Chester, NYThe pilot's inadequate preflight which failed to reveal fuel contamination.Feb 7, 1998 · N55412 · Substantial damageNTSB FTW98LA123Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Conroe, TXThe pilot's delay in aborting the landing due to excessive airspeed during the approach.Feb 7, 1998 · N7117L · Substantial damageNTSB FTW98LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Bulverde, TXThe pilot's failure to maintain the proper glidepath following a total electrical failure resulting from an inoperative voltage regulator. Factors were the dark night conditions, the pilot's lack of experience in night flying, and the trees.Feb 4, 1998 · N13711 · Substantial damageNTSB FTW98LA408Accident · No injuriesLimited investigationFinal reportPalermo Challenger II · Erwinville, LAThe pilot's failure to compensate for the prevailing crosswind. Factors were the crosswind and the loss of engine power due to the separation of the fuel pick-up line.Jan 20, 1998 · N266RP · Substantial damageNTSB ATL98LA034Accident · No injuriesLimited investigationFinal reportAmerican General AA-1A · Orlando, FLThe pilot's failure to maintain flying speed.Jan 18, 1998 · N6364L · Substantial damageNTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.Jan 18, 1998 · N7443G · Substantial damageNTSB CHI98FA082Accident · 1 fatalField investigationFinal reportBeech 95-55 · Pinckneyville, ILThe pilot descent below minimum descent altitude and his intentional operation with known deficiencies in equipment. Factors were the dark night, fog, rain, and the trees.Jan 15, 1998 · N54643 · DestroyedNTSB FTW98MA096Accident · 2 fatalMajor investigationFinal reportGates Learjet 25B · Houston, TXThe flight crew's continued descent of the airplane below the glideslope and through the published decision height without visual contact with the runway environment. Also, when the captain encountered difficulty tracking the localizer course, his improper…Jan 13, 1998 · N627WS · DestroyedNTSB MIA98LA053Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pooler, GAThe pilot's failure to maintain a safe altitude and a visual lookout while operating under a special visual flight rules clearance in instrument flight rule conditions, which resulted in the helicopter colliding with trees. Contributing to the accident was…Jan 7, 1998 · N333FC · Substantial damageNTSB LAX98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Compton, CAThe failure of maintenance personnel to adequately inspect the aircraft during an annual inspection to detect a chafed and leaking engine fuel supply line.Jan 4, 1998 · N9406X · Substantial damageNTSB FTW98LA085Accident · No injuriesLimited investigationFinal reportMooney M20J · Westport, OKThe pilot's inadequate compensation for the existing wind conditions. A factor was gusty winds.Jan 2, 1998 · N201LG · Substantial damageNTSB NYC98LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355 · New York, NYthe pilot's misjudgment of distance and speed on final approach with a tailwind, and his failure to perform a go-around in a timely manner. A factor in the accident was the strong tailwind.Dec 31, 1997 · N355DS · Substantial damageNTSB FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.Dec 31, 1997 · N736VQ · DestroyedNTSB CHI98LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Chesterfield, MOthe pilot's failure to position the fuel selector to the proper fuel tank which led to fuel starvation.Dec 31, 1997 · N627V · Substantial damageNTSB NYC98LA051Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Albany, OHthe pilot's improper in-flight planning/decision and failure to turn off the carburetor heat during the go-around. Related factors were: the pilot's lack of experience in make and model, and the proximity of trees.Dec 28, 1997 · N1469N · Substantial damageNTSB CHI98LA072Accident · 1 fatalLimited investigationFinal reportPiper PA-30/A · Hastings, NEThe pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.Dec 24, 1997 · N9WG · DestroyedNTSB ATL98FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Tallahassee, FLThe pilot's failure to maintain the proper glidepath and adequate obstacle clearance which resulted in collision with a power transmission line.Dec 23, 1997 · N8074Z · DestroyedNTSB LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.Dec 21, 1997 · N8805P · Substantial damageNTSB FTW98FA074Accident · 2 fatalField investigationFinal reportBeech A100 · Colo Springs, COFailure of the pilot to follow IFR Procedures and maintain the minimum descent altitude (MDA). A related factor was fog.Dec 21, 1997 · N100BE · DestroyedNTSB NYC98FA047Accident · 1 fatalField investigationFinal reportCady LONG-EZ · West Milford, NJFailure of the pilot to use carburetor heat, which resulted in carburetor ice. Carburetor icing conditions and terrain conditions were contributing factors.Dec 20, 1997 · N18CC · Substantial damage