NTSB investigations, 1977, 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\") = 1977
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") = 1977 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 OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HINTSB OAK78DJA02Accident · No injuriesClosedEmair MA-1 · Lihue, HINTSB OAK78FJA01Accident · Minor injuriesClosedBeech C45G · Honolulu, HINTSB OAK77FA059Accident · 2 fatalClosedCessna 172N · Pahala, HINTSB OAK77FA050Accident · 2 fatalClosedSkyvan SC-7 · Kailua Kona, HINTSB DCA77AA024Accident · Serious injuriesClosedDouglas DC-10 · Honolulu, HINTSB OAK77FJA14Accident · Serious injuriesClosedMurrayair MA-I · Lihue, HINTSB OAK77FJA15Accident · No injuriesClosedBoeing 747 · Honolulu, HINTSB OAK77FJA13Accident · No injuriesClosedEnstrom F28C · Honolulu, HINTSB OAKMMFJA12Accident · 1 fatalClosedRockwell 112B · Honolulu, HINTSB OAK77FA032Accident · 4 fatalClosedCessna 172M · Lahaina Maui, HINTSB OAK77DJA11Accident · No injuriesClosedCessna 150 · Hilo, HINTSB OAK77DJA10Accident · Serious injuriesClosedCessna 340 · Kauna Point, HINTSB OAK77DJA09Accident · 5 fatalClosedCessna 310 · Honolulu, HINTSB OAK77FJA08Accident · No injuriesClosedBrittnorman BN-2 · Maui, HINTSB OAK77FJA07Accident · 2 fatalClosedHughes 269C · Honolulu, HINTSB OAK77FJA06Accident · Minor injuriesClosedGrumman AA-1B · Honolulu, HINTSB OAK77IA012Incident · Minor injuriesClosedBoeing 707 · Honolulu, HINTSB OAK77FJA05Accident · No injuriesClosedPiper PA28R · Lanai City, HINTSB OAK77FJA04Accident · Minor injuriesClosedRockwell 112A · Waipahu, HI