NTSB investigations, VT
32 cases where NTSB found Task performance.
Cases per year
| 2010 | 1 |
|---|---|
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 6 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 2 |
| 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\", '0206'))
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", '0206')) 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 ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.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 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 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 ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.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 ERA17LA312Accident · No injuriesLimited investigationFinal reportPiper PA28 · Lyndonville, VTThe pilot's loss of airplane control during takeoff.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 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 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 ERA14IA249Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Warren, VTThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA13CA427Accident · Minor injuriesData collectionFinal reportCessna 182E · Middletown Springs, VTThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.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 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.