NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 OAK66F0177Accident · No injuriesClosedCessna 310C · Molokai, HINTSB OAK66F0171Accident · 2 fatalClosedBeechcraft C45H · Maui, HINTSB OAK66F0169Accident · No injuriesClosedPiper PA-28 · Honolulu, HINTSB OAK66F0132Accident · Serious injuriesClosedBell 47J2A · Lihue, HINTSB OAK66F0134Accident · No injuriesClosedBeechcraft C45H · Kauai, HINTSB OAK66F0136Accident · Minor injuriesClosedAero Cmdr 500A · Lanai, HINTSB OAK66D0086Accident · No injuriesClosedCessna 150 · Honolulu, HINTSB OAK66F0096Accident · No injuriesClosedBeech C-45H · Honolulu, HINTSB OAK66F0056Accident · No injuriesClosedGlobe GC1-B · Honolulu, HINTSB OAK66D0074Accident · No injuriesClosedBoeing A-75N1 · Pahala, HINTSB OAK66F0060Accident · No injuriesClosedBeechcraft C-45G · Honolulu, HINTSB OAK66D0087Accident · 3 fatalClosedCessna 175 · 90s Oahu, HINTSB OAK66F0061Accident · Serious injuriesClosedHiller UH12E · Waikamoi, HINTSB OAK66F0046Accident · No injuriesClosedPiper PA-28 · Honokaa, HINTSB OAK66F0032Accident · No injuriesClosedCessna 185 · Honolulu, HINTSB OAK65F0069Accident · No injuriesClosedNo.American B25 · Honolulu, HINTSB OAK65F0055Accident · Serious injuriesClosedPiper J5C · Honolulu, HINTSB OAK65F0054Accident · 1 fatalClosedPiper PA-28 · Lanai City, HI