Skip to content

NTSB investigations, 1974, TX

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, TX per year, 1962–2026: 12,312 cases
1962	3
1963	2
1964	397
1965	415
1966	429
1967	433
1968	360
1969	357
1970	330
1971	310
1972	260
1973	292
1974	318
1975	292
1976	312
1977	316
1978	276
1979	304
1980	293
1981	367
1982	295
1983	256
1984	255
1985	229
1986	185
1987	195
1988	153
1989	154
1990	143
1991	132
1992	130
1993	136
1994	119
1995	164
1996	141
1997	138
1998	141
1999	136
2000	140
2001	135
2002	119
2003	126
2004	137
2005	129
2006	108
2007	117
2008	125
2009	120
2010	127
2011	121
2012	126
2013	102
2014	120
2015	110
2016	126
2017	91
2018	119
2019	116
2020	116
2021	97
2022	118
2023	104
2024	101
2025	103
2026	91

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 FTW75DQG36Accident · No injuriesClosedPiper PA-28 · Shallowater, TXDec 31, 1974 · N3656R · Substantial damage NTSB FTW75AF046Accident · 4 fatalClosedBeech V35B · Kent, TXDec 30, 1974 · N437T · Destroyed 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 FTW75DPD21Accident · No injuriesClosedBellanca 7GCBC · Cross Plains, TXDec 25, 1974 · N9182L · Substantial damage NTSB FTW75AF043Accident · 3 fatalClosedBeech 35 · Vidor, TXDec 23, 1974 · N80463 · Destroyed NTSB FTW75FQD14Accident · No injuriesClosedDehavilland DHC-2 · Van Horn, TXDec 20, 1974 · N94477 · Substantial damage NTSB FTW75DRJ21Accident · No injuriesClosedCessna 150 · Nacogdoches, TXDec 18, 1974 · N18607 · Substantial damage NTSB FTW75IF042Incident · No injuriesClosedBoeing 727 · Houston, TXDec 14, 1974 · N8152G · Minor damage NTSB FTW75AF041Accident · 2 fatalClosedCessna 172M · Freestone, TXDec 14, 1974 · N13344 · Destroyed NTSB FTW75AF039Accident · 2 fatalClosedPiper PA-23 · Denton, TXDec 10, 1974 · N5085Y · Destroyed NTSB FTW75FRA15Accident · Serious injuriesClosedBeech A23 · College Statn, TXDec 8, 1974 · N3563R · Substantial damage NTSB FTW75DRG46Accident · No injuriesClosedBeech G35 · Lampasas, TXDec 8, 1974 · N4243D · Substantial damage NTSB FTW75FQG34Accident · No injuriesClosedCessna 310P · Abernathy, TXDec 7, 1974 · N381F · Substantial damage NTSB FTW75FRG48Accident · Serious injuriesClosedBell 47GB31 · Freer, TXDec 5, 1974 · N8505F · Substantial damage NTSB FTW75AF037Accident · 2 fatalClosedPiper PA-30 · Graford, TXDec 5, 1974 · N123RC · Destroyed NTSB FTW75DRG44Accident · No injuriesClosedMaule M5220C · Austin, TXDec 3, 1974 · N62002 · Substantial damage NTSB FTW75FPD20Accident · No injuriesClosedCessna 175 · Abilene, TXDec 1, 1974 · N7266M · Destroyed NTSB FTW75DRG42Accident · No injuriesClosedBeech 95-C55 · Batesville, TXDec 1, 1974 · N70EE · Substantial damage NTSB FTW75FRG41Accident · No injuriesClosedBeech B35 · San Antonio, TXNov 30, 1974 · N8721A · Substantial damage NTSB FTW75DRG43Accident · No injuriesClosedCessna 172M · Rachal, TXNov 29, 1974 · N20196 · Substantial damage NTSB FTW75FQG33Accident · Minor injuriesClosedStinson 108-3 · Plains, TXNov 27, 1974 · N6192M · Substantial damage NTSB FTW75FPA15Accident · No injuriesClosedCessna 172L · Greenville, TXNov 26, 1974 · N8180M · Substantial damage NTSB FTW75FRG39Accident · Minor injuriesClosedCessna 310D · Austin, TXNov 23, 1974 · N6891T · Destroyed NTSB FTW75DRA14Accident · Minor injuriesClosedCessna 150L · Orange, TXNov 23, 1974 · N11265 · Substantial damage NTSB FTW75FRJ19Accident · Minor injuriesClosedCessna 182A · Longview, TXNov 21, 1974 · N5030D · Substantial damage NTSB FTW75FPA14Accident · No injuriesClosedBellanca 17-30A · Dallas, TXNov 21, 1974 · N100MV · 2 aircraft · Substantial damage NTSB FTW75DQG34Accident · No injuriesClosedCessna 310F · Stanton, TXNov 20, 1974 · N5841X · Substantial damage NTSB FTW75FQG32Accident · No injuriesClosedBoeing A75 · Roaring Sprgs, TXNov 19, 1974 · N55065 · Destroyed NTSB FTW75FPD19Accident · No injuriesClosedCessna 210 · Jacksboro, TXNov 19, 1974 · N93995 · Substantial damage NTSB FTW75FPD18Accident · Minor injuriesClosedTaylorcraft BC12-D · N.Richld Hils, TXNov 19, 1974 · N43708 · Destroyed NTSB FTW75AF044Accident · 4 fatalClosedCessna 170B · Conroe, TXNov 17, 1974 · N338B · Destroyed NTSB FTW75AF035Accident · 2 fatalClosedPiper PA-23 · Falfurrias, TXNov 17, 1974 · N1395P · Destroyed NTSB FTW75DRG38Accident · No injuriesClosedPiper PA-28 · Encinal, TXNov 13, 1974 · N2157T · Substantial damage NTSB FTW75DRA12Accident · Minor injuriesClosedPiper PA-28 · Columbus, TXNov 12, 1974 · N16387 · Substantial damage NTSB FTW75FRG36Accident · No injuriesClosedCessna 140A · Port Lavaca, TXNov 10, 1974 · N9650A · Substantial damage NTSB FTW75DRG37Accident · No injuriesClosedPiper PA-28 · Uvalde, TXNov 10, 1974 · N15245 · Substantial damage NTSB FTW75AF032Accident · 1 fatalClosedPiper PA-28 · El Paso, TXNov 9, 1974 · N269JB · Destroyed NTSB FTW75FPD16Accident · No injuriesClosedPiper PA-22 · N.Richlnd Hls, TXNov 8, 1974 · N1839P · Substantial damage NTSB FTW75DRA13Accident · No injuriesClosedAmer Avco AA-1B · Port Arthur, TXNov 7, 1974 · N9880L · Substantial damage NTSB FTW75FQG30Accident · Serious injuriesClosedCessna A188 · Pampa, TXNov 6, 1974 · N8171V · Destroyed NTSB FTW75FPD15Accident · Minor injuriesClosedCessna 150 · Burleson, TXNov 5, 1974 · N60281 · Substantial damage NTSB FTW75FPD17Accident · 1 fatalClosedTeenie TWO · Wichita Falls, TXNov 4, 1974 · N17362 · Destroyed NTSB FTW75DRA11Accident · No injuriesClosedCessna 140 · Conroe, TXNov 4, 1974 · N1998V · Substantial damage NTSB FTW75AF031Accident · 4 fatalClosedPiper PA-22 · Shallowater, TXNov 3, 1974 · N1941P · Destroyed NTSB FTW75AF030Accident · No injuriesClosedCessna 210 · Grand Prairie, TXNov 2, 1974 · N7352E · 2 aircraft · Substantial damage NTSB FTW75FQG28Accident · No injuriesClosedPiper PA-24 · Lubbock, TXNov 1, 1974 · N9366P · Substantial damage NTSB FTW75DRG34Accident · Serious injuriesClosedPiper PA-25 · Pharr, TXOct 30, 1974 · N6706Z · Destroyed NTSB FTW75DRG33Accident · Minor injuriesClosedErco 415-C · Weslaco, TXOct 24, 1974 · N87382 · Substantial damage NTSB FTW75AF027Accident · 1 fatalClosedPiper PA-32 · Huntsville, TXOct 23, 1974 · N3928W · Destroyed