Skip to content

NTSB investigations, 1974, WV

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 per year

19632026

NTSB investigations, 1974, WV per year, 1963–2026: 869 cases
1963	1
1964	20
1965	28
1966	26
1967	21
1968	31
1969	35
1970	32
1971	16
1972	28
1973	23
1974	31
1975	25
1976	18
1977	21
1978	19
1979	28
1980	21
1981	21
1982	16
1983	18
1984	17
1985	21
1986	7
1987	9
1988	22
1989	13
1990	16
1991	13
1992	16
1993	11
1994	9
1995	5
1996	13
1997	15
1998	8
1999	8
2000	7
2001	15
2002	7
2003	11
2004	12
2005	7
2006	7
2007	6
2008	3
2009	11
2010	10
2011	9
2012	7
2013	5
2014	6
2015	3
2016	8
2017	6
2018	3
2019	4
2020	1
2021	4
2022	5
2023	6
2024	10
2025	4
2026	10

Where

Latest cases

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 year(c."eventDate") = 1974 AND c."eventStateOrRegion" = 'WV' 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 year(c.\"eventDate\") = 1974
    AND c.\"eventStateOrRegion\" = 'WV' 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 year(c."eventDate") = 1974
  AND c."eventStateOrRegion" = 'WV' 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 IAD75DI213Accident · No injuriesClosedEnstrom F-28A · Willow Is, WVDec 24, 1974 · N9278 · Substantial damage NTSB NYC75FGM20Accident · No injuriesClosedBeech A90 · Wheeling, WVNov 21, 1974 · N52C · Substantial damage NTSB IAD75FIJ12Accident · No injuriesClosedCessna 172 · Ellamore, WVNov 20, 1974 · N8614U · Substantial damage NTSB IAD75AI029Accident · 3 fatalClosedPiper PA-28 · Morgantown, WVNov 9, 1974 · N6545J · Destroyed NTSB IAD75AIJ11Accident · No injuriesClosedCessna 172 · Hazelgreen, WVOct 24, 1974 · N7242A · Destroyed NTSB IAD75FIJ10Accident · Minor injuriesClosedBell 47G4A · Wayne, WVOct 17, 1974 · N8124J · Destroyed NTSB IAD75AI018Accident · 1 fatalClosedPiper PA-22 · Huntington, WVOct 4, 1974 · N1822P · Destroyed NTSB IAD75FIJ08Accident · Serious injuriesClosedPiper PA-28 · Elkins, WVAug 31, 1974 · N56845 · Destroyed NTSB IAD75FGM08Accident · No injuriesClosedCessna 172 · N Cumberland, WVAug 26, 1974 · N174KA · Substantial damage NTSB IAD75DIG04Accident · No injuriesClosedCessna 182N · Slanesville, WVAug 25, 1974 · N92816 · Substantial damage NTSB IAD75DIJ04Accident · No injuriesClosedPiper PA-24 · Morgantown, WVAug 13, 1974 · N5676P · Substantial damage NTSB IAD75DIJ03Accident · Serious injuriesClosedBell 47G2A1 · Layland, WVAug 10, 1974 · N1215W · Substantial damage NTSB IAD75FIJ05Accident · No injuriesClosedAero Sport D-260 · Hurricane, WVAug 4, 1974 · N3669 · Substantial damage NTSB IAD75FIJ06Accident · No injuriesClosedBeech 65-80 · Charleston, WVAug 1, 1974 · N242Q · Substantial damage NTSB IAD75AI003Accident · No injuriesClosedCessna 172K · Hinton, WVJul 23, 1974 · N79031 · Substantial damage NTSB IAD75FIJ02Accident · No injuriesClosedPiper PA-28 · Morgantown, WVJul 18, 1974 · N203CB · Substantial damage NTSB IAD75FIJ01Accident · No injuriesClosedPiper PA-22 · Fayetteville, WVJul 17, 1974 · N3748A · Substantial damage NTSB IAD74DIG28Accident · Minor injuriesClosedCessna 172G · Petersburg, WVJun 11, 1974 · N4638L · Substantial damage NTSB NYC74AM106Accident · 1 fatalClosedPiper PA-28 · Huntington, WVJun 8, 1974 · N7302F · Destroyed NTSB IAD74AI067Accident · 2 fatalClosedPiper PA-28 · Harper Ferry, WVJun 7, 1974 · N9979W · Destroyed NTSB IAD74DIJ17Accident · No injuriesClosedCessna 140 · Gary, WVMay 24, 1974 · N72829 · Destroyed NTSB IAD74DIJ16Accident · No injuriesClosedPiper PA-28 · S.Charleston, WVMay 17, 1974 · N9442J · Substantial damage NTSB IAD74FIJ15Accident · No injuriesClosedCessna 172 · Charlestown, WVMay 12, 1974 · N78600 · Substantial damage NTSB IAD74DIJ14Accident · Serious injuriesClosedStits SA3B · Rainelle, WVApr 19, 1974 · N5145 · Substantial damage NTSB IAD74AI056Accident · 2 fatalClosedPiper PA-28 · Maysville, WVApr 8, 1974 · N41953 · Destroyed NTSB IAD74FIJ13Accident · No injuriesClosedCessna 310C · Greenbank, WVMar 17, 1974 · N1791H · Substantial damage NTSB IAD74AI045Accident · 4 fatalClosedBeech 65 · Williamstown, WVFeb 24, 1974 · N9535Q · Destroyed NTSB IAD74DIJ12Accident · Minor injuriesClosedDart RP-S1 · Marlinton, WVFeb 17, 1974 · N3116 · Substantial damage NTSB IAD74DIJ10Accident · No injuriesClosedCessna 150F · Minerl Wells, WVJan 27, 1974 · N8048S · Substantial damage NTSB IAD74DIJ09Accident · Minor injuriesClosedPiper PA-28 · Pineville, WVJan 24, 1974 · N7285J · Substantial damage NTSB IAD74AI038Accident · No injuriesClosedCessna 177 · Parkersburg, WVJan 7, 1974 · N34667 · Minor damage