Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 FTW74FQG36Accident · No injuriesClosedBell 47G-2 · Stratford, TXDec 30, 1973 · N6708D · Substantial damage NTSB FTW74AF047Accident · 1 fatalClosedBeech C-45H · Dallas, TXDec 26, 1973 · N118X · Destroyed NTSB FTW74FRA21Accident · Serious injuriesClosedMaule M4220C · Cordele, TXDec 24, 1973 · N2005U · Destroyed NTSB FTW74DRG44Accident · Minor injuriesClosedLuscombe 8A · New Braunfels, TXDec 23, 1973 · N45722 · Substantial damage NTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXDec 22, 1973 · N2227J · Destroyed NTSB FTW74AF045Accident · Serious injuriesClosedBeech C-45H · Waco, TXDec 20, 1973 · N2122 · Destroyed NTSB FTW74FRJ21Accident · No injuriesClosedHelio Acft H-295 · Mt.Pleasant, TXDec 15, 1973 · N6350V · Substantial damage NTSB FTW74DRG43Accident · No injuriesClosedAeronca 7AC · Marble Falls, TXDec 14, 1973 · N2603E · Substantial damage NTSB FTW74DPD32Accident · No injuriesClosedStinson 108 · Mineral Wells, TXDec 12, 1973 · N8406K · Substantial damage NTSB FTW74DQG33Accident · No injuriesClosedPiper PA-25 · Floydada, TXDec 11, 1973 · N6057Z · Substantial damage NTSB FTW74DRG42Accident · No injuriesClosedMooney M20C · San Antonio, TXDec 9, 1973 · CF-PXG · Substantial damage NTSB FTW74FPD31Accident · Minor injuriesClosedPiper PA-22 · Grapevine, TXDec 6, 1973 · N1176C · Substantial damage NTSB FTW74DRG39Accident · No injuriesClosedCessna 172 · Austin, TXDec 4, 1973 · N84148 · Substantial damage NTSB FTW74AF040Accident · 1 fatalClosedMitsubishi MU-2B · Coleman, TXDec 3, 1973 · N307MA · Substantial damage NTSB FTW74DRJ20Accident · Minor injuriesClosedCessna 182 · Lufkin, TXDec 2, 1973 · N5991B · Substantial damage NTSB FTW74DPA13Accident · No injuriesClosedCessna 150L · Poynor, TXNov 30, 1973 · N5302Q · Substantial damage NTSB FTW74AF039Accident · 2 fatalClosedCessna 337 · Marathon, TXNov 27, 1973 · N86198 · Destroyed NTSB FTW74AF038Accident · 2 fatalClosedPiper PA-23 · Navasota, TXNov 25, 1973 · N2067P · Destroyed NTSB FTW74DQG34Accident · No injuriesClosedCessna 177RG · Lehman, TXNov 24, 1973 · N8015G · Substantial damage NTSB FTW74DPD30Accident · Minor injuriesClosedBensen B8M · Olney, TXNov 23, 1973 · N6237 · Destroyed NTSB FTW74DPD29Accident · Minor injuriesClosedCessna 150F · Breckenridge, TXNov 22, 1973 · N8073S · Destroyed NTSB FTW74FRG35Accident · Minor injuriesClosedAmer Avco AA-1A · Brownsville, TXNov 21, 1973 · N6426L · Substantial damage NTSB FTW74DPD27Accident · Minor injuriesClosedPiper PA-24 · Abilene, TXNov 21, 1973 · N6572P · Substantial damage NTSB FTW74AF033Accident · 1 fatalClosedCessna 150F · Plano, TXNov 18, 1973 · N8336G · Destroyed NTSB FTW74FQG28Accident · Minor injuriesClosedN.American AT-6 · Shallowater, TXNov 17, 1973 · N7000S · Substantial damage NTSB FTW74DRG34Accident · No injuriesClosedMorane FI156C · Harlingen, TXNov 16, 1973 · N43FS · Substantial damage NTSB FTW74DPD28Accident · No injuriesClosedPiper PA-20 · Denton, TXNov 16, 1973 · N7714K · Substantial damage NTSB FTW74DPA11Accident · No injuriesClosedCallair A-9 · Wilson, TXNov 16, 1973 · N3583G · Substantial damage NTSB FTW74FPD26Accident · 1 fatalClosedPiper PA-25 · Munday, TXNov 15, 1973 · N6915Z · Destroyed NTSB FTW74DQG31Accident · No injuriesClosedGrumman G-164 · Waka, TXNov 15, 1973 · N6592 · Destroyed NTSB FTW74FRG33Accident · No injuriesClosedCessna A188 · Port Isabel, TXNov 12, 1973 · N3500Q · Substantial damage NTSB FTW74DRG32Accident · No injuriesClosedCessna 172L · Zapata, TXNov 10, 1973 · N4341Q · Substantial damage NTSB FTW74DQG27Accident · No injuriesClosedCessna 210 · Hereford, TXNov 8, 1973 · N3766Y · Substantial damage NTSB FTW04DRG41Accident · No injuriesClosedPiper PA-32 · Corpus Chrsti, TXNov 7, 1973 · N55848 · Substantial damage NTSB FTW74AF029Accident · 2 fatalClosedCessna 310I · Euless, TXNov 6, 1973 · N8077M · Destroyed NTSB FTW74AF028Accident · 1 fatalClosedN.American AT-6G · Paris, TXNov 5, 1973 · N2885G · Destroyed NTSB FTW74DPD21Accident · No injuriesClosedLuscombe 8A · Denton, TXNov 4, 1973 · N28759 · Substantial damage NTSB FTW74AF035Accident · 2 fatalClosedCessna 172K · Cherokee, TXNov 4, 1973 · N79049 · Destroyed NTSB FTW74AF027Accident · 4 fatalClosedAero Comdr 100 · Dialville, TXNov 4, 1973 · N2940T · Destroyed NTSB FTW74FRA20Accident · Minor injuriesClosedMooney M20A · Huntsville, TXNov 3, 1973 · N6032X · Substantial damage NTSB FTW74DRA19Accident · No injuriesClosedPiper PA-28 · Angleton, TXNov 3, 1973 · N6380R · Substantial damage NTSB FTW74DPD22Accident · No injuriesClosedLockheed 18 · Eastland, TXNov 2, 1973 · N984E · Substantial damage NTSB FTW74FPA09Accident · Minor injuriesClosedPiper PA-28 · Addison, TXOct 31, 1973 · N5771F · Destroyed NTSB FTW74AF026Accident · No injuriesClosedBeech E18S · El Paso, TXOct 27, 1973 · N995H · Substantial damage NTSB FTW74FRJ18Accident · 1 fatalClosedCallair A-9 · Hooks, TXOct 26, 1973 · N3592G · Destroyed NTSB FTW74FQG24Accident · No injuriesClosedPiper PA-25 · Sylvester, TXOct 25, 1973 · N6623Z · Substantial damage NTSB FTW74FPD20Accident · 1 fatalClosedPiper PA-25 · Rochester, TXOct 25, 1973 · N7295Z · Destroyed NTSB FTW74FPA08Accident · Minor injuriesClosedPiper PA-25 · Caddo Mills, TXOct 25, 1973 · N6610Z · Destroyed NTSB FTW74FPD24Accident · No injuriesClosedMessrsmitt ME-109 · Brownwood, TXOct 24, 1973 · N109ME · Substantial damage NTSB FTW74DQG25Accident · No injuriesClosedBellanca 7ECA · Panhandle, TXOct 23, 1973 · N11665 · Substantial damage