NTSB investigations, 1964, NE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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

19622026
NTSB investigations, 1964, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

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\") = 1964
    AND c.\"eventStateOrRegion\" = 'NE' 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 UNK65X1077Accident · No injuriesClosedHughes 269A · Columbus, NEDec 20, 1964 · N8704F · Substantial damageNTSB UNK65X0986Accident · No injuriesClosedPiper PA22 · Wayne, NEDec 12, 1964 · N4348A · Substantial damageNTSB UNK65X0921Accident · No injuriesClosedBellanca 14-19 · Kearney, NEDec 5, 1964 · N520A · Substantial damageNTSB UNK65X0823Accident · No injuriesClosedPiper PA18 · Valentine, NENov 25, 1964 · N3236P · Substantial damageNTSB UNK65X0773Accident · No injuriesClosedBeechcraft 35 · Lincoln, NENov 21, 1964 · N2940V · Substantial damageNTSB UNK65X0625Accident · 2 fatalClosedAeronca 7AC · Merriman, NENov 8, 1964 · N84209 · DestroyedNTSB UNK65X0608Accident · No injuriesClosedCessna 182 · Grand Is, NENov 8, 1964 · N2971Y · Substantial damageNTSB UNK65X0601Accident · No injuriesClosedPiper PA22 · Hastings, NENov 7, 1964 · N3712P · Substantial damageNTSB UNK65X0590Accident · No injuriesClosedCessna 320 · Norfolk, NENov 7, 1964 · N3047R · Substantial damageNTSB UNK65X0436Accident · No injuriesClosedCessna 170 · Marshland, NEOct 25, 1964 · N4103V · Substantial damageNTSB UNK65X0432Accident · No injuriesClosedCessna 180 · Gretna, NEOct 25, 1964 · N2938A · Substantial damageNTSB UNK65X0399Accident · No injuriesClosedMooney 20P · Kearney, NEOct 24, 1964 · N6913U · Substantial damageNTSB UNK65X0381Accident · No injuriesClosedBell 47J2 · Kimball, NEOct 22, 1964 · N73923 · Substantial damageNTSB UNK65X0345Accident · 1 fatalClosedBrantly B2 · Broadwater, NEOct 20, 1964 · N5924X · DestroyedNTSB UNK65X0323Accident · No injuriesClosedBeechcraft 23 · Kearney, NEOct 18, 1964 · N8717M · Substantial damageNTSB UNK65X0149Accident · 2 fatalClosedAeronca L-16 · Bee, NEOct 4, 1964 · N9041C · DestroyedNTSB UNK64X4132Accident · No injuriesClosedCessna 172D · Valentine, NESep 24, 1964 · N8561X · Substantial damageNTSB UNK64X4100Accident · No injuriesClosedBeech D17S · Burwell, NESep 22, 1964 · N322H · Substantial damageNTSB UNK64X3988Accident · No injuriesClosedBeechcraft 23 · Ogallala, NESep 14, 1964 · N2377Q · Substantial damageNTSB UNK64X3930Accident · No injuriesClosedHughes 269A · North Platte, NESep 12, 1964 · N8715F · DestroyedNTSB UNK64X3898Accident · No injuriesClosedBeechcraft 33 · Hastings, NESep 10, 1964 · N1512Z · Substantial damageNTSB UNK64X3870Accident · No injuriesClosedBeechcraft K35 · Omaha, NESep 8, 1964 · N9546R · Substantial damageNTSB UNK64X3831Accident · 2 fatalClosedBellanca 14-193 · Atkinson, NESep 6, 1964 · N8816R · DestroyedNTSB UNK64X3759Accident · Minor injuriesClosedHughes 269A · Lexington, NESep 3, 1964 · N8800F · DestroyedNTSB UNK64X3587Accident · No injuriesClosedPiper PA18 · Lincoln, NEAug 25, 1964 · N320T · Substantial damageNTSB UNK64X3487Accident · No injuriesClosedBeechcraft B95A · Gozad, NEAug 20, 1964 · N9695Y · DestroyedNTSB UNK64X3323Accident · Serious injuriesClosedPiper PA-18A · Loomis, NEAug 10, 1964 · N7764D · DestroyedNTSB UNK64X3295Accident · No injuriesClosedCessna 170B · Grand Island, NEAug 9, 1964 · N3292A · Substantial damageNTSB UNK64X3068Accident · No injuriesClosedPiper PA25 · Mclean, NEJul 27, 1964 · N7018Z · Substantial damageNTSB UNK64X2795Accident · No injuriesClosedPiper PA12 · Gordon, NEJul 12, 1964 · N1771P · DestroyedNTSB UNK64X2720Accident · No injuriesClosedSlingsby Lark 4 · Max, NEJul 8, 1964 · N135G · 2 aircraft · Substantial damageNTSB UNK64X2691Accident · 1 fatalClosedPiper J3 · Tekamah, NEJul 6, 1964 · N98775 · DestroyedNTSB UNK64X2589Accident · No injuriesClosedPiper DA25 · Neligh, NEJul 1, 1964 · N6944Z · Substantial damageNTSB UNK64X2568Accident · No injuriesClosedPiper PA22 · Sidney, NEJun 29, 1964 · N4785Z · Substantial damageNTSB UNK64X2484Accident · Minor injuriesClosedBell 47G · Ord, NEJun 25, 1964 · N935B · DestroyedNTSB UNK64X2308Accident · 1 fatalClosedPiper PA22 · Grant, NEJun 15, 1964 · N2915Z · DestroyedNTSB UNK64X2304Accident · No injuriesClosedCessna 120 · Lexington, NEJun 15, 1964 · N76948 · Substantial damageNTSB UNK64X2287Accident · No injuriesClosedPiper PA28 · Burwell, NEJun 14, 1964 · N5152W · Substantial damageNTSB UNK64X2248Accident · No injuriesClosedCessna 170A · Omaha, NEJun 12, 1964 · N5728C · Substantial damageNTSB UNK64X2156Accident · Minor injuriesClosedPiper PA-18 · North Platte, NEJun 6, 1964 · N9061D · DestroyedNTSB UNK64X1813Accident · 1 fatalClosedFunk B85C · Fort Calhoun, NEMay 17, 1964 · N81192 · DestroyedNTSB UNK64X1744Accident · 2 fatalClosedBeech B95 · Columbus, NEMay 12, 1964 · N9890R · Substantial damageNTSB UNK64X1631Accident · No injuriesClosedCessna 175 · North Platte, NEMay 5, 1964 · N7521M · Substantial damageNTSB UNK64X1630Accident · No injuriesClosedCessna 172C · Niobrara, NEMay 5, 1964 · N1841Y · Substantial damageNTSB UNK64X1454Accident · No injuriesClosedBeechcraft 35 · Omaha, NEApr 25, 1964 · N2886V · Substantial damageNTSB UNK64X1343Accident · Minor injuriesClosedCessna 180 · Dix, NEApr 16, 1964 · N2197Z · DestroyedNTSB UNK64X1296Accident · No injuriesClosedPiper PA16 · Lincoln, NEApr 13, 1964 · N5250H · Substantial damageNTSB UNK64X1224Accident · Minor injuriesClosedTaylorcraft BL65 · Mullen, NEApr 8, 1964 · N22268 · Substantial damageNTSB UNK64X1184Accident · Minor injuriesClosedCessna 182A · Lincoln, NEApr 5, 1964 · N4865D · Substantial damageNTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NEApr 3, 1964 · N76748 · Substantial damage