Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 FTW73DRA14Accident · No injuriesClosedCessna 177 · Tomball, TXDec 31, 1972 · N29434 · Substantial damage NTSB FTW73FQD12Accident · No injuriesClosedHelio Acft H-391B · El Paso, TXDec 30, 1972 · N316HW · Substantial damage NTSB FTW73AF033Accident · 4 fatalClosedBeech 65-80 · Kent, TXDec 29, 1972 · N9867 · Destroyed NTSB FTW73FRG40Accident · No injuriesClosedCessna 150 · Rockport, TXDec 28, 1972 · N8724G · Substantial damage NTSB FTW73FQG27Accident · Serious injuriesClosedCessna 150 · Adrian, TXDec 28, 1972 · N50030 · Substantial damage NTSB FTW73FRA13Accident · No injuriesClosedPiper PA-28 · Bellville, TXDec 27, 1972 · N4119J · Substantial damage NTSB FTW73DQG26Accident · Serious injuriesClosedPiper PA-22 · Amarillo, TXDec 25, 1972 · N7835D · No damage NTSB FTW73DPD17Accident · No injuriesClosedHiller Acft UH-12C · Valley View, TXDec 23, 1972 · N5328V · Substantial damage NTSB FTW73AF032Accident · 1 fatalClosedCessna 172F · Cleveland, TXDec 20, 1972 · N8589U · Destroyed NTSB FTW73AF031Accident · 2 fatalClosedPiper PA-28 · Grand Prairie, TXDec 20, 1972 · N9677W · Destroyed NTSB FTW73AF030Accident · 1 fatalClosedCessna 210J · Bedford, TXDec 18, 1972 · N3319S · Destroyed NTSB FTW73DRG32Accident · No injuriesClosedHughes 269A · Uvalde, TXDec 13, 1972 · N8774F · Substantial damage NTSB FTW73AF025Accident · 3 fatalClosedPiper PA-24 · Quemado, TXDec 9, 1972 · N7714P · Destroyed NTSB FTW73FRG31Accident · Minor injuriesClosedBell 206A · Stonewall, TXDec 8, 1972 · N6249N · Destroyed NTSB FTW73AF024Accident · 2 fatalClosedPiper PA-32 · Laredo, TXDec 8, 1972 · N5229S · Destroyed NTSB FTW73DRG30Accident · No injuriesClosedBell 47G-5 · Harlingen, TXDec 7, 1972 · N7923J · Substantial damage NTSB FTW73DRJ23Accident · No injuriesClosedPiper PA-28 · Hallsville, TXDec 6, 1972 · N1750T · Substantial damage NTSB FTW73AF023Accident · 3 fatalClosedPiper PA-32 · Baytown, TXDec 3, 1972 · N3782W · Destroyed NTSB FTW73FQG25Accident · Serious injuriesClosedStits SA6-B · Spearman, TXDec 2, 1972 · N5960 · Destroyed NTSB FTW73AF022Accident · 1 fatalClosedCessna 150E · Flatonia, TXDec 1, 1972 · N3034J · Destroyed NTSB FTW73DPA19Accident · No injuriesClosedCessna 150 · Greenville, TXNov 28, 1972 · N1706Q · Substantial damage NTSB FTW73FQG24Accident · No injuriesClosedAero Comdr 500-B · Sonora, TXNov 26, 1972 · N620TW · Substantial damage NTSB FTW73AF020Accident · 2 fatalClosedPiper PA-24 · Mt.Vernon, TXNov 22, 1972 · N5723P · Destroyed NTSB FTW73DRG28Accident · No injuriesClosedAero Comdr 500 · Fredricksburg, TXNov 20, 1972 · N3833C · Substantial damage NTSB FTW73AFO19Accident · 5 fatalClosedBeech B35 · Troy, TXNov 17, 1972 · N96V · Destroyed NTSB FTW73FPA18Accident · No injuriesClosedBeech A23 · Lancaster, TXNov 16, 1972 · N3590R · Substantial damage NTSB FTW73AFO18Accident · 1 fatalClosedCessna 182K · Eliasville, TXNov 12, 1972 · N657AK · Destroyed NTSB FTW73FRG25Accident · No injuriesClosedCessna 150L · Corps Christi, TXNov 11, 1972 · N1473Q · Substantial damage NTSB FTW73DPA17Accident · Minor injuriesClosedPiper J3C-85 · Grosebeck, TXNov 10, 1972 · N25102 · Destroyed NTSB FTW73FPD15Accident · No injuriesClosedBeech A23 · Roanoke, TXNov 9, 1972 · N1473L · Substantial damage NTSB FTW73AF017Accident · 2 fatalClosedAero Comdr 680 · Dallas, TXNov 6, 1972 · N6204D · Destroyed NTSB FTW73FRA12Accident · Serious injuriesClosedCessna 172 · Riverside, TXNov 5, 1972 · N7140A · Substantial damage NTSB FTW73AF016Accident · No injuriesClosedPiper PA-18 · Friendswood, TXNov 5, 1972 · N4612Y · 2 aircraft · Minor damage NTSB FTW73DQG22Accident · No injuriesClosedCessna 150L · Robert Lee, TXNov 4, 1972 · N18103 · Substantial damage NTSB FTW73FQG23Accident · Serious injuriesClosedGrumman G-164 · Roby, TXNov 3, 1972 · N10231 · Destroyed NTSB FTW73FPA16Accident · No injuriesClosedAeronca 11AC · Plano, TXNov 1, 1972 · N86311 · Substantial damage NTSB FTW73FQD09Accident · No injuriesClosedCessna 150 · Fabens, TXOct 30, 1972 · N7212S · Substantial damage NTSB FTW73AF026Accident · 2 fatalClosedCessna 421 · Fort Hancock, TXOct 29, 1972 · N5959M · Destroyed NTSB FTW73FRG24Accident · Serious injuriesClosedPiper PA-28 · Round Rock, TXOct 24, 1972 · N4256T · Destroyed NTSB FTW73AF014Accident · 7 fatalClosedPiper PA-24 · Goldthwaite, TXOct 20, 1972 · N9111P · Destroyed NTSB FTW73DRG22Accident · No injuriesClosedPiper PA-25 · Uvalde, TXOct 17, 1972 · N6662Z · Substantial damage NTSB FTW73AF013Accident · 2 fatalClosedPiper PA-28 · Comstock, TXOct 15, 1972 · N8018N · Destroyed NTSB FTW73FRA11Accident · Minor injuriesClosedMooney M20B · Brazoria, TXOct 13, 1972 · N74546 · Substantial damage NTSB FTW73FPD12Accident · No injuriesClosedCessna 182 · Weatherford, TXOct 6, 1972 · N2169G · Substantial damage NTSB FTW73DQG20Accident · No injuriesClosedCallair A-9A · Turkey, TXOct 5, 1972 · N9649Z · Substantial damage NTSB FTW73DRG35Accident · No injuriesClosedPiper PA-28 · Cypress Mill, TXOct 3, 1972 · N9419W · Substantial damage NTSB FTW73DQG21Accident · No injuriesClosedCessna 150 · Acuff, TXOct 2, 1972 · N6718G · Substantial damage NTSB FTW73APA13Accident · Minor injuriesClosedPiper PA-24 · Waco, TXSep 27, 1972 · N7702P · Substantial damage NTSB FTW73FPA14Accident · No injuriesClosedCessna 140 · Terrell, TXSep 26, 1972 · N77153 · Substantial damage NTSB FTW73DRG17Accident · No injuriesClosedBrezy Pushr 1 · Bend, TXSep 15, 1972 · N1154 · Substantial damage