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 NYC74DNC30Accident · Minor injuriesClosedBeech A23-24 · Wilmington, VTNov 10, 1973 · N4794J · Substantial damage NTSB NYC74DNC27Accident · No injuriesClosedCessna 150 · W.Wardsboro, VTOct 10, 1973 · N17296 · Substantial damage NTSB NYC74FNC24Accident · No injuriesClosedCessna 180 · Warren, VTOct 8, 1973 · N5110E · 2 aircraft · Substantial damage NTSB NYC74DNC23Accident · No injuriesClosedPiper PA-12 · Richford, VTSep 22, 1973 · CF-HVT · Substantial damage NTSB NYC74DNC18Accident · No injuriesClosedCessna 150 · Burlington, VTAug 14, 1973 · N3551L · Substantial damage NTSB NYC74DNC20Accident · Minor injuriesClosedPiper PA-28 · North Hero, VTAug 4, 1973 · N9495J · Substantial damage NTSB NYC74FNC15Accident · No injuriesClosedChampion 7GCBC · Springfield, VTJul 29, 1973 · N1880G · Substantial damage NTSB NYC74DNC04Accident · No injuriesClosedCessna 177 · St.Johnsbury, VTJul 15, 1973 · N3176T · Substantial damage NTSB NYC74FNC05Accident · No injuriesClosedErco 415-C · Highgate, VTJul 8, 1973 · N93659 · Substantial damage NTSB NYC73FNC76Accident · Minor injuriesClosedCessna 182N · Lincoln, VTJun 28, 1973 · N92431 · Destroyed NTSB NYC73FNC74Accident · Serious injuriesClosedCessna 150H · Ludlow, VTJun 4, 1973 · N22653 · Substantial damage NTSB NYC73FNC62Accident · No injuriesClosedCessna 310B · Burlington, VTMar 24, 1973 · N310B · Substantial damage NTSB NYC73DNC61Accident · No injuriesClosedCessna 182N · Montpelier, VTMar 23, 1973 · N92472 · Substantial damage NTSB NYC73FNC59Accident · No injuriesClosedPiper PA-23 · Newport, VTMar 19, 1973 · N6086Y · Substantial damage NTSB NYC73FNC56Accident · Serious injuriesClosedBeech K35 · West Dover, VTFeb 24, 1973 · N6086E · Substantial damage NTSB NYC73FNC55Accident · No injuriesClosedPiper J3C-65 · Springfield, VTFeb 23, 1973 · N1401V · Substantial damage NTSB NYC73AN116Accident · 2 fatalClosedCessna 310J · Londonderry, VTFeb 22, 1973 · N3149L · Destroyed NTSB NYC73DNC44Accident · Minor injuriesClosedCessna 150H · Enosburg, VTDec 23, 1972 · CF-AOY · Substantial damage NTSB NYC73AN083Accident · 4 fatalClosedCessna 411 · Winooski, VTDec 15, 1972 · N111DS · Destroyed NTSB NYC73AN079Accident · 1 fatalClosedCessna 172K · Bennington, VTDec 12, 1972 · N46717 · Destroyed NTSB NYC73DNC40Accident · No injuriesClosedPiper PA-32 · Ludlow, VTNov 25, 1972 · N4026R · Substantial damage NTSB NYC73DNC39Accident · No injuriesClosedBell 206A · Mount Snow, VTNov 24, 1972 · N3527T · Substantial damage NTSB NYC73DNC26Accident · No injuriesClosedPiper PA-22 · Basin Harbor, VTSep 28, 1972 · N3520A · Substantial damage NTSB NYC73FNC23Accident · No injuriesClosedCessna 305A · Warren, VTSep 2, 1972 · N11SU · 2 aircraft · Substantial damage NTSB NYC73DNC12Accident · Minor injuriesClosedCessna 172 · W Dover, VTAug 8, 1972 · N19740 · Substantial damage NTSB NYC73DNC09Accident · No injuriesClosedCessna 305A · Ely, VTJul 30, 1972 · N8275 · Substantial damage NTSB NYC72FNC43Accident · No injuriesClosedPiper PA-22 · Warren, VTMay 29, 1972 · N8012D · Substantial damage NTSB NYC72DNC47Accident · No injuriesClosedSchleicher K8B · W.Bridgewater, VTMay 23, 1972 · N1164 · Substantial damage NTSB NYC72DNC49Accident · No injuriesClosedCessna 150 · Alburg, VTMay 13, 1972 · N6756G · Substantial damage NTSB NYC72FNC41Accident · No injuriesClosedPiper PA-28 · Mt.Snow, VTMay 6, 1972 · N5652U · Substantial damage NTSB NYC72DNC38Accident · No injuriesClosedCessna 172 · W.Dover, VTApr 9, 1972 · N7214G · Substantial damage NTSB NYC72DNC33Accident · No injuriesClosedCessna 310H · West Dover, VTMar 9, 1972 · N12TT · Substantial damage NTSB NYC72AN100Accident · 2 fatalClosedPiper PA-23 · Dorset, VTFeb 22, 1972 · N13912 · Substantial damage NTSB NYC72DNC31Accident · No injuriesClosedCessna 150 · West Dover, VTFeb 11, 1972 · N51245 · Substantial damage NTSB NYC72AN093Accident · 3 fatalClosedBeech B95 · Mt Tabor, VTFeb 5, 1972 · N283AA · Substantial damage NTSB NYC72DNC26Accident · No injuriesClosedBeech V35 · St.Johnsbury, VTJan 30, 1972 · N9406S · Substantial damage NTSB NYC72DNC25Accident · No injuriesClosedCessna 206P · West Dover, VTJan 17, 1972 · N2522X · Substantial damage NTSB NYC72DNC17Accident · Minor injuriesClosedBeech A23A · West Dover, VTNov 23, 1971 · N7903L · Substantial damage NTSB NYC72FNC14Accident · Serious injuriesClosedPiper PA-28 · Manchester, VTOct 17, 1971 · N6042W · Destroyed NTSB NYC71FNC33Accident · No injuriesClosedBeech 95-B55 · Bondville, VTJun 28, 1971 · N240WS · Substantial damage NTSB NYC71FNC30Accident · No injuriesClosedSchweizer 2-33 · Warren, VTJun 12, 1971 · N2448W · Substantial damage NTSB NYC71DNC29Accident · No injuriesClosedCessna 150G · Sutton, VTMay 30, 1971 · N6299S · Substantial damage NTSB NYC71FNC27Accident · 1 fatalClosedCherokee II · Springfield, VTApr 24, 1971 · N8722E · Destroyed NTSB NYC71FNC25Accident · No injuriesClosedPiper PA-22 · Warren, VTApr 12, 1971 · N8012D · Substantial damage NTSB NYC71FFA55Accident · No injuriesClosedPiper PA-28 · Underhill, VTMar 27, 1971 · N28NA · Substantial damage NTSB NYC71DFA54Accident · No injuriesClosedPiper PA-28 · West Dover, VTMar 24, 1971 · N4183J · Substantial damage NTSB NYC71FFA49Accident · No injuriesClosedPiper PA-28 · West Dover, VTFeb 14, 1971 · N5253L · Substantial damage NTSB NYC71DFA47Incident · No injuriesClosedPiper PA-28 · Burlington, VTFeb 6, 1971 · N7311F · Minor damage NTSB NYC71FFA44Accident · Serious injuriesClosedBeech 65 · Newport, VTJan 28, 1971 · N5850J · Substantial damage NTSB NYC71AN085Accident · 5 fatalClosedAero Comdr 1121A · South Burlington, VTJan 27, 1971 · N400CP · Destroyed