NTSB investigations, 1976
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
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 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 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 OAK77FVM05Accident · No injuriesClosedPiper PA-24 · San Carlos, CANTSB OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CANTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CANTSB OAK77DXQ04Accident · No injuriesClosedPiper PA28 · Winnemucca, NVNTSB NYC77FFJ08Accident · No injuriesClosedTed Smith 601 · Dunkirk, NYNTSB NYC77FA026Accident · Serious injuriesClosedPiper PA-30 · College Point, NYNTSB NYC77DHA10Accident · No injuriesClosedCessna 182K · Pittstown, NJNTSB MIA77FLD24Accident · Minor injuriesClosedCessna 401 · Tampa, FLNTSB MIA77FLD23Accident · Minor injuriesClosedLet-Np-K L-13 · Clearwater, FLNTSB LAX77FUG17Accident · No injuriesClosedMooney M20C · Big Bear City, CANTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CANTSB IAD77DKW11Accident · No injuriesClosedBrantly B2B · Fayetteville, TNNTSB FTW77FQG07Accident · Minor injuriesClosedNa Rockwell 112 · Wildorado, TXNTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMNTSB CHI77FEI08Accident · Minor injuriesClosedPiper PA-28 · Avon Lake, OHNTSB SEA77FYC12Accident · No injuriesClosedCessna TU206D · Farmington, ORNTSB MKC77FER12Accident · Minor injuriesClosedCessna 172 · Morris, MNNTSB MIA77FKG14Accident · Serious injuriesClosedPiper PA-28 · Cleveland, GANTSB IAD77DLJ03Accident · No injuriesClosedCessna 180 · Rougemont, NCNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXNTSB CHI77FEC08Accident · No injuriesClosedCessna 150 · Pontiac, MINTSB MKC77FER13Accident · No injuriesClosedCessna 182 · Brainerd, MNNTSB MKC77FCJ08Accident · Minor injuriesClosedBellanca 7ECA · Tecumseh, NENTSB MKC77FCD06Accident · Minor injuriesClosedAero-Star 600 · Pella, IANTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NENTSB MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCNTSB LAX77FA017Accident · No injuriesClosedDehavilland DHC-6 · Los Angeles, CANTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MINTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MINTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MONTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLNTSB MIA77DLA22Accident · No injuriesClosedBeech 35 · Ft.Pierce, FLNTSB MIA77DLA12Accident · No injuriesClosedPiper PA-11 · Perry, FLNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftNTSB LAX77DUQ12Accident · No injuriesClosedCessna 150 · California Cty, CANTSB LAX77DUJ16Accident · No injuriesClosedCessna 150 · Bagdad, AZNTSB IAD77FLJ06Accident · Serious injuriesClosedTaylorcraft BC12-D · Durants Neck, NCNTSB FTW77FRD05Accident · No injuriesClosedGrumman G-164A · Welsh, LANTSB FTW77FRD03Accident · No injuriesClosedBell 206B · Gulf Of Mexico (Gulf of Mexico)NTSB FTW77DQD04Accident · No injuriesClosedCessna 177 · El Paso, TXNTSB CHI77FA019Accident · Serious injuriesClosedBeech D-18S · Cairo, ILNTSB ANC77FAA08Accident · No injuriesClosedCessna 170B · Fairbanks, AKNTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WANTSB NYC77IA025Incident · No injuriesClosedBoeing 727 · Bangor, MENTSB NYC77FNC14Accident · No injuriesClosedCessna 310J · New London, NHNTSB NYC77FFJ09Accident · No injuriesClosedPiper PA-28 · Akron, NYNTSB MKC77FCA07Accident · No injuriesClosedCessna 182H · Monticello, MONTSB MIA77FLG04Accident · No injuriesClosedBeech D55 · Charleston, SCNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FL