Skip to content

NTSB investigations, VT

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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' 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'
  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'
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 NYC81FNC08Accident · No injuriesClosedHiller Acft UH-12C · Mendon, VTMar 5, 1981 · N73876 · Destroyed NTSB NYC81DNC05Accident · No injuriesClosedCessna 182 · Middlebury, VTOct 12, 1980 · N3491U · Substantial damage NTSB NYC80DA082Accident · No injuriesClosedCessna 150J · Woodstock, VTAug 10, 1980 · N3389J · Substantial damage NTSB NYC80FNC48Accident · No injuriesClosedPiper J-3 · Springfield, VTAug 3, 1980 · N88069 · Substantial damage NTSB NYC80FNC32Accident · No injuriesClosedCessna 182 · South Hero, VTJul 17, 1980 · N738EQ · Substantial damage NTSB NYC80FA049Accident · 2 fatalClosedCessna 210H · Lyndonville, VTJul 2, 1980 · N2229R · Destroyed NTSB NYC80DNC19Accident · No injuriesClosedAero Comdr 100 · Cornwall, VTApr 15, 1980 · N9877 · Destroyed NTSB NYC80DNC17Accident · No injuriesClosedCessna 150 · Burlington, VTApr 3, 1980 · N10731 · Substantial damage NTSB NYC80DNC08Accident · No injuriesClosedCessna 210L · Randolph, VTJan 24, 1980 · N94069 · Destroyed NTSB DEN80FA017Accident · 1 fatalClosedPiper PA-18 · Kelton, VTJan 19, 1980 · N3351A · Substantial damage NTSB NYC80DNC07Accident · No injuriesClosedCessna 150G · Lemington, VTJan 3, 1980 · N4074J · Substantial damage NTSB NYC80FNC04Accident · No injuriesClosedPiper PA-28 · Bennington, VTNov 17, 1979 · N8118V · Substantial damage NTSB NYC80FA011Accident · 3 fatalClosedCessna 337G · Bennington, VTNov 17, 1979 · N53560 · Destroyed NTSB NYC80DNC03Accident · No injuriesClosedPiper PA-28 · Newport, VTOct 15, 1979 · CGQXR · Substantial damage NTSB NYC80DNC06Accident · No injuriesClosed0berlerchne MG23SL · Roxbury, VTOct 8, 1979 · N1156Q · Substantial damage NTSB NYC79FA105Accident · 3 fatalClosedBeech 35C33A · Warren, VTSep 24, 1979 · N1984S · Destroyed NTSB NYC79FNC46Accident · Minor injuriesClosedBellanca 17-30 · Panton, VTAug 8, 1979 · N6570V · Substantial damage NTSB NYC79FNC42Accident · No injuriesClosedEnstrom F28A · West Hartford, VTAug 1, 1979 · N259Q · Substantial damage NTSB NYC79FA069Accident · No injuriesClosedBell 47G · Poultney, VTJul 30, 1979 · N64816 · Substantial damage NTSB NYC79DNC34Accident · No injuriesClosedPiper PA-28 · Vinalhaven, VTJul 3, 1979 · N4342T · Substantial damage NTSB NYC79DNC41Accident · No injuriesClosedCessna 140A · Johnson, VTJun 29, 1979 · N5347C · Substantial damage NTSB NYC79FNC30Accident · Minor injuriesClosedCessna 140 · Burlington, VTJun 14, 1979 · N2570N · Substantial damage NTSB NYC79FNC25Accident · Minor injuriesClosedBellanca 7GCBC · St.Albans, VTApr 28, 1979 · N5034K · Substantial damage NTSB NYC79FNC22Accident · No injuriesClosedBell 47G · Swanton, VTApr 12, 1979 · N902Z · Substantial damage NTSB NYC79FNC21Accident · Serious injuriesClosedGrum Amer AA-5 · Burlington, VTMar 21, 1979 · N4501L · Destroyed NTSB NYC79FA029Accident · 4 fatalClosedPiper PA-31 · Springfield, VTMar 10, 1979 · N27530 · Substantial damage NTSB NYC79DNC20Accident · No injuriesClosedHelio Acft H-295 · Burlington, VTFeb 25, 1979 · N6453V · Substantial damage NTSB NYC79DNC14Accident · Serious injuriesClosedPiper PA-28 · Bennington, VTDec 27, 1978 · N6476J · Substantial damage NTSB NYC79DNC10Accident · No injuriesClosedBergfalke 2 · Newport, VTNov 11, 1978 · CF-ACN · Substantial damage NTSB NYC79FA006Accident · 1 fatalClosedPiper PA-38 · West Townshend, VTOct 28, 1978 · N9372T · Destroyed NTSB NYC79FNC03Accident · Serious injuriesClosedLet-Np-K L-13 · Warren, VTOct 7, 1978 · N90598 · Substantial damage NTSB NYC79FNC02Accident · No injuriesClosedCessna 195 · Morrisville, VTOct 3, 1978 · N217AW · Substantial damage NTSB NYC79DNC01Accident · No injuriesClosedCessna 150 · Lowell, VTOct 1, 1978 · N565Q · Destroyed NTSB NYC78FNC45Accident · No injuriesClosedPiper PA-30 · Warren, VTAug 21, 1978 · N8419Y · Substantial damage NTSB NYC78FNC43Accident · Serious injuriesClosedBeech A-36 · Burlington, VTJul 31, 1978 · N25704 · Substantial damage NTSB NYC78DNC40Accident · No injuriesClosedCessna 185 · St Albans, VTJul 21, 1978 · N22901 · Substantial damage NTSB NYC78FNC28Accident · No injuriesClosedPiper PA-22 · Warren, VTJun 1, 1978 · N7229D · Substantial damage NTSB NYC78FA040Accident · 2 fatalClosedPiper PA-30 · Montpelier, VTApr 7, 1978 · N8559Y · Destroyed NTSB NYC78FNC21Accident · No injuriesClosedPiper PA-32 · Rutland, VTMar 20, 1978 · N3760W · Substantial damage NTSB NYC78FA033Accident · 2 fatalClosedPiper PA-28 · Sandgate, VTMar 15, 1978 · N9006K · Destroyed NTSB NYC78DNC20Accident · No injuriesClosedCessna 206 · Warren, VTFeb 25, 1978 · N3972G · Substantial damage NTSB NYC78FNC09Accident · No injuriesClosedMooney M20F · Danby, VTJan 11, 1978 · N6850V · Substantial damage NTSB NYC78DNC08Accident · No injuriesClosedSchweizer SGS232 · Warren, VTDec 27, 1977 · N2432W · Substantial damage NTSB NYC78DNC10Accident · No injuriesClosedPiper PA-28 · West Dover, VTDec 23, 1977 · N4495X · Substantial damage 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 NYC77DNC39Accident · Serious injuriesClosedSchneider LS-1F · Bennington, VTJul 3, 1977 · N77VL · Substantial damage NTSB NYC77DNC36Accident · No injuriesClosedBeech 18G · Burlington, VTJun 12, 1977 · N79LA · Substantial damage NTSB NYC77FNC30Accident · Serious injuriesClosedPiper PA-28 · Post Mills, VTMay 17, 1977 · N9781W · Substantial damage