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 FTW92LA081Accident · No injuriesLimited investigationFinal reportCameron 084 · Maumelle, ARThe pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.Mar 7, 1992 · N6008J · DestroyedNTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.Mar 6, 1992 · N100LC · DestroyedNTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.Mar 6, 1992 · N8104G · DestroyedNTSB DEN92FA040Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · New Castle, COAn inadvertent stall during an instrument approach with the autopilot engaged. A factor was: the pilot's physical impairment from a prescription drug.Mar 5, 1992 · N303CA · DestroyedNTSB FTW92LA096Accident · Minor injuriesLimited investigationFinal reportBurnett Teenie II · Edmond, OKPartial engine power loss due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.Feb 29, 1992 · N5749 · Substantial damageNTSB FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.Feb 27, 1992 · N5499R · Substantial damageNTSB FTW92LA075Accident · No injuriesLimited investigationFinal reportBell 206B III · Grand IsleHeavy sea state due to the high winds. A factor was the power loss.Feb 26, 1992 · N2750F · Substantial damageNTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.Feb 26, 1992 · N347G · DestroyedNTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…Feb 25, 1992 · N6928L · DestroyedNTSB LAX92FA121Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Agua Dulce, CAThe pilot's abrupt aircraft control and failure to maintain airspeed. Contributing to this accident was the inadvertent stall/spin.Feb 22, 1992 · N9066L · DestroyedNTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.Feb 20, 1992 · N4373U · Substantial damageNTSB ATL92LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA32-300 · Hickory, NCWhile on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…Feb 20, 1992 · N332DD · Substantial damageNTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.Feb 19, 1992 · N33464 · Substantial damageNTSB NYC92FA062Accident · 1 fatalField investigationFinal reportCessna 150 · White Lake, NYThe pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…Feb 16, 1992 · N6559F · Substantial damageNTSB DCA92MA022Accident · 4 fatalMajor investigationFinal reportDouglas DC-8-63 · Swanton, OHThe failure of the flightcrew to properly recognize or recover in a timely manner from the unusual aircraft attitude that resulted from the captain's apparent spatial disorientation, resulting from physiological factors and/or a failed attitude director…Feb 15, 1992 · N794AL · DestroyedNTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.Feb 13, 1992 · N89071 · Substantial damageNTSB ANC92LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Anchorage, AKThe pilot's misjudgment of the fuel consumption of the airplane; thereby exhausting the fuel supply prematurely. Factor relating to the accident was the lack of a suitable forced landing area.Feb 13, 1992 · N3877P · Substantial damageNTSB MIA92FA085Accident · 1 fatalField investigationFinal reportCessna 425 · Lakeland, FLLoss of control in flight by the pilot for undetermined reasons.Feb 11, 1992 · N66LM · Substantial damageNTSB MIA92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Smyrna Bch, FLImproper weather evaluation by the pilot in command resulting in the in flight encounter with fog during the downdwind leg shortly after takeoff to remain in the traffic pattern.Feb 10, 1992 · N20974 · Substantial damageNTSB MIA92LA082Accident · No injuriesLimited investigationFinal reportBurch Rotorway Exec · Lakeland, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing. This resulted in a hard landing, collision of the main rotor blades with the tailboom, and subsequent roll over of the helicopter. Contributing…Feb 9, 1992 · N618VN · Substantial damageNTSB MIA92LA078Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…Feb 9, 1992 · N6222L · Substantial damageNTSB DEN92LA031Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Durango, COThe pilot's failure to maintain directional control. A factor was: crosswind.Feb 9, 1992 · N5637W · Substantial damageNTSB ANC92LA033Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Cube Cove, AKThe encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.Feb 9, 1992 · N905D · Substantial damageNTSB NYC92LA056Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Caldonia, NYThe pilot's improper use of carburetor heat which resulted in a loss of engine power. A factor relating to the accident was weather conducive to carburetor icing.Feb 8, 1992 · N986T · Substantial damageNTSB ANC92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.Feb 8, 1992 · N8620S · Substantial damageNTSB CHI92DCD02Accident · Minor injuriesFinal reportQuad City Challenger · Blakesburg, IAFailure of the pilot to maintain aircraft control during final approach. Weather conditions, high wind and turbulence, were factors in the accident.Feb 7, 1992 · UNREG · DestroyedNTSB FTW92LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXThe pilot's failure to fully extend the landing gear by the alternate gear extention system. Factors were the dark night, low ceiling, fog, drizzle and failure of the electrical system.Feb 4, 1992 · N9754B · Substantial damageNTSB ANC92LA032Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Metlakatla, AKTotal failure of the rivets attaching the trim tab control horn to the right elevator trim tab.Feb 4, 1992 · N13GA · Substantial damageNTSB ANC92LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tununak, AKMisjudged wind information. Factors to the accident were: turbulence, crosswind and flight into known adverse weather.Feb 4, 1992 · N76RL · Substantial damageNTSB FTW92LA065Accident · No injuriesLimited investigationFinal reportCessna 150L · Searcy, ARThe pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.Feb 2, 1992 · N11567 · Substantial damageNTSB FTW92DQA01Accident · 1 fatalFinal reportAir Trans. White Lightning · Aztec, NMThe inadvertent stall and the pilot's lack of experience in the accident aircraft.Jan 31, 1992 · N121WE · DestroyedNTSB FTW92LA062Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · E.I. Blk 108The pilot's failure to maintain altitude above the water. Factors were the pilot attempting flight into known adverse weather conditions of fog and low ceilings during dawn light conditions.Jan 29, 1992 · N65603 · Substantial damageNTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.Jan 29, 1992 · N8379N · DestroyedNTSB LAX92LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ft Mojave, AZAn inadequate annual inspection performed by other maintenance personnel. Contributing to this accident was the flap cable failure due to corrosion.Jan 26, 1992 · N23455 · Substantial damageNTSB LAX92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Tonopah, NVThe pilot's failure to assure that there was an adequate supply of fuel in the airplane to complete the flight due to alcoholic impairment of efficiency and judgement resulting in a total loss of power of both engines.Jan 25, 1992 · N7325L · Substantial damageNTSB MIA92LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · West Palm Beach, FLPartial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.Jan 12, 1992 · N4188S · Substantial damageNTSB BFO92LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Mount Holly, NJA loss of engine power for undetermined reasons.Jan 7, 1992 · N3906F · Substantial damageNTSB CHI92FA067Accident · 1 fatalField investigationFinal reportBeech A-36TC · Pekin, ILThe pilot-in-command's continued flight into icing conditions and his failure to use the airplane's anti-ice/de-ice system resulting in a build-up of ice over the airplane's surface area and resultant loss of control. Factors which contributed to the accident…Jan 5, 1992 · N345CC · DestroyedNTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.Jan 4, 1992 · N7491R · Substantial damageNTSB BFO92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wadsworth, OHFailure of the pilot to attain an adequate airspeed during an attempted go around, which resulted in a stall. His premature raising of the flaps and lack of experience in the make and model of aircraft were related factors.Jan 4, 1992 · N2587L · Substantial damageNTSB DCA92MA016Accident · 2 fatalMajor investigationFinal reportBeech 1900C · Gabriels, NYFailure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…Jan 3, 1992 · N55000 · DestroyedNTSB MIA92LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eustis, FLThe pilot misjudged altitude and distance resulting in undershooting the landing. Contributing to the acident was the dark night condition.Jan 2, 1992 · N7582S · Substantial damageNTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…Jan 1, 1992 · N680JM · Substantial damageNTSB CHI92LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Huntington, INPilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…Dec 31, 1991 · N2859R · DestroyedNTSB BFO92FA013Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · North Salem, NYA loss of control due to a distraction caused by a partial loss of power. Contributing to the accident was adverse weather near the destination airport.Dec 30, 1991 · N36362 · DestroyedNTSB NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…Dec 29, 1991 · N811BE · DestroyedNTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.Dec 28, 1991 · N2471G · Substantial damageNTSB MIA92FA053Accident · Serious injuriesField investigationFinal reportCessna 172RG · Melbourne, FLThe flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…Dec 28, 1991 · N9718B · Substantial damageNTSB SEA92LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Missoula, MTThe pilot's poor in-flight decision, failure to perform a missed approach, and improper altitude. Factors include poor preflight planning/preparation, and weather conditions below approach minimums.Dec 27, 1991 · N6408P · Substantial damageNTSB MIA92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Fayetteville, NCThe pilot-in-command's failure to perform an adequate preflight in that he failed to assure adequate fuel for the flight was available. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Dec 26, 1991 · N5583W · Substantial damage