Fatal NTSB investigations, 1976
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\") = 1976
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") = 1976 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 SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WANTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CANTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CANTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MINTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MONTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftNTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJNTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CANTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMNTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLNTSB CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INNTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHNTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVNTSB NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MANTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CANTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDNTSB DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CONTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MINTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CANTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKNTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXNTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CANTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INNTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WINTSB FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKNTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRNTSB DCA77AA006Accident · 3 fatalClosedDehavilland DHC-6 · Wildwood, NJNTSB OAK77FJA01Accident · 2 fatalClosedYankee AA1 · Wainiha, HINTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXNTSB DEN77FA013Accident · 1 fatalClosedCessna 120 · Sheridan, WYNTSB CHI77FEV06Accident · 1 fatalClosedHughes 369C · Pontiac, ILNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHNTSB CHI76FA013Accident · 1 fatalClosedCessna 421B · Winchester, INNTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXNTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INNTSB OAK77FA015Accident · 2 fatalClosedLockheed PV-1 · Yosemite, CANTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLNTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NENTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CANTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXNTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYNTSB LAX77FUJ10Accident · 1 fatalClosedScorpion TOO · Corona, CA