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

19632026
NTSB investigations, 1965, 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\") = 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.

NTSB OAK66F0177Accident · No injuriesClosedCessna 310C · Molokai, HINov 24, 1965 · N1859H · Substantial damageNTSB OAK66F0171Accident · 2 fatalClosedBeechcraft C45H · Maui, HINov 12, 1965 · N9915Z · DestroyedNTSB OAK66F0169Accident · No injuriesClosedPiper PA-28 · Honolulu, HINov 5, 1965 · N5794W · Substantial damageNTSB OAK66F0132Accident · Serious injuriesClosedBell 47J2A · Lihue, HIOct 20, 1965 · N3072G · DestroyedNTSB OAK66F0134Accident · No injuriesClosedBeechcraft C45H · Kauai, HIOct 11, 1965 · N9909Z · Substantial damageNTSB OAK66F0136Accident · Minor injuriesClosedAero Cmdr 500A · Lanai, HISep 27, 1965 · N9376R · Substantial damageNTSB OAK66D0086Accident · No injuriesClosedCessna 150 · Honolulu, HISep 26, 1965 · N6674T · Substantial damageNTSB OAK66F0096Accident · No injuriesClosedBeech C-45H · Honolulu, HISep 22, 1965 · N134 · Substantial damageNTSB OAK66F0056Accident · No injuriesClosedGlobe GC1-B · Honolulu, HIAug 26, 1965 · N78250 · Substantial damageNTSB OAK66D0074Accident · No injuriesClosedBoeing A-75N1 · Pahala, HIAug 24, 1965 · N48730 · Substantial damageNTSB OAK66F0060Accident · No injuriesClosedBeechcraft C-45G · Honolulu, HIAug 20, 1965 · N866H · Substantial damageNTSB OAK66D0087Accident · 3 fatalClosedCessna 175 · 90s Oahu, HIAug 18, 1965 · N8378T · DestroyedNTSB OAK66F0061Accident · Serious injuriesClosedHiller UH12E · Waikamoi, HIAug 16, 1965 · N5385V · DestroyedNTSB OAK66F0046Accident · No injuriesClosedPiper PA-28 · Honokaa, HIJul 29, 1965 · N7836W · Substantial damageNTSB OAK66F0032Accident · No injuriesClosedCessna 185 · Honolulu, HIJul 15, 1965 · N4105Y · Substantial damageNTSB OAK65F0069Accident · No injuriesClosedNo.American B25 · Honolulu, HIMay 7, 1965 · N9754Z · Substantial damageNTSB OAK65F0055Accident · Serious injuriesClosedPiper J5C · Honolulu, HIMar 28, 1965 · N62031 · Substantial damageNTSB OAK65F0054Accident · 1 fatalClosedPiper PA-28 · Lanai City, HIMar 9, 1965 · N6382W · Destroyed