NTSB investigations, 1964, TX

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1964, 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\") = 1964
    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 UNK65X1198Accident · No injuriesClosedCessna 182 · Houston, TXDec 31, 1964 · N5669B · Substantial damageNTSB UNK65X1167Accident · No injuriesClosedCessna 210 · Houston, TXDec 28, 1964 · N3706Y · Substantial damageNTSB UNK65X1165Accident · No injuriesClosedMooney M20D · Dallas, TXDec 27, 1964 · N1222X · Substantial damageNTSB UNK65X1151Accident · No injuriesClosedMooney M20C · El Paso, TXDec 27, 1964 · N6876U · Substantial damageNTSB UNK65X1142Accident · No injuriesClosedPiper PA24 · Wichita Falls, TXDec 26, 1964 · N8103P · Substantial damageNTSB UNK65X1126Accident · No injuriesClosedCessna 182 · Smyer, TXDec 25, 1964 · N8686T · Substantial damageNTSB UNK65X1125Accident · No injuriesClosedAeronca 11AC · Alanreed, TXDec 25, 1964 · N9815E · Substantial damageNTSB UNK65X1113Accident · No injuriesClosedCessna 182 · Mason, TXDec 24, 1964 · N8985X · Substantial damageNTSB UNK65X1112Accident · No injuriesClosedBeech C35 · Paris, TXDec 24, 1964 · N5846C · Substantial damageNTSB UNK65X1109Accident · No injuriesClosedCessna 172E · San Antonio, TXDec 24, 1964 · N5743T · Substantial damageNTSB UNK65X1104Accident · Serious injuriesClosedRyan ST-3KR · Lubbock, TXDec 23, 1964 · N579S · DestroyedNTSB UNK65X1086Accident · No injuriesClosedPiper PA28 · Addison, TXDec 22, 1964 · N6323W · Substantial damageNTSB UNK65X1085Accident · No injuriesClosedPiper PA22 · Andrews, TXDec 22, 1964 · N8764D · DestroyedNTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · DestroyedNTSB UNK65X1049Accident · No injuriesClosedPiper PA24 · Midland, TXDec 19, 1964 · N8289P · Substantial damageNTSB UNK65X1046Accident · No injuriesClosedBeechraft C45H · Boerne, TXDec 18, 1964 · N413TB · Substantial damageNTSB UNK65X1033Accident · No injuriesClosedPiper PA24 · Sugar Land, TXDec 17, 1964 · N6388P · Substantial damageNTSB UNK65X1024Accident · No injuriesClosedPiper PA22 · Sanford, TXDec 16, 1964 · N3751A · Substantial damageNTSB UNK65X1017Accident · No injuriesClosedErcoupe 415C · Sunray, TXDec 15, 1964 · N93988 · Substantial damageNTSB UNK65X1015Accident · No injuriesClosedHiller UH-12B · Pharr, TXDec 14, 1964 · N10195 · Substantial damageNTSB UNK65X1008Accident · No injuriesClosedCessna 182E · Austin, TXDec 14, 1964 · N3012Y · Substantial damageNTSB UNK65X1006Accident · No injuriesClosedTaylorcraft BC12D · Poteet, TXDec 13, 1964 · N29785 · Substantial damageNTSB UNK65X1004Accident · No injuriesClosedHiller UH12A · Austin, TXDec 13, 1964 · N6444D · Substantial damageNTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXDec 7, 1964 · N2393L · Substantial damageNTSB UNK65X0932Accident · No injuriesClosedCessna 120 · Houston, TXDec 5, 1964 · N90137 · Substantial damageNTSB UNK65X0928Accident · No injuriesClosedBoeing 75 · Normangee, TXDec 5, 1964 · N5214N · DestroyedNTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXDec 4, 1964 · N2360U · Substantial damageNTSB UNK65X0902Accident · No injuriesClosedCessna 182 · Houston, TXDec 2, 1964 · N3997D · Substantial damageNTSB UNK65X0901Accident · No injuriesClosedCessna 182 · Waco, TXDec 2, 1964 · N6127B · Substantial damageNTSB UNK65X0897Accident · No injuriesClosedBeechraft 65 · Midland, TXDec 2, 1964 · N456PC · Substantial damageNTSB UNK65X0878Accident · No injuriesClosedAeronca 7AC · Keller, TXNov 29, 1964 · N4320E · Substantial damageNTSB UNK65X0869Accident · 1 fatalClosedCessna 182A · Loma Alta, TXNov 28, 1964 · N6125B · DestroyedNTSB UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNov 28, 1964 · N7123X · DestroyedNTSB UNK65X0859Accident · No injuriesClosedCessna 310I · Houston, TXNov 27, 1964 · N8116M · Substantial damageNTSB UNK65X0856Accident · No injuriesClosedBeech J35 · San Antonio, TXNov 27, 1964 · N3066C · Substantial damageNTSB UNK65X0854Accident · No injuriesClosedCessna 210A · El Paso, TXNov 27, 1964 · N951E · Substantial damageNTSB UNK65X0852Accident · Serious injuriesClosedCessna 172B · Uvalde, TXNov 27, 1964 · N7857X · DestroyedNTSB UNK65X0834Accident · No injuriesClosedPiper PA18 · Marfa, TXNov 25, 1964 · N3994Z · Substantial damageNTSB UNK65X0833Accident · No injuriesClosedBeechcraft D18 · Alief, TXNov 25, 1964 · N62R · Substantial damageNTSB UNK65X0824Accident · No injuriesClosedPiper PA24 · Lowake, TXNov 25, 1964 · N7794P · Substantial damageNTSB UNK65X0801Accident · No injuriesClosedBeechcraft 35-A33 · Lowake, TXNov 22, 1964 · N630V · Substantial damageNTSB UNK65X0778Accident · No injuriesClosedPiper PA-28 · Bula, TXNov 21, 1964 · N6122W · Substantial damageNTSB UNK65X0774Accident · Minor injuriesClosedCessna 172 · Lorenzo, TXNov 21, 1964 · N8111X · Substantial damageNTSB UNK65X0736Accident · No injuriesClosedBeechcraft F35 · Dallas, TXNov 16, 1964 · N5089B · Substantial damageNTSB UNK65X0719Accident · No injuriesClosedCessna 310 · Waco, TXNov 15, 1964 · N90L · Substantial damageNTSB UNK65X0699Accident · No injuriesClosedBeechcraft M35 · Midland, TXNov 14, 1964 · N9817R · Substantial damageNTSB UNK65X0671Accident · No injuriesClosedCessna 210 · Kerrville, TXNov 12, 1964 · N9568X · Substantial damageNTSB UNK65X0657Accident · Minor injuriesClosedCessna 170B · Childress, TXNov 11, 1964 · N8106A · Substantial damageNTSB UNK65X0653Accident · No injuriesClosedPiper PA22 · Fort Mckavett, TXNov 11, 1964 · N2386A · Substantial damageNTSB UNK65X0646Accident · No injuriesClosedCessna 172B · Lubbock, TXNov 10, 1964 · N2182Y · Substantial damage