# NTSB investigations, 1974, VT

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB NYC75FNC20](https://openairdocs.org/ntsb/NYC75FNC20.md): Cessna 172C · West Dover, VT · Accident · Minor injuries · Closed · Dec 7, 1974 · N2024Y · Substantial damage
- [NTSB NYC75FNC15](https://openairdocs.org/ntsb/NYC75FNC15.md): Schweizer SGS233 · Warren, VT · Accident · Minor injuries · Closed · Oct 22, 1974 · N1228S · Substantial damage
- [NTSB NYC75DNC12](https://openairdocs.org/ntsb/NYC75DNC12.md): Grumman AA1-B · N Springfield, VT · Accident · No injuries · Closed · Oct 3, 1974 · N633L · Substantial damage
- [NTSB NYC75DNC07](https://openairdocs.org/ntsb/NYC75DNC07.md): Smith Mini · Post Mills, VT · Accident · No injuries · Closed · Sep 2, 1974 · N417A · Substantial damage
- [NTSB NYC75AN020](https://openairdocs.org/ntsb/NYC75AN020.md): Beech 35-A33 · Bennington, VT · Accident · 4 fatal · Closed · Aug 17, 1974 · N385Z · Destroyed
- [NTSB NYC75AN008](https://openairdocs.org/ntsb/NYC75AN008.md): Piper PA-32 · Manchester, VT · Accident · Serious injuries · Closed · Jul 20, 1974 · N3804W · Destroyed
- [NTSB NYC74DNC48](https://openairdocs.org/ntsb/NYC74DNC48.md): Aero Comdr 100 · Benson, VT · Accident · No injuries · Closed · Jun 15, 1974 · N3614X · Substantial damage
- [NTSB NYC74DNC43](https://openairdocs.org/ntsb/NYC74DNC43.md): Cessna 150 · Washington, VT · Accident · No injuries · Closed · May 16, 1974 · N3545J · Destroyed
- [NTSB NYC74FNC42](https://openairdocs.org/ntsb/NYC74FNC42.md): Piper PA-28R · Middlebury, VT · Accident · No injuries · Closed · May 10, 1974 · N9415N · Substantial damage
- [NTSB NYC74AN088](https://openairdocs.org/ntsb/NYC74AN088.md): Mooney M20C · Dorset, VT · Accident · 4 fatal · Closed · Apr 15, 1974 · N78990 · Destroyed
- [NTSB NYC74FNC37](https://openairdocs.org/ntsb/NYC74FNC37.md): Piper PA-31 · Wilmington, VT · Accident · No injuries · Closed · Feb 9, 1974 · N510BB · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 year(c."eventDate") = 1974
  AND c."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=VT&year=1974

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.