Fatal NTSB investigations, 1966
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\") = 1966
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") = 1966 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 MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GANTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoNTSB MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSNTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CANTSB FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMNTSB SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTNTSB MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNNTSB DCA67R0001Accident · 4 fatalClosedCanadair CL-44 · Tourane, VMNTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CANTSB OAK67A0056Accident · 10 fatalClosedLockheed 18 · Baja, MexicoNTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCNTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHNTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CANTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILNTSB FTW67A0064Accident · 1 fatalClosedBoeing NA75A · Alamo, TXNTSB FTW67F0372Accident · 1 fatalClosedGlobe GC-1B · Bellville, TXNTSB CHI67A0074Accident · 1 fatalClosedBensen B8-M · Dowagiac, MINTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OHNTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTNTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDNTSB MKC67A0038Accident · 1 fatalClosedAero Comdr 680E · Minneapolis, MNNTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORNTSB LAX67A0057Accident · 1 fatalClosedPiper J-3C · Carlsbad, CANTSB FTW67A0063Accident · 1 fatalClosedCessna 150 · New Orleans, LANTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WANTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARNTSB DEN67A0035Accident · 2 fatalClosedBeech 65-88 · Woods Cross, UTNTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARNTSB CHI67A0072Accident · 1 fatalClosedPiper PA-22 · Pataskala, OHNTSB MKC67A0037Accident · 2 fatalClosedChampion 7DC · Anselmo, NENTSB FTW67A0060Accident · 1 fatalClosedCessna 182 · Ponca City, OKNTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNNTSB MIA67A0064Accident · 4 fatalClosedPiper PA-28 · St.Augustine, FLNTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LANTSB NYC67A0090Accident · 2 fatalClosedPiper PA-23 · Copenhagen, NYNTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNNTSB LAX67A0054Accident · 1 fatalClosedCessna 150 · Santee, CANTSB OAK67F0185Accident · 1 fatalClosedCessna 172 · Wailau, HINTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANTSB SEA67A0038Accident · 2 fatalClosedCessna 182H · Frances, WANTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANTSB MKC67A0036Accident · 2 fatalClosedCessna 172G · Elkhorn, IANTSB DEN67A0033Accident · 1 fatalClosedStinson 108-1 · Sterling, CONTSB CHI67A0067Accident · 4 fatalClosedPiper PA-28 · Madison, WI