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 NYC68A0037Accident · 1 fatalClosedPiper PA-28 · Waitsfield, VTAug 26, 1967 · N6494W · Destroyed NTSB NYC68D0113Accident · No injuriesClosedLake LA-4 · Outh Hero, VTAug 6, 1967 · N1126L · Substantial damage NTSB NYC68F0232Accident · Minor injuriesClosedCessna 337 · West Addison, VTJul 23, 1967 · N6242F · Destroyed NTSB NYC67D0632Accident · No injuriesClosedPiper PA-28 · Burlington, VTApr 15, 1967 · N6556W · Substantial damage NTSB NYC67D0555Accident · No injuriesClosedPiper PA-24 · Enosburg Falls, VTMar 12, 1967 · N8260P · Substantial damage NTSB NYC67A0114Accident · No injuriesClosedCessna 310 · Bennington, VTFeb 11, 1967 · N1101Q · Substantial damage NTSB NYC67A0113Accident · 4 fatalClosedBeech 35 · Arlington, VTFeb 11, 1967 · CF-MEP · Destroyed NTSB NYC67F0510Accident · No injuriesClosedBeech G35 · Morrisville, VTFeb 4, 1967 · N4517D · Substantial damage NTSB NYC67D0486Accident · No injuriesClosedPiper PA-28 · Basin Harbor, VTJan 22, 1967 · N6556W · Substantial damage NTSB NYC67D0464Accident · No injuriesClosedCessna 150 · Milton, VTJan 18, 1967 · N6995F · Substantial damage NTSB NYC67A0063Accident · 1 fatalClosedSchweizer SGS232 · Morrisville, VTOct 22, 1966 · N5841V · Destroyed NTSB NYC67F0545Accident · No injuriesClosedCessna 305A · Warren, VTOct 12, 1966 · N6393T · Substantial damage NTSB NYC67A0057Accident · 3 fatalClosedPiper PA-30 · Stowe, VTOct 6, 1966 · N7289Y · Destroyed NTSB NYC67F0184Accident · Minor injuriesClosedSchweitzer SGS126 · Warren, VTAug 9, 1966 · N9924J · Substantial damage NTSB NYC67F0142Accident · No injuriesClosedErco 415-D · Manchester, VTJul 20, 1966 · N99246 · Substantial damage NTSB NYC67D0047Accident · No injuriesClosedCessna 182 · Putney, VTJun 15, 1966 · N3244U · Substantial damage NTSB NYC66F0653Accident · Minor injuriesClosedPiper PA-22 · Winooski, VTMay 11, 1966 · N5445Z · Substantial damage NTSB NYC66F0690Accident · No injuriesClosedAeronca 7BCM · Morrisville, VTMay 1, 1966 · N2035A · Substantial damage NTSB NYC66D0594Accident · No injuriesClosedPiper PA-28 · Wardsboro, VTMar 30, 1966 · N7156W · Substantial damage NTSB NYC66A0060Accident · 4 fatalClosedBeech D35 · Barre, VTNov 25, 1965 · N2169D · Destroyed NTSB NYC66F0348Accident · No injuriesClosedPiper PA-30 · Shelburne, VTOct 17, 1965 · N7522Y · Substantial damage NTSB NYC66F0341Accident · No injuriesClosedTaylorcraft DCO · East Berkshire, VTOct 14, 1965 · N46444 · Substantial damage NTSB NYC66D0246Accident · Minor injuriesClosedTaylorcraft BC-65 · Jamaica, VTSep 28, 1965 · N36316 · Substantial damage NTSB UNK65X1536Accident · Serious injuriesClosedPiper PA12S · Ely, VTSep 21, 1965 · N98918 · Substantial damage NTSB NYC66A0037Accident · 4 fatalClosedBeech 23 · Rutland, VTSep 20, 1965 · N8768M · Destroyed NTSB NYC66A0035Accident · 2 fatalClosedCessna 172 · West Dover, VTSep 13, 1965 · N9809T · Destroyed NTSB NYC66D0213Accident · No injuriesClosedCessna 150 · Burlington, VTSep 5, 1965 · N3941U · Substantial damage NTSB NYC66D0146Accident · No injuriesClosedCessna 206 · Windsor, VTAug 4, 1965 · N2159F · Substantial damage NTSB NYC66A0024Accident · Serious injuriesClosedDouglas DC-3 · Newport, VTAug 2, 1965 · N19428 · No damage NTSB NYC66F0095Accident · Serious injuriesClosedWaco UPF7 · Manchester, VTJul 17, 1965 · N32168 · Destroyed NTSB NYC66D0048Accident · No injuriesClosedCessna 180S · Milton, VTJun 28, 1965 · N5319D · Destroyed NTSB NYC66F0014Accident · No injuriesClosedPiper PA-28 · Burlington, VTJun 5, 1965 · N7817W · Substantial damage NTSB UNK65X1492Accident · Minor injuriesClosedPiper PA-12 · Bennington, VTMay 13, 1965 · N2302M · Substantial damage NTSB NYC65F0053Accident · No injuriesClosedPiper PA28 · Newport, VTFeb 13, 1965 · N8004W · Substantial damage NTSB UNK65X1217Accident · No injuriesClosedPiper PA28 · Morrisville, VTJan 2, 1965 · N7817W · Substantial damage NTSB UNK65X1071Accident · No injuriesClosedPiper J3C · Salisbury, VTDec 20, 1964 · N70925 · Substantial damage NTSB UNK65X0632Accident · No injuriesClosedCessna 180 · Acburg, VTNov 9, 1964 · N7784A · Substantial damage NTSB UNK65X0357Accident · Minor injuriesClosedHelisoar HP10 · Waitsfield, VTOct 21, 1964 · N4601G · Substantial damage NTSB UNK65X0142Accident · No injuriesClosedCessna 195 · Bristol, VTOct 4, 1964 · N9870A · Destroyed NTSB UNK65X0138Accident · Minor injuriesClosedSchweizer TG2 · Berlin, VTOct 4, 1964 · N49530 · Substantial damage NTSB UNK64X3923Accident · No injuriesClosedCessna 185 · Grand Isle, VTSep 11, 1964 · N1001N · Substantial damage NTSB UNK64X3914Accident · No injuriesClosedBoeing A75N1 · Clarendon, VTSep 11, 1964 · N73796 · Substantial damage NTSB UNK64X3820Accident · No injuriesClosedCessna 182 · Bennington, VTSep 6, 1964 · N8864 · Substantial damage NTSB UNK64X3741Accident · No injuriesClosedErcoupe 415C · Bennington, VTSep 2, 1964 · N2415H · Substantial damage NTSB UNK64X3525Accident · 1 fatalClosedSchweizer 1-26 · Moretown, VTAug 21, 1964 · N3832A · Substantial damage NTSB UNK64X3400Accident · Minor injuriesClosedVertol 42A · Waitsfield, VTAug 15, 1964 · CF-IMZ · Substantial damage NTSB UNK64X3033Accident · No injuriesClosedCessna 140 · Barre, VTJul 25, 1964 · N89746 · Substantial damage NTSB UNK64X2865Accident · Minor injuriesClosedPiper PA-22 · St Johnsbury, VTJul 16, 1964 · CF-KSI · Substantial damage NTSB UNK64X1476Accident · No injuriesClosedBrantly B2 · Thetford, VTApr 26, 1964 · N4997C · Substantial damage NTSB UNK64X1406Accident · Serious injuriesClosedHughes 269B · Winooski, VTApr 21, 1964 · N9323F · Substantial damage