NTSB investigations, 1966
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\") = 1966 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 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 SEA67F0232Accident · No injuriesClosedBeech A45 · Aurora, ORNTSB SEA67D0228Accident · No injuriesClosedPiper PA-28 · Bellevue, WANTSB OAK67F0239Accident · No injuriesClosedPiper PA-28 · Carmel Valley, CANTSB NYC67D0439Accident · No injuriesClosedPiper PA-22 · Clarion, PANTSB NYC67D042.Accident · No injuriesClosedPiper PA-22 · Jaffrey, NHNTSB MKC67F0383Accident · Minor injuriesClosedAeronca 7CCM · Phelphs, MNNTSB MKC67D0395Accident · No injuriesClosedCessna 120 · Marion, IANTSB MKC67D0385Accident · No injuriesClosedPiper PA-18 · Kempton, NDNTSB MKC67D0375Accident · No injuriesClosedPiper PA-22 · Grundy Cntr, IANTSB MKC67D0350Accident · No injuriesClosedCessna 210B · Lincoln, NENTSB MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GANTSB MIA67F0348Accident · Minor injuriesClosedPiper PA-28 · Ocala, FLNTSB MIA67F0339Accident · No injuriesClosedPiper PA-22 · Ellenton, FLNTSB MIA67D0357Accident · No injuriesClosedCessna 170A · Cocoa, FLNTSB MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GANTSB LAX67F0225Accident · No injuriesClosedPiper PA-24 · Hawthorne, CANTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoNTSB DIA67F0009Accident · No injuriesClosedLuscombe 8F · Gaithersburg, MDNTSB DIA67D0006Accident · No injuriesClosedBeech D35 · Waynesboro, VANTSB CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OHNTSB SEA67F0245Accident · Serious injuriesClosedCessna 170A · Kalama, WANTSB NYC67F0574Accident · No injuriesClosedPiper PA-24 · Coraopolis, PANTSB NYC67F0443Accident · No injuriesClosedCessna 320D · Morristown, NJNTSB NYC67F0428Accident · No injuriesClosedPiper PA-24 · Selinsgrove, PANTSB NYC67D0675Accident · No injuriesClosedCessna 172C · Greenville, PANTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJNTSB NYC67D0455Accident · No injuriesClosedCessna 150 · Sheffield, MANTSB NYC67D0453Accident · No injuriesClosedCessna 150 · White Plains, NYNTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NENTSB MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSNTSB MIA67F0340Accident · Serious injuriesClosedCessna 180 · Vicksburg, MSNTSB MIA67F0335Accident · No injuriesClosedPiper PA-28 · Pikeville, NCNTSB FTW67F0399Accident · Minor injuriesClosedCessna 150 · Palo Pinto, TXNTSB FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKNTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VANTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Frederick, MDNTSB DCA67R0002Accident · Minor injuriesClosedDouglas DC-7C · Saigon, VMNTSB CHI67F0433Accident · No injuriesClosedBellanca 14-13 · Warsaw, INNTSB CHI67D0445Accident · No injuriesClosedPiper PA-22 · Toledo, OHNTSB OAK67F0202Accident · No injuriesClosedPiper PA-24 · Sacramento, CANTSB OAK67D0180Accident · No injuriesClosedCessna 150 · Vallejo, CANTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CANTSB OAK67A0054Accident · No injuriesClosedHughes 269A · Hayward, CANTSB NYC67I0096Incident · No injuriesClosedFairchild F-27 · Bridgeport, CTNTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NENTSB MIA67F0354Accident · Minor injuriesClosedPiper PA-32 · San Juan, PRNTSB MIA67D0367Accident · No injuriesClosedCessna 172 · Duncan Town, Burkina FasoNTSB FTW67D0379Accident · No injuriesClosedPitts 190 · Duncan, OKNTSB FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARNTSB FTW67A0067Accident · No injuriesClosedCessna P206 · Chickasha, OK