NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 LAX81FJA04Accident · Serious injuriesClosedCessna 182H · Haleiwa, HIDec 7, 1980 · N1965X · Substantial damageNTSB LAX81FA017Accident · 1 fatalClosedHughes 369D · Kaaawa, HINov 19, 1980 · N58243 · DestroyedNTSB LAX81FJA03Accident · Minor injuriesClosedBell 206L · Kauai, HINov 2, 1980 · N59358 · Substantial damageNTSB LAX81FJA02Accident · Serious injuriesClosedPiper J3-65D · Waialua, HIOct 16, 1980 · N62222 · Substantial damageNTSB LAX81FJA01Accident · No injuriesClosedBeech 3NM · Hilo, HIOct 1, 1980 · N6620 · Substantial damageNTSB LAX80FJA23Accident · Serious injuriesClosedHiller UH-12E · Honolulu, HIAug 5, 1980 · N81959 · DestroyedNTSB LAX80FJA22Accident · No injuriesClosedMyna Bird 1 · Lihue, HIJul 28, 1980 · N5574K · Substantial damageNTSB LAX80DJA21Accident · 1 fatalClosedCessna T188C · Hawaiian Islands, HIJul 22, 1980 · N3887J · DestroyedNTSB LAX80FJA20Accident · Serious injuriesClosedSchweizer SGS126 · Oahu, HIJul 6, 1980 · N5640V · Substantial damageNTSB LAX80FJA19Accident · Minor injuriesClosedBeech D18S · Honolulu, HIJun 22, 1980 · N191U · Substantial damageNTSB LAX80FA109Accident · 2 fatalClosedPiper PA-34 · Lihue, HIJun 15, 1980 · N2564Q · DestroyedNTSB LAX80FJA18Accident · 3 fatalClosedCessna 172N · Kahului, HIJun 14, 1980 · N172JB · DestroyedNTSB LAX80FJA16Accident · No injuriesClosedPiper PA-24 · Kamuela, HIJun 1, 1980 · N7084P · Substantial damageNTSB LAX80FJA15Accident · No injuriesClosedBeech E18S · Lanai, HIMay 29, 1980 · N777AF · Substantial damageNTSB LAX80DJA17Accident · No injuriesClosedCessna 310A · Honolulu, HIMay 24, 1980 · N6740T · Substantial damageNTSB LAX80FJA14Accident · No injuriesClosedBellanca 7KCAB · Molokai, HIMay 4, 1980 · N88191 · Substantial damageNTSB LAX80DJA13Accident · No injuriesClosedPiper PA-28 · Kailua Kona, HIMar 12, 1980 · N35789 · Substantial damageNTSB LAX80DJA12Accident · No injuriesClosedHiller Acft UH-12E · Waimea Kauai, HIFeb 23, 1980 · N155HA · DestroyedNTSB LAX80DJA10Accident · Minor injuriesClosedHiller 12E · Kealia Kauai, HIFeb 17, 1980 · N90474 · DestroyedNTSB LAX80FJA11Accident · 2 fatalClosedCessna 172E · Lanai City, HIFeb 15, 1980 · N9982Q · DestroyedNTSB LAX80DJA09Accident · No injuriesClosedBell 206 · Honolulu, HIJan 19, 1980 · N789PR · DestroyedNTSB LAX80FA033Accident · 2 fatalClosedBeech D18S · Honolulu, HIJan 8, 1980 · N641E · DestroyedNTSB LAX80DJA08Accident · Serious injuriesClosedLockheed 18 · Palmyra Island, HIJan 5, 1980 · N163R · Substantial damage