Fatal NTSB investigations, 1965
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.
Cases per year
| 1962 | 11 |
|---|---|
| 1963 | 13 |
| 1964 | 539 |
| 1965 | 560 |
| 1966 | 581 |
| 1967 | 625 |
| 1968 | 718 |
| 1969 | 655 |
| 1970 | 643 |
| 1971 | 664 |
| 1972 | 697 |
| 1973 | 731 |
| 1974 | 727 |
| 1975 | 692 |
| 1976 | 707 |
| 1977 | 713 |
| 1978 | 800 |
| 1979 | 691 |
| 1980 | 672 |
| 1981 | 705 |
| 1982 | 638 |
| 1983 | 651 |
| 1984 | 617 |
| 1985 | 555 |
| 1986 | 507 |
| 1987 | 496 |
| 1988 | 502 |
| 1989 | 484 |
| 1990 | 499 |
| 1991 | 482 |
| 1992 | 494 |
| 1993 | 437 |
| 1994 | 445 |
| 1995 | 456 |
| 1996 | 421 |
| 1997 | 402 |
| 1998 | 422 |
| 1999 | 404 |
| 2000 | 443 |
| 2001 | 412 |
| 2002 | 417 |
| 2003 | 440 |
| 2004 | 418 |
| 2005 | 428 |
| 2006 | 408 |
| 2007 | 387 |
| 2008 | 373 |
| 2009 | 359 |
| 2010 | 363 |
| 2011 | 398 |
| 2012 | 389 |
| 2013 | 344 |
| 2014 | 360 |
| 2015 | 365 |
| 2016 | 341 |
| 2017 | 338 |
| 2018 | 361 |
| 2019 | 381 |
| 2020 | 294 |
| 2021 | 321 |
| 2022 | 330 |
| 2023 | 295 |
| 2024 | 292 |
| 2025 | 275 |
| 2026 | 248 |
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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal' 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 MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCNTSB SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORNTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CANTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXNTSB ANC66A0047Accident · 3 fatalClosedPiper PA-14 · Anchorage, AKNTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORNTSB MIA66A0073Accident · 3 fatalClosedPiper PA-24NTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTNTSB MIA66S0003Accident · 1 fatalClosedMooney M20E · Georgetwn, Burkina FasoNTSB MIA66A0072Accident · 1 fatalClosedMooney M-18C · Newbern, ALNTSB NYC66A0069Accident · 2 fatalClosedBeech D35 · Louisa, VANTSB ANC66A0026Accident · 2 fatalClosedPiper PA-24 · Umiat, AKNTSB MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDNTSB DEN66A0050Accident · 2 fatalClosedCessna 182 · Laveen, AZNTSB FTW66A0059Accident · 1 fatalClosedPiper J3 · Arlington, TXNTSB MIA66A0070Accident · 2 fatalClosedCessna 172C · Castle Hayne, NCNTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INNTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GANTSB MIA66F0402Accident · 1 fatalClosedBeechcraft A-23 · Southern Pines, NCNTSB DEN66A0048Accident · 3 fatalClosedLockheed L-1049 · Alamosa, CONTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PANTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYNTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALNTSB LAX66A0048Accident · 1 fatalClosedCessna 172C · Montello, NVNTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CONTSB DEN66A0044Accident · 2 fatalClosedCessna 120 · Kingman, AZNTSB OAK66A0028Accident · 3 fatalClosedCessna 182E · El Portal, CANTSB DEN66A0047Accident · 2 fatalClosedPiper PA-24 · Cuba, NMNTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CONTSB FTW66A0057Accident · 1 fatalClosedBeech 35-B33 · Goliad, TXNTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INNTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYNTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NENTSB LAX66A0047Accident · 2 fatalClosedCessna 172 · Winterhaven, CANTSB OAK66A0030Accident · 2 fatalClosedPiper J3C-S · PalauNTSB MIA66A0065Accident · 2 fatalClosedErcoupe F01 · UnkownNTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYNTSB OAK66A0026Accident · 1 fatalClosedMidget-Mstg MM-1 · Hollister, CANTSB MKC66A0033Accident · 1 fatalClosedAeronca 11AC · Iola, KSNTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GANTSB NYC66A0064Accident · 2 fatalClosedMaule M-4 · Windber, PANTSB MIA66F0346Accident · 1 fatalClosedPiper J4A · Greenville, MSNTSB DCA66A0005Accident · 4 fatalClosedLockheed L1049C · Carmel, NYNTSB NYC66A0063Accident · 2 fatalClosedNavion NAV-A · Fort Ann, NYNTSB NYC66A0062Accident · 1 fatalClosedCessna 337 · Glen Falls, NYNTSB OAK66A0025Accident · 1 fatalClosedCessna 182 · Stock, CANTSB FTW66A0054Accident · 2 fatalClosedBeech T34A · Gila Bend, AZNTSB MIA66D0419Accident · 1 fatalClosedCessna 150 · Marathon, FLNTSB FTW66S0002Accident · 2 fatalClosedErco 415-C · Saltillo, Mexico