NTSB investigations, VT
32 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 6 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
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.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA26LA277Accident · No injuriesClass 4 · LimitedFinal reportRans S-6-S · Morgan, VTThe pilot’s failure to maintain control of the airplane during takeoff, resulting in an aerodynamic stall and impact with water.NTSB ERA25LA130Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Manchester, VTThe 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 CEN23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Burlington, VTThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and the flight instructor’s delayed remedial action.NTSB ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.NTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.NTSB ERA20CA159Accident · No injuriesData collectionFinal reportAeronca 7AC · Enosburg, VTThe pilot's improper decision to land on unsuitable terrain, which resulted in a nose-over.NTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.NTSB GAA18CA510Accident · No injuriesData collectionFinal reportMaule MX7 · Post Mills, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.NTSB GAA18CA392Accident · No injuriesData collectionFinal reportSchempp Hirth Discus CS · Pomfret, VTThe glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.NTSB ERA18FA148Accident · 1 fatalField investigationFinal reportPiper PA34 · Bennington, VTThe 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 GAA18CA283Accident · No injuriesData collectionFinal reportSchweizer SGS123 · Tunbridge, VTThe student glider’s inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB 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.NTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB 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.NTSB GAA17CA298Accident · No injuriesData collectionFinal reportSchweizer SGS233 · Springfield, VTThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway in trees.NTSB GAA16CA495Accident · No injuriesData collectionFinal reportPiper PA 11 · Grand Isle, VTThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during a simulated engine failure and forced landing with a tailwind, which resulted in an aerodynamic stall.NTSB GAA16CA388Accident · No injuriesData collectionFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer · Island Pond, VTThe pilot's exceedance of the airplane's critical angle-of-attack during approach, resulting in an inadvertent stall and hard landing.NTSB ERA16CA128Accident · Serious injuriesData collectionFinal reportCessna 180 · South Burlington, VTThe pilot's failure to maintain airplane control during takeoff roll, which resulted in a nose over.NTSB ERA15LA381Accident · No injuriesLimited investigationFinal reportBrown James W Zenith Stol CH 750 · Charlotte, VTThe pilot’s inadequate compensation for a crosswind during landing, which resulted in a side load application to the nose landing gear and its subsequent collapse.NTSB GAA15CA084Accident · No injuriesData collectionFinal reportFaunce PA-11 · Morrisville, VTThe pilot's failure to maintain directional control during the landing roll and his deliberate application of excessive braking pressure.NTSB ERA15CA037Accident · No injuriesData collectionFinal reportAviat S 2C · Rutland, VTThe pilot's failure to maintain directional control during landing rollout in gusty crosswind conditions, which resulted in a ground loop and subsequent substantial damage to the airplane.NTSB ERA13LA397Accident · Serious injuriesLimited investigationFinal reportAeronca 65CA · Hardwick, VTThe improper maintenance of the carburetor, which resulted in a total loss of engine power due to carburetor flooding.NTSB ERA13LA311Accident · No injuriesLimited investigationFinal reportCessna 172M · Burlington, VTThe pilot's improper turn down an airport access road while attempting to taxi to a runway. Contributing to the accident was the airport management's failure to install proper signage indicating that an airport access road was prohibited to aircraft.NTSB ERA13CA100Accident · No injuriesData collectionFinal reportRaytheon A36 · Rutland, VTThe pilot's failure to maintain control of the airplane while maneuvering on a snow-packed surface after landing, which resulted in a collision with a fuel truck.NTSB ERA12CA342Accident · No injuriesData collectionFinal reportPiper PA46 · Springfield, VTThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ERA12CA222Accident · Minor injuriesData collectionFinal reportCessna 172N · Orleans, VTThe pilot’s failure to maintain clearance from a power line while conducting low-altitude flight.NTSB ERA12CA162Accident · No injuriesData collectionFinal reportCessna 172L · Grand Isle, VTThe pilot's inability to stop the airplane on a grass runway with undetected ice.NTSB 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.NTSB 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.NTSB ERA10LA238Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Newfane, VTThe pilot's inadvertent encounter with a rope while maneuvering during powerline operations for undetermined reasons.NTSB 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.NTSB NYC08CA217Accident · Minor injuriesData collectionFinal reportSchleicher ASW-27B · Warren, VTThe pilot's delayed decision to divert to a suitable landing area.