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 NYC91FA212Accident · 1 fatalField investigationFinal reportBeech 58 · Brookhaven, NYPilot physiological incapacitation which resulted in a loss of control in flight, and an uncontrolled descent into water.Aug 16, 1991 · N104SB · DestroyedNTSB ATL91LA162Accident · 1 fatalLimited investigationFinal reportHarold J. Eagen Pitts Special S-1C · Monroe, GAContamination and water existing in the fuel system which resulted in engine stoppage and the pilot's continued flight with a known aircraft deficiency.Aug 16, 1991 · N9HE · DestroyedNTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.Aug 15, 1991 · N84692 · Substantial damageNTSB ANC91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Angoon, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was pilot's intentional abrupt maneuvering at a low altitude and the flaps that retracted a knotch.Aug 10, 1991 · N715V · DestroyedNTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.Aug 9, 1991 · N8444S · Substantial damageNTSB MIA91LA195Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gainesville, FLA loss of engine power for undetermined reasons and a lack of suitable terrain for a forced landing.Aug 9, 1991 · N5396Q · Substantial damageNTSB CHI91LA258Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Delavan, WIMisjudged fuel consumption calculations by the pilot which resulted in fuel exhaustion. A factor related to the accident was refueling not performed.Aug 9, 1991 · N6159F · Substantial damageNTSB MIA91LA194Accident · Minor injuriesLimited investigationFinal reportSchultz Avid Flyer 502 · O'Brien, FLThe pilot in command's improper planned final approach, which resulted in an in flight collision with an electrical service line, and in flight collision with terrain.Aug 8, 1991 · N15DW · Substantial damageNTSB CHI91FA254Accident · 2 fatalField investigationFinal reportCessna 172M · Ottumwa, IAImproper IFR procedure by the pilot by not maintaining the proper minimum descent altitude (mda) until established on the ILS localizer and glidepath.Aug 6, 1991 · N61568 · DestroyedNTSB NYC91LA203Accident · No injuriesLimited investigationFinal reportCessna 150L · Moraine, OHThe failure of the pilot to maintain airspeed during a go-around, resulting in an inadvertent stall and in flight collision with terrain.Aug 5, 1991 · N17210 · Substantial damageNTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.Aug 4, 1991 · N53AS · Substantial damageNTSB DEN91LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Slaton, TXFailure of the engine's number three piston. A related factor was: collision with a ditch during the landing roll.Aug 4, 1991 · N7806U · Substantial damageNTSB CHI91LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MODirectional control was not maintained by the pilot. A factor related to the accident was lack of total experience in type of operation by the pilot.Aug 4, 1991 · N5134Q · Substantial damageNTSB LAX91FA342Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Reno, NVFailure of the pilot to maintain proper airspeed by employing an excessive angle of attack during the takeoff climb during a go-around resulting in an aerodynamic stall and subsequent inflight loss of control. Contributing to the accident was the pilot's poor…Aug 3, 1991 · N5277L · DestroyedNTSB DEN91LA107Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Tulsa, OKThe engine ailure for undetermined reasons. Factors were the light condition and the lack of suitable terrain.Aug 3, 1991 · N643T · DestroyedNTSB CHI91LA245Accident · Serious injuriesLimited investigationFinal reportHiller 1345 · Michigan City, INFuel exhaustion due the pilot's delay in refueling. Factors related to the accident were pressure induced by others (passenger), and the absence of suitable terrain.Aug 3, 1991 · N57972 · Substantial damageNTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.Aug 1, 1991 · N3722W · DestroyedNTSB DEN91LA106Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Aspen, COA pilot induced inadvertent stall. Factors were: the pilot's failure to ascertain the landing gear was down and locked in a timely manner, a low (fluid) level in hydraulic reservoir, causing the hydraulic pump to fluctuate (cavitate), and the pilot's…Aug 1, 1991 · N9711X · DestroyedNTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.Jul 31, 1991 · N9190U · DestroyedNTSB NYC91LA195Accident · Minor injuriesLimited investigationFinal reportBeech C50 · Salem, OHEngine failure as a result of improper maintenance and failure of the propeller feathering system for an undetermined reason. Factors were aircraft poor climb performance as resulted of the unfeathered propeller and obstructions which prevented a return to…Jul 31, 1991 · N9674R · Substantial damageNTSB LAX91LA335Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Scottsdale, AZFailure of the pilot-in-command accurately performing inflight fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot-in-command's poorly planned approached which terminated in a…Jul 31, 1991 · N8067G · Substantial damageNTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.Jul 31, 1991 · N5076 · Substantial damageNTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.Jul 28, 1991 · N2801F · Minor damageNTSB DEN91LA105Accident · Minor injuriesLimited investigationFinal reportFink, Charles H. FIN-1 · Albuquerque, NMA failure of the throttle system which prevented the pilot from achieving sufficient power to maintain flight. A factor was: the rough terrain.Jul 28, 1991 · N1033Y · DestroyedNTSB CHI91DEC03Accident · 1 fatalFinal reportAL White Breezy AWY · Leslie, MIThe pilot's failure to adequately maintain control of the aircraft. A factor was the exessive descent rate.Jul 28, 1991 · N2AW · Substantial damageNTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.Jul 28, 1991 · N64022 · Substantial damageNTSB ATL91LA144Accident · No injuriesLimited investigationFinal reportBeech C24R · Morrisville, NCFailure of the left main landing gear uplock cylinder which precluded extension of the landing gear.Jul 28, 1991 · N6713P · Substantial damageNTSB NYC91LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Westfield, MAThe pilot's failure to refuel resulting in a power failure due to fuel exhaustion, and subsequent forced landing in unsuitable terrain.Jul 27, 1991 · N62246 · Substantial damageNTSB LAX91LA330Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Minden, NVThe pilot's failure to properly adjust the mixture setting prior to landing to ensure the continued operation of the engine.Jul 27, 1991 · N2037W · Substantial damageNTSB FTW91LA132Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Sealy, TXThe pilot's failure to maintain clearance from an object on approach.Jul 27, 1991 · N8514 · Substantial damageNTSB MIA91LA191Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Hilliard, FLFailure of the pilot to maintain a proper glidepath during final approach resulting in the inflight collision with trees then the ground.Jul 26, 1991 · N31864 · Substantial damageNTSB LAX91LA325Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAThe cfi's failure to initiate the go-around maneuver in a timely manner, and his failure to terminate the simulated emergency maneuver at a proper altitude. A contributing factor was the gusty surface wind.Jul 24, 1991 · N5352D · Substantial damageNTSB FTW91DRG06Accident · 1 fatalFinal reportQuestair Venture · San Marcos, TXThe pilot's failure to maintain flying airspeed resulting in a stall.Jul 24, 1991 · N7PZ · DestroyedNTSB LAX91FA324Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Granada Hills, CAA loss of directional control following an undetermined autopilot failure, during which the pilot failed to perform the emergency procedure to correct a mis-trim condition. Contributing to the accident was a perceived elevator control problem; the inability…Jul 23, 1991 · N77CQ · DestroyedNTSB ANC91LA105Accident · No injuriesLimited investigationFinal reportCessna 182 · Girdwood, AKImproper in flight planning, fuel starvation and fuel supply not understood by the pilot. Contributing to the accident was rough and uneven terrain.Jul 22, 1991 · N4944D · Substantial damageNTSB LAX91LA322Accident · Serious injuriesLimited investigationFinal reportExperimental Brown 2 · San Carlos, CAThe failure of the pilot to maintain control of the aircraft during the attempted go around.Jul 21, 1991 · N255Y · Substantial damageNTSB SEA91LA192Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, WAA delayed go-around, and airspeed not being maintained. Factors include the pilot's overconfidence in the aircraft's ability, the pilot's lack of total experience in this type of operation, misjudged clearance, and the use of improper procedure.Jul 20, 1991 · N12958 · Substantial damageNTSB BFO91LA070Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Oakland, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jul 20, 1991 · N9599L · DestroyedNTSB ATL91LA136Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Belhaven, NCThe poor in flight planning by the pilot. Factors related to the accident were the failure of the pilot to compensate for the tail wind, maintain airspeed, and maintain clearance from the trees.Jul 20, 1991 · N51361 · Substantial damageNTSB SEA91FA175Accident · 1 fatalField investigationFinal reportCessna TU206G · Mccall, IDProcedures/directives were not followed. Factors to the accident were: improper fuel boost pump selector position, leaded spark plugs and sunglare.Jul 17, 1991 · N7216N · DestroyedNTSB LAX91LA317Accident · No injuriesLimited investigationFinal reportBeech 55B · Cupertino, CAFuel exhaustion which resulted from the pilot inaccurately calculating fuel consumption and fuel requirements.Jul 17, 1991 · N54339 · Substantial damageNTSB LAX91LA315Accident · 2 fatalLimited investigationFinal reportPiper PA32-300 · Corona, CAThe pilot's failure to maintain an airspeed above the aircraft's stall speed after the engine failed. Factors contributing to the accident were: the failure of the engine, magneto and accessory drive gear, the rough terrain conditions over which the engine…Jul 17, 1991 · N5233S · Substantial damageNTSB CHI91MA220Accident · No injuriesMajor investigationFinal reportAerospace ATR-42-300 · Peoria, ILInadequate aircraft equipment component (failed bolt), and insufficient inspection standards pertaining to the failed bolt. A factor related to the accident is inaccurate maintenance record keeping relating to oil consumption.Jul 17, 1991 · N425TE · Substantial damageNTSB DEN91LA100Accident · Minor injuriesLimited investigationFinal reportAerostar S57-A · Avon, COThe pilot's failure to maintain a visual lookout. A factor was: the pilot's attention being diverted.Jul 14, 1991 · N57053 · Substantial damageNTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.Jul 14, 1991 · N8803P · Substantial damageNTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.Jul 14, 1991 · N7616W · DestroyedNTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.Jul 13, 1991 · N50081 · Substantial damageNTSB NYC91FA178Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Yarmouth, MAThe failure of the number one cylinder fuel injector line due to fatigue cracking induced by corrosion and propagated by cyclic loading which resulted in a total loss of engine power. The corrosion was due to the manufacturer's process of brazing the metal…Jul 13, 1991 · N36272 · DestroyedNTSB LAX91LA309Accident · 2 fatalLimited investigationFinal reportMooney M20 · Little River, CAThe pilot inadvertently inducing a stall spin condition with insufficient altitude to recover from the spin.Jul 13, 1991 · N999LM · DestroyedNTSB FTW91LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Cresson, TXA loss of engine power for unknown reasons and the failure of the certified flight instructor/pilot-in-command to feather the propeller.Jul 11, 1991 · N289RL · Destroyed