Skip to content

Final NTSB investigations, 1974

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

Final NTSB investigations, 1974 per year, 1962–2026: 171,593 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,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,145
2025	782
2026	365

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."completionStatus" = 'Completed' 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.\"completionStatus\" = 'Completed'
  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."completionStatus" = 'Completed'
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