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 NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.Nov 19, 1994 · N402BK · DestroyedNTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.Nov 18, 1994 · N14315 · DestroyedNTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.Nov 17, 1994 · N731QH · Substantial damageNTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.Nov 11, 1994 · N4469D · Substantial damageNTSB CHI95FA035Accident · 1 fatalField investigationFinal reportSikorsky S-76A · Cameron, LAthe copilot's failure to maintain altitude and the pilot-in-command's inadequate supervision of the operation. Factors include the dark night and low ceiling, and the flightcrew's failure to set the proper altimeter setting.Nov 9, 1994 · N2620 · DestroyedNTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.Nov 8, 1994 · N1380F · Substantial damageNTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.Nov 7, 1994 · N1566X · Substantial damageNTSB LAX95FA029Accident · Serious injuriesField investigationFinal reportCessna 421A · Sparks, NVThe pilot's improper use of the fuel selector and subsequent fuel starvation.Nov 1, 1994 · N421WB · DestroyedNTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.Oct 31, 1994 · N7207C · DestroyedNTSB FTW95LA035Accident · Minor injuriesLimited investigationFinal reportCessna T-210M · Tyler, TXLoss of engine power due to inadequate fuel management and fuel starvation. A factor was the lack of suitable terrain available for the forced landing.Oct 29, 1994 · N533CA · Substantial damageNTSB FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.Oct 28, 1994 · N86781 · Substantial damageNTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.Oct 23, 1994 · N90875 · Substantial damageNTSB CHI95LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIinaccurate planning by the pilot which resulted in the failure to assure an adequate fuel supply to complete the flight. A factor associated with the accident was the lack of a suitable landing site for the forced landing.Oct 23, 1994 · N6464J · Substantial damageNTSB NYC95LA015Accident · No injuriesLimited investigationFinal reportCessna 172B · Honesdale, PAthe fuel selector was in the improper position, which resulted in a total loss of engine power, due to fuel starvation, a forced landing, and subsequent impact with a stone wall.Oct 21, 1994 · N7491E · Substantial damageNTSB CHI95FA018Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Sellersburg, INFailure of the pilot to follow IFR procedures by allowing the aircraft to deviate left of the ILS localizer course, by not maintaining the proper ILS glide path, and by continuing descent below the ILS decision height.Oct 20, 1994 · N40509 · DestroyedNTSB LAX95LA013Accident · No injuriesLimited investigationFinal reportStan G. Hallam RV-6 · Bridgeport, CAthe pilot's poorly planned approach, his failure to maintain the proper airspeed and descent rate, and his failure to perform the necessary remedial action.Oct 19, 1994 · N93SJ · Substantial damageNTSB NYC95LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Worthington, PAThe failure of the aileron control cable which resulted in the inflight loss of control and collision with trees.Oct 15, 1994 · N70751 · Substantial damageNTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.Oct 15, 1994 · N9238 · Substantial damageNTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.Oct 14, 1994 · N20TA · Substantial damageNTSB SEA95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, ORThe failure of the dual student to maintain a proper glidepath and the pilot-in-command's inadequate supervision.Oct 12, 1994 · N4334E · Substantial damageNTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.Oct 12, 1994 · N601AV · Substantial damageNTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.Oct 11, 1994 · N8413P · Substantial damageNTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.Oct 10, 1994 · N7327K · Substantial damageNTSB NYC95LA002Accident · No injuriesLimited investigationFinal reportCessna 185F · Rochester, MAThe pilot's inadeqaute calculation of fuel and inadeqaute inflight decision which resulted in fuel exhaustion and the loss of engine power.Oct 9, 1994 · N53074 · Substantial damageNTSB LAX95LA017Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · La Verne, CAan inadvertant entry into a settling with power condition and the flight instructor's inability to correct the situation due to an inadequate altitude above ground.Oct 8, 1994 · N5697D · Substantial damageNTSB NYC95FA001Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Montgomery, NYwas the failure of the pilot to maintain adequate terrain clearance on final approach which resulted in a tree strike. Factors were the night conditions and the failure of the pilot to use the recommended runway.Oct 3, 1994 · N8397F · DestroyedNTSB FTW95FA001Accident · 1 fatalField investigationFinal reportMcmurtrie Jurca MJ-10 · Bartlesville, OKAn inadvertent pilot-induced stall at too low an altitude to effect a safe recovery. Factors were the malfunctioning propeller system and the uncommanded feathering of the propeller.Oct 1, 1994 · N379SF · DestroyedNTSB FTW94IA321Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11-F · Anchorage, AKRight inboard flap vane component separation due to undetermined reasons.Sep 29, 1994 · N603FE · Minor damageNTSB LAX94FA383Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 520N · Mesa, AZFailure of the chase helicopter pilot to maintain clearance from the lead helicopter during a night approach to land. Possible factors relating to the accident were: darkness, and inadequate radio coordination between flight crews of the two helicopters.Sep 28, 1994 · N520NT · 2 aircraft · DestroyedNTSB LAX94LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Fullerton, CAFuel starvation due to improper fuel management.Sep 27, 1994 · N8707P · DestroyedNTSB LAX94LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Woodland, CAthe failure of the pilot to maintain an adequate airspeed during a short field approach and the inadvertent entry into a stall/mush condition. In addition, the instructor failed to take proper remedial action.Sep 25, 1994 · N4813T · Substantial damageNTSB FTW94LA310Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Nikiski, AKThe pilot's improper descent rate. A factor was the check pilot's inadequate supervision.Sep 25, 1994 · N5583C · DestroyedNTSB FTW94LA309Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Denton, TXThe fuel starvation induced power loss due to the pilot's failure to maintain an adequate amount of fuel. Factors which contributed were: the lack of suitable terrain for the forced landing, and the pilot's evasive maneuver.Sep 25, 1994 · N9425C · Substantial damageNTSB CHI94LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Williamsport, INThe continued flight into adverse weather conditions, the student's failure to maintain a proper glideslope and the CFI's delay in initiating remedial action. Factors related to the accident were the lightning and turbulent thunderstorm conditions.Sep 24, 1994 · N55DH · DestroyedNTSB LAX94LA371Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Benson, AZthe pilot's failure to maintain adequate main rotor rpm during a go-around attempt.Sep 21, 1994 · VCHOS · Substantial damageNTSB CHI94LA341Accident · No injuriesLimited investigationFinal reportDooley, James M Velocity · Valparaiso, INthe pilot-in-command's improper use of the elevator trim. A factor was the pilot-in-command's lack of total experience in type of aircraft.Sep 20, 1994 · N107JD · Substantial damageNTSB FTW94LA302Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Houston, TXThe pilot's loss of directional control during the go around.Sep 19, 1994 · N9247U · DestroyedNTSB CHI94LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Madison, WIThe pilot-in-command not maintaining a proper glidepath during his final approach to landing. A factor associated with the accident was the lack of recent experience in the type operation performed by the pilot.Sep 18, 1994 · N2283Q · Substantial damageNTSB MIA94LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe failure of the pilot-in-command to calculate fuel consumption correctly resulting in loss of engine power due to fuel exhaustion.Sep 14, 1994 · N6517M · Substantial damageNTSB FTW94LA297Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARThe pilot's failure to maintain airspeed and the resultant aerodynamic stall.Sep 13, 1994 · N4607C · Substantial damageNTSB CHI94LA325Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chicago, ILthe pilot-in-command (CFI)'s inadequate supervision. Factors were the abrupt flare by the dual student.Sep 13, 1994 · N616SF · Substantial damageNTSB NYC94FA176Accident · No injuriesField investigationFinal reportWDL 1B · Farmingdale, NYInadequate design of the airship, which allowed the center ballonet to overfill and to collapse the trunking to the fore and aft ballonets, rendering the airship uncontrollable. Factors related to the accident were: inadequate maintenance by the…Sep 11, 1994 · N317TW · Substantial damageNTSB MIA94LA210Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLThe pilot's failure to see and avoid the banner.Sep 11, 1994 · N53925 · Substantial damageNTSB LAX94LA359Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Corona, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion and the rough terrain were factors in this accident.Sep 11, 1994 · N4328L · Substantial damageNTSB NYC94LA173Accident · No injuriesLimited investigationFinal reportSchleicher ASW15B · Dansville, NYThe pilot allowed the speed of the glider to get to low on final approach which resulted in a rapid descent, subsequent undershoot of the runway, and impact with a tree. A factor in this accident was a downdraft condition.Sep 10, 1994 · N827 · Substantial damageNTSB SEA94LA236Accident · No injuriesLimited investigationFinal reportCessna 182 · Circle, MTThe failure of the pilot-in-command (CFI) to perform an adequate preflight inspection of the airplane, including the proper securing of the fuel cap. The pilot's failure to divert to the nearest airport after recognizing excessive fuel consumption was a…Sep 8, 1994 · N2889R · Substantial damageNTSB DCA94MA076Accident · 132 fatalClass 1 · MajorFinal reportBoeing B-737-300 · Aliquippa, PAA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…Sep 8, 1994 · N513AU · DestroyedNTSB LAX94FA355Accident · 1 fatalField investigationFinal reportCessna 310H · Reno, NVThe pilot's failure to maintain minimum control airspeed.Sep 7, 1994 · N1081Q · DestroyedNTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.Sep 5, 1994 · N5526D · Substantial damageNTSB NYC94LA168Accident · No injuriesLimited investigationFinal reportBeech C35 · Rhinebeck, NYThe pilot's inadequate preflight planning and inaccurate fuel consumption calculations, resulting in fuel starvation and engine failure, and the subsequent collision with trees during a forced landing. A factor related to the accident was the turbulent air…Sep 4, 1994 · N5291C · Substantial damage