NTSB investigations, 1965
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\") = 1965 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") = 1965 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 OAK66F0179Accident · No injuriesClosedMooney 20A · Hayward, CANTSB OAK66D0178Accident · Minor injuriesClosedPiper PA-22 · Mammoth Lake, CANTSB NYC66F0443Accident · No injuriesClosedErcoupe 415-C · Laytonsville, MDNTSB NYC66D0438Accident · Minor injuriesClosedLuscombe 8A · Sanford, MENTSB NYC66D0420Accident · No injuriesClosedCessna 310C · Philadelphia, PANTSB NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MANTSB MKC66F0336Accident · Minor injuriesClosedCessna U206 · Augusta, KSNTSB MKC66D0371Accident · No injuriesClosedMooney M20A · Kansas City, KSNTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSNTSB MIA66F0398Accident · No injuriesClosedGlobe GC-1A · Orlando, FLNTSB MIA66F0393Accident · No injuriesClosedChampion 7FC · Kissimee, FLNTSB MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCNTSB LAX66A0052Accident · Minor injuriesClosedBell 47G-2 · Piru, CANTSB DEN66D0193Accident · No injuriesClosedCessna 170B · Carefree, AZNTSB CHI66F0509Accident · No injuriesClosedMooney M20B · Springfield, ILNTSB ANC66D0086Accident · No injuriesClosedCessna 172 · Port Heiden, AKNTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WANTSB SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORNTSB NYC66F0435Accident · No injuriesClosedErcoupe 415-D · Marlboro, MANTSB NYC66D0698Accident · Minor injuriesClosedCessna 172 · Charleston, WVNTSB NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VANTSB MKC66F0346Accident · No injuriesClosedPiper PA-22 · Park Rapids, MNNTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NENTSB MKC66D0364Accident · No injuriesClosedCessna 182 · Centerville, IANTSB MIA66F0505Accident · Serious injuriesClosedNavion A · Oceanway, FLNTSB MIA66A0074Accident · No injuriesClosedBrantly B-2 · Tampa, FLNTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CANTSB LAX66A0050Accident · Minor injuriesClosedHughes 269B · Bakersfield, CANTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXNTSB DEN66A0051Accident · No injuriesClosedBell 47G3B1 · Mesa, AZNTSB ANC66A0047Accident · 3 fatalClosedPiper PA-14 · Anchorage, AKNTSB SEA66D0188Accident · No injuriesClosedCessna 180 · Babb, MTNTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORNTSB OAK66F0176Accident · No injuriesClosedPiper PA-23 · Reno, NVNTSB OAK66D0170Accident · No injuriesClosedCessna 210C · Antioch, CANTSB NYC66F0412Accident · Serious injuriesClosedCessna 150 · Medford, NJNTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VANTSB MKC66D0366Accident · No injuriesClosedBeech A23 · Marion, IANTSB MKC66D0340Accident · No injuriesClosedCessna 150 · Faucett, MONTSB MIA66F0355Accident · Minor injuriesClosedCessna 172 · Pine Hall, NCNTSB MIA66A0073Accident · 3 fatalClosedPiper PA-24NTSB FTW66F0473Accident · No injuriesClosedBeechcraft AT-11 · Monroe, LANTSB FTW66D0464Accident · No injuriesClosedPiper PA-22 · Rosston, OKNTSB FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARNTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXNTSB DEN66F0199Accident · No injuriesClosedMooney M20C · Phoenix, AZNTSB DEN66F0195Accident · No injuriesClosedCessna 310A · Salt Lake City, UTNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTNTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILNTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, OR