Fatal NTSB investigations, 1964
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 | 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 | 247 |
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.\"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") = 1964 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 UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKNTSB LAX65A0058Accident · 2 fatalClosedBeechcraft T34A · Wrightwood, CANTSB UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNNTSB UNK65X1192Accident · 3 fatalClosedCessna 182E · Ventura, CANTSB UNK65X1191Accident · 4 fatalClosedPiper PA-28 · Gorman, CANTSB UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MINTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARNTSB UNK65X1177Accident · 1 fatalClosedHeadskinner SJ-1 · Magnolia, OHNTSB UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTNTSB UNK65X1166Accident · 1 fatalClosedPiper PA-28 · King Salmon, AKNTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CANTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLNTSB UNK65X1150Accident · 4 fatalClosedBellanca 14-13 · Detroit, MINTSB UNK65X1149Accident · 2 fatalClosedPiper PA16 · La Habra, CANTSB UNK65X1134Accident · 1 fatalClosedPiper PA15 · Denham Springs, LANTSB UNK65X1122Accident · 2 fatalClosedPiper PA-24 · Philip, SDNTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KSNTSB UNK65X1119Accident · 2 fatalClosedMooney M20E · Show Low, AZNTSB UNK65X1118Accident · 1 fatalClosedPiper PA-24 · Bartonville, ILNTSB UNK65X1117Accident · 3 fatalClosedLockheed L-1049 · San Francisco, CANTSB UNK65X1108Accident · 3 fatalClosedPiper PA-22 · Salem, ORNTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNNTSB UNK65X1098Accident · 1 fatalClosedCessna 175 · Leeds, ALNTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNNTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORNTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXNTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILNTSB UNK65X1064Accident · 2 fatalClosedPiper PA-24 · Huntington Lk, CANTSB UNK65X1060Accident · 1 fatalClosedCessna 175 · Cloverdale, CANTSB UNK65X1059Accident · 1 fatalClosedPiper PA-24 · Ogden, UTNTSB UNK65X1047Accident · 2 fatalClosedBeechcraft C-50 · Altadena, CANTSB NYC65A0089Accident · 2 fatalClosedCessna 182G · Kasson, WVNTSB UNK65X1007Accident · 1 fatalClosedCessna 120 · Anaheim, CANTSB UNK65X1005Accident · 2 fatalClosedPiper PA-18 · Carrington Isl., UTNTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSNTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKNTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILNTSB UNK65X0990Accident · 1 fatalClosedDerringer D-1 · Palos Verdes, CANTSB UNK65X0972Accident · 1 fatalClosedCessna 310 · Napa, CANTSB UNK65X0971Accident · 4 fatalClosedCessna 172 · Torrance, CANTSB UNK65X0970Accident · 1 fatalClosedHughes 269A · Moraga, CANTSB UNK65X0964Accident · 1 fatalClosedCessna 185 · Norton Sound, AKNTSB UNK65X0956Accident · 1 fatalClosedPiper PA28 · Waterville, OHNTSB UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LANTSB UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNNTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLNTSB MIA65A0061Accident · 1 fatalClosedBellanca 14-19 · Bronson, FLNTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARNTSB UNK65X0908Accident · 5 fatalClosedCessna 172 · Shelby, NCNTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, IL