NTSB investigations, 1967, HI
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1963 | 2 |
|---|---|
| 1964 | 16 |
| 1965 | 18 |
| 1966 | 22 |
| 1967 | 29 |
| 1968 | 19 |
| 1969 | 20 |
| 1970 | 12 |
| 1971 | 21 |
| 1972 | 19 |
| 1973 | 24 |
| 1974 | 17 |
| 1975 | 13 |
| 1976 | 19 |
| 1977 | 20 |
| 1978 | 18 |
| 1979 | 17 |
| 1980 | 23 |
| 1981 | 17 |
| 1982 | 13 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 12 |
| 1989 | 15 |
| 1990 | 11 |
| 1991 | 18 |
| 1992 | 17 |
| 1993 | 9 |
| 1994 | 18 |
| 1995 | 12 |
| 1996 | 12 |
| 1997 | 14 |
| 1998 | 7 |
| 1999 | 12 |
| 2000 | 15 |
| 2001 | 12 |
| 2002 | 3 |
| 2003 | 14 |
| 2004 | 15 |
| 2005 | 16 |
| 2006 | 13 |
| 2007 | 10 |
| 2008 | 11 |
| 2009 | 10 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 10 |
| 2015 | 6 |
| 2016 | 14 |
| 2017 | 8 |
| 2018 | 12 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 13 |
| 2023 | 8 |
| 2024 | 11 |
| 2025 | 6 |
| 2026 | 5 |
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\") = 1967
AND c.\"eventStateOrRegion\" = 'HI' 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") = 1967 AND c."eventStateOrRegion" = 'HI' 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 OAK68F0254Accident · No injuriesClosedDehaviland DHC-6 · Honolulu, HINTSB OAK68A0050Accident · 2 fatalClosedBell 47J-2A · Hanalei, HINTSB OAK68F0249Accident · Serious injuriesClosedCessna 150F · Wahaiwa, HINTSB OAK68A0049Accident · Minor injuriesClosedBell 47G3B1 · Honolulu, HINTSB OAK68D0252Accident · No injuriesClosedN.American SNJ-B5 · Honolulu, HINTSB OAK68A0046Accident · Minor injuriesClosedBoeing 707 · Honolulu, HINTSB OAK68A0043Accident · No injuriesClosedCessna 172 · Kamuela, HINTSB OAK68D0192Accident · Minor injuriesClosedBeech C-45H · Lanai, HINTSB OAK68F0120Accident · No injuriesClosedCulver L-AR90 · Honolulu, HINTSB OAK68F0102Accident · No injuriesClosedPiper PA-24 · Honolulu, HINTSB OAK68F0107Accident · Minor injuriesClosedErco 415-C · Hanu Maui, HINTSB OAK68F0106Accident · No injuriesClosedCessna 150 · Honolulu, HINTSB OAK68A0019Accident · 1 fatalClosedBoeing B75N1 · Honolulu, HINTSB OAK68D0064Accident · No injuriesClosedPiper PA-28 · Lihue Kaui, HINTSB OAK68A0008Accident · No injuriesClosedVickers 745D · Honolulu, HINTSB OAK68F0070Accident · No injuriesClosedDehavilland 104 · Lahaina, HINTSB OAK68F0034Accident · No injuriesClosedSchweizer SGS232 · Mokuleia, HINTSB OAK68A0006Accident · 1 fatalClosedBoeing A75N1 · Haena, HINTSB OAK68F0035Accident · No injuriesClosedPiper PA-32 · Kaupulehu, HINTSB OAK67A0088Accident · 1 fatalClosedCessna 172H · Hawi, HINTSB OAK67A0078Accident · Minor injuriesClosedAero Comdr 500 · Kaunakakai, HINTSB OAK67F0288Accident · No injuriesClosedStinson L-5 · Waianae, HINTSB OAK67D0277Accident · No injuriesClosedBeech 95A55 · Onolulu, HINTSB OAK67D0253Accident · No injuriesClosedBell 47G3B1 · Hilo, HINTSB OAK67D0236Accident · No injuriesClosedPiper PA-22 · Honolulu, HINTSB OAK67D0235Accident · No injuriesClosedCessna 310G · Kaluapapa, HINTSB OAK67D0208Accident · Minor injuriesClosedCessna 182 · Haleo Lono, HINTSB OAK67D0195Accident · No injuriesClosedPiper PA-12 · Molokai, HINTSB OAK67F0263Accident · 3 fatalClosedCurtiss-Wrt C-46 · Hilo, HI