OpenAirDocs.org

NTSB investigations, VT

76 cases where the phase of flight was Approach.

Cases per year

19642026

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\" = 'VT' 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 ERA22LA393Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Bennington, VTThe pilot’s failure to maintain airspeed during a go-around, resulting in an aerodynamic stall, loss of control, and collision with terrain.Aug 29, 2022 · N3768T · Substantial damageNTSB ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.Aug 25, 2018 · N6936B · Substantial damageNTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.May 5, 2018 · N17909 · Substantial damageNTSB GAA17CA519Accident · No injuriesData collectionFinal reportPiper J5A · Springfield, VTThe pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.Aug 27, 2017 · N30897 · Substantial damageNTSB ERA11CA152Accident · Serious injuriesData collectionFinal reportAirbus A320-232 · North Fayston, VTThe airplane's inadvertent encounter with turbulence during the approach, which resulted in serious injury to a flight attendant.Feb 19, 2011 · N706JB · No damageNTSB ERA11LA025Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Warren, VTThe pilot's inadvertent deployment of the airbrake handle past the upper limit of its normal operating range, which resulted in binding of the controls.Oct 18, 2010 · N188PX · Substantial damageNTSB ERA10FA029Accident · 1 fatalField investigationFinal reportCessna 172P · Bennington, VTThe pilot’s failure to maintain clearance from terrain during a night approach. Contributing to the accident was the pilot’s non-standard traffic pattern over higher terrain.Oct 25, 2009 · N55479 · Substantial damageNTSB ERA09LA323Accident · 1 fatalLimited investigationFinal reportYork Ronald J Rotorway 162F · Berlin, VTA loss of control in flight for undetermined reasons.Jun 5, 2009 · N162RY · DestroyedNTSB NYC07CA151Accident · No injuriesData collectionFinal reportLet Super Blanik L-23 · Warren, VTThe glider's inadvertent encounter with windshear. A factor was the outflow from a nearby thunderstorm.Jun 27, 2007 · N8022 · Substantial damageNTSB DEN07CA103Accident · No injuriesData collectionFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.Jun 22, 2007 · N8078Y · Substantial damageNTSB NYC07FA038Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601P · West Dover, VTA loss of control during approach for undetermined reasons, which resulted in a collision with trees.Dec 2, 2006 · N9797Q · DestroyedNTSB NYC06MA192Accident · 1 fatalMajor investigationFinal reportEmbraer 110P1 · Pownal, VTThe pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…Aug 4, 2006 · N59BA · DestroyedNTSB NYC06FA034Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Burlington, VTThe pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…Nov 22, 2005 · N26399 · Substantial damageNTSB NYC04LA141Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK-21 · Warren, VTThe pilot's improper pre-flight and in-flight planning, which resulted in a forced landing after experiencing a loss of thermal lift. A factor was the loss of thermal lift.Jun 16, 2004 · N21VT · Substantial damageNTSB NYC04CA072Accident · No injuriesData collectionFinal reportCessna 172 · West Dover, VTThe pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.Feb 14, 2004 · N8880V · Substantial damageNTSB IAD02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Barre, VTThe pilot's failure to maintain airspeed during a go-around attempt, which resulted in an inadvertent stall and a subsequent impact with trees. A factor was the pilot's delayed initiation of the go-around.Jul 15, 2002 · N43860 · Substantial damageNTSB NYC01LA222Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Warren, VTThe pilot's improper fuel planning, which resulted in fuel exhaustion.Sep 2, 2001 · N7247Z · Substantial damageNTSB NYC00LA219Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Post Mills, VTwas the pilot's improper fuel management which resulted in power loss due to fuel starvation.Aug 5, 2000 · N73044 · Substantial damageNTSB IAD99LA024Accident · Serious injuriesLimited investigationFinal reportBell 47-G5 · Essex Junction, VTthe pilot's improper entry into the autorotation, which resulted in the loss of power and a low rotor rpm condition. Also causal was the pilot's improper execution of the autorotation which resulted in the hard landing. Factors in the accident were the…Dec 14, 1998 · N8103J · Substantial damageNTSB NYC97LA119Accident · Minor injuriesLimited investigationFinal reportEnstrom F-280C · Sharon, VTThe pilot's improper decision to descend and fly at 100 feet over a river and his failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with wires.Jun 13, 1997 · N5700J · Substantial damageNTSB IAD96LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · Stowe, VTfailure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.Jul 19, 1996 · N5091G · DestroyedNTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.Oct 19, 1995 · N36264 · Substantial damageNTSB NYC95LA161Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Warren, VTa failed elevator cable which resulted in an inflight loss of control and uncontrolled contact with trees.Jul 13, 1995 · N5204G · DestroyedNTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.Jun 10, 1995 · N10913 · 2 aircraft · 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 BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.Aug 28, 1994 · N720PC · Substantial damageNTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…Nov 26, 1993 · N4VG · DestroyedNTSB BFO93LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob Speed Astir II · Chester, VTThe pilot's inadequate inflight planning and an in flight encounter with a downdraft while on final approach.Jul 4, 1993 · N164SS · DestroyedNTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.Oct 13, 1991 · N898KG · Substantial damageNTSB NYC90FA054Accident · 3 fatalField investigationFinal reportCessna 310R · Burlington, VTFor an unknown reason, the aircraft entered a descent and crashed in a lake.Jan 16, 1990 · N5115J · DestroyedNTSB NYC89LA014Accident · Serious injuriesLimited investigationFinal reportLet L13 · Warren, VTPilot's improper supervision of flight, permitted the student to not maintain the proper airspeed and stall the glider and crash into the ground.Oct 17, 1988 · CFYSR · Substantial damageNTSB NYC89LA009Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Rutland, VTThe accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…Oct 9, 1988 · N9431R · DestroyedNTSB NYC85FA152Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-B · Waitsfield, VTThis glider was involved in a soaring championship course. About 52 minutes after starting the course witnesses observed the aircraft maneuvering for a landing on an open field. While in a steep bank the aircraft stalled and impacted the ground.Jun 19, 1985 · N240WT · DestroyedNTSB NYC84FA294Accident · 2 fatalField investigationFinal reportCessna 414 · Wallingford, VTThe plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…Aug 24, 1984 · N18SM · DestroyedNTSB NYC84FA042Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Bennington, VTThe acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is…Nov 29, 1983 · N2958R · DestroyedNTSB NYC84LA031Accident · No injuriesLimited investigationFinal reportBeech B23 · West Dover, VTThe plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still…Nov 18, 1983 · N7605R · Substantial damageNTSB NYC83LNC07Accident · Minor injuriesFinal reportBölkow B-1 · Groton, VTThe plt was on a x-country flt of aprx 100 miles. She reported that on the last leg of the flt, a lack of 'lift' was encountered & an off arpt landing was initiated. While on final apch to land in a field, the glider struck a telephone wire aprx 30 ft AGL.…Jun 22, 1983 · N911CW · Substantial damageNTSB NYC83FNC06Accident · No injuriesFinal reportGrumman AA-5A · Warren, VTThe plt reported that during a landing on rwy 4, he encountered wind shear which forced the acft to lose alt & touch down short of the rwy. The acft then veered left & collided with a hangar. The plt reported the wind was from 300 deg at 12 gusting 18 KTS.…Jun 2, 1983 · CGAEX · Substantial damageNTSB NYC82DA145Accident · No injuriesFinal reportPiper PA-23-250 · Ludlow, VTThe pilot stated that during the landing, he encountered wind shear and the aircraft touched down about two feet short of the runway. He reported a 30 degree slope at the lip of the runway. All of the landing gear failed. The aircraft slid off the runway and…Jul 4, 1982 · N5343Y · Substantial damageNTSB NYC82FA134Accident · No injuriesField investigationFinal reportPiper PA-31 · Bennington, VTWhile on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine…Jun 28, 1982 · N620WF · Substantial damageNTSB NYC82DA023Accident · No injuriesFinal reportCessna 150M · Swanton, VTDuring the initial takeoff, the pilot noted a partial loss of engine power at about 200 ft AGL. Carburetor heat was applied and power was restored. He flew the traffic pattern and landed, and then he made another preflight inspection and a full run-up. During…Jan 16, 1982 · N704KE · Substantial damageNTSB NYC80FA049Accident · 2 fatalClosedCessna 210H · Lyndonville, VTJul 2, 1980 · N2229R · DestroyedNTSB NYC80DNC06Accident · No injuriesClosed0berlerchne MG23SL · Roxbury, VTOct 8, 1979 · N1156Q · Substantial damageNTSB NYC79FNC25Accident · Minor injuriesClosedBellanca 7GCBC · St.Albans, VTApr 28, 1979 · N5034K · Substantial damageNTSB NYC79FA029Accident · 4 fatalClosedPiper PA-31 · Springfield, VTMar 10, 1979 · N27530 · Substantial damageNTSB NYC78FNC45Accident · No injuriesClosedPiper PA-30 · Warren, VTAug 21, 1978 · N8419Y · Substantial damageNTSB NYC78DNC40Accident · No injuriesClosedCessna 185 · St Albans, VTJul 21, 1978 · N22901 · Substantial damageNTSB NYC78FA040Accident · 2 fatalClosedPiper PA-30 · Montpelier, VTApr 7, 1978 · N8559Y · DestroyedNTSB NYC78DNC20Accident · No injuriesClosedCessna 206 · Warren, VTFeb 25, 1978 · N3972G · Substantial damageNTSB NYC78FA001Accident · 4 fatalClosedMooney M20J · Morristown, VTOct 26, 1977 · N201GT · Substantial damage