Skip to content

NTSB investigations, VT

18 cases where the first occurrence was “Loss of control - on ground/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)
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 IAD02LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Rutland, VTThe pilot's failure to maintain directional control during the takeoff attempt.Jun 21, 2002 · N739RS · Substantial damage NTSB NYC02LA079Accident · Serious injuriesLimited investigationFinal reportMaule M-5-180C · Bennington, VTThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.Mar 31, 2002 · N711JR · Substantial damage NTSB NYC01LA230Accident · No injuriesLimited investigationFinal reportCarver RAF 2000 GTX SE · Barre, VTThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident were wind gusts.Sep 22, 2001 · N90407 · Substantial damage NTSB NYC99LA135Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Bennington, VTThe pilot's inadequate pre-flight briefing which resulted in control interference by the right front seat passenger.May 29, 1999 · N126MC · Substantial damage NTSB BFO94LA114Accident · No injuriesLimited investigationFinal reportCessna 150 · Swanton, VTThe student pilot's failure to maintain directional control.Jun 24, 1994 · N714CX · Substantial damage NTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.Jan 23, 1994 · N8211V · Substantial damage NTSB NYC93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Dover, VTThe pilot's failure to maintain directional control during takeoff, and his inadequate remedial actions, resulting in a collision with a snowbank. Factors related to the accident were the ice covered runway and the snowbank along the runway edges.Jan 29, 1993 · N40586 · Substantial damage NTSB NYC91LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Vergennes, VTThe pilot's excessive taxi speed, resulted in an on ground loss of control.May 21, 1991 · N9163Z · Substantial damage NTSB NYC90LA003Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennington, VTFailure of the student pilot to maintain directional control during landing. Contributing factor(s) was: the crosswind.Oct 1, 1989 · N20017 · Substantial damage NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.May 1, 1989 · N45981 · Substantial damage NTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…Feb 28, 1988 · N97979 · Substantial damage NTSB NYC86LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, VTThe plt lost directional control of the acft during takeoff run. The acft traveled off the side of the rwy into tall grass and nosed over. The plt stated that he may have pressed the brake pedal inadvertently instead of the rudder.Aug 12, 1986 · N6455G · Substantial damage NTSB NYC86LA246Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Snow, VTPilot lost directional control on landing when he came in long and fast. The aircraft ran off the end of the runway, collided with shrubbery and was destroyed. The plt did not file an acc report.Aug 10, 1986 · N43982 · Destroyed NTSB NYC85LA220Accident · No injuriesLimited investigationFinal reportCessna 170B · Morrisville, VTAccording to the plt, a post maintenance test flt was performed about 45 mins before the landing occurred. The plt stated that he allowed the right seat passenger a student plt and owner of the Cessna 170, to fly and land the acft. Upon landing the plt…Aug 24, 1985 · N3568C · Substantial damage NTSB NYC85LA046Accident · No injuriesLimited investigationFinal reportCessna 140 · Burlington, VTThe acft skidded & veered left during the landing roll, & subsequently, it nosed over on the rwy.Dec 21, 1984 · N77110 · Substantial damage NTSB NYC84LA156Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Vultee L-13A · Dummerston, VTDuring arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the…May 2, 1984 · N90426 · Substantial damage NTSB NYC83LA181Accident · No injuriesLimited investigationFinal reportCessna 140 · Londonderry, VTThe plt reported that during a landing on rwy 23, the acft difted off the rwy when he did not allow for a x-wind. A go-around was initiated. However, the landing gear contacted a mound of dirt & the acft nosed over while it was at full throttle. Reportedly,…Jul 16, 1983 · N3644V · Substantial damage NTSB NYC82DA146Accident · No injuriesFinal reportCessna 305A · Morrisville, VTThe pilot reported that he landed on runway 19 with a wind from 250 deg at 15, gusting 20 knots. He reported that as the aircraft rolled out, a severe gust of wind was encountered that put the plane on the left gear only. Subsequently, the left gear failed…Jul 9, 1982 · N22SU · Substantial damage