NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NEDec 30, 1965 · N7236X · Substantial damageNTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NEDec 9, 1965 · N9584D · DestroyedNTSB MKC66F0312Accident · Serious injuriesClosedCessna 172 · Sutherland, NENov 28, 1965 · N5632R · Substantial damageNTSB MKC66F0317Accident · No injuriesClosedPiper PA-28 · Lincoln, NENov 27, 1965 · N7151W · Substantial damageNTSB MKC66F0356Accident · No injuriesClosedPiper PA-24 · Omaha, NENov 24, 1965 · N7948P · Substantial damageNTSB MKC66F0303Accident · Minor injuriesClosedCessna 175 · Mullen, NENov 14, 1965 · N7280M · DestroyedNTSB MKC66F0292Accident · No injuriesClosedAeronca 7AC · Valley, NENov 4, 1965 · N85636 · Substantial damageNTSB MKC66F0296Accident · No injuriesClosedBeechcraft B95 · Columbus, NENov 2, 1965 · N2084C · Substantial damageNTSB MKC66F0286Accident · Serious injuriesClosedPiper PA-24 · Lincoln, NEOct 30, 1965 · N7148P · Substantial damageNTSB MKC66F0284Accident · No injuriesClosedPiper PA-12 · Paxton, NEOct 26, 1965 · N78552 · Substantial damageNTSB MKC66F0390Accident · No injuriesClosedPiper PA-28 · Grand Island, NEOct 18, 1965 · N8667W · Substantial damageNTSB MKC66F0259Accident · No injuriesClosedCessna 210 · Omaha, NEOct 9, 1965 · N6545X · Substantial damageNTSB MKC66F0250Accident · No injuriesClosedTaylorcraft BL-65 · Spencer, NEOct 3, 1965 · N27415 · Substantial damageNTSB MKC66F0227Accident · No injuriesClosedPiper PA-24 · Ogallala, NEOct 3, 1965 · N8844P · Substantial damageNTSB MKC66A0019Accident · 3 fatalClosedDouglas A-26 · Scottsbluff, NESep 17, 1965 · N67907 · DestroyedNTSB MKC66F0222Accident · No injuriesClosedBeechcraft 35-33 · Omaha, NESep 9, 1965 · N875R · Substantial damageNTSB MKC66F0195Accident · No injuriesClosedPiper PA-23 · Wallace, NESep 7, 1965 · N4322P · Substantial damageNTSB MKC66F0192Accident · No injuriesClosedCessna 185 · Fairbury, NEAug 27, 1965 · N9852X · Substantial damageNTSB MKC66F0191Accident · No injuriesClosedPiper PA-18A · Hershey, NEAug 15, 1965 · N7885D · Substantial damageNTSB MKC66F0137Accident · No injuriesClosedPiper PA-18A · Elm Creek, NEAug 5, 1965 · N1025A · Substantial damageNTSB MKC66F0163Accident · No injuriesClosedCessna 180 · Scottsbluff, NEAug 2, 1965 · N7629A · Substantial damageNTSB MKC66F0136Accident · No injuriesClosedBeechcraft A-23 · Crofton, NEAug 2, 1965 · N8798M · Substantial damageNTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NEAug 1, 1965 · N4279N · Substantial damageNTSB UNK65X1519Accident · No injuriesClosedPiper PA-18A · Kimball, NEJul 25, 1965 · N9099D · Substantial damageNTSB MKC66F0107Accident · No injuriesClosedPiper J-3 · Giltner, NEJul 25, 1965 · N3340N · Substantial damageNTSB MKC66F0108Accident · No injuriesClosedPiper PA-25 · Hayes Center, NEJul 21, 1965 · N6191Z · Substantial damageNTSB MKC66F0094Accident · Minor injuriesClosedPiper PA-18 · Fremont, NEJul 17, 1965 · N7489D · Substantial damageNTSB MKC66F0084Accident · No injuriesClosedMooney M20 · Omaha, NEJul 17, 1965 · N5289B · DestroyedNTSB MKC66A0002Accident · Serious injuriesClosedBoeing 707 131B · Omaha, NEJul 6, 1965 · N756TW · No damageNTSB MKC66F0074Accident · Serious injuriesClosedCessna 182C · Culbertson, NEJul 3, 1965 · N8600T · Substantial damageNTSB MKC66F0070Accident · Minor injuriesClosedChampion 7GCB · Imperial, NEJul 3, 1965 · N9937Y · Substantial damageNTSB MKC66F0092Accident · Serious injuriesClosedPiper PA-18 · Minden, NEJul 1, 1965 · N4396A · Substantial damageNTSB MKC66D0054Accident · No injuriesClosedPiper PA-18A · Sutherland, NEJun 28, 1965 · N1894A · Substantial damageNTSB MKC66F0057Accident · No injuriesClosedBeech A35 · Hoskins, NEJun 22, 1965 · N8406A · Substantial damageNTSB MKC65A0077Accident · 1 fatalClosedPiper J3C · Nebraska City, NEJun 21, 1965 · N6149H · DestroyedNTSB MKC66D0046Accident · No injuriesClosedPiper PA-22 · Gibbon, NEJun 20, 1965 · N4902Z · Substantial damageNTSB MKC66F0064Accident · No injuriesClosedPiper PA-25 · Scottsbluff, NEJun 18, 1965 · N6470Z · Substantial damageNTSB MKC66F0060Accident · Serious injuriesClosedAeronca 7AC · Springview, NEJun 14, 1965 · N82060 · Substantial damageNTSB MKC66F0053Accident · No injuriesClosedCallair A-6 · Humbolt, NEJun 14, 1965 · N2926G · Substantial damageNTSB MKC66F0045Accident · No injuriesClosedBeechcraft F-17D · Papillion, NEJun 3, 1965 · N46296 · Substantial damageNTSB MKC66F0032Accident · No injuriesClosedPiper PA-25 · Gilead, NEJun 3, 1965 · N7062Z · Substantial damageNTSB MKC66F0031Accident · No injuriesClosedCessna 182H · Grand Island, NEJun 3, 1965 · N3457S · Substantial damageNTSB MKC65A0071Accident · 4 fatalClosedBeechcraft 35 · Bee, NEJun 1, 1965 · N80450 · DestroyedNTSB MKC66D0037Accident · No injuriesClosedPiper PA-18A · Decatur, NEMay 30, 1965 · N3993P · Substantial damageNTSB MKC66F0004Accident · Serious injuriesClosedPiper PA-22 · Imperial, NEMay 28, 1965 · N2661P · DestroyedNTSB MKC65F0154Accident · 1 fatalClosedSchweizer SGS126 · Papillion, NEMay 16, 1965 · N2768R · DestroyedNTSB MKC66D0001Accident · Minor injuriesClosedPiper J3-C · Nebraska City, NEMay 12, 1965 · N3482K · DestroyedNTSB MKC65F0131Accident · No injuriesClosedPiper PA-22 · Sutherland, NEMay 6, 1965 · N3052Z · Substantial damageNTSB MKC65D0114Accident · No injuriesClosedCessna 182 · Ord, NEMay 2, 1965 · N6269A · Substantial damageNTSB MKC65F0134Accident · No injuriesClosedBeechcraft 23 · Lincoln, NEApr 21, 1965 · N23070 · Substantial damage