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 NYC92LA013Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov Lark I-28-B2 · Blairstown, NJAn improperly planned approach which resulted in an inadvertent stall with insufficient altitude for recovery. A factor related to the accident was improper use of the flight controls by the pilot.Oct 18, 1991 · N350BB · Substantial damageNTSB LAX92LA019Accident · 1 fatalLimited investigationFinal reportCessna 120 · Olancha, CAFailure of the pilot to maintain adequate airspeed resulting in an inadvertent stall while on final approach. Factors were the high density altitude and the pilot's poor approach planning.Oct 18, 1991 · N120MK · DestroyedNTSB FTW92IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe pilot's failure to attain proper runway alignment prior to touchdown and his failure to initiate a go around to remedy the situation. A factor was the low altitude at which he initiated the side step maneuver for which he was cleared.Oct 17, 1991 · PHBUU · Minor damageNTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.Oct 17, 1991 · N3735Y · Substantial damageNTSB ANC92LA008Accident · No injuriesLimited investigationFinal reportCessna A185E · Dog Salmon Riv, AKThe pilot's failure to maintain airspeed. Contributing to the accident was the downdraft.Oct 17, 1991 · N2756J · Substantial damageNTSB CHI92LA012Accident · No injuriesLimited investigationFinal reportRockwell 112YC · Detroit, MIThe pilot's failure to perform a major repair and continued operation of the airplane with known deficiencies.Oct 16, 1991 · N4603W · Substantial damageNTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.Oct 14, 1991 · N8379V · Substantial damageNTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.Oct 13, 1991 · N898KG · Substantial damageNTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.Oct 13, 1991 · N8182K · DestroyedNTSB LAX92LA013Accident · No injuriesLimited investigationFinal reportStinson 108-8 · Susanville, CAAn inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.Oct 12, 1991 · N87607 · Substantial damageNTSB LAX92LA012Accident · No injuriesLimited investigationFinal reportBeech K35 · Grass Valley, CAThe inadvertent encounter with a microburst/downburst phenomena associated with thunderstorm activity. A factor in the accident was the failure of the pilot to adequately assess the weather conditions during the landing attempt.Oct 11, 1991 · N9559R · Substantial damageNTSB MIA92LA009Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Panama City, FLLoss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.Oct 10, 1991 · N25PA · Substantial damageNTSB CHI92LA005Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Cassville, MOThe pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.Oct 10, 1991 · N2563J · Substantial damageNTSB NYC92LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Lincoln, METhe pilot's failure to see and avoid the transmission lines. A factor was the sunglare.Oct 9, 1991 · N76101 · Substantial damageNTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.Oct 9, 1991 · N5399B · Substantial damageNTSB ATL92LA003Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gadsden, ALFuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.Oct 6, 1991 · N4726X · Substantial damageNTSB FTW92LA004Accident · No injuriesLimited investigationFinal reportCessna 210C · Leander, TXThe pilot's disregard for the hazardous weather advisories received. A factor was the weather.Oct 5, 1991 · N3655Y · Substantial damageNTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.Sep 30, 1991 · N42LF · DestroyedNTSB NYC91LA251Accident · Minor injuriesLimited investigationFinal reportCessna C-152 II · Blue Bell, PAThe pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…Sep 29, 1991 · N48806 · Substantial damageNTSB BFO91LA086Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Grayson, KYThe pilot's failure to maintain control of the aircraft during the attempted go-around.Sep 29, 1991 · N10PT · Substantial damageNTSB SEA91LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Malaga, WAThe instructor pilot's failure to insure adequate terrain clearance during the go-around maneuver. Factors contributing to the accident were 1) rising terrain, 2) high density altitude condition, and 3) the instructor pilot's delay of the go-around.Sep 26, 1991 · N4740H · Substantial damageNTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.Sep 26, 1991 · N4113G · Substantial damageNTSB CHI91DTK04Accident · 1 fatalFinal reportBoland/Poe Tsunami · Pierre, SDA bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…Sep 25, 1991 · NX39JR · DestroyedNTSB MIA91LA223Accident · No injuriesLimited investigationFinal reportCentrair 101A · Groveland, FLThe pilot in command's poor in flight decision planning, and inadvertent stall mush while on approach to land. Contributing to the accident was his lack of total experience.Sep 21, 1991 · N93KG · Substantial damageNTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.Sep 21, 1991 · N8728N · Substantial damageNTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.Sep 21, 1991 · N700CH · Substantial damageNTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…Sep 20, 1991 · N915PM · Substantial damageNTSB CHI91LA278Accident · No injuriesLimited investigationFinal reportCessna 310J · Sugar Grove, ILThe buckled nose landing gear retraction/extension gear drive tube. A factor in the accident was the pilot in command not having the landing gear inspected at the interval recommended by the manufacturer.Sep 20, 1991 · N300RA · Substantial damageNTSB SEA91LA243Accident · No injuriesLimited investigationFinal reportDonald W. Sorrels Vans RV-6 · Kennewick, WAThe loss of power due to the pilot/builder's improper adjustment of the engine idle speed. A factor relating to the accident was the soft terrain at the accident site.Sep 18, 1991 · N391DS · Substantial damageNTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.Sep 17, 1991 · N4795T · Substantial damageNTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.Sep 16, 1991 · N714RK · Substantial damageNTSB NYC91LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · Norwood, MAPremature retraction of the wing flaps during a go-around which resulted in an inadvertent stall with insufficient altitude for recovery. Factors related to the accident were: the pilot's lack of total experience in make and model, and lack of recent…Sep 12, 1991 · N71393 · Substantial damageNTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.Sep 12, 1991 · N13DT · DestroyedNTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.Sep 11, 1991 · N7730Y · DestroyedNTSB LAX91LA390Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Chula Vista, CAThe pilot's failure to maintain the proper airspeed and misjudging the landing flare altitude. The powerplant failure for an undetermined reason and the unsuitable terrain for the float equipped helicopter were factors in the accident.Sep 10, 1991 · N2618D · Substantial damageNTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.Sep 8, 1991 · N16WW · Substantial damageNTSB MIA91LA216Accident · No injuriesLimited investigationFinal reportCessna 182 · Titusville, FLThe pilot in command's improper preflight planning and his failure to ensure that the aircraft contained sufficient fuel for the flight.Sep 7, 1991 · N5648B · Substantial damageNTSB ANC91LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKWas the pilot's failure to maintain a proper descent rate. Contributing to the accident was the gust of tailwind.Sep 7, 1991 · N2KA · Substantial damageNTSB ATL91LA167Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Calhoun, GAThe pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.Sep 1, 1991 · N43LT · Substantial damageNTSB NYC91LA226Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Nantucket, MAThe pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.Aug 31, 1991 · N296TH · DestroyedNTSB LAX91LA378Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Mojave, CAThe glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…Aug 31, 1991 · N901DH · DestroyedNTSB ATL91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Stockbridge, GAThe pilot's failure to maintain flying speed after experiencing a partial loss of engine power. Factors in this accident were, loose carburetors, annual inspection not performed, and pilot's lack of recent experience.Aug 31, 1991 · N44PG · Substantial damageNTSB ANC91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gold King, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was the rising terrain and the tailwind condition.Aug 31, 1991 · N2664A · Substantial damageNTSB CHI91DEV03Accident · 1 fatalFinal reportHocker Dragonfly · Metropolis, ILPilot's failure to maintain airspeed above stall.Aug 30, 1991 · N28P · DestroyedNTSB DEN91LA121Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Parker, COPartial failure of the aircraft powerplant for undetermined reasons. A related factor was: the soft terrain.Aug 29, 1991 · N2628C · Substantial damageNTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.Aug 26, 1991 · N3909F · Substantial damageNTSB CHI91LA269Accident · No injuriesLimited investigationFinal reportCessna 172E · Harbor Springs, MIThe pilot's failure to adequately compensate for wind conditions. A factor associated with the accident was his delay in initiating the go-around.Aug 22, 1991 · N3891S · Substantial damageNTSB MIA91IA201Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Clearwater, FLTotal loss of engine power due to fuel starvation caused by improper fuel tank selector position by the pilot-in-command. Contributing to the incident was the pilot's total lack of experience.Aug 21, 1991 · N9558W · Minor damageNTSB SEA91LA209Accident · No injuriesLimited investigationFinal reportCessna 172M · Oak Harbor, WAThe pilot's allowing the airspeed to decay below the stall speed. Factors contributing to the accident were the pilot's failure to maintain directional control and the pilot's lack of total recent experience.Aug 16, 1991 · CGFTE · Substantial damageNTSB NYC91LA213Accident · No injuriesLimited investigationFinal reportCessna 150C · Kemblesville, PAThe instructor pilots' inadequate supervision, the student pilots' overshoot of the simulated landing area, and the power loss for undetermined reasons.Aug 16, 1991 · N16AC · Substantial damage