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

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

NTSB OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HIDec 31, 1977 · N56357 · DestroyedNTSB OAK78DJA02Accident · No injuriesClosedEmair MA-1 · Lihue, HIDec 29, 1977 · N305MA · Substantial damageNTSB OAK78FJA01Accident · Minor injuriesClosedBeech C45G · Honolulu, HIDec 17, 1977 · N2874G · DestroyedNTSB OAK77FA059Accident · 2 fatalClosedCessna 172N · Pahala, HISep 29, 1977 · N733FZ · DestroyedNTSB OAK77FA050Accident · 2 fatalClosedSkyvan SC-7 · Kailua Kona, HIAug 25, 1977 · N4917 · DestroyedNTSB DCA77AA024Accident · Serious injuriesClosedDouglas DC-10 · Honolulu, HIAug 19, 1977 · RP-C2003 · Minor damageNTSB OAK77FJA14Accident · Serious injuriesClosedMurrayair MA-I · Lihue, HIAug 18, 1977 · N104MA · DestroyedNTSB OAK77FJA15Accident · No injuriesClosedBoeing 747 · Honolulu, HIAug 13, 1977 · B1860 · No damageNTSB OAK77FJA13Accident · No injuriesClosedEnstrom F28C · Honolulu, HIAug 4, 1977 · N595H · Substantial damageNTSB OAKMMFJA12Accident · 1 fatalClosedRockwell 112B · Honolulu, HIMay 24, 1977 · N1285J · DestroyedNTSB OAK77FA032Accident · 4 fatalClosedCessna 172M · Lahaina Maui, HIMay 19, 1977 · N20548 · DestroyedNTSB OAK77DJA11Accident · No injuriesClosedCessna 150 · Hilo, HIMay 18, 1977 · N18503 · Substantial damageNTSB OAK77DJA10Accident · Serious injuriesClosedCessna 340 · Kauna Point, HIApr 26, 1977 · N7839Q · DestroyedNTSB OAK77DJA09Accident · 5 fatalClosedCessna 310 · Honolulu, HIApr 13, 1977 · N8179M · DestroyedNTSB OAK77FJA08Accident · No injuriesClosedBrittnorman BN-2 · Maui, HIApr 5, 1977 · N555JA · Substantial damageNTSB OAK77FJA07Accident · 2 fatalClosedHughes 269C · Honolulu, HIMar 16, 1977 · N9619F · DestroyedNTSB OAK77FJA06Accident · Minor injuriesClosedGrumman AA-1B · Honolulu, HIJan 13, 1977 · N1475R · 2 aircraft · Substantial damageNTSB OAK77IA012Incident · Minor injuriesClosedBoeing 707 · Honolulu, HIJan 12, 1977 · N1501W · Substantial damageNTSB OAK77FJA05Accident · No injuriesClosedPiper PA28R · Lanai City, HIJan 9, 1977 · N56357 · Substantial damageNTSB OAK77FJA04Accident · Minor injuriesClosedRockwell 112A · Waipahu, HIJan 4, 1977 · N1481J · Substantial damage