OpenAirDocs.org

NTSB investigations, NY

675 cases where the phase of flight was Approach.

Cases per year

19622026

Where

Open the map

Latest cases

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.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND 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 ERA24LA382Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX-7 · Amsterdam, NYThe pilot’s failure to maintain adequate clearance from powerlines during final approach for landing.Sep 13, 2024 · N53081 · Substantial damageNTSB ERA24LA224Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lagrangeville, NYThe pilot’s failure to maintain control of the airplane during the landing and subsequent go-around attempt. Also causal was the flight instructor’s delayed remedial action.May 17, 2024 · N462PW · Substantial damageNTSB ERA24LA116Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmingdale, NYThe student pilot’s lack of fuel management during the flight and the flight instructor’s inadequate monitoring of his student’s fuel management, resulting in fuel starvation and a forced landing to a highway.Feb 20, 2024 · N33667 · Substantial damageNTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.Mar 5, 2023 · N8149R · DestroyedNTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.Nov 5, 2022 · N51AL · Substantial damageNTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.Aug 14, 2022 · N33125 · Substantial damageNTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.Feb 28, 2022 · N7943Y · Substantial damageNTSB ERA22LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Ballston Spa, NYThe flight instructor’s and student pilot’s inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 27, 2021 · N2353Z · Substantial damageNTSB ERA22LA007Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Batavia, NYThe pilot’s failure to disengage the autopilot prior to climbing out of a fog bank.Oct 7, 2021 · N505TJ · Substantial damageNTSB ERA21LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Pleasant Valley, NYA total loss of engine power due to failure of the magnetos, which were not overhauled in accordance with the manufacturer’s time specifications.Dec 27, 2020 · N8311X · Substantial damageNTSB ERA21LA083Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon Hawker · Farmingdale, NYThe flight crew’s delayed decision to initiate a go-around after the approach had become unstabilized, which resulted in a hard landing.Dec 21, 2020 · N412JA · Substantial damageNTSB ERA21LA035Accident · 3 fatalClass 3 · LimitedFinal reportGrumman GA7 · Ellicott, NYThe pilot’s continued descent below the minimum descent altitude while conducting an instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.Nov 1, 2020 · N791GA · DestroyedNTSB ERA20CA211Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Olean, NYA loss of engine power for undetermined reasons.Jun 5, 2020 · N5044Z · Substantial damageNTSB ERA20LA163Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · East Hampton, NYThe partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.Apr 25, 2020 · N33005 · Substantial damageNTSB ERA20CA102Accident · No injuriesData collectionFinal reportCessna 172 · Rochester, NYThe pilot's failure to maintain airplane control during a go-around. Contributing to the accident was the pilot’s decision to take off after perceiving a rudder issue during taxi operations.Feb 16, 2020 · N1126U · Substantial damageNTSB ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.Dec 28, 2019 · N52840 · Substantial damageNTSB ERA19LA150Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New York, NYThe pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…Apr 14, 2019 · N5296H · Substantial damageNTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.Apr 11, 2019 · N3795J · Substantial damageNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB GAA18CA015Accident · Minor injuriesData collectionFinal reportThomas G Parkhurst Kitfox IV · Sidney, NYThe pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin.Oct 18, 2017 · N37TP · Substantial damageNTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.Jul 17, 2017 · N55US · Substantial damageNTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.Jul 4, 2017 · N45851 · Substantial damageNTSB ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…Apr 23, 2017 · N9907B · Substantial damageNTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.Apr 2, 2017 · N734SN · Substantial damageNTSB ERA17FA115Accident · 2 fatalField investigationFinal reportRyan Navion · Westhampton Beach, NYThe flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…Feb 26, 2017 · N4529K · DestroyedNTSB GAA17CA061Accident · No injuriesData collectionFinal reportBeech 95B55 · Plattsburgh, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover.Nov 14, 2016 · N180GA · Substantial damageNTSB ERA16FA044Accident · 2 fatalField investigationFinal reportBeech F33A · North Salem, NYA loss of airplane control for reasons that could not be determined because examination of the wreckage revealed no mechanical deficiencies.Nov 19, 2015 · N9318Q · DestroyedNTSB GAA16CA033Accident · No injuriesData collectionFinal reportCessna 150 · Millbrook, NYThe pilot's loss of heading control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.Oct 23, 2015 · N6709S · Substantial damageNTSB ERA14CA453Accident · Minor injuriesData collectionFinal reportSchleicher ASK 21 · Wurtsboro, NYA loss of lift during the landing approach, which resulted in impact with terrain.Sep 20, 2014 · N421SL · Substantial damageNTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.Jul 29, 2014 · N66358 · Substantial damageNTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.Jul 19, 2014 · N6467Q · DestroyedNTSB ERA14LA018Accident · No injuriesLimited investigationFinal reportFuller Van L Sonex · Palatine, NYA total loss of engine power for reasons that could not be determined because a test run and partial teardown of the engine did not reveal any anomalies.Oct 16, 2013 · N68VF · Substantial damageNTSB ERA13CA375Accident · Minor injuriesData collectionFinal reportMark C Pauls RV-7A · Cortland, NYA partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.Aug 25, 2013 · N411AK · Substantial damageNTSB ERA13CA353Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Eagle Bay, NYThe pilot's failure to set the engine throttle to full power during a go-around.Aug 2, 2013 · N555AX · Substantial damageNTSB ERA13FA215Accident · 1 fatalField investigationFinal reportSchweizer SGS 2-32 · Shirley, NYThe pilot’s failure to maintain airspeed during final approach, which resulted in a stall. Contributing to the accident was the pilot’s likely impairment due to an over-the-counter sedating antihistamine.Apr 27, 2013 · N9857E · Substantial damageNTSB DCA13CA066Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYan inadvertant birdstrike on approach.Dec 5, 2012 · N411ZW · Substantial damageNTSB ERA13CA077Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Middletown, NYThe pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.Dec 2, 2012 · N5787S · Substantial damageNTSB ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.Nov 17, 2012 · N8519M · Substantial damageNTSB ERA13LA018Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Yorktown, NYThe pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.Oct 12, 2012 · N443FD · Substantial damageNTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…Mar 18, 2012 · N987KB · Substantial damageNTSB ERA12FA093Accident · 1 fatalField investigationFinal reportWing John R Wittman Tailwind · Fulton, NYThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.Dec 1, 2011 · N865JT · Substantial damageNTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.Jul 27, 2011 · N7365P · Substantial damageNTSB ERA11LA417Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Sagaponack, NYThe loss of engine power for undetermined reasons.Jul 24, 2011 · N2ER · Substantial damageNTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.Jul 9, 2011 · N3344A · Substantial damageNTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…Jun 28, 2011 · N61579 · Substantial damageNTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…Jun 1, 2011 · N2656H · Substantial damageNTSB ERA11CA309Accident · Minor injuriesData collectionFinal reportBeech A23 · Greene, NYThe pilot's decision to continue a visual approach with low visibility and in heavy rain and his subsequent failure to maintain clearance from trees.May 21, 2011 · N3548R · Substantial damageNTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.Dec 23, 2010 · N968SM · Substantial damageNTSB ERA11CA057Accident · Serious injuriesData collectionFinal reportAeronca O58B · Livingston, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Nov 12, 2010 · N46014 · Substantial damageNTSB ERA10TA493Accident · Minor injuriesFinal reportBell 412 · Brooklyn, NYThe fatigue fracture of the reduction gearbox output drive gear, which resulted in the loss of power output from the engines to the helicopter rotor blade system and a subsequent forced landing. The fracture of the output drive gear was caused by a fatigue…Sep 22, 2010 · N412PD · Substantial damage