Skip to content

NTSB investigations, 1966, TX

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 FTW67F0399Accident · Minor injuriesClosedCessna 150 · Palo Pinto, TXDec 30, 1966 · N7320X · Substantial damage NTSB FTW67F0428Accident · No injuriesClosedBeech F35 · Cotulla, TXDec 28, 1966 · N4233B · Substantial damage NTSB FTW67D0470Accident · No injuriesClosedPiper PA-24 · Lyford, TXDec 26, 1966 · N6028P · Substantial damage NTSB FTW67D0361Accident · No injuriesClosedCessna 172 · Grand Saline, TXDec 26, 1966 · N5810A · Substantial damage NTSB FTW67D0396Accident · No injuriesClosedCessna 180 · Nacogdoches, TXDec 25, 1966 · N9047C · Substantial damage NTSB FTW67D0395Accident · Minor injuriesClosedAeronca 7FC · Houston, TXDec 24, 1966 · N9817Y · Substantial damage NTSB FTW67F0393Accident · No injuriesClosedPiper PA-23 · Austin, TXDec 23, 1966 · N4367P · Substantial damage NTSB FTW67D0373Accident · No injuriesClosedBeech E35 · Dallas, TXDec 20, 1966 · N3317C · Substantial damage NTSB FTW67D0348Accident · No injuriesClosedCessna 182 · Muleshoe, TXDec 20, 1966 · N8399S · Substantial damage NTSB FTW67F0347Accident · Minor injuriesClosedCessna 172G · Pearland, TXDec 19, 1966 · N3728L · Substantial damage NTSB FTW67D0359Accident · No injuriesClosedCessna 150 · Burleson, TXDec 18, 1966 · N6424F · Substantial damage NTSB FTW67F0392Accident · No injuriesClosedPiper PA-16 · Odessa, TXDec 17, 1966 · N5790H · Substantial damage NTSB FTW67D0358Accident · No injuriesClosedBeech H35 · Dallas, TXDec 17, 1966 · N5032B · Substantial damage NTSB FTW67D0459Accident · No injuriesClosedMooney M20C · Vanderpool, TXDec 16, 1966 · N78917 · Substantial damage NTSB FTW67A0064Accident · 1 fatalClosedBoeing NA75A · Alamo, TXDec 14, 1966 · N73878 · Destroyed NTSB FTW67F0372Accident · 1 fatalClosedGlobe GC-1B · Bellville, TXDec 12, 1966 · N80521 · Destroyed NTSB FTW67D0357Accident · No injuriesClosedCessna 172 · Odessa, TXDec 12, 1966 · N1459F · Substantial damage NTSB FTW67F0344Accident · No injuriesClosedPiper PA-23 · Fort Worth, TXDec 8, 1966 · N1408P · Substantial damage NTSB FTW67F0343Accident · Minor injuriesClosedTemco D-16A · Saginaw, TXDec 4, 1966 · N129N · Substantial damage NTSB FTW67D0355Accident · No injuriesClosedMooney M20A · Cumby, TXDec 4, 1966 · N6596B · Substantial damage NTSB FTW67F0427Accident · No injuriesClosedPiper PA-22 · Kingsville, TXDec 3, 1966 · N6135D · Substantial damage NTSB FTW67D0342Accident · No injuriesClosedPiper PA-24 · Spearman, TXDec 2, 1966 · N6344P · Substantial damage NTSB FTW67D0341Accident · No injuriesClosedPiper PA-22 · Buffalo, TXDec 2, 1966 · N4803A · Substantial damage NTSB FTW67D0354Accident · Minor injuriesClosedErcoupe 415-C · Pecos, TXNov 30, 1966 · N87082 · Substantial damage NTSB FTW67D0340Accident · No injuriesClosedCessna 320B · Alief, TXNov 29, 1966 · N9836L · Substantial damage NTSB FTW67D0320Accident · No injuriesClosedCessna 150G · Beaumont, TXNov 29, 1966 · N2463J · Substantial damage NTSB FTW67F0370Accident · Serious injuriesClosedBeech D45 · Kingsville, TXNov 27, 1966 · N4946C · Destroyed NTSB FTW67D0391Accident · No injuriesClosedPiper PA-28 · San Antonio, TXNov 27, 1966 · N6319R · Substantial damage NTSB FTW67D0337Accident · No injuriesClosedBellanca 260 · Miami, TXNov 27, 1966 · N7624E · Substantial damage NTSB FTW67F0353Accident · No injuriesClosedCessna 182G · Spring Branch, TXNov 26, 1966 · N2315R · Substantial damage NTSB FTW67F0306Accident · No injuriesClosedCessna 150A · Abilene, TXNov 26, 1966 · N6669T · Destroyed NTSB FTW67D0390Accident · No injuriesClosedPiper PA-24 · Pumpville, TXNov 26, 1966 · N6568P · Substantial damage NTSB FTW67D0336Accident · No injuriesClosedStinson 108-3 · Houston, TXNov 26, 1966 · N798C · Substantial damage NTSB FTW67F0352Accident · No injuriesClosedAlon A-2 · El Paso, TXNov 24, 1966 · N6596Q · Substantial damage NTSB FTW67F0335Accident · No injuriesClosedTaylorcraft DC0-65 · Grapeland, TXNov 24, 1966 · N50630 · Substantial damage NTSB FTW67D0351Accident · Minor injuriesClosedCessna 150 · Dell City, TXNov 24, 1966 · N3657J · Destroyed NTSB FTW67D0334Accident · No injuriesClosedCessna 172 · Lubbock, TXNov 20, 1966 · N5717A · Substantial damage NTSB FTW68F0246Accident · Minor injuriesClosedPiper PA-22 · Dallas, TXNov 19, 1966 · N3238B · Substantial damage NTSB FTW67F0317Accident · No injuriesClosedPiper PA-18 · Mcallen, TXNov 19, 1966 · N4040Z · Substantial damage NTSB FTW67F0304Accident · No injuriesClosedErcoupe 415-C · Fort Worth, TXNov 19, 1966 · N93884 · Destroyed NTSB FTW67A0056Accident · No injuriesClosedHiller UH-12L · Woodville, TXNov 19, 1966 · N9780C · Substantial damage NTSB FTW67I0055Incident · No injuriesClosedConvair 880 · Carswell Afb, TXNov 18, 1966 · N8814E · Minor damage NTSB FTW67F0349Accident · Serious injuriesClosedCessna 170B · Angleton, TXNov 18, 1966 · N8044A · Substantial damage NTSB FTW67D0300Accident · No injuriesClosedPiper PA-24 · Columbus, TXNov 18, 1966 · N6200P · Substantial damage NTSB FTW67D0331Accident · No injuriesClosedCessna 182 · Hamilton, TXNov 17, 1966 · N2889Y · Substantial damage NTSB FTW67A0057Accident · 1 fatalClosedPiper PA-24 · Sanderson, TXNov 15, 1966 · N5519P · Destroyed NTSB FTW67A0054Accident · No injuriesClosedBeech C-45H · El Paso, TXNov 15, 1966 · N5558V · Substantial damage NTSB FTW67F0303Accident · No injuriesClosedPiper PA-22 · Addison, TXNov 13, 1966 · N8627C · Substantial damage NTSB FTW67F0323Accident · No injuriesClosedCessna 150 · San Antonio, TXNov 12, 1966 · N7036X · Substantial damage NTSB FTW67D0628Accident · No injuriesClosedCessna 205 · Dallas, TXNov 12, 1966 · N8289Z · Substantial damage