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

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

NTSB OAK70F0207Accident · Minor injuriesClosedCessna 182 · Honaunau, HIDec 30, 1969 · N1953X · DestroyedNTSB OAK70F0174Accident · No injuriesClosedPiper PA-28 · Lahaina, HIDec 6, 1969 · N5228W · Substantial damageNTSB OAK70D0185Accident · No injuriesClosedStearman E-75 · Paauhau, HIDec 5, 1969 · N4770V · Substantial damageNTSB OAK70F0154Accident · Serious injuriesClosedDehaviland 104-6A · Kalaupapa, HINov 3, 1969 · N669R · Substantial damageNTSB OAK70F0163Accident · No injuriesClosedPiper PA-22 · Honolulu, HINov 1, 1969 · N4711Z · Substantial damageNTSB OAK70D0144Accident · No injuriesClosedCessna 177 · Honolulu, HIOct 16, 1969 · N30283 · Substantial damageNTSB OAK70F0156Accident · 1 fatalClosedBauch B-8-M · Hilo, HIOct 12, 1969 · N4019 · DestroyedNTSB OAK70D0143Accident · Minor injuriesClosedPiper PA-28 · Kalaupapa, HIOct 10, 1969 · N163FC · DestroyedNTSB OAK70D0130Accident · No injuriesClosedCessna 150H · Kamuela, HISep 26, 1969 · N5129G · Substantial damageNTSB OAK70F0062Accident · Minor injuriesClosedPiper PA-28 · Mauna Loa, HIAug 7, 1969 · N5811W · Substantial damageNTSB LAX70A0006Accident · 1 fatalClosedDehavilland DH104 · Kekaha, HIJul 25, 1969 · N88G · DestroyedNTSB OAK70D0031Accident · Minor injuriesClosedPiper PA-28 · Hilo, HIJul 12, 1969 · N187FC · Substantial damageNTSB OAK69A0074Accident · No injuriesClosedVickers 745D · Honolulu, HIJun 27, 1969 · N7410 · Substantial damageNTSB OAK70D0018Accident · Minor injuriesClosedGiant Bee · Honolulu, HIJun 22, 1969 · N3511 · Substantial damageNTSB OAK70D0020Accident · Minor injuriesClosedCessna 140 · Hana, HIJun 14, 1969 · N72838 · Substantial damageNTSB OAK70F0013Accident · Serious injuriesClosedCessna 150 · Wheeler Ab, HIJun 12, 1969 · N8221S · DestroyedNTSB OAK69D0270Accident · No injuriesClosedCessna 150 · Lanai City, HIApr 10, 1969 · N8777S · Substantial damageNTSB NYC69A0080Accident · Serious injuriesClosedBoeing 707 · Honolulu, HIMar 20, 1969 · N427PA · No damageNTSB OAK69F0223Accident · No injuriesClosedCessna 310I · Kona, HIJan 24, 1969 · N8046M · Substantial damageNTSB OAK69F0213Accident · 1 fatalClosedConvair BT-13B · Waipahu, HIJan 13, 1969 · N63227 · Destroyed