Skip to content

NTSB investigations, 1977, TX

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXDec 29, 1977 · N714ZQ · Destroyed NTSB FTW78FPA10Accident · Serious injuriesClosedMitsubishi MU-2J · Addison, TXDec 28, 1977 · N245MA · Substantial damage NTSB FTW78FPA11Accident · No injuriesClosedPiper PA-24 · Paris, TXDec 25, 1977 · N8509P · Substantial damage NTSB FTW78FPA09Accident · Minor injuriesClosedPiper PA-28 · Allen, TXDec 23, 1977 · N55285 · Destroyed NTSB FTW78DQD08Accident · 1 fatalClosedCessna 177RG · Coyanosa, TXDec 23, 1977 · CF-BTL · Destroyed NTSB FTW78FQD07Accident · No injuriesClosedBellanca 17-31 · Salt Flat, TXDec 22, 1977 · N8852V · Substantial damage NTSB FTW78FA019Accident · 2 fatalClosedPiper PA-28R · Giddings, TXDec 22, 1977 · N116MM · Destroyed NTSB FTW78FQG10Accident · Minor injuriesClosedPiper PA-18A · Sterling City, TXDec 21, 1977 · N2260A · Destroyed NTSB FTW78FRA11Accident · 1 fatalClosedLuscombe 8A · Pearland, TXDec 18, 1977 · N1285K · 2 aircraft · Destroyed NTSB FTW78FPD11Accident · No injuriesClosedRyan Navion · Denton, TXDec 18, 1977 · N4181K · Substantial damage NTSB FTW78DRG20Accident · Minor injuriesClosedGrum-Amer AA-1B · West Realitos, TXDec 18, 1977 · N1605R · Substantial damage NTSB FTW78DRG19Accident · No injuriesClosedCessna 172 · San Saba, TXDec 18, 1977 · N75594 · Substantial damage NTSB FTW78FPD10Accident · No injuriesClosedCessna 172 · Ft.Worth, TXDec 14, 1977 · N7960G · Substantial damage NTSB FTW78DRA10Accident · No injuriesClosedCessna 177 · Orange, TXDec 14, 1977 · N13734 · Substantial damage NTSB FTW78DQG15Accident · No injuriesClosedPiper PA-24 · Amarillo, TXDec 14, 1977 · N29BJ · Substantial damage NTSB FTW78FPD09Accident · No injuriesClosedPiper PA-28 · Colleyville, TXDec 13, 1977 · N7794C · Substantial damage NTSB FTW78FPA08Accident · No injuriesClosedBell 47J · Addison, TXDec 13, 1977 · N2895B · Substantial damage NTSB FTW78FA017Accident · 3 fatalClosedPiper PA-24 · Kerrville, TXDec 11, 1977 · N7126P · Destroyed NTSB FTW78DQD06Accident · No injuriesClosedCessna 305A · Wink, TXDec 11, 1977 · N5233G · Substantial damage NTSB FTW78DRG18Accident · No injuriesClosedBeech 58 · Laredo, TXDec 10, 1977 · N7212R · Substantial damage NTSB FTW78FPA07Accident · No injuriesClosedCessna A185F · Canton, TXDec 9, 1977 · N5401R · Substantial damage NTSB FTW78FPD08Accident · Minor injuriesClosedCessna P206 · Mineral Wells, TXDec 7, 1977 · N2675X · Destroyed NTSB FTW78DQD05Accident · No injuriesClosedBell 47J · El Paso, TXDec 6, 1977 · N2881B · Substantial damage NTSB FTW78FA015Accident · 3 fatalClosedCessna 310 · Wharton, TXDec 5, 1977 · N3000D · Destroyed NTSB FTW78DPA05Accident · No injuriesClosedTaylorcraft BC12-D · Trinidad, TXDec 5, 1977 · N44422 · Substantial damage NTSB FTW78FRA09Accident · Serious injuriesClosedPiper PA-28 · Baytown, TXDec 3, 1977 · N41261 · 2 aircraft · Destroyed NTSB FTW78DPA06Accident · No injuriesClosedCessna 150 · Plano, TXDec 3, 1977 · N5217Q · Substantial damage NTSB FTW78FQG09Accident · No injuriesClosedCessna T210L · Amarillo, TXDec 2, 1977 · N999MD · Substantial damage NTSB FTW78FA013Accident · No injuriesClosedCessna U206B · Georgetown, TXDec 2, 1977 · N3860G · Destroyed NTSB FTW78DQG08Accident · No injuriesClosedPiper PA-28 · Floydada, TXDec 2, 1977 · N6560W · Substantial damage NTSB FTW78FPD07Accident · No injuriesClosedBell 222 · Mansfield, TXDec 1, 1977 · N9992K · Substantial damage NTSB FTW78DPD06Accident · No injuriesClosedCessna 180 · Coleman, TXNov 27, 1977 · N3108C · Substantial damage NTSB FTW78FRG15Accident · Serious injuriesClosedMooney M20C · Blanco, TXNov 24, 1977 · N9661M · Substantial damage NTSB FTW78DRG16Accident · No injuriesClosedPiper PA-22 · Laredo, TXNov 23, 1977 · N9534D · Substantial damage NTSB FTW78FRA08Accident · Serious injuriesClosedPiper PA-24 · Houston, TXNov 22, 1977 · N6693P · Destroyed NTSB FTW78DPD05Accident · Minor injuriesClosedCessna 150H · Dublin, TXNov 20, 1977 · N7037S · Substantial damage NTSB FTW78DQD04Accident · No injuriesClosedStinson 108-1 · Marfa, TXNov 19, 1977 · N8553K · Substantial damage NTSB FTW78FQG07Accident · Serious injuriesClosedCessna L-19 · Lubbock, TXNov 16, 1977 · N117 · Destroyed NTSB FTW78FRA06Accident · No injuriesClosedNavion B · Leona, TXNov 13, 1977 · N2WD · Substantial damage NTSB FTW78DRG14Accident · No injuriesClosedCessna 152 · Port Mansfield, TXNov 13, 1977 · N24534 · Substantial damage NTSB FTW78DRA07Accident · No injuriesClosedPiper PA-28 · Tomball, TXNov 12, 1977 · N6258J · Substantial damage NTSB FTW78FA009Accident · No injuriesClosedBeech 99A · Killeen, TXNov 6, 1977 · N13RA · 2 aircraft · Substantial damage NTSB FTW78DRG11Accident · No injuriesClosedCessna 170B · Brady, TXNov 4, 1977 · N4695C · Substantial damage NTSB FTW78FPD04Accident · No injuriesClosedCessna 172 · Jacksboro, TXNov 3, 1977 · N3860L · Substantial damage NTSB FTW78FRG10Accident · Serious injuriesClosedPiper PA-25 · Laredo, TXNov 2, 1977 · N7048Z · Destroyed NTSB FTW78FA008Accident · 1 fatalClosedSchweizer 1-26B · Cedar Hill, TXOct 29, 1977 · N10368 · Destroyed NTSB FTW78DRA05Accident · Minor injuriesClosedPiper PA-22 · East Bernard, TXOct 28, 1977 · N1216C · Destroyed NTSB FTW78DQG06Accident · No injuriesClosedBellanca 8GCBC · Olton, TXOct 25, 1977 · N7616S · Substantial damage NTSB FTW78FA007Accident · 1 fatalClosedEsteen Skyblt · Albany, TXOct 24, 1977 · N4RH · Destroyed NTSB FTW78FRG07Accident · Serious injuriesClosedCessna 205 · Seguin, TXOct 22, 1977 · N8124Z · Destroyed