Skip to content

NTSB investigations, 1979, TX

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 FTW80DPD08Accident · No injuriesClosedCessna 172 · Denton, TXDec 26, 1979 · N75510 · Substantial damage NTSB FTW80FRG16Accident · No injuriesClosedCessna 152 · San Antonio, TXDec 24, 1979 · N68816 · Substantial damage NTSB FTW80DRJ08Accident · No injuriesClosedPiper PA-28 · Lufkin, TXDec 23, 1979 · N32639 · Substantial damage NTSB FTW80DRA15Accident · No injuriesClosedBeech 95-55 · Houston, TXDec 23, 1979 · N2155L · Substantial damage NTSB FTW80DQG07Accident · No injuriesClosedCessna 172 · Spearman, TXDec 23, 1979 · N2662U · Substantial damage NTSB FTW80FPD07Accident · No injuriesClosedCessna 120 · Lawn, TXDec 22, 1979 · N44BM · Substantial damage NTSB FTW80FA027Accident · 1 fatalClosedCessna 172H · Moshiem, TXDec 21, 1979 · N1792F · Destroyed NTSB FTW80FA026Accident · 2 fatalClosedCessna 182E · Comfort, TXDec 21, 1979 · N2853Y · Destroyed NTSB FTW80FRG15Accident · Minor injuriesClosedPiper PA-32 · Encinal, TXDec 20, 1979 · N607LJ · Destroyed NTSB FTW80DRA14Accident · No injuriesClosedMeyers 200 · La Porte, TXDec 20, 1979 · N495C · Substantial damage NTSB FTW80DQG06Accident · No injuriesClosedCessna 152 · Sweetwater, TXDec 20, 1979 · N4727B · Substantial damage NTSB FTW80DRA13Accident · No injuriesClosedBeech 95-A55 · Angleton, TXDec 17, 1979 · N910TL · Substantial damage NTSB FTW80FRG13Accident · 1 fatalClosedErco 415-C · Troy, TXDec 15, 1979 · N93477 · Destroyed NTSB FTW80FA021Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 15, 1979 · N57329 · Destroyed NTSB FTW80DRG12Accident · No injuriesClosedCessna 170 · Johnson City, TXDec 15, 1979 · N4153V · Substantial damage NTSB FTW80DRG14Accident · No injuriesClosedCessna 305 · Fort Hood, TXDec 8, 1979 · N13025 · Substantial damage NTSB FTW80DPA04Accident · No injuriesClosedGrumman G-164 · Lott, TXDec 8, 1979 · N472Y · Substantial damage NTSB FTW80FRA12Accident · No injuriesClosedCessna 152 · Eagle Lake, TXDec 7, 1979 · N49190 · Destroyed NTSB FTW80FRA11Accident · Minor injuriesClosedCessna 172N · Houston, TXDec 7, 1979 · N5720E · Substantial damage NTSB FTW80DRG11Accident · No injuriesClosedEnstrom F-28C · Port Mansfield, TXDec 7, 1979 · N51759 · Substantial damage NTSB FTW80FPA03Accident · No injuriesClosedCessna 172 · Terrell, TXDec 6, 1979 · N7912B · Substantial damage NTSB FTW80DRG10Accident · No injuriesClosedCessna 150 · Llano, TXDec 4, 1979 · N704YV · Substantial damage NTSB FTW80FQG05Accident · No injuriesClosedPiper PA-31T · San Angelo, TXDec 2, 1979 · N444JW · Destroyed NTSB FTW80DRG09Accident · No injuriesClosedBell 47G-5A · Alice, TXNov 29, 1979 · N58132 · Substantial damage NTSB FTW80FA019Accident · 1 fatalClosedMitsubishi MU-2B · Post Oak, TXNov 26, 1979 · N234MA · Destroyed NTSB FTW80IA018Incident · 1 fatalClosedLockheed L-1011 · Mineral Wells, TXNov 25, 1979 · N714DA · No damage NTSB FTW80DRA10Accident · No injuriesClosedCessna 172K · Arcola, TXNov 25, 1979 · N79573 · Substantial damage NTSB FTW80IA017Incident · No injuriesClosedCessna U206 · Centerville, TXNov 19, 1979 · N222LS · No damage NTSB FTW80DA015Accident · 1 fatalClosedCessna 210 · El Paso, TXNov 18, 1979 · N732ZR · Minor damage NTSB FTW80FA014Accident · 2 fatalClosedCessna 152 · Lillian, TXNov 17, 1979 · N7611B · Destroyed NTSB FTW80DQD02Accident · No injuriesClosedCessna 150 · Fort Stockton, TXNov 17, 1979 · N6383K · Substantial damage NTSB FTW80DA016Accident · No injuriesClosedScorpion II · Bay City, TXNov 17, 1979 · NONE · Substantial damage NTSB FTW80IA013Incident · No injuriesClosedAerospatle AS350D · Mansfield, TXNov 14, 1979 · N3596Z · No damage NTSB FTW80IA012Incident · No injuriesClosedCessna 500 · Dallas, TXNov 12, 1979 · N40JF · Minor damage NTSB FTW80FRG08Accident · Minor injuriesClosedPiper PA-28R · Jonestown, TXNov 11, 1979 · N6239C · Destroyed NTSB FTW80FPA02Accident · No injuriesClosedBellanca 17-30A · Dallas, TXNov 11, 1979 · N8270R · Destroyed NTSB FTW80FA011Accident · 2 fatalClosedCessna 172M · Sugarland, TXNov 11, 1979 · N21479 · Destroyed NTSB FTW80IA010Incident · No injuriesClosedDouglas DC-3C · Grand Prairie, TXNov 10, 1979 · N103CA · Minor damage NTSB FTW80DPD06Accident · No injuriesClosedCessna 182 · Roanoke, TXNov 7, 1979 · N2309G · Substantial damage NTSB FTW80DPD04Accident · Minor injuriesClosedCessna 172 · Wichita Falls, TXNov 7, 1979 · N737HE · Substantial damage NTSB FTW80FRA09Accident · Serious injuriesClosedBeech F35 · Silsbee, TXNov 3, 1979 · N4270B · Destroyed NTSB FTW80FRA08Accident · No injuriesClosedCessna 182 · Spring Creek, TXNov 3, 1979 · N5773B · Substantial damage NTSB FTW80DQG04Accident · No injuriesClosedPiper PA-32 · Crane, TXNov 3, 1979 · N32934 · Substantial damage NTSB FTW80FRA07Accident · Serious injuriesClosedCessna 182 · Houston, TXNov 2, 1979 · N2797Q · Minor damage NTSB FTW80FRA06Accident · No injuriesClosedPiper PA-28 · Houston, TXNov 2, 1979 · N4587R · Substantial damage NTSB FTW80DQG03Accident · No injuriesClosedBeech A23 · Dalhart, TXNov 2, 1979 · N7925L · Substantial damage NTSB FTW80FRA05Accident · No injuriesClosedCessna 340 · Katy, TXNov 1, 1979 · N5163J · Substantial damage NTSB FTW80DRG07Accident · No injuriesClosedBoeing B75N1 · Crystal City, TXNov 1, 1979 · N75939 · Substantial damage NTSB FTW80DA009Accident · No injuriesClosedCessna U206D · Lubbock, TXNov 1, 1979 · N71967 · Substantial damage NTSB FTW80IA006Incident · Minor injuriesClosedBeechcraft B99 · Abilene, TXOct 31, 1979 · N35CA · Minor damage