# NTSB investigations, VT: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 3 · 116 cases

## Latest cases

- [NTSB ERA25LA130](https://openairdocs.org/ntsb/ERA25LA130.md): Piper PA-28-235 · Manchester, VT · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 26, 2025 · N43DN · Substantial damage
  > The pilot’s improper decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall/spin.
- [NTSB ERA21LA309](https://openairdocs.org/ntsb/ERA21LA309.md): Enstrom 280 · Colchester, VT · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 30, 2021 · N36DK · Destroyed
  > An in-flight fire originating in the engine compartment near the turbocharger from a source that could not be determined, which resulted in a loss of engine power and led to an autorotation and a hard landing.
- [NTSB GAA18CA392](https://openairdocs.org/ntsb/GAA18CA392.md): Schempp Hirth Discus CS · Pomfret, VT · Accident · No injuries · Data collection · Final report · Jul 3, 2018 · N1122Q · Substantial damage
  > The glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.
- [NTSB ERA18FA148](https://openairdocs.org/ntsb/ERA18FA148.md): Piper PA34 · Bennington, VT · Accident · 1 fatal · Field investigation · Final report · May 20, 2018 · N1101X · Destroyed
  > The pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.
- [NTSB GAA18CA283](https://openairdocs.org/ntsb/GAA18CA283.md): Schweizer SGS123 · Tunbridge, VT · Accident · No injuries · Data collection · Final report · May 13, 2018 · N9915J · Substantial damage
  > The student glider’s inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.
- [NTSB CEN18FA037](https://openairdocs.org/ntsb/CEN18FA037.md): Cessna 172G · Pittsford, VT · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2017 · N4676L · Destroyed
  > The pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB ERA14IA249](https://openairdocs.org/ntsb/ERA14IA249.md): Embraer EMB-110P1 · Warren, VT · Incident · No injuries · Incident investigation · Final report · May 21, 2014 · N116WA · Minor damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA14LA202](https://openairdocs.org/ntsb/ERA14LA202.md): Oconnor Paul A Ultimate Aero 10-200 · Saint Albans, VT · Accident · No injuries · Limited investigation · Final report · Apr 18, 2014 · N827D · Destroyed
  > The propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.
- [NTSB ERA13CA427](https://openairdocs.org/ntsb/ERA13CA427.md): Cessna 182E · Middletown Springs, VT · Accident · Minor injuries · Data collection · Final report · Sep 21, 2013 · N3152Y · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB NYC07CA186](https://openairdocs.org/ntsb/NYC07CA186.md): Schempp-Hirth Ventus-2C · Greensboro, VT · Accident · No injuries · Data collection · Final report · Aug 4, 2007 · N60LK · Substantial damage
  > The pilot's delayed decision to divert to a suitable landing area. Contributing to the accident was the uneven terrain of the forced landing site.
- [NTSB NYC06CA017](https://openairdocs.org/ntsb/NYC06CA017.md): Cessna 150L · Shelburne, VT · Accident · No injuries · Data collection · Final report · Oct 21, 2005 · N1693Q · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB IAD05LA085](https://openairdocs.org/ntsb/IAD05LA085.md): Martel Air Command 532Elite · Highgate, VT · Accident · 1 fatal · Limited investigation · Final report · Jun 26, 2005 · UNREG · Substantial damage
  > The pilot's improper cyclic input, which resulted in a retreating rotor blade stall, and its subsequent impact with the propeller. Also causal, was the pilot's failure to acquire proper training. A factor was the pilot's decision not to have a stability…
- [NTSB NYC02FA051](https://openairdocs.org/ntsb/NYC02FA051.md): Smith Aerostar 601P · Chittenden, VT · Accident · 2 fatal · Field investigation · Final report · Jan 25, 2002 · N104CS · Destroyed
  > The pilot's failure to maintain aircraft control while holding.
- [NTSB NYC00LA069](https://openairdocs.org/ntsb/NYC00LA069.md): Mooney M20M · Montpelier, VT · Accident · No injuries · Limited investigation · Final report · Jan 21, 2000 · N223KT · Substantial damage
  > A blocked crankcase breather line due to ice and improper maintenance which resulted in further restricting the line. A factor in this accident was the below freezing outside air temperature.
- [NTSB NYC99FA199](https://openairdocs.org/ntsb/NYC99FA199.md): Cessna P210N · Worcester, VT · Accident · 3 fatal · Field investigation · Final report · Aug 14, 1999 · N24CD · Destroyed
  > The pilot's inadequate in-flight planning/decision, his failure to follow the published instrument departure procedure for the particular runway, and his continued flight into known adverse weather. A factor was thunderstorms.
- [NTSB NYC98LA182](https://openairdocs.org/ntsb/NYC98LA182.md): Piper J3L-65 · Morristown, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1998 · N26712 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB NYC98LA132](https://openairdocs.org/ntsb/NYC98LA132.md): Extra Flugzeugbau Flugzeugbau EA260 · Georgia, VT · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1998 · N148GC · Destroyed
  > The pilot's inadequate inflight decision and the loss of engine power due to a blocked vent line. A contributing factor was an unreliable fuel gauge.
- [NTSB IAD98LA030](https://openairdocs.org/ntsb/IAD98LA030.md): Cessna 172 · Rutland, VT · Accident · No injuries · Limited investigation · Final report · Feb 26, 1998 · N5593E · Substantial damage
  > the pilot's improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: unfavorable (headwind) conditions, and brush/small trees in the forced landing area.
- [NTSB NYC97FA185](https://openairdocs.org/ntsb/NYC97FA185.md): Piper PA-28R-200 · Glastenbury, VT · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1997 · CGHUE · Destroyed
  > the pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.
- [NTSB NYC97LA127](https://openairdocs.org/ntsb/NYC97LA127.md): Eiriavion PIK-20E · Rochester, VT · Accident · No injuries · Limited investigation · Final report · Jun 23, 1997 · N1043G · Substantial damage
  > The pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.
- [NTSB NYC96FA023](https://openairdocs.org/ntsb/NYC96FA023.md): Piper PA-24-180 · Hartford, VT · Accident · 3 fatal · Field investigation · Final report · Nov 9, 1995 · N7734P · Destroyed
  > the pilot's inadequate preflight planning/preparation, his inadequate removal of airframe ice, and his failure to maintain adequate airspeed, which resulted in a stall/spin and an inflight collision with terrain. Factors relating to the accident were: the…
- [NTSB NYC95LA228](https://openairdocs.org/ntsb/NYC95LA228.md): Cessna 150M · Rutland, VT · Accident · No injuries · Limited investigation · Final report · Sep 28, 1995 · N9289U · Substantial damage
  > the loss of engine power for an undetermined reason.
- [NTSB NYC95FA129](https://openairdocs.org/ntsb/NYC95FA129.md): Cessna T210N · Monkton, VT · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1995 · N4602U · Destroyed
  > failure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.
- [NTSB NYC95LA067](https://openairdocs.org/ntsb/NYC95LA067.md): Cessna 180J · West Dover, VT · Accident · No injuries · Limited investigation · Final report · Mar 3, 1995 · N180BF · Substantial damage
  > A loss of power for undetermined reasons. The frozen snow covered terrain was a factor.
- [NTSB BFO94LA087](https://openairdocs.org/ntsb/BFO94LA087.md): WSK PZL Krosno KR-03A · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Jun 3, 1994 · N4194D · Destroyed
  > The pilot's premature release from the tow plane. The lack of lift and the downdraft were factors.
- [NTSB BFO94LA003](https://openairdocs.org/ntsb/BFO94LA003.md): Schweizer SGS 2-33A · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Nov 7, 1993 · N1178S · Substantial damage
  > The pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.
- [NTSB BFO93LA163](https://openairdocs.org/ntsb/BFO93LA163.md): Piper PA-28-161 · Stowe, VT · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1993 · N6911C · Destroyed
  > The pilot's improper in-flight planning/decision. A related factor in the accident was: the partial loss of engine power for an undetermined reason.
- [NTSB NYC93LA155](https://openairdocs.org/ntsb/NYC93LA155.md): Cessna 150G · Lyndonville, VT · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1993 · N2807S · Substantial damage
  > An inadvertent stall of the airplane as a result of the pilot's failure to maintain adequate airspeed and improper use of the carburetor heat and flaps during takeoff which degraded aircraft performance.
- [NTSB BFO93FA030](https://openairdocs.org/ntsb/BFO93FA030.md): American General AG5B · Vergennes, VT · Accident · 1 fatal · Field investigation · Final report · Feb 18, 1993 · N1192Z · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…
- [NTSB BFO92LA056](https://openairdocs.org/ntsb/BFO92LA056.md): Cessna 150 · Warren, VT · Accident · No injuries · Limited investigation · Final report · May 10, 1992 · N27395 · Substantial damage
  > The pilot's failure to select a safe altitude for flight in mountainous terrain. The downdraft was a factor.
- [NTSB NYC92LA019](https://openairdocs.org/ntsb/NYC92LA019.md): Piper J3C-65 · Manchester, VT · Accident · No injuries · Limited investigation · Final report · Oct 26, 1991 · N70548 · Substantial damage
  > The pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.
- [NTSB NYC91FA239](https://openairdocs.org/ntsb/NYC91FA239.md): Convair CV-580 · Belvedere Ctr, VT · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1991 · CFICA · Destroyed
  > Failure of the first officer (co-pilot) to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: the lack of two pilots in the cockpit,…
- [NTSB NYC91LA061](https://openairdocs.org/ntsb/NYC91LA061.md): Piper PA-28R-200 · Sherburne, VT · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1991 · N777CL · Destroyed
  > The pilots intentional flight into icing conditions with an airplane not equipped for flight in known icing conditions. This resulted in an uncontrolled descent and contact with trees in instrument meteorological conditions. Factors related to the accident…
- [NTSB NYC90FA225](https://openairdocs.org/ntsb/NYC90FA225.md): Piper PA-30 · Berlin, VT · Accident · 4 fatal · Field investigation · Final report · Sep 22, 1990 · CFSKO · Destroyed
  > The non-instrument rated pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and…
- [NTSB NYC89LA209](https://openairdocs.org/ntsb/NYC89LA209.md): Cessna 210 · No. Windham, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1989 · N2054S · Destroyed
  > The pilot's failure to assure an adequate supply of fuel was available.
- [NTSB NYC89FA135](https://openairdocs.org/ntsb/NYC89FA135.md): Cessna 172M · Bradford, VT · Accident · 2 fatal · Field investigation · Final report · May 21, 1989 · N1272U · 2 aircraft · Minor damage
  > Failure of the rated pilots in both aircraft to see and avoid a midair collison.
- [NTSB NYC89IA084](https://openairdocs.org/ntsb/NYC89IA084.md): Beech 200 · Burlington, VT · Incident · No injuries · Incident investigation · Final report · Feb 15, 1989 · N123D · No damage
  > Improper preflight which resulted in a frozen elevator surface.
- [NTSB NYC88LA198](https://openairdocs.org/ntsb/NYC88LA198.md): Lake LA-4-200 · Montpelier, VT · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 1988 · N2883P · Substantial damage
  > Engine power loss due to fuel contamination of water and rust particles in fuel system.
- [NTSB NYC88FA147](https://openairdocs.org/ntsb/NYC88FA147.md): Lake LA4-250 · Shaftsbury, VT · Accident · 1 fatal · Field investigation · Final report · May 29, 1988 · N1405F · Destroyed
  > The Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…
- [NTSB NYC88FA062](https://openairdocs.org/ntsb/NYC88FA062.md): Piper PA-32RT-300 · Burlington, VT · Accident · 4 fatal · Field investigation · Final report · Dec 31, 1987 · N2243J · Destroyed
  > Drg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…
- [NTSB NYC88FA042](https://openairdocs.org/ntsb/NYC88FA042.md): Mooney M20K · Danby, VT · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1987 · N252ZF · Destroyed
  > The pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose…
- [NTSB NYC87LA268](https://openairdocs.org/ntsb/NYC87LA268.md): Piper PA-28 · Plymouth, VT · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N302RB · Destroyed
  > While cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped…
- [NTSB NYC87FA063](https://openairdocs.org/ntsb/NYC87FA063.md): Mooney M20C · Highgate, VT · Accident · 1 fatal · Field investigation · Final report · Jan 20, 1987 · N3496X · Destroyed
  > According to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…
- [NTSB NYC87FA025](https://openairdocs.org/ntsb/NYC87FA025.md): Bell 206B · Brattleboro, VT · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1986 · N52EG · Destroyed
  > The helicopter crashed into a wooded ridge aprx 2 NM from it's liftoff location. Persons who reside under the flt path were awakened by the acft as it was descending into IMC at what sounded like full power. The plt's heliport was at an elevation of 950 ft…
- [NTSB NYC86FA201](https://openairdocs.org/ntsb/NYC86FA201.md): Aero Commander 680FL · Duxsbury, VT · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1986 · N6341U · Destroyed
  > The plt was on a VFR flight from montpelier, VT to burlington, VT; a distance of about 80 mis. A mountain range is between the two location. Shortly after takeoff the plt radioed burlington approach control and requested an IFR clearance to land at…
- [NTSB NYC85FA227](https://openairdocs.org/ntsb/NYC85FA227.md): Cessna 150M · Danby, VT · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1985 · N66190 · Destroyed
  > The pilot of N66190 received a weather briefing from lebanon flight service station and was advised of low ceilings and also advised that visual flight rules flight was not recommended. At about the time N66190 was departing rutland, Vermont, a helicopter…
- [NTSB NYC85LA186](https://openairdocs.org/ntsb/NYC85LA186.md): Piper PA-18-95 · Stowe, VT · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N5777D · Substantial damage
  > During cruise flt, the plt heard a loud knocking coming from the eng and a decrease in oil pressure. During the landing in a fld, the landing gear collapsed and the acft ground looped. Examination of the eng disclosed that the hydraulic lifters of three of…
- [NTSB NYC85FNC04](https://openairdocs.org/ntsb/NYC85FNC04.md): Bell 206B · W. Brattleboro, VT · Accident · Serious injuries · Final report · May 30, 1985 · N23LV · Destroyed
  > The acft lost pwr during normal cruise. The plt attempted to autorotate into a clearing in the trees. Post accident exam discovered an air leak in the fuel control. The pressure compressor discharge (pcd) line 'b' nut was disconnected from the fuel control.…
- [NTSB NYC85FA088](https://openairdocs.org/ntsb/NYC85FA088.md): Lake LA-4-200 · Swanton, VT · Accident · Serious injuries · Field investigation · Final report · Mar 25, 1985 · N6024V · Destroyed
  > During normal cruise flt the plt became unable to move the elevator control. The flt was continued to the planned destination using elevator trim for pitch control. On final approach to the rwy the acft was caught by a wind gust & pitched nose down. The plt…
- [NTSB NYC85FA083](https://openairdocs.org/ntsb/NYC85FA083.md): Cessna 401A · Dorset, VT · Accident · 1 fatal · Field investigation · Final report · Mar 18, 1985 · N12CQ · Destroyed
  > The plt was about 30 miles from rutland when he radioed the arpt for weather info. He was informed that clouds were 1500 ft broken and 2700 ft overcast with snow, light fog and 5 miles visibility. The plt responded that he would call again when he got closer…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=VT&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=VT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.