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 LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.Sep 4, 1994 · N8431T · Substantial damageNTSB LAX94LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rescue, CAThe pilot's delayed go-around. His inadequate compensation for the wind was a factor.Sep 4, 1994 · N9699Q · Substantial damageNTSB CHI94FA307Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Lincoln, ILThe pilot's failure to maintain airspeed while performing a go-around.Sep 2, 1994 · N4362F · DestroyedNTSB NYC94LA162Accident · No injuriesLimited investigationFinal reportCessna 310Q · Salem, OHThe pilot misjudged altitude and distance which resulted in a undershoot of the runway and collision with objects.Sep 1, 1994 · N7579Q · Substantial damageNTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.Sep 1, 1994 · N3272X · DestroyedNTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…Aug 31, 1994 · N382EH · Substantial damageNTSB CHI94LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Indianapolis, INthe pilot's improper use of the mixture control, the poorly planned approach and the inadvertent stall.Aug 30, 1994 · N2452M · Substantial damageNTSB CHI94LA304Accident · No injuriesLimited investigationFinal reportCessna 210L · Orr, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the false indication from the fuel quantity gauges, and terrain condition in the emergency landing area.Aug 29, 1994 · N712JM · Substantial damageNTSB LAX94LA340Accident · 1 fatalLimited investigationFinal reportBeech D95A · Oakdale, CAImproper in-flight planning/decision by the flight instructor (CFI), and the cfi's inadequate supervision by not assuring that the minimum control speed (VMC) was maintained. A factor related to the accident was: the cfi's lack of experience in multi-engine…Aug 28, 1994 · N4835J · DestroyedNTSB BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.Aug 28, 1994 · N720PC · Substantial damageNTSB ATL94LA160Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Pine Mountain, GAThe pilot's inadequate compensation for existing wind conditions, and his failure to maintain both airspeed and clearance from a fence. Factors were the tailwind and the gusts which existed at the time of the accident.Aug 26, 1994 · N6650A · Substantial damageNTSB SEA94LA229Accident · No injuriesLimited investigationFinal reportBeech E-35 · Everett, WAThe nose gear extension assembly failure.Aug 25, 1994 · N5093C · Substantial damageNTSB ATL94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Washington, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion. A factor was the unsuitable terrain, a plowed field, available for landing.Aug 22, 1994 · N7726Z · Substantial damageNTSB FTW94FA274Accident · No injuriesField investigationFinal reportBell 230 · Albert Lea, MNThe pilot's failure to execute the proper approach and the ensuing settling with power. Factors were the tailwind, and the congestion around the airport.Aug 19, 1994 · N230EM · Substantial damageNTSB FTW94FA273Accident · 3 fatalField investigationFinal reportCessna 310 · Pryor, OKFailure of the pilot to maintain minimum control airspeed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: an oil leak from a fatigue crack in the engine crankcase, and inadequate maintenance.Aug 18, 1994 · N5319A · DestroyedNTSB NYC94FA160Accident · 4 fatalField investigationFinal reportCessna 320C · Waynesboro, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall/spin and his lack of qualification to conduct flight in type aircraft. A factor is the loss of engine power for undetermined reasons.Aug 16, 1994 · N85WM · DestroyedNTSB CHI94LA275Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 120A · Bloomington, ILthe unforcast, unanticipated adverse wind conditions and thermal activity. A factor was the powerlines.Aug 16, 1994 · N416TC · Substantial damageNTSB SEA94LA212Accident · No injuriesLimited investigationFinal reportAvid Magnum · Woodland, WAInadequate in-flight planning/decision and clearance from trees was not maintained. A factor to the accident was trees.Aug 15, 1994 · N180AB · Substantial damageNTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.Aug 15, 1994 · N6429B · Substantial damageNTSB LAX94LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Overgaard, AZthe pilot's failure to maintain an adequate airspeed margin, which resulted in an inadvertent stall. Factors in the accident were weather conditions, high density altitude, and shifting wind conditions.Aug 11, 1994 · N9044A · Substantial damageNTSB SEA94LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDFuel starvation due to the pilot-in-command's failure to verify the fuel tank selector position during the approach, and his failure to perform the published emergency procedures for an engine-out situation. A factor in the accident was a transmission wire.Aug 9, 1994 · N20818 · Substantial damageNTSB CHI94LA273Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeoville, ILthe pilot's inadequate preflight planning/preparation and improper emergency procedure. Factors associated with the accident are the pilot's improper positioning of the fuel tank selector, and the rough, uneven terrain.Aug 9, 1994 · N3634R · Substantial damageNTSB BFO94LA128Accident · Serious injuriesLimited investigationFinal reportHankins/Dickerson Clipped Wings II · Laurel, MDThe failure of the engine ignition system capacitor discharge unit which caused loss of total engine power.Aug 9, 1994 · N4287R · Substantial damageNTSB NYC94LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wellsboro, PAThe pilot's impairment of judgment and performance due to alcohol, which led to his misjudgment of altitude and distance to the runway and collision with terrain, while on final approach to land. A factor related to the accident was: darkness.Aug 8, 1994 · N9673C · Substantial damageNTSB SEA94LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Salmon, IDThe pilot's failure to adequately judge the distance and altitude to the runway during the night VFR approach. Factors in the accident were: fatigue, lack of recent night flying experience, the dark night, and the operator's inadequate supervision of the…Aug 7, 1994 · N47671 · Substantial damageNTSB NYC94LA152Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Schuylerville, NYthe pilots failure to maintain adequate airspeed, which resulted in a stall/mush.Aug 6, 1994 · N3441E · Substantial damageNTSB LAX94LA307Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Agua Dulce, CAthe pilot's poorly planned approach and improper remedial action. Factors relating to this accident were the high density altitude and prevailing tailwind.Aug 6, 1994 · N701SH · DestroyedNTSB BFO94LA130Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Morris, PAThe pilot misjudged altitude and distance, which resulted in an undershoot of the runway.Aug 6, 1994 · N1074E · Substantial damageNTSB ANC94LA098Accident · No injuriesLimited investigationFinal reportCessna 206 · Juneau, AKThe total loss of power for undetermined reasons. The pilot's failure to follow the prescribed procedure for the use of the auxiliary fuel boost pump switch, operating the airplane with a improperly operating switch, and the lack of suitable terrain in the…Aug 5, 1994 · N9120M · Substantial damageNTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.Aug 4, 1994 · N6276M · Substantial damageNTSB NYC94FA145Accident · 1 fatalField investigationFinal reportCessna 210N · Martinsburg, WVFailure of the pilot to maintain adequate altitude and proper climb during the missed approach. Factors related to the accident were: darkness, fog, and conditions conducive to pilot fatigue.Aug 3, 1994 · N4875U · DestroyedNTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.Aug 1, 1994 · N7960M · Substantial damageNTSB CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.Aug 1, 1994 · N3693M · DestroyedNTSB ANC94LA094Accident · Serious injuriesLimited investigationFinal reportBell 206 · Kenai, AKThe pilot attempting to operate the helicopter in an environment which exceeded the aircraft's performance envelope.Jul 30, 1994 · N90315 · Substantial damageNTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.Jul 29, 1994 · N4268Y · Substantial damageNTSB LAX94LA300Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Elko, NVa loss of engine power from fuel exhaustion due to the pilot's improper preflight and fuel consumption calculations while operating with known equipment malfunctions.Jul 27, 1994 · N180BK · Substantial damageNTSB LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.Jul 27, 1994 · N3627Q · Substantial damageNTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.Jul 25, 1994 · N32925 · Substantial damageNTSB FTW94FA242Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Lakeview, ARThe pilot's failure to maintain minimum required airspeed for flight.Jul 23, 1994 · N36566 · Substantial damageNTSB SEA94LA189Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Seattle, WAThe proper touchdown point was misjudged by the pilot. During the go-around attempt, he failed to maintain clearance from obstacles.Jul 22, 1994 · N73175 · Substantial damageNTSB FTW94LA240Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Moriarity, NMThe pilot's inadequate compensation for wind conditions and the high density altitude. Factors were gusty wind conditions, downdrafts and the degraded engine performance due to pervious detonation damage.Jul 20, 1994 · N71RJ · Substantial damageNTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.Jul 20, 1994 · N9843Q · Substantial damageNTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.Jul 19, 1994 · N63EA · 2 aircraft · Substantial damageNTSB FTW94LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Littlefield, TXAn inadvertent stall. Factors were low altitude and airspeed at the beginning of the downwind turn.Jul 16, 1994 · N33915 · Substantial damageNTSB FTW94FA233Accident · 2 fatalField investigationFinal reportCessna 310Q · Greenville, TXThe cfi's failure to maintain airspeed above VMC, resulting in a loss of control during the single engine G0-around. Factors were not attaining runway alignment and the cfi's failure to retract the landing gear for the go-around procedure.Jul 14, 1994 · N310AE · DestroyedNTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.Jul 14, 1994 · N21380 · Substantial damageNTSB LAX94LA284Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Tucson, AZa loss of engine power for undetermined reasons.Jul 13, 1994 · N5668M · Substantial damageNTSB MIA94LA178Accident · 1 fatalLimited investigationFinal reportHickey Windrose · Williston, FLThe pilot-in-command's failure to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact.Jul 12, 1994 · N20674 · DestroyedNTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.Jul 9, 1994 · N67318 · Substantial damageNTSB CHI94LA221Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Land O'Lakes, WIthe pilot's failure to maintain clearance with trees. Factors in the accident were the trees, the pilot's operation with known deficiencies in equipment, and the pilot's diverted attention.Jul 6, 1994 · N625P · Substantial damage