NTSB investigations, 1965, 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.
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\") = 1965
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") = 1965 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 FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXNTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXNTSB FTW66F0472Accident · No injuriesClosedBeechcraft D50 · Mcallen, TXNTSB FTW66F0565Accident · Serious injuriesClosedAero CDR 520 · Abernathy, TXNTSB FTW66D0489Accident · No injuriesClosedBeechcraft P-35 · Hilltop Lakes, TXNTSB FTW66D0488Accident · No injuriesClosedNavion A · Harlingen, TXNTSB FTW66A0059Accident · 1 fatalClosedPiper J3 · Arlington, TXNTSB FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXNTSB FTW66A0058Incident · No injuriesClosedBoeing 727 · Amarillo, TXNTSB FTW66F0459Accident · No injuriesClosedCessna 150B · Longview, TXNTSB FTW66F0430Accident · Minor injuriesClosedPiper PA-22 · Fort Worth, TXNTSB FTW66D0454Accident · No injuriesClosedCessna 150 · Bryan, TXNTSB FTW66D0439Accident · No injuriesClosedCessna 182 · Pecos, TXNTSB FTW66F0504Accident · Serious injuriesClosedPiper PA-23 · Dexter, TXNTSB FTW66A0057Accident · 1 fatalClosedBeech 35-B33 · Goliad, TXNTSB FTW66F0453Accident · No injuriesClosedCessna 172 · Houston, TXNTSB FTW66A0056Accident · No injuriesClosedBell 47J-2 · Refugio, TXNTSB FTW66F0438Accident · No injuriesClosedCessna 150 · Houston, TXNTSB FTW66D0448Accident · No injuriesClosedCessna 150 · Houston, TXNTSB FTW66D0436Accident · No injuriesClosedBuecker 131 · Waco, TXNTSB FTW66F0429Accident · No injuriesClosedMooney M20C · Fort Worth, TXNTSB FTW66F0447Accident · No injuriesClosedCessna 185B · Orange, TXNTSB FTW66F0446Accident · No injuriesClosedAlon A2 · Amarillo, TXNTSB FTW66A0055Accident · No injuriesClosedDouglas A-26 · San Antonio, TXNTSB FTW66F0444Accident · No injuriesClosedCessna 195 · Sugarland, TXNTSB FTW66F0435Accident · No injuriesClosedCessna 180C · Alvin, TXNTSB FTW66F0428Accident · No injuriesClosedLuscombe 8A · Bowie, TXNTSB FTW66D0443Accident · No injuriesClosedPiper PA-22 · Johnson City, TXNTSB FTW66D0411Accident · No injuriesClosedCessna 150F · Morton, TXNTSB FTW66A0053Accident · No injuriesClosedHughes 269A · Lubbock, TXNTSB FTW66F0427Accident · No injuriesClosedCessna 172 · Megargel, TXNTSB FTW66D0457Accident · No injuriesClosedPiper PA-22 · Spearman, TXNTSB FTW66D0442Accident · No injuriesClosedErcoupe 415-C · Teague, TXNTSB FTW66A0052Accident · No injuriesClosedPiper PA-24 · Mcallen, TXNTSB FTW66D0441Accident · No injuriesClosedPiper PA-22 · Amarillo, TXNTSB FTW66D0399Accident · No injuriesClosedCessna 172 · Dallas, TXNTSB FTW66F0456Accident · No injuriesClosedPiper PA-22 · Bandera, TXNTSB FTW66F0426Accident · No injuriesClosedMooney M20B · Galveston, TXNTSB FTW66F0410Accident · No injuriesClosedBeechcraft 95 · Karnack, TXNTSB FTW66D0425Accident · No injuriesClosedBellanca 14-19 · Beamont, TXNTSB FTW66D0409Accident · No injuriesClosedCessna 180 · Bandera, TXNTSB FTW66F0408Accident · Serious injuriesClosedPiper PA-18A · Memphis, TXNTSB FTW66F0398Accident · No injuriesClosedPiper PA-28 · Elpaso, TXNTSB FTW66D0432Accident · No injuriesClosedPiper PA-28 · Littlefield, TXNTSB FTW66F0397Accident · No injuriesClosedBeechcraft F35 · Arlington, TXNTSB FTW66D0423Accident · No injuriesClosedCessna 182H · Midland, TXNTSB FTW66F0381Accident · No injuriesClosedBeechcraft 95-A55 · El Paso, TXNTSB FTW66F0380Accident · No injuriesClosedPiper PA-23 · Dallas, TXNTSB FTW66D0406Accident · No injuriesClosedPiper J3C-65 · Humble, TXNTSB FTW66F0395Accident · No injuriesClosedBeech 35-33 · Tyler, TX