NTSB investigations, VT
10 cases where NTSB found Info processing/decision.
Cases per year
| 2012 | 1 |
|---|---|
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 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\", '020415'))
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", '020415')) 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 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 ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.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 ERA18FA238Accident · 3 fatalField investigationFinal reportSchweizer SGS 2 32 · Morrisville, VTThe pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…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 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 ERA17FA072Accident · 1 fatalField investigationFinal reportPiper PA28 · Middlebury, VTThe pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…NTSB ERA12CA222Accident · Minor injuriesData collectionFinal reportCessna 172N · Orleans, VTThe pilot’s failure to maintain clearance from a power line while conducting low-altitude flight.