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

19632026
NTSB investigations, 1967, HI per year, 1963–2026: 871 cases
19632
196416
196518
196622
196729
196819
196920
197012
197121
197219
197324
197417
197513
197619
197720
197818
197917
198023
198117
198213
198311
198413
198519
198620
198726
198812
198915
199011
199118
199217
19939
199418
199512
199612
199714
19987
199912
200015
200112
20023
200314
200415
200516
200613
200710
200811
200910
20106
20117
201210
201310
201410
20156
201614
20178
201812
201910
20206
20215
202213
20238
202411
20256
20265

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.

NTSB OAK68F0254Accident · No injuriesClosedDehaviland DHC-6 · Honolulu, HIDec 16, 1967 · N8081N · Substantial damageNTSB OAK68A0050Accident · 2 fatalClosedBell 47J-2A · Hanalei, HIDec 13, 1967 · N8501F · DestroyedNTSB OAK68F0249Accident · Serious injuriesClosedCessna 150F · Wahaiwa, HIDec 12, 1967 · N6285R · DestroyedNTSB OAK68A0049Accident · Minor injuriesClosedBell 47G3B1 · Honolulu, HIDec 11, 1967 · N1346X · DestroyedNTSB OAK68D0252Accident · No injuriesClosedN.American SNJ-B5 · Honolulu, HIDec 2, 1967 · N3163G · Substantial damageNTSB OAK68A0046Accident · Minor injuriesClosedBoeing 707 · Honolulu, HINov 21, 1967 · G-ARWE · Substantial damageNTSB OAK68A0043Accident · No injuriesClosedCessna 172 · Kamuela, HINov 7, 1967 · N4349L · Substantial damageNTSB OAK68D0192Accident · Minor injuriesClosedBeech C-45H · Lanai, HINov 6, 1967 · N9504Z · Substantial damageNTSB OAK68F0120Accident · No injuriesClosedCulver L-AR90 · Honolulu, HIOct 7, 1967 · N80082 · Substantial damageNTSB OAK68F0102Accident · No injuriesClosedPiper PA-24 · Honolulu, HISep 14, 1967 · N6326P · Substantial damageNTSB OAK68F0107Accident · Minor injuriesClosedErco 415-C · Hanu Maui, HISep 12, 1967 · N3597H · Substantial damageNTSB OAK68F0106Accident · No injuriesClosedCessna 150 · Honolulu, HISep 1, 1967 · N2091Z · Substantial damageNTSB OAK68A0019Accident · 1 fatalClosedBoeing B75N1 · Honolulu, HIAug 25, 1967 · N67917 · DestroyedNTSB OAK68D0064Accident · No injuriesClosedPiper PA-28 · Lihue Kaui, HIAug 5, 1967 · N5811W · Substantial damageNTSB OAK68A0008Accident · No injuriesClosedVickers 745D · Honolulu, HIJul 31, 1967 · N7410 · Substantial damageNTSB OAK68F0070Accident · No injuriesClosedDehavilland 104 · Lahaina, HIJul 29, 1967 · N668R · Substantial damageNTSB OAK68F0034Accident · No injuriesClosedSchweizer SGS232 · Mokuleia, HIJul 16, 1967 · N2442W · Substantial damageNTSB OAK68A0006Accident · 1 fatalClosedBoeing A75N1 · Haena, HIJul 14, 1967 · N67916 · DestroyedNTSB OAK68F0035Accident · No injuriesClosedPiper PA-32 · Kaupulehu, HIJun 24, 1967 · N3347W · Substantial damageNTSB OAK67A0088Accident · 1 fatalClosedCessna 172H · Hawi, HIJun 11, 1967 · N1486F · DestroyedNTSB OAK67A0078Accident · Minor injuriesClosedAero Comdr 500 · Kaunakakai, HIMay 13, 1967 · N8453C · Substantial damageNTSB OAK67F0288Accident · No injuriesClosedStinson L-5 · Waianae, HIApr 30, 1967 · N5614V · Substantial damageNTSB OAK67D0277Accident · No injuriesClosedBeech 95A55 · Onolulu, HIApr 20, 1967 · N9517Y · Substantial damageNTSB OAK67D0253Accident · No injuriesClosedBell 47G3B1 · Hilo, HIMar 17, 1967 · N1346X · Substantial damageNTSB OAK67D0236Accident · No injuriesClosedPiper PA-22 · Honolulu, HIMar 9, 1967 · N4711Z · Substantial damageNTSB OAK67D0235Accident · No injuriesClosedCessna 310G · Kaluapapa, HIFeb 28, 1967 · N2920R · Substantial damageNTSB OAK67D0208Accident · Minor injuriesClosedCessna 182 · Haleo Lono, HIJan 17, 1967 · N2698F · DestroyedNTSB OAK67D0195Accident · No injuriesClosedPiper PA-12 · Molokai, HIJan 8, 1967 · N3987M · DestroyedNTSB OAK67F0263Accident · 3 fatalClosedCurtiss-Wrt C-46 · Hilo, HIJan 6, 1967 · N30046 · Destroyed