NTSB investigations, VT
33 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2010 | 2 |
|---|---|
| 2012 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 8 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\", '0106'))
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", '0106')) 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 ERA26LA260Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Highgate, VTThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA25LA241Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Burlington, VTThe pilot’s failure to maintain control of the airplane on landing.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…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 ERA22LA393Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Bennington, VTThe pilot’s failure to maintain airspeed during a go-around, resulting in an aerodynamic stall, loss of control, and collision with terrain.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 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 ERA20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 170 · Morrisville, VTThe pilot's failure to maintain directional control and subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall and collision with terrain.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 GAA19CA577Accident · No injuriesData collectionFinal reportPitts S2 · Morrisville, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose down.NTSB GAA18CA543Accident · No injuriesData collectionFinal reportBosko Wr/Bosko Ce Safari · Highgate, VTThe student pilot’s failure to maintain lateral control during a hover.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 ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.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 GAA18CA547Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, VTThe student pilot’s improper landing flare, which resulted in a bounced landing.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 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 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 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 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 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 ERA10LA405Accident · No injuriesLimited investigationFinal reportGlines Sportsman GS-2 · Morrisville, VTThe pilot's improper flare during a forced landing. Contributing to the accident was a loss of fuel pressure for undetermined reasons.NTSB ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.