NTSB investigations, 1966, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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
AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 SEA67D0218Accident · No injuriesClosedNavion A · Boise, IDNTSB SEA67D0199Accident · No injuriesClosedCessna 172 · Dubois, IDNTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNTSB SEA67D0178Accident · Minor injuriesClosedCessna 150 · Wayan, IDNTSB SEA67D0164Accident · Minor injuriesClosedAeronca 7AC · Twin Falls, IDNTSB SEA67F0170Accident · No injuriesClosedPiper PA-18 · Weiser, IDNTSB SEA67A0035Accident · 2 fatalClosedCessna 180C · Ngrangeville, IDNTSB SEA67A0034Accident · 3 fatalClosedBeech 35 · Stanley, IDNTSB SEA67F0143Accident · No injuriesClosedPiper J4 · Homedale, IDNTSB SEA67D0159Accident · Minor injuriesClosedCessna 150 · Avery, IDNTSB SEA67A0028Accident · 5 fatalClosedCessna 185E · Ngrangeville, IDNTSB SEA67A0024Accident · No injuriesClosedBell 47G-3 · Challis, IDNTSB SEA67A0023Accident · 3 fatalClosedPiper PA-23 · Stanley, IDNTSB SEA67F0096Accident · 1 fatalClosedWaco UPF-7 · Wilder, IDNTSB SEA67F0101Accident · Serious injuriesClosedSchweizer 1-26B · Ketchum, IDNTSB SEA67D0094Accident · No injuriesClosedCessna 182 · Caldwell, IDNTSB SEA67D0066Accident · Minor injuriesClosedPiper PA-24 · Challis, IDNTSB SEA67A0006Accident · 3 fatalClosedCessna 172 · Cascade, IDNTSB SEA67D0090Accident · No injuriesClosedPiper PA-18 · Hamer, IDNTSB SEA67D0088Accident · No injuriesClosedCessna 210 · Rigby, IDNTSB SEA67D0067Accident · Minor injuriesClosedPiper PA-18A · Rupert, IDNTSB SEA67D0038Accident · No injuriesClosedPiper PA-18A · Clover, IDNTSB SEA67A0003Accident · 1 fatalClosedStinson L-5 · Emmett, IDNTSB SEA67D0072Accident · No injuriesClosedCessna 180 · Genesee, IDNTSB SEA67D0063Accident · No injuriesClosedAeronca 7FC · Twin Falls, IDNTSB SEA67D0036Accident · No injuriesClosedCessna 182 · Riggins, IDNTSB SEA67D0031Accident · No injuriesClosedLuscombe 8A · Montpelier, IDNTSB SEA67D0016Accident · No injuriesClosedTaylorcraft BC12-D · Hailey, IDNTSB SEA67D0037Accident · Serious injuriesClosedBellanca 14-13 · Mackay, IDNTSB SEA67D0030Accident · No injuriesClosedLuscombe 8E · Idaho City, IDNTSB SEA67D0023Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDNTSB SEA67D0080Accident · No injuriesClosedPiper PA-24 · Challis, IDNTSB SEA67D0039Accident · Serious injuriesClosedStinson 108 · Buhl, IDNTSB SEA67D0058Accident · Minor injuriesClosedPiper PA-24 · Montpelier, IDNTSB SEA67D0012Accident · No injuriesClosedAeronca 15AC · Coeur D'Alene, IDNTSB SEA67D0057Accident · Serious injuriesClosedLuscombe 8A · Challis, IDNTSB SEA67D0025Accident · No injuriesClosedCessna 172 · Atomic City, IDNTSB SEA66A0064Accident · 1 fatalClosedPiper PA-18A · St Anthony, IDNTSB SEA66D0279Accident · No injuriesClosedPiper PA-22 · Boise, IDNTSB SEA67D0011Accident · Minor injuriesClosedCessna 180A · Albion, IDNTSB SEA67D0015Accident · No injuriesClosedPiper PA-18A · Swan Valley, IDNTSB SEA66D0300Accident · No injuriesClosedCessna 180 · Grace, IDNTSB SEA66A0061Accident · Minor injuriesClosedCessna 206 · Elk City, IDNTSB SEA66D0283Accident · No injuriesClosedCessna 150C · Orofino, IDNTSB SEA66D0282Accident · No injuriesClosedCessna 182 · Grangeville, IDNTSB SEA67D0024Accident · Serious injuriesClosedPiper PA-28 · Big Springs, IDNTSB SEA66D0269Accident · No injuriesClosedCessna 120 · Boise, IDNTSB SEA66D0263Accident · Minor injuriesClosedPiper PA-22 · Union, IDNTSB SEA66D0246Accident · No injuriesClosedCessna 180 · Moose Creek, ID