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
| 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
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.
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
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 UNK65X1198Accident · No injuriesClosedCessna 182 · Houston, TXNTSB UNK65X1167Accident · No injuriesClosedCessna 210 · Houston, TXNTSB UNK65X1165Accident · No injuriesClosedMooney M20D · Dallas, TXNTSB UNK65X1151Accident · No injuriesClosedMooney M20C · El Paso, TXNTSB UNK65X1142Accident · No injuriesClosedPiper PA24 · Wichita Falls, TXNTSB UNK65X1126Accident · No injuriesClosedCessna 182 · Smyer, TXNTSB UNK65X1125Accident · No injuriesClosedAeronca 11AC · Alanreed, TXNTSB UNK65X1113Accident · No injuriesClosedCessna 182 · Mason, TXNTSB UNK65X1112Accident · No injuriesClosedBeech C35 · Paris, TXNTSB UNK65X1109Accident · No injuriesClosedCessna 172E · San Antonio, TXNTSB UNK65X1104Accident · Serious injuriesClosedRyan ST-3KR · Lubbock, TXNTSB UNK65X1086Accident · No injuriesClosedPiper PA28 · Addison, TXNTSB UNK65X1085Accident · No injuriesClosedPiper PA22 · Andrews, TXNTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXNTSB UNK65X1049Accident · No injuriesClosedPiper PA24 · Midland, TXNTSB UNK65X1046Accident · No injuriesClosedBeechraft C45H · Boerne, TXNTSB UNK65X1033Accident · No injuriesClosedPiper PA24 · Sugar Land, TXNTSB UNK65X1024Accident · No injuriesClosedPiper PA22 · Sanford, TXNTSB UNK65X1017Accident · No injuriesClosedErcoupe 415C · Sunray, TXNTSB UNK65X1015Accident · No injuriesClosedHiller UH-12B · Pharr, TXNTSB UNK65X1008Accident · No injuriesClosedCessna 182E · Austin, TXNTSB UNK65X1006Accident · No injuriesClosedTaylorcraft BC12D · Poteet, TXNTSB UNK65X1004Accident · No injuriesClosedHiller UH12A · Austin, TXNTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXNTSB UNK65X0932Accident · No injuriesClosedCessna 120 · Houston, TXNTSB UNK65X0928Accident · No injuriesClosedBoeing 75 · Normangee, TXNTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXNTSB UNK65X0902Accident · No injuriesClosedCessna 182 · Houston, TXNTSB UNK65X0901Accident · No injuriesClosedCessna 182 · Waco, TXNTSB UNK65X0897Accident · No injuriesClosedBeechraft 65 · Midland, TXNTSB UNK65X0878Accident · No injuriesClosedAeronca 7AC · Keller, TXNTSB UNK65X0869Accident · 1 fatalClosedCessna 182A · Loma Alta, TXNTSB UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNTSB UNK65X0859Accident · No injuriesClosedCessna 310I · Houston, TXNTSB UNK65X0856Accident · No injuriesClosedBeech J35 · San Antonio, TXNTSB UNK65X0854Accident · No injuriesClosedCessna 210A · El Paso, TXNTSB UNK65X0852Accident · Serious injuriesClosedCessna 172B · Uvalde, TXNTSB UNK65X0834Accident · No injuriesClosedPiper PA18 · Marfa, TXNTSB UNK65X0833Accident · No injuriesClosedBeechcraft D18 · Alief, TXNTSB UNK65X0824Accident · No injuriesClosedPiper PA24 · Lowake, TXNTSB UNK65X0801Accident · No injuriesClosedBeechcraft 35-A33 · Lowake, TXNTSB UNK65X0778Accident · No injuriesClosedPiper PA-28 · Bula, TXNTSB UNK65X0774Accident · Minor injuriesClosedCessna 172 · Lorenzo, TXNTSB UNK65X0736Accident · No injuriesClosedBeechcraft F35 · Dallas, TXNTSB UNK65X0719Accident · No injuriesClosedCessna 310 · Waco, TXNTSB UNK65X0699Accident · No injuriesClosedBeechcraft M35 · Midland, TXNTSB UNK65X0671Accident · No injuriesClosedCessna 210 · Kerrville, TXNTSB UNK65X0657Accident · Minor injuriesClosedCessna 170B · Childress, TXNTSB UNK65X0653Accident · No injuriesClosedPiper PA22 · Fort Mckavett, TXNTSB UNK65X0646Accident · No injuriesClosedCessna 172B · Lubbock, TX