Fatal NTSB investigations, VT
9 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1999 | 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 240)
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."highestInjuryLevel" = 'Fatal' 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" = 240) 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 NYC99FA199Accident · 3 fatalField investigationFinal reportCessna P210N · Worcester, VTThe pilot's inadequate in-flight planning/decision, his failure to follow the published instrument departure procedure for the particular runway, and his continued flight into known adverse weather. A factor was thunderstorms.NTSB BFO93FA030Accident · 1 fatalField investigationFinal reportAmerican General AG5B · Vergennes, VTVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…NTSB NYC90FA225Accident · 4 fatalField investigationFinal reportPiper PA-30 · Berlin, VTThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and…NTSB NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB NYC87FA063Accident · 1 fatalField investigationFinal reportMooney M20C · Highgate, VTAccording to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…NTSB NYC87FA025Accident · 1 fatalField investigationFinal reportBell 206B · Brattleboro, VTThe helicopter crashed into a wooded ridge aprx 2 NM from it's liftoff location. Persons who reside under the flt path were awakened by the acft as it was descending into IMC at what sounded like full power. The plt's heliport was at an elevation of 950 ft…NTSB NYC85FA227Accident · 2 fatalField investigationFinal reportCessna 150M · Danby, VTThe pilot of N66190 received a weather briefing from lebanon flight service station and was advised of low ceilings and also advised that visual flight rules flight was not recommended. At about the time N66190 was departing rutland, Vermont, a helicopter…NTSB NYC85FA083Accident · 1 fatalField investigationFinal reportCessna 401A · Dorset, VTThe plt was about 30 miles from rutland when he radioed the arpt for weather info. He was informed that clouds were 1500 ft broken and 2700 ft overcast with snow, light fog and 5 miles visibility. The plt responded that he would call again when he got closer…NTSB NYC82FA176Accident · 1 fatalField investigationFinal reportCessna 150L · West Brattlebor, VTAt 2036 the plt contacted bradley approach control (a/c) on freq 121.5 & stated he was lost, at an altitude of 4,000 ft & in "almost IFR weather." Since the acft was not transponder equipped a/c had the plt use VOR orientation procedures to determine his…