NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 OAK7MDJA03Accident · No injuriesClosedMurrayair MA-1 · Keaau, HINTSB OAK77FJA01Accident · 2 fatalClosedYankee AA1 · Wainiha, HINTSB OAK77DJA04Accident · Minor injuriesClosedSczeny-Roth BG12B · Mokuleia, HINTSB OAK76FJA25Accident · Minor injuriesClosedHughes 369 · Haena Kauai, HINTSB OAK76DJA23Accident · No injuriesClosedBoeing A75N1 · Hanapepe, HINTSB OAK76AP067Accident · Serious injuriesClosedCessna 402B · Molokai, HINTSB OAK76DJA21Accident · Minor injuriesClosedCessna 207 · Kahului, HINTSB OAK76FJA20Accident · 1 fatalClosedBeech M35 · Honolulu, HINTSB OAK76DJA22Accident · No injuriesClosedMurrayair MA-1 · Koloa, HINTSB OAK76FJA19Accident · No injuriesClosedAmer Avco AA1-B · Ford Island, HINTSB OAK76DJA18Accident · Minor injuriesClosedMurrayair MA-1 · Pahala, HINTSB OAK76DJA16Accident · No injuriesClosedMurrayair MA-1 · Honokaa, HINTSB OAK76FJA17Accident · No injuriesClosedDouglas DC-10 · Honolulu, HINTSB OAK76DJA11Accident · No injuriesClosedBoeing A75N1 · Koloa, HINTSB OAK76DJA15Accident · No injuriesClosedDehavilland DHC-3 · Upolu Point, HINTSB OAK76FJA14Accident · No injuriesClosedPiper PA-32 · Lihue, HINTSB OAK76FJA13Accident · Serious injuriesClosedCessna 402A · Honolulu, HINTSB OAK76FJA10Accident · No injuriesClosedHiller Acft UH-12E · Oahu, HINTSB OAK76FJA09Accident · 1 fatalClosedBell 206B · Honolulu, HI