OpenAirDocs.org

Fatal NTSB investigations, VT

7 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19842026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
  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 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 NYC99FA007Accident · 2 fatalField investigationFinal reportCessna 172G · Bennington, VTThe pilot's VFR flight into IMC. Contributing factors were the pilot's lack of recent experience, mountainous/hilly terrain, and clouds.Oct 12, 1998 · N1330F · DestroyedNTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.Oct 31, 1991 · N8855J · DestroyedNTSB NYC86FA201Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Duxsbury, VTThe 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…Aug 8, 1986 · N6341U · DestroyedNTSB NYC86FNC04Accident · 1 fatalFinal reportRolladen-Schneider LS-4A · Rochester, VTThe pilot was participating in a x-country soaring race. Aprox 15 miles from destination and for unknown reasons, the pilot experienced in flight collision with terrain. There was no evidence of pre-impact malfunction or failure. The pilot was certificated…Jun 22, 1986 · N430RH · Substantial damageNTSB 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 · Destroyed