Skip to content

NTSB investigations, 1975, TX

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 FTW76FRG36Accident · No injuriesClosedBeech 58 · Wimberly, TXDec 31, 1975 · N80KC · Substantial damage NTSB FTW76FPA14Accident · No injuriesClosedCessna 310J · Addison, TXDec 26, 1975 · N49AM · Substantial damage NTSB FTW76FPA13Accident · Minor injuriesClosedCessna 150 · Rice, TXDec 26, 1975 · N8393J · Substantial damage NTSB FTW76DQG40Accident · Minor injuriesClosedCessna 180 · Borger, TXDec 26, 1975 · N9210C · Destroyed NTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXDec 23, 1975 · N16479 · Destroyed NTSB FTW76DRG31Accident · No injuriesClosedCessna 172 · Eagle Pass, TXDec 20, 1975 · N3874L · Substantial damage NTSB FTW76FPD22Accident · No injuriesClosedFokker D-7 · Grand Prairie, TXDec 17, 1975 · N1918S · Substantial damage NTSB FTW76AF050Accident · 4 fatalClosedCessna T310Q · Lewisville, TXDec 12, 1975 · N888DB · Destroyed NTSB FTW76FRG30Accident · Serious injuriesClosedCessna 182A · Three Rivers, TXDec 11, 1975 · N4772D · Destroyed NTSB FTW76AF049Accident · No injuriesClosedBeech D18S · Mineral Wells, TXDec 8, 1975 · N629Z · Substantial damage NTSB FTW76FPA15Accident · No injuriesClosedBell 47D-1 · Irving, TXDec 7, 1975 · N5226 · Substantial damage NTSB FTW76FRA18Accident · Minor injuriesClosedCessna 210A · La Grange, TXDec 4, 1975 · N9508X · Substantial damage NTSB FTW76FPA12Accident · Minor injuriesClosedGrumman AA1-B · Lancaster, TXDec 3, 1975 · N8896L · Substantial damage NTSB FTW76FPA11Accident · No injuriesClosedPiper PA-28 · Dallas, TXNov 30, 1975 · N55TB · Substantial damage NTSB FTW76FQG39Accident · 1 fatalClosedBellanca 7ECA · Plainview, TXNov 28, 1975 · N53789 · Substantial damage NTSB FTW76FPD21Accident · No injuriesClosedCessna 140 · Mineral Wells, TXNov 28, 1975 · N4204N · Substantial damage NTSB FTW76AF047Accident · 1 fatalClosedPiper PA-32 · San Marcos, TXNov 28, 1975 · N3606W · Destroyed NTSB FTW76FRG29Accident · Minor injuriesClosedPiper PA-32 · Wimberly, TXNov 24, 1975 · N3724W · Substantial damage NTSB FTW76FRJ13Accident · Minor injuriesClosedAmer Avco AA1-B · Ashland, TXNov 18, 1975 · N6514L · Substantial damage NTSB FTW76FPD19Accident · No injuriesClosedPiper PA-24 · Fort Worth, TXNov 12, 1975 · N8346P · Substantial damage NTSB FTW7LDQG38Accident · No injuriesClosedMonocoupe 90AL · Midland, TXNov 10, 1975 · N1161 · Substantial damage NTSB FTW76FPD18Accident · No injuriesClosedCessna 210 · Blue Mound, TXNov 9, 1975 · N9747X · Substantial damage NTSB FTW76FQG37Accident · No injuriesClosedCessna 172 · Lubbock, TXNov 8, 1975 · N2459L · Substantial damage NTSB FTW76AF042Accident · 2 fatalClosedLing-T-Vogt SA341G · Houston, TXNov 6, 1975 · N341FR · 2 aircraft · Substantial damage NTSB FTW76FRA16Accident · No injuriesClosedEnstrom F-28A · Houston, TXNov 3, 1975 · N494H · Substantial damage NTSB FTW76FQG36Accident · No injuriesClosedAmer Avco AA1-B · Amarillo, TXNov 2, 1975 · N6516L · Substantial damage NTSB FTW76DRG28Accident · No injuriesClosedAlon A-2 · San Antonio, TXNov 1, 1975 · N6593Q · Substantial damage NTSB FTW76DQG35Accident · No injuriesClosedGrumman G-164 · Slayton, TXNov 1, 1975 · N464Y · Substantial damage NTSB FTW76FPA10Accident · No injuriesClosedPiper PA-34 · Plano, TXOct 30, 1975 · N32510 · Destroyed NTSB FTW76FRA15Accident · Minor injuriesClosedBeech V35B · Houston, TXOct 29, 1975 · N1655W · Substantial damage NTSB FTW76AF038Accident · 2 fatalClosedCessna 210L · Magnolia, TXOct 29, 1975 · N5392V · Destroyed NTSB FTW76DQG41Accident · No injuriesClosedCessna 210 · Amarillo, TXOct 28, 1975 · N93155 · Substantial damage NTSB FTW76AF039Accident · 1 fatalClosedPiper PA-22 · Edna, TXOct 27, 1975 · N3543P · Destroyed NTSB FTW76FPD17Accident · Serious injuriesClosedCessna 175 · Denton, TXOct 25, 1975 · N7122M · Substantial damage NTSB FTW76AF037Accident · 1 fatalClosedPiper PA-17 · Fabens, TXOct 25, 1975 · N4861H · Destroyed NTSB FTW76DRA14Accident · No injuriesClosedSport Aire II · Yoakum, TXOct 21, 1975 · N77BT · Substantial damage NTSB FTW76AF035Accident · 1 fatalClosedAeronca 7AC · Calvert, TXOct 21, 1975 · N2921E · Destroyed NTSB FTW76DRG27Accident · No injuriesClosedPiper PA-11 · Chapman Ranch, TXOct 19, 1975 · N4856M · Substantial damage NTSB FTW76FPA09Accident · Minor injuriesClosedPiper PA-28 · Sherman, TXOct 18, 1975 · N8197N · Destroyed NTSB FTW76FPD16Accident · No injuriesClosedAeronca 7FC · Ft Worth, TXOct 17, 1975 · N4877E · Substantial damage NTSB FTW76FRJ11Accident · Minor injuriesClosedCessna 172 · Lake Hawkins, TXOct 16, 1975 · N7295A · Substantial damage NTSB FTW76AF033Accident · 2 fatalClosedBeech V35 · Diboll, TXOct 16, 1975 · N6237V · Destroyed NTSB FTW76AF032Accident · 4 fatalClosedMooney M20C · Robstown, TXOct 16, 1975 · N79333 · Destroyed NTSB FTW76FQG32Accident · 2 fatalClosedN.American P-51D · Carlsbad, TXOct 15, 1975 · N651D · Destroyed NTSB FTW76FQG31Accident · 1 fatalClosedN.American P-51D · Carlsbad, TXOct 15, 1975 · CF-USA · Destroyed NTSB FTW76FPD15Accident · No injuriesClosedCessna 182 · Fort Worth, TXOct 10, 1975 · N3328R · Substantial damage NTSB FTW76DQG29Accident · No injuriesClosedPiper PA-22 · Levelland, TXOct 9, 1975 · N9994D · Substantial damage NTSB FTW76AF029Accident · 1 fatalClosedBeech A45 · Houston, TXOct 9, 1975 · N8PW · Destroyed NTSB FTW76FQG30Accident · No injuriesClosedMooney M20K · Claude, TXOct 7, 1975 · N3706N · Substantial damage NTSB FTW76DPD14Accident · Minor injuriesClosedBellanca 14-19 · Ft Worth, TXOct 5, 1975 · N1283R · Substantial damage