NTSB investigations, VT
7 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 3 |
| 2002 | 1 |
Where
Latest 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340)
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" = 340) 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 IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindNTSB NYC87LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vergennes, VTDuring a landing attempt at basin harbor airport, the pilot came in high and fast. He did not correct and failed to go around. He overran the runway and crashed into a ditch causing substantial damage to the aircraft. The plt did not file an acc report.NTSB NYC87DNC11Accident · No injuriesFinal reportBeech C23 · Vergennes, VTThe pilot of the Beech C23 had taken off and was returning to the airport due to deteriorating weather conditions. The pilot attempted to land on runway 20, but made a go around because of gusty winds. On the second attempt to land on the same runway, the…NTSB NYC87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Rutland, VTDrg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was…NTSB NYC87DNC03Accident · No injuriesFinal reportAero Commander 680 · Barre, VTWitness observed the acft touchdown about 2000 feet down 5001 foot rwy. The rwy was reported wet and icy in spots at the north end only. The acft overran the rwys end and went down into a ravine about 25 ft below rwy level. There was no indication of…NTSB NYC86LA202Accident · Minor injuriesLimited investigationFinal reportLearjet 55 · Rutland, VTThe lear 55 taxied out for takeoff and inadvertently attempted a takeoff on the wrong runway. When he realized his mistake, he aborted the takeoff because he knew the runway length was significently less than his required field length. Insufficient runway…NTSB NYC82DA129Accident · No injuriesFinal reportI.C.A. Brasov IS-28B2 · Warren, VTThe pilot had little or no previous flight time in this romanian built glider. He reported departing from an airport located on the lee side of the sugarbush mountains. He stated that a strong west wind produced a turbulent rotor near the airport and the…