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 NYC77DNC20Accident · No injuriesClosedCessna 402 · Bennington, VTFeb 3, 1977 · N4090L · Substantial damage NTSB NYC77FA015Accident · 1 fatalClosedCessna 150L · Sherburne, VTNov 23, 1976 · N5376Q · Destroyed NTSB NYC76DNC65Accident · No injuriesClosedPiper PA-25 · Montpelier, VTAug 13, 1976 · N8524L · Destroyed NTSB NYC76DNC60Accident · Minor injuriesClosedTaylorcraft BC12-D · Warren, VTJul 31, 1976 · N39193 · Substantial damage NTSB NYC76FNC59Accident · No injuriesClosedCessna 177RG · Clarendon, VTJul 23, 1976 · N1167M · Destroyed NTSB NYC76FNC58Accident · No injuriesClosedCessna 150L · Westminster, VTJul 22, 1976 · N5237Q · Substantial damage NTSB NYC76DNC57Accident · No injuriesClosedPiper PA-25 · Middlebury, VTJul 19, 1976 · N8529L · Substantial damage NTSB NYC76AN108Accident · 2 fatalClosedLuscombe 8A · Plainfield, VTJul 5, 1976 · N1083K · Destroyed NTSB NYC76FNC54Accident · No injuriesClosedMooney M20C · Benson, VTJul 3, 1976 · N6479U · Substantial damage NTSB NYC76DNC49Accident · No injuriesClosedCessna A188B · W Cornwall, VTMay 8, 1976 · N6509G · Substantial damage NTSB NYC76AM093Accident · 2 fatalClosedCessna 310 · Rutland, VTApr 26, 1976 · N7696Q · Destroyed NTSB NYC76FNC46Accident · No injuriesClosedCessna 305A · Warren, VTApr 16, 1976 · N5264G · Substantial damage NTSB NYC76FNC37Accident · 1 fatalClosedBellanca 14-19 · Ludlow, VTMar 30, 1976 · N7668B · Destroyed NTSB NYC76DNC36Accident · No injuriesClosedCessna 180 · Warren, VTMar 15, 1976 · N5110E · Substantial damage NTSB NYC76AN083Accident · Serious injuriesClosedGrumman G-1159 · Burlington, VTFeb 22, 1976 · N397F · Destroyed NTSB NYC76AN077Accident · 3 fatalClosedCessna 172K · Burlington, VTFeb 11, 1976 · N79285 · Substantial damage NTSB NYC76DNC43Accident · No injuriesClosedPiper PA-28 · Post Mills, VTFeb 8, 1976 · N2143T · Substantial damage NTSB NYC76DNC42Accident · Minor injuriesClosedBeech A36 · Stowe, VTFeb 6, 1976 · N7794R · Substantial damage NTSB NYC76AN074Accident · 2 fatalClosedPiper PA-23 · S Burlington, VTFeb 4, 1976 · N65TM · Destroyed NTSB NYC76DNC44Accident · No injuriesClosedPiper PA-28 · Post Mills, VTJan 31, 1976 · N9930W · Substantial damage NTSB NYC76DNC40Accident · No injuriesClosedCessna 150 · Fairhaven, VTJan 25, 1976 · N60939 · Substantial damage NTSB NYC76AN070Accident · No injuriesClosedPiper PA-32 · Wilmington, VTJan 23, 1976 · N5594J · Substantial damage NTSB NYC76DNC33Accident · No injuriesClosedCessna 182 · Rutland, VTDec 25, 1975 · N2342R · Substantial damage NTSB NYC76FNC32Accident · Serious injuriesClosedAero Comdr 112A · Georgia, VTDec 20, 1975 · C-GNUX · Destroyed NTSB NYC76AN054Accident · No injuriesClosedBeech E18S · N Springfield, VTDec 9, 1975 · N62V · Substantial damage NTSB NYC76FNC30Accident · No injuriesClosedCessna 150M · S Hinesburg, VTNov 9, 1975 · N45295 · Substantial damage NTSB NYC76AN047Accident · 1 fatalClosedStinson 108-2 · Bellows Falls, VTOct 29, 1975 · N9464K · Destroyed NTSB NYC76FNC30Accident · Minor injuriesClosedLuscombe 8E · Milton, VTOct 25, 1975 · N1808B · Substantial damage NTSB NYC76FNC25Accident · No injuriesClosedCessna 210H · Newport, VTOct 19, 1975 · N5982F · Substantial damage NTSB NYC7LDNC03Accident · No injuriesClosedPiper PA-24 · Warren, VTJul 26, 1975 · N6442P · Substantial damage NTSB NYC75DNC38Accident · No injuriesClosedCessna A150 · Shelbourne, VTJun 21, 1975 · N6154F · Destroyed NTSB NYC75FNC37Accident · No injuriesClosedCessna 172L · Putney, VTJun 11, 1975 · N7247Q · Substantial damage NTSB NYC75FNC34Accident · No injuriesClosedAero Comdr 100 · Stowe, VTMay 24, 1975 · N4061X · Substantial damage NTSB NYC75DNC33Accident · No injuriesClosedPiper PA-25 · Middlebury, VTMay 22, 1975 · N8601L · Destroyed NTSB NYC75DNC31Accident · No injuriesClosedCessna 172H · Montpelier, VTMay 5, 1975 · N2831L · 2 aircraft · Substantial damage NTSB NYC75FNC28Accident · No injuriesClosedBeech B24R · Morrisville, VTApr 12, 1975 · N2195W · Substantial damage NTSB NYC75DNC26Accident · No injuriesClosedBeech 35C33A · Morrisville, VTMar 29, 1975 · N319JM · Substantial damage NTSB NYC75DNC23Accident · No injuriesClosedCessna 150 · West Dover, VTJan 24, 1975 · N11394 · Substantial damage NTSB NYC75FNC20Accident · Minor injuriesClosedCessna 172C · West Dover, VTDec 7, 1974 · N2024Y · Substantial damage NTSB NYC75FNC15Accident · Minor injuriesClosedSchweizer SGS233 · Warren, VTOct 22, 1974 · N1228S · Substantial damage NTSB NYC75DNC12Accident · No injuriesClosedGrumman AA1-B · N Springfield, VTOct 3, 1974 · N633L · Substantial damage NTSB NYC75DNC07Accident · No injuriesClosedSmith Mini · Post Mills, VTSep 2, 1974 · N417A · Substantial damage NTSB NYC75AN020Accident · 4 fatalClosedBeech 35-A33 · Bennington, VTAug 17, 1974 · N385Z · Destroyed NTSB NYC75AN008Accident · Serious injuriesClosedPiper PA-32 · Manchester, VTJul 20, 1974 · N3804W · Destroyed NTSB NYC74DNC48Accident · No injuriesClosedAero Comdr 100 · Benson, VTJun 15, 1974 · N3614X · Substantial damage NTSB NYC74DNC43Accident · No injuriesClosedCessna 150 · Washington, VTMay 16, 1974 · N3545J · Destroyed NTSB NYC74FNC42Accident · No injuriesClosedPiper PA-28R · Middlebury, VTMay 10, 1974 · N9415N · Substantial damage NTSB NYC74AN088Accident · 4 fatalClosedMooney M20C · Dorset, VTApr 15, 1974 · N78990 · Destroyed NTSB NYC74FNC37Accident · No injuriesClosedPiper PA-31 · Wilmington, VTFeb 9, 1974 · N510BB · Substantial damage NTSB NYC74AN044Accident · 3 fatalClosedPiper PA-28 · Manchester, VTNov 18, 1973 · N9DC · Destroyed