Skip to content

NTSB investigations, 1976, TX

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

NTSB investigations, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 FTW77FQG07Accident · Minor injuriesClosedNa Rockwell 112 · Wildorado, TXDec 31, 1976 · N1082J · Substantial damage NTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · Destroyed NTSB FTW77DQD04Accident · No injuriesClosedCessna 177 · El Paso, TXDec 28, 1976 · N30044 · Substantial damage NTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXDec 23, 1976 · N30AM · Destroyed NTSB FTW77FRG20Accident · No injuriesClosedLake LA-4 · San Antonio, TXDec 22, 1976 · N2036L · Substantial damage NTSB FTW77FPD06Accident · Minor injuriesClosedCessna 172 · Henrietta, TXDec 22, 1976 · N6972A · Substantial damage NTSB FTW77DRG21Accident · Minor injuriesClosedCessna 150 · Mason, TXDec 22, 1976 · N4808X · Substantial damage NTSB FTW77FQG06Accident · No injuriesClosedN. American TB-25N · Vega, TXDec 21, 1976 · N3680G · Substantial damage NTSB FTW77FRG19Accident · No injuriesClosedBeech D50 · San Marcos, TXDec 19, 1976 · N13011 · Destroyed NTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXDec 17, 1976 · N7379W · Destroyed NTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXDec 11, 1976 · N1455F · Destroyed NTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXDec 10, 1976 · N3091Y · Destroyed NTSB FTW77FRG16Accident · No injuriesClosedAero Comdr 680E · Mineral, TXDec 9, 1976 · N344V · Destroyed NTSB FTW77FRG17Accident · No injuriesClosedCessna 320D · Austin, TXDec 6, 1976 · N3310Q · Substantial damage NTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXDec 5, 1976 · N5204A · Destroyed NTSB FTW77FPD05Accident · No injuriesClosedCessna 150F · Ft. Worth, TXNov 28, 1976 · N8019S · Substantial damage NTSB FTW77DRG13Accident · No injuriesClosedPiper PA-28 · Killeen, TXNov 26, 1976 · N1726T · Substantial damage NTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNov 21, 1976 · N66A · Destroyed NTSB FTW77FA014Accident · 1 fatalClosedCessna 210B · Waelder, TXNov 19, 1976 · N9705X · Destroyed NTSB FTW77FA013Accident · 1 fatalClosedPiper PA-28 · Rosebud, TXNov 19, 1976 · N9061W · Destroyed NTSB FTW77FA012Accident · Minor injuriesClosedBeech D18S · Sachse, TXNov 19, 1976 · N2050D · Destroyed NTSB FTW77DRA05Accident · No injuriesClosedPiper PA-28 · Houston, TXNov 15, 1976 · N5114L · Substantial damage NTSB FTW77KQG04Accident · Serious injuriesClosedCessna 172 · Petersburg, TXNov 12, 1976 · N8267B · Destroyed NTSB FTW77DQG05Accident · No injuriesClosedMooney M20C · Amarillo, TXNov 12, 1976 · N7167U · Substantial damage NTSB FTW77FRG09Accident · No injuriesClosedPiper PA-23 · Rachal, TXNov 11, 1976 · XB-HAO · Substantial damage NTSB FTW77FRA04Accident · Serious injuriesClosedCessna 150M · Chester, TXNov 10, 1976 · N10EB · Destroyed NTSB FTW77DRA03Accident · No injuriesClosedCessna 150 · Texas City, TXNov 7, 1976 · N8018F · Substantial damage NTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · Destroyed NTSB FTW77FA010Accident · 2 fatalClosedCessna A150M · Cypress, TXNov 5, 1976 · N9871J · Destroyed NTSB FTW77FPD04Accident · No injuriesClosedPiper PA-25 · Anson, TXNov 3, 1976 · N9733P · Substantial damage NTSB FTW77DQD02Accident · Minor injuriesClosedCessna 210H · Pecos, TXNov 1, 1976 · N5938F · Destroyed NTSB FTW77FPD03Accident · Minor injuriesClosedPiper PA-28 · Roanoke, TXOct 31, 1976 · N6498W · Substantial damage NTSB FTW77DRG06Accident · No injuriesClosedCessna 182 · Elmendorf, TXOct 31, 1976 · N6091B · Substantial damage NTSB FTW77DRA02Accident · Minor injuriesClosedVollman EAA · Huntsville, TXOct 30, 1976 · N20MV · Substantial damage NTSB FTW77DRA01Accident · No injuriesClosedDemoiselle A · Columbus, TXOct 30, 1976 · N65269 · Destroyed NTSB FTW77DRG04Accident · No injuriesClosedBell 47G · Sonora, TXOct 26, 1976 · N7732 · Substantial damage NTSB FTW77FRG03Accident · Serious injuriesClosedBell 47G-4A · Laredo, TXOct 24, 1976 · N62445 · Destroyed NTSB FTW77FRG05Accident · 1 fatalClosedAir Tractor AT-301 · La Feria, TXOct 22, 1976 · N4343S · Destroyed NTSB FTW77FA006Accident · 1 fatalClosedCessna 210B · Granbury, TXOct 21, 1976 · N9640X · Substantial damage NTSB FTW77FA005Accident · 1 fatalClosedPiper PA-28R · Elmendorf, TXOct 18, 1976 · N5348T · Destroyed NTSB FTW77FRG07Accident · No injuriesClosedLake LA-4 · Los Fresnos, TXOct 16, 1976 · N6011V · Substantial damage NTSB FTW77FA004Accident · 4 fatalClosedPiper PA-23 · College Sta, TXOct 16, 1976 · N1434P · Destroyed NTSB FTW77FA007Accident · 1 fatalClosedBellanca 17-30 · Seguin, TXOct 15, 1976 · N4819V · Destroyed NTSB FTW77FQG02Accident · No injuriesClosedPiper PA-28 · Denver City, TXOct 14, 1976 · N8986W · Substantial damage NTSB FTW77FRG02Accident · Serious injuriesClosedBell 47G · Kerrville, TXOct 12, 1976 · N2772 · Destroyed NTSB FTW77FPD02Accident · No injuriesClosedPiper PA-28R · Arlington, TXOct 12, 1976 · N2130T · Substantial damage NTSB FTW77DQD01Accident · No injuriesClosedBeech V35 · Fort Hancock, TXOct 12, 1976 · XB-MAD · Substantial damage NTSB FTW77FRG01Accident · No injuriesClosedCessna 210K · Austin, TXOct 10, 1976 · N8262M · Substantial damage NTSB FTW77DQG03Accident · Minor injuriesClosedSnow 600S2R · Snyder, TXOct 9, 1976 · N4856X · Destroyed NTSB FTW76FPA01Accident · No injuriesClosedCessna 150 · Bonham, TXOct 9, 1976 · N5531G · Substantial damage