NTSB investigations, 1965, 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.

Cases per year

19622026
NTSB investigations, 1965, TX per year, 1962–2026: 12,312 cases
19623
19632
1964397
1965415
1966429
1967433
1968360
1969357
1970330
1971310
1972260
1973292
1974318
1975292
1976312
1977316
1978276
1979304
1980293
1981367
1982295
1983256
1984255
1985229
1986185
1987195
1988153
1989154
1990143
1991132
1992130
1993136
1994119
1995164
1996141
1997138
1998141
1999136
2000140
2001135
2002119
2003126
2004137
2005129
2006108
2007117
2008125
2009120
2010127
2011121
2012126
2013102
2014120
2015110
2016126
201791
2018119
2019116
2020116
202197
2022118
2023104
2024101
2025103
202691

Latest cases

Query with SQL
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\") = 1965
    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.

NTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXDec 30, 1965 · N126Y · DestroyedNTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXDec 29, 1965 · N4554D · DestroyedNTSB FTW66F0472Accident · No injuriesClosedBeechcraft D50 · Mcallen, TXDec 28, 1965 · N4338D · Substantial damageNTSB FTW66F0565Accident · Serious injuriesClosedAero CDR 520 · Abernathy, TXDec 27, 1965 · N33L · DestroyedNTSB FTW66D0489Accident · No injuriesClosedBeechcraft P-35 · Hilltop Lakes, TXDec 24, 1965 · N1720G · Substantial damageNTSB FTW66D0488Accident · No injuriesClosedNavion A · Harlingen, TXDec 23, 1965 · N4507K · Substantial damageNTSB FTW66A0059Accident · 1 fatalClosedPiper J3 · Arlington, TXDec 20, 1965 · N38620 · DestroyedNTSB FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXDec 19, 1965 · N7190T · Substantial damageNTSB FTW66A0058Incident · No injuriesClosedBoeing 727 · Amarillo, TXDec 16, 1965 · N9851TW · Minor damageNTSB FTW66F0459Accident · No injuriesClosedCessna 150B · Longview, TXDec 14, 1965 · N7289X · Substantial damageNTSB FTW66F0430Accident · Minor injuriesClosedPiper PA-22 · Fort Worth, TXDec 11, 1965 · N2370P · Substantial damageNTSB FTW66D0454Accident · No injuriesClosedCessna 150 · Bryan, TXDec 11, 1965 · N6243T · Substantial damageNTSB FTW66D0439Accident · No injuriesClosedCessna 182 · Pecos, TXDec 11, 1965 · N3598U · Substantial damageNTSB FTW66F0504Accident · Serious injuriesClosedPiper PA-23 · Dexter, TXDec 10, 1965 · N52024 · Substantial damageNTSB FTW66A0057Accident · 1 fatalClosedBeech 35-B33 · Goliad, TXDec 10, 1965 · N9752Y · DestroyedNTSB FTW66F0453Accident · No injuriesClosedCessna 172 · Houston, TXDec 9, 1965 · N8935B · Substantial damageNTSB FTW66A0056Accident · No injuriesClosedBell 47J-2 · Refugio, TXDec 9, 1965 · N73902 · Substantial damageNTSB FTW66F0438Accident · No injuriesClosedCessna 150 · Houston, TXDec 8, 1965 · N7860E · Substantial damageNTSB FTW66D0448Accident · No injuriesClosedCessna 150 · Houston, TXDec 8, 1965 · N5911T · Substantial damageNTSB FTW66D0436Accident · No injuriesClosedBuecker 131 · Waco, TXDec 8, 1965 · N154S · Substantial damageNTSB FTW66F0429Accident · No injuriesClosedMooney M20C · Fort Worth, TXDec 7, 1965 · N78870 · Substantial damageNTSB FTW66F0447Accident · No injuriesClosedCessna 185B · Orange, TXDec 6, 1965 · N2532Z · Substantial damageNTSB FTW66F0446Accident · No injuriesClosedAlon A2 · Amarillo, TXDec 6, 1965 · N6572Q · 2 aircraft · Substantial damageNTSB FTW66A0055Accident · No injuriesClosedDouglas A-26 · San Antonio, TXDec 6, 1965 · N507WB · Substantial damageNTSB FTW66F0444Accident · No injuriesClosedCessna 195 · Sugarland, TXDec 5, 1965 · N9389A · Substantial damageNTSB FTW66F0435Accident · No injuriesClosedCessna 180C · Alvin, TXDec 5, 1965 · N9203T · Substantial damageNTSB FTW66F0428Accident · No injuriesClosedLuscombe 8A · Bowie, TXDec 5, 1965 · N45404 · Substantial damageNTSB FTW66D0443Accident · No injuriesClosedPiper PA-22 · Johnson City, TXDec 5, 1965 · N5111Z · Substantial damageNTSB FTW66D0411Accident · No injuriesClosedCessna 150F · Morton, TXNov 30, 1965 · N8108S · Substantial damageNTSB FTW66A0053Accident · No injuriesClosedHughes 269A · Lubbock, TXNov 30, 1965 · N8926F · Substantial damageNTSB FTW66F0427Accident · No injuriesClosedCessna 172 · Megargel, TXNov 29, 1965 · N2916U · Substantial damageNTSB FTW66D0457Accident · No injuriesClosedPiper PA-22 · Spearman, TXNov 28, 1965 · N3752P · Substantial damageNTSB FTW66D0442Accident · No injuriesClosedErcoupe 415-C · Teague, TXNov 27, 1965 · N93884 · Substantial damageNTSB FTW66A0052Accident · No injuriesClosedPiper PA-24 · Mcallen, TXNov 27, 1965 · N8393P · Substantial damageNTSB FTW66D0441Accident · No injuriesClosedPiper PA-22 · Amarillo, TXNov 26, 1965 · N3382B · Substantial damageNTSB FTW66D0399Accident · No injuriesClosedCessna 172 · Dallas, TXNov 24, 1965 · N722LC · Substantial damageNTSB FTW66F0456Accident · No injuriesClosedPiper PA-22 · Bandera, TXNov 22, 1965 · N2828P · Substantial damageNTSB FTW66F0426Accident · No injuriesClosedMooney M20B · Galveston, TXNov 22, 1965 · N74736 · Substantial damageNTSB FTW66F0410Accident · No injuriesClosedBeechcraft 95 · Karnack, TXNov 21, 1965 · N8294D · Substantial damageNTSB FTW66D0425Accident · No injuriesClosedBellanca 14-19 · Beamont, TXNov 21, 1965 · N8883R · Substantial damageNTSB FTW66D0409Accident · No injuriesClosedCessna 180 · Bandera, TXNov 21, 1965 · N2999A · Substantial damageNTSB FTW66F0408Accident · Serious injuriesClosedPiper PA-18A · Memphis, TXNov 20, 1965 · N9443D · DestroyedNTSB FTW66F0398Accident · No injuriesClosedPiper PA-28 · Elpaso, TXNov 20, 1965 · N6860W · Substantial damageNTSB FTW66D0432Accident · No injuriesClosedPiper PA-28 · Littlefield, TXNov 19, 1965 · N6031W · Substantial damageNTSB FTW66F0397Accident · No injuriesClosedBeechcraft F35 · Arlington, TXNov 18, 1965 · N266S · Substantial damageNTSB FTW66D0423Accident · No injuriesClosedCessna 182H · Midland, TXNov 18, 1965 · N3497S · Substantial damageNTSB FTW66F0381Accident · No injuriesClosedBeechcraft 95-A55 · El Paso, TXNov 16, 1965 · N8501M · Substantial damageNTSB FTW66F0380Accident · No injuriesClosedPiper PA-23 · Dallas, TXNov 14, 1965 · N3218P · Substantial damageNTSB FTW66D0406Accident · No injuriesClosedPiper J3C-65 · Humble, TXNov 13, 1965 · N35674 · Substantial damageNTSB FTW66F0395Accident · No injuriesClosedBeech 35-33 · Tyler, TXNov 10, 1965 · N634V · Substantial damage