Fatal NTSB investigations, 1973
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 243 |
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\") = 1973
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") = 1973 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 OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CANTSB ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKNTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WANTSB MIA74AM051Accident · 2 fatalClosedMooney M20F · Huntsville, ALNTSB IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYNTSB LAX74AL047Accident · 5 fatalClosedCessna 210-5 · Hesperia, CANTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILNTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WANTSB IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDNTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LANTSB OAK74AP025Accident · 3 fatalClosedBeech C35 · Kings Ldg, CANTSB FTW74AF047Accident · 1 fatalClosedBeech C-45H · Dallas, TXNTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CONTSB MKC74AK035Accident · 6 fatalClosedBeech 95-55 · New Salem, NDNTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CANTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SDNTSB MIA74FLD49Accident · 1 fatalClosedPitts S1C · Leesburg, FLNTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILNTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPNTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PANTSB LAX74OL049Accident · 4 fatalClosedMooney M20C · Mulege, MexicoNTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXNTSB OAK74FJA11Accident · 4 fatalClosedPiper PA-28 · Kukuihaele, HINTSB OAK74AP026Accident · 3 fatalClosedCessna 172I · Callahan, CANTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PANTSB NYC74IN055Incident · 1 fatalClosedBoeing 727 · Syracuse, NYNTSB NYC74AN056Accident · 2 fatalClosedBeech 95-B55 · Colonie, NYNTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoNTSB MIA74AM049Accident · 2 fatalClosedBeech C90 · W Columbia, SCNTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CANTSB LAX74AL044Accident · 2 fatalClosedPiper PA-28 · Corona, CANTSB OAK74AP023Accident · 2 fatalClosedPiper PA-22 · Concord, CANTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INNTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSNTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKNTSB UNK74X0101Incident · 31 fatalClosedBoeing 707 · Rome, ItalyNTSB FTW74AF043Accident · 2 fatalClosedAeronca 7BCM · Grainola, OKNTSB MKC74AK032Accident · 1 fatalClosedBellanca 7GCBC · Lebanon, SDNTSB DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYNTSB DCA74AZ013Accident · 3 fatalClosedLockheed 1049H · Miami, FLNTSB ANC74AA049Accident · 2 fatalClosedPiper PA-18 · Puntilla, AKNTSB MKC74AK031Accident · 1 fatalClosedBeech 95-B55 · Willow Springs, MONTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MONTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VANTSB OAK74FVG20Accident · 1 fatalClosedSemco T · Chico, CANTSB NYC74FHD28Accident · 1 fatalClosedTaylor Mono · Millville, NJNTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTNTSB CHI74AC047Accident · 1 fatalClosedChampion 7GCAA · South Haven, MINTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PANTSB FTW74DRD20Accident · 2 fatalClosedCessna 182 · Mexico City, Mexico