Skip to content

NTSB investigations, 1974

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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

19622026

NTSB investigations, 1974 per year, 1962–2026: 180,581 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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 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
  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
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 OAK75DVA38Accident · No injuriesClosedHiller Acft UH-12C · Kettlmn Cty, CADec 31, 1974 · N4785C · Destroyed NTSB NYC75FNE24Accident · Minor injuriesClosedAeronca 7AC · Turner Falls, MADec 31, 1974 · N85191 · Substantial damage NTSB NYC75FNE23Accident · Serious injuriesClosedCessna 150M · Southampton, MADec 31, 1974 · N66284 · Substantial damage NTSB NYC75FGT10Accident · No injuriesClosedPiper PA-24 · Frackville, PADec 31, 1974 · N5197P · Substantial damage NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB MKC75FCD30Accident · No injuriesClosedCessna 150 · Ottuma, IADec 31, 1974 · N7757F · Substantial damage NTSB MIA75FLD47Accident · Serious injuriesClosedCessna 172 · Ormond Beach, FLDec 31, 1974 · N23389 · Substantial damage NTSB LAX75FUA19Accident · No injuriesClosedCessna 172K · Avalon, CADec 31, 1974 · N84754 · Substantial damage NTSB IAD75AI038Accident · 2 fatalClosedBeech H18 · St Augustine, FLDec 31, 1974 · N500MM · Destroyed NTSB FTW75DRD24Accident · No injuriesClosedCessna 120 · Golden Meadow, LADec 31, 1974 · N76235 · Substantial damage NTSB FTW75DQG36Accident · No injuriesClosedPiper PA-28 · Shallowater, TXDec 31, 1974 · N3656R · Substantial damage NTSB FTW75AF047Accident · 1 fatalClosedCessna 175 · Abbeville, LADec 31, 1974 · N8066T · Destroyed NTSB OAK75AP030Accident · 2 fatalClosedCessna 172L · 3 Rivers, CADec 30, 1974 · N7840G · Destroyed NTSB NYC75AN078Accident · 2 fatalClosedPiper PA-32 · Fairchance, PADec 30, 1974 · N32264 · Destroyed NTSB MKC75FCD29Accident · No injuriesClosedHughes 269A · Bettendorf, IADec 30, 1974 · N8823F · Destroyed NTSB MIA75AM040Accident · 2 fatalClosedPiper PA-30 · Atlanta, GADec 30, 1974 · N7007Y · Destroyed NTSB LAX75FUD03Accident · No injuriesClosedCessna 172M · Snta Monica, CADec 30, 1974 · N13723 · Substantial damage NTSB LAX75FUA20Accident · Minor injuriesClosedCessna 182G · Buena Park, CADec 30, 1974 · C-GWBF · Substantial damage NTSB FTW75AF046Accident · 4 fatalClosedBeech V35B · Kent, TXDec 30, 1974 · N437T · Destroyed NTSB CHI75FEC31Accident · No injuriesClosedCessna 150 · S Rockwood, MIDec 30, 1974 · N50794 · Substantial damage NTSB ANC75AA049Accident · No injuriesClosedDehavilland DHC-2 · Prnc O'Wales, AKDec 30, 1974 · N4766 · Substantial damage NTSB OAK75FVM18Accident · No injuriesClosedGlobe GC-1B · Palo Alto, CADec 29, 1974 · N78200 · Substantial damage NTSB OAK75DVD30Accident · No injuriesClosedCulver V · Sonoma, CADec 29, 1974 · N6545C · Substantial damage NTSB OAK75AP028Accident · 1 fatalClosedAmer Avco AA1-A · Newark, CADec 29, 1974 · N9443L · Destroyed NTSB NYC75FHJ24Accident · No injuriesClosedAmer Avco AA1-B · Melville, NYDec 29, 1974 · N6216L · Substantial damage NTSB MKC75DTK09Accident · Minor injuriesClosedCessna 172F · Warner, SDDec 29, 1974 · CF-JIE · Substantial damage NTSB MKC75DCQ31Accident · No injuriesClosedBeech J35 · Scott City, KSDec 29, 1974 · N7269B · Substantial damage NTSB MKC75DCJ43Accident · No injuriesClosedCessna 150L · Hastings, NEDec 29, 1974 · N11436 · Substantial damage NTSB MIA75OKT40Accident · No injuriesClosedAero Comdr 500 · Walker Cay, Burkina FasoDec 29, 1974 · N36T · Substantial damage NTSB MIA75DLD45Accident · Minor injuriesClosedCessna 182L · Summerfield, FLDec 29, 1974 · N3372R · Substantial damage NTSB LAX75DVA40Accident · No injuriesClosedBeech B35 · Bakersfield, CADec 29, 1974 · N5234C · Substantial damage NTSB LAX75DUG25Accident · Minor injuriesClosedPiper PA-20 · Rubidoux, CADec 29, 1974 · N7382K · Substantial damage NTSB IAD75FLQ11Accident · Serious injuriesClosedAero Comdr 500B · Paducah, KYDec 29, 1974 · N553HH · Substantial damage NTSB IAD75AI037Accident · 2 fatalClosedPiper PA-32 · Laytonsville, MDDec 29, 1974 · N3840W · Substantial damage NTSB FTW75AF045Accident · No injuriesClosedBeech D55 · El Dorado, ARDec 29, 1974 · N318Q · Substantial damage NTSB ANC75AAG60Accident · Serious injuriesClosedCessna 172 · Kodiak, AKDec 29, 1974 · N46348 · Substantial damage NTSB NYC75FFA25Accident · No injuriesClosedCessna 172 · Malone, NYDec 28, 1974 · N35531 · Substantial damage NTSB NYC75DHA28Accident · No injuriesClosedCessna 170A · Pittstown, NJDec 28, 1974 · N7A · Substantial damage NTSB NYC75DHA25Accident · No injuriesClosedCessna 172 · Manville, NJDec 28, 1974 · N6966A · Substantial damage NTSB NYC75AN077Accident · Serious injuriesClosedBoeing 707 · Richmond, VADec 28, 1974 · N8432 · No damage NTSB MKC75FCD28Accident · No injuriesClosedLuscombe 8A · Rockwell Cty, IADec 28, 1974 · N45927 · Substantial damage NTSB MKC75AN076Accident · 1 fatalClosedCessna 177 · Grand Island, NYDec 28, 1974 · N29496 · Destroyed NTSB MIA75DKT37Accident · No injuriesClosedPiper PA-30 · Sanibel, FLDec 28, 1974 · N8635Y · Substantial damage NTSB LAX75FUJ51Accident · No injuriesClosedHelio Acft H-295 · Carefree, AZDec 28, 1974 · N6491V · Substantial damage NTSB LAX75DUJ59Accident · No injuriesClosedCessna 182J · Tucson, AZDec 28, 1974 · N2783F · Substantial damage NTSB FTW75FQG35Accident · No injuriesClosedCessna 150 · Slaton, TXDec 28, 1974 · N6718G · Substantial damage NTSB FTW75DRA16Accident · No injuriesClosedCessna 172L · Kirbyville, TXDec 28, 1974 · N4341Q · Substantial damage NTSB DEN75DTE44Accident · No injuriesClosedCessna 150 · Salida, CODec 28, 1974 · N2920V · Substantial damage NTSB CHI75FEP36Accident · No injuriesClosedCessna 170B · Waukesha, WIDec 28, 1974 · N3120B · Substantial damage NTSB CHI75DEM13Accident · No injuriesClosedCessna 150H · Cadillac, MIDec 28, 1974 · N6934S · Substantial damage