Skip to content

Fatal NTSB investigations, VT

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
  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'
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 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…Aug 1, 1982 · N17135 · Destroyed NTSB NYC80FA049Accident · 2 fatalClosedCessna 210H · Lyndonville, VTJul 2, 1980 · N2229R · Destroyed NTSB DEN80FA017Accident · 1 fatalClosedPiper PA-18 · Kelton, VTJan 19, 1980 · N3351A · Substantial damage NTSB NYC80FA011Accident · 3 fatalClosedCessna 337G · Bennington, VTNov 17, 1979 · N53560 · Destroyed NTSB NYC79FA105Accident · 3 fatalClosedBeech 35C33A · Warren, VTSep 24, 1979 · N1984S · Destroyed NTSB NYC79FA029Accident · 4 fatalClosedPiper PA-31 · Springfield, VTMar 10, 1979 · N27530 · Substantial damage NTSB NYC79FA006Accident · 1 fatalClosedPiper PA-38 · West Townshend, VTOct 28, 1978 · N9372T · Destroyed NTSB NYC78FA040Accident · 2 fatalClosedPiper PA-30 · Montpelier, VTApr 7, 1978 · N8559Y · Destroyed NTSB NYC78FA033Accident · 2 fatalClosedPiper PA-28 · Sandgate, VTMar 15, 1978 · N9006K · Destroyed NTSB NYC78FA007Accident · 3 fatalClosedCessna 180 · Jay, VTNov 6, 1977 · N9298C · Destroyed NTSB NYC78FA001Accident · 4 fatalClosedMooney M20J · Morristown, VTOct 26, 1977 · N201GT · Substantial damage NTSB NYC77FA067Accident · 2 fatalClosedPiper PA-24 · Windham, VTJul 4, 1977 · N5039P · Destroyed NTSB NYC77FA015Accident · 1 fatalClosedCessna 150L · Sherburne, VTNov 23, 1976 · N5376Q · Destroyed NTSB NYC76AN108Accident · 2 fatalClosedLuscombe 8A · Plainfield, VTJul 5, 1976 · N1083K · Destroyed NTSB NYC76AM093Accident · 2 fatalClosedCessna 310 · Rutland, VTApr 26, 1976 · N7696Q · Destroyed NTSB NYC76FNC37Accident · 1 fatalClosedBellanca 14-19 · Ludlow, VTMar 30, 1976 · N7668B · Destroyed NTSB NYC76AN077Accident · 3 fatalClosedCessna 172K · Burlington, VTFeb 11, 1976 · N79285 · Substantial damage NTSB NYC76AN074Accident · 2 fatalClosedPiper PA-23 · S Burlington, VTFeb 4, 1976 · N65TM · Destroyed NTSB NYC76AN047Accident · 1 fatalClosedStinson 108-2 · Bellows Falls, VTOct 29, 1975 · N9464K · Destroyed NTSB NYC75AN020Accident · 4 fatalClosedBeech 35-A33 · Bennington, VTAug 17, 1974 · N385Z · Destroyed NTSB NYC74AN088Accident · 4 fatalClosedMooney M20C · Dorset, VTApr 15, 1974 · N78990 · Destroyed NTSB NYC74AN044Accident · 3 fatalClosedPiper PA-28 · Manchester, VTNov 18, 1973 · N9DC · Destroyed NTSB NYC73AN116Accident · 2 fatalClosedCessna 310J · Londonderry, VTFeb 22, 1973 · N3149L · Destroyed NTSB NYC73AN083Accident · 4 fatalClosedCessna 411 · Winooski, VTDec 15, 1972 · N111DS · Destroyed NTSB NYC73AN079Accident · 1 fatalClosedCessna 172K · Bennington, VTDec 12, 1972 · N46717 · Destroyed NTSB NYC72AN100Accident · 2 fatalClosedPiper PA-23 · Dorset, VTFeb 22, 1972 · N13912 · Substantial damage NTSB NYC72AN093Accident · 3 fatalClosedBeech B95 · Mt Tabor, VTFeb 5, 1972 · N283AA · Substantial damage NTSB NYC71FNC27Accident · 1 fatalClosedCherokee II · Springfield, VTApr 24, 1971 · N8722E · Destroyed NTSB NYC71AN085Accident · 5 fatalClosedAero Comdr 1121A · South Burlington, VTJan 27, 1971 · N400CP · Destroyed NTSB NYC71AN080Accident · 5 fatalClosedPiper PA-32 · Shrewsbury, VTJan 15, 1971 · N4850S · Destroyed NTSB NYC70A0038Accident · 5 fatalClosedPiper PA-23 · Warren, VTSep 28, 1969 · N6602Y · Destroyed NTSB NYC70A0012Accident · 1 fatalClosedCessna 206 · Springfield, VTJul 26, 1969 · N5269U · Destroyed NTSB NYC68A0118Accident · 2 fatalClosedPiper PA-28 · Westfield, VTMay 10, 1968 · N4931J · Destroyed NTSB NYC68A0107Accident · 7 fatalClosedBeech G18S · Weston, VTMar 19, 1968 · N172S · Destroyed NTSB NYC68A0064Accident · 4 fatalClosedPiper PA-28 · Richford, VTOct 22, 1967 · N9737J · Destroyed NTSB NYC68A0037Accident · 1 fatalClosedPiper PA-28 · Waitsfield, VTAug 26, 1967 · N6494W · Destroyed NTSB NYC67A0113Accident · 4 fatalClosedBeech 35 · Arlington, VTFeb 11, 1967 · CF-MEP · Destroyed NTSB NYC67A0063Accident · 1 fatalClosedSchweizer SGS232 · Morrisville, VTOct 22, 1966 · N5841V · Destroyed NTSB NYC67A0057Accident · 3 fatalClosedPiper PA-30 · Stowe, VTOct 6, 1966 · N7289Y · Destroyed NTSB NYC66A0060Accident · 4 fatalClosedBeech D35 · Barre, VTNov 25, 1965 · N2169D · Destroyed NTSB NYC66A0037Accident · 4 fatalClosedBeech 23 · Rutland, VTSep 20, 1965 · N8768M · Destroyed NTSB NYC66A0035Accident · 2 fatalClosedCessna 172 · West Dover, VTSep 13, 1965 · N9809T · Destroyed NTSB UNK64X3525Accident · 1 fatalClosedSchweizer 1-26 · Moretown, VTAug 21, 1964 · N3832A · Substantial damage