NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 OAK70F0207Accident · Minor injuriesClosedCessna 182 · Honaunau, HINTSB OAK70F0174Accident · No injuriesClosedPiper PA-28 · Lahaina, HINTSB OAK70D0185Accident · No injuriesClosedStearman E-75 · Paauhau, HINTSB OAK70F0154Accident · Serious injuriesClosedDehaviland 104-6A · Kalaupapa, HINTSB OAK70F0163Accident · No injuriesClosedPiper PA-22 · Honolulu, HINTSB OAK70D0144Accident · No injuriesClosedCessna 177 · Honolulu, HINTSB OAK70F0156Accident · 1 fatalClosedBauch B-8-M · Hilo, HINTSB OAK70D0143Accident · Minor injuriesClosedPiper PA-28 · Kalaupapa, HINTSB OAK70D0130Accident · No injuriesClosedCessna 150H · Kamuela, HINTSB OAK70F0062Accident · Minor injuriesClosedPiper PA-28 · Mauna Loa, HINTSB LAX70A0006Accident · 1 fatalClosedDehavilland DH104 · Kekaha, HINTSB OAK70D0031Accident · Minor injuriesClosedPiper PA-28 · Hilo, HINTSB OAK69A0074Accident · No injuriesClosedVickers 745D · Honolulu, HINTSB OAK70D0018Accident · Minor injuriesClosedGiant Bee · Honolulu, HINTSB OAK70D0020Accident · Minor injuriesClosedCessna 140 · Hana, HINTSB OAK70F0013Accident · Serious injuriesClosedCessna 150 · Wheeler Ab, HINTSB OAK69D0270Accident · No injuriesClosedCessna 150 · Lanai City, HINTSB NYC69A0080Accident · Serious injuriesClosedBoeing 707 · Honolulu, HINTSB OAK69F0223Accident · No injuriesClosedCessna 310I · Kona, HINTSB OAK69F0213Accident · 1 fatalClosedConvair BT-13B · Waipahu, HI