Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 FTW68F0411Accident · No injuriesClosedBeech A23 · Tyler, TXDec 29, 1967 · N6939Q · Substantial damage NTSB FTW68D0410Accident · Minor injuriesClosedCessna 310D · Midland, TXDec 29, 1967 · N6989T · Substantial damage NTSB FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXDec 27, 1967 · N7097P · Destroyed NTSB FTW68A0046Accident · No injuriesClosedAero Comdr 1121 · Houston, TXDec 26, 1967 · N650M · Substantial damage NTSB FTW68D0409Accident · No injuriesClosedBeech A23 · Lamesa, TXDec 24, 1967 · N5769V · Substantial damage NTSB FTW68D0393Accident · No injuriesClosedErco 415-C · Wichita Falls, TXDec 24, 1967 · N3387H · Substantial damage NTSB FTW68F0418Accident · No injuriesClosedCessna 177 · San Antonio, TXDec 23, 1967 · N2258Y · Substantial damage NTSB FTW68F0408Accident · Minor injuriesClosedCessna 150 · Angleton, TXDec 22, 1967 · N8898S · Destroyed NTSB FTW68D0458Accident · No injuriesClosedCessna 182 · Aspermont, TXDec 22, 1967 · N9360X · Substantial damage NTSB FTW68F0407Accident · Serious injuriesClosedMooney M-22 · Kerrville, TXDec 21, 1967 · N7710M · Destroyed NTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXDec 19, 1967 · N6885P · Destroyed NTSB FTW68F0399Accident · Minor injuriesClosedCessna 210C · Gatesville, TXDec 18, 1967 · N3928Y · Substantial damage NTSB FTW68F0385Accident · Serious injuriesClosedCessna 150 · Lorena, TXDec 15, 1967 · N8088F · Substantial damage NTSB FTW68F0384Accident · No injuriesClosedCessna 150G · Addison, TXDec 12, 1967 · N2731S · Substantial damage NTSB FTW68F0397Accident · No injuriesClosedBeech H35 · Anson, TXDec 11, 1967 · N5566D · Substantial damage NTSB FTW68F0383Accident · No injuriesClosedBeech A23 · Alief, TXDec 8, 1967 · N3695Q · Substantial damage NTSB FTW68D0396Accident · No injuriesClosedCessna 172 · San Marcos, TXDec 6, 1967 · N3607L · Substantial damage NTSB FTW68F0392Accident · No injuriesClosedCessna 172 · Jasper, TXDec 4, 1967 · N8140B · Substantial damage NTSB FTW68F0391Accident · No injuriesClosedCessna 310D · Addison, TXDec 3, 1967 · N6994T · Substantial damage NTSB FTW68D0380Accident · No injuriesClosedSchweizer 2-33 · Rockwall, TXDec 3, 1967 · N5704S · Substantial damage NTSB FTW68D0379Accident · No injuriesClosedPiper PA-24 · Ralls, TXDec 2, 1967 · N8445P · Substantial damage NTSB FTW68F0389Accident · Minor injuriesClosedCessna 182D · Ft.Stockton, TXDec 1, 1967 · N8718X · Substantial damage NTSB FTW68F0378Accident · No injuriesClosedBeech B35 · Plainview, TXDec 1, 1967 · N8877A · Substantial damage NTSB FTW68A0058Accident · 3 fatalClosedCessna 182 · Orange, TXDec 1, 1967 · N8952X · Destroyed NTSB FTW68D0388Accident · No injuriesClosedBellanca 17-30 · Cotulla, TXNov 30, 1967 · N6668V · Substantial damage NTSB FTW68D0377Accident · No injuriesClosedPiper PA-23 · Andrews, TXNov 30, 1967 · N5032Y · Substantial damage NTSB FTW68F0376Accident · No injuriesClosedCessna 182A · El Paso, TXNov 29, 1967 · N2108G · Substantial damage NTSB FTW68F0367Accident · No injuriesClosedCessna 150G · Lancaster, TXNov 27, 1967 · N2880S · Substantial damage NTSB FTW68A0055Accident · 1 fatalClosedCessna 310H · Alpine, TXNov 27, 1967 · N1118Q · Destroyed NTSB FTW68D0417Accident · No injuriesClosedCessna 206 · Pampa, TXNov 26, 1967 · N8058Z · Substantial damage NTSB FTW68D0375Accident · No injuriesClosedPiper PA-28 · Decatur, TXNov 25, 1967 · N9482J · Substantial damage NTSB FTW68D0370Accident · No injuriesClosedCessna 172H · Alief, TXNov 25, 1967 · N1717H · Substantial damage NTSB FTW68D0342Accident · No injuriesClosedCessna 150G · San Antonio, TXNov 25, 1967 · N2632J · Substantial damage NTSB FTW68F0374Accident · Serious injuriesClosedMooney M20C · San Antonio, TXNov 23, 1967 · N6471U · Substantial damage NTSB FTW68D0355Accident · No injuriesClosedBeech 65-A80 · Concan, TXNov 22, 1967 · N899Q · Destroyed NTSB FTW68F0416Accident · Serious injuriesClosedBoeing E75 · Lancaster, TXNov 19, 1967 · N16716 · Substantial damage NTSB FTW68D0337Accident · No injuriesClosedCessna 182 · Mason, TXNov 19, 1967 · N82N · Substantial damage NTSB FTW68F0363Accident · Serious injuriesClosedPiper PA-22 · Claude, TXNov 18, 1967 · N3235Z · Substantial damage NTSB FTW68F0353Accident · No injuriesClosedN.American SNJ-6 · Blue Mound, TXNov 18, 1967 · N3671F · Substantial damage NTSB FTW68D0395Accident · Minor injuriesClosedCessna 172H · Junction, TXNov 18, 1967 · N3772R · Destroyed NTSB FTW68D0373Accident · No injuriesClosedPiper PA-28 · Sherman, TXNov 18, 1967 · N7558R · Substantial damage NTSB FTW68A0050Accident · 1 fatalClosedN American P-51 · Brownwood, TXNov 18, 1967 · N12065 · Destroyed NTSB FTW68F0405Accident · No injuriesClosedBeech H35 · Texarkana, TXNov 15, 1967 · N5032B · Substantial damage NTSB FTW68A0049Accident · 1 fatalClosedPiper J-3 · New Gulf, TXNov 15, 1967 · N88369 · Destroyed NTSB FTW68D0351Accident · Minor injuriesClosedStinson 108-2 · Houston, TXNov 14, 1967 · N9668K · Substantial damage NTSB FTW68F0350Accident · No injuriesClosedCessna 210F · Houston, TXNov 13, 1967 · N6172R · Destroyed NTSB FTW68F0387Accident · No injuriesClosedBeech J35 · Beaumont, TXNov 12, 1967 · N8358D · Substantial damage NTSB FTW68D0372Accident · No injuriesClosedMooney M20E · Tahoka, TXNov 12, 1967 · N79819 · Substantial damage NTSB FTW68F0360Accident · No injuriesClosedPiper PA-28 · Lubbock, TXNov 10, 1967 · N6066W · Substantial damage NTSB FTW68D0426Accident · No injuriesClosedPiper PA-24 · Maude, TXNov 10, 1967 · N7811P · Substantial damage