NTSB investigations, VT
12 cases where NTSB found Action.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2017 | 1 |
| 2023 | 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\", '020410'))
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", '020410')) 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 ERA24LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-39 · Highgate, VTThe pilot’s inadvertent retraction of the landing gear during landing rollout, which resulted in a landing gear collapse.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 ERA15LA022Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warren, VTThe glider pilot’s failure to avoid the tow plane after the aborted takeoff due to both pilots’ failure to review the aborted takeoff procedure before the flight, which led to both pilots turning right after the aborted takeoff.NTSB ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.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 ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.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 ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.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.