NTSB investigations, 1965, NC

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, NC per year, 1962–2026: 3,234 cases
19623
19632
1964102
196583
196681
1967101
196885
196977
197067
197186
197289
1973118
1974100
197590
197676
197777
197877
197952
198059
198147
198259
198356
198453
198551
198660
198747
198852
198952
199048
199152
199250
199337
199452
199539
199632
199749
199835
199938
200042
200140
200237
200338
200427
200542
200639
200737
200833
200937
201031
201137
201228
201330
201429
201544
201625
201734
201824
201929
202030
202141
202230
202334
202433
202522
202627

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\" = 'NC' 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 MIA66F0355Accident · Minor injuriesClosedCessna 172 · Pine Hall, NCDec 29, 1965 · N6967A · Substantial damageNTSB MIA66F0394Accident · Serious injuriesClosedPiper PA-22 · Wilmington, NCDec 26, 1965 · N4745A · Substantial damageNTSB MIA66A0070Accident · 2 fatalClosedCessna 172C · Castle Hayne, NCDec 19, 1965 · N8470X · Substantial damageNTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCDec 17, 1965 · N4836Z · Substantial damageNTSB MIA66F0402Accident · 1 fatalClosedBeechcraft A-23 · Southern Pines, NCDec 16, 1965 · N8867M · DestroyedNTSB MIA66F0409Accident · No injuriesClosedPiper PA-24 · New Bern, NCDec 14, 1965 · N6830P · Substantial damageNTSB MIA66A0067Accident · No injuriesClosedJodel D1190S · Wilmington, NCDec 14, 1965 · N2803Q · Substantial damageNTSB MIA66F0342Accident · No injuriesClosedPiper PA-22 · Wendell, NCDec 11, 1965 · N2312P · 2 aircraft · Substantial damageNTSB MIA66D0332Accident · No injuriesClosedCessna 210 · Lumberton, NCNov 28, 1965 · N210E · Substantial damageNTSB MIA66F0324Accident · No injuriesClosedPiper PA-24 · Statesville, NCNov 26, 1965 · N6922P · Substantial damageNTSB MIA66A0061Accident · 1 fatalClosedPiper PA-28 · New Topsail Bc, NCNov 26, 1965 · N6902W · DestroyedNTSB MIA66F0305Accident · No injuriesClosedPiper PA-18A · Fontana Villge, NCNov 15, 1965 · N8070D · Substantial damageNTSB MIA66F0328Accident · No injuriesClosedCessna 180 · Charlotte, NCNov 14, 1965 · N4684B · Substantial damageNTSB MIA66F0315Accident · Serious injuriesClosedPiper PA-18 · Moriah, NCNov 14, 1965 · N1856P · DestroyedNTSB MIA66A0056Accident · 3 fatalClosedStinson 108-3 · Lawndale, NCNov 11, 1965 · N6733M · DestroyedNTSB MIA66D0313Accident · Minor injuriesClosedCessna 182 · Scotland Neck, NCNov 4, 1965 · N7178E · Substantial damageNTSB MIA66F0304Accident · No injuriesClosedBeechcraft D35 · Greensboro, NCNov 2, 1965 · N2109D · Substantial damageNTSB MIA66F0308Accident · No injuriesClosedErcoupe 415C · Spruce Pine, NCOct 30, 1965 · N87294 · Substantial damageNTSB MIA66F0295Accident · No injuriesClosedCessna 205 · Hendersonville, NCOct 29, 1965 · N8203Z · Substantial damageNTSB MIA66F0280Accident · Minor injuriesClosedCessna 140 · Shelby, NCOct 27, 1965 · N76477 · Substantial damageNTSB MIA66F0286Accident · No injuriesClosedPiper PA-20 · Charlotte, NCOct 26, 1965 · N1512A · Substantial damageNTSB MIA66F0261Accident · No injuriesClosedBeechcraft D35 · Gastonia, NCOct 16, 1965 · N2845V · Substantial damageNTSB MIA66A0042Accident · Minor injuriesClosedDouglas DC-7 · Charlotte, NCOct 16, 1965 · N824D · Substantial damageNTSB MIA66D0282Accident · No injuriesClosedPiper PA-20 · No Wilkesboro, NCOct 3, 1965 · N7738K · Substantial damageNTSB MIA66F0253Accident · No injuriesClosedPiper PA-23 · Albemarle, NCSep 19, 1965 · N5329Y · Substantial damageNTSB MIA66A0027Accident · No injuriesClosedBell 47D1 · Sligo, NCSep 7, 1965 · N9115R · Substantial damageNTSB MIA66F0211Accident · No injuriesClosedCessna 182 · Shelby, NCSep 5, 1965 · N2854Y · Substantial damageNTSB IAD75AI030Accident · 1 fatalClosedCessna 120 · Black Mountain, NCSep 3, 1965 · N76173 · DestroyedNTSB MIA66F0187Accident · Serious injuriesClosedCessna 170B · Grimesland, NCAug 30, 1965 · N8033A · Substantial damageNTSB MIA66D0189Accident · No injuriesClosedPiper PA-22 · Buies Creek, NCAug 30, 1965 · N7120B · Substantial damageNTSB MIA66F0186Accident · No injuriesClosedPiper PA-22 · High Point, NCAug 28, 1965 · N8610D · Substantial damageNTSB MIA66F0166Accident · No injuriesClosedPiper PA-24 · Jacksonville, NCAug 24, 1965 · N8643P · Substantial damageNTSB MIA66F0165Accident · No injuriesClosedPiper PA-28 · Cove City, NCAug 21, 1965 · N8141W · Substantial damageNTSB MIA66F0162Accident · No injuriesClosedConvair L-13A · Ayden, NCAug 17, 1965 · N2531B · Substantial damageNTSB MIA66A0019Accident · 1 fatalClosedBeechcraft A-35 · Statesville, NCAug 13, 1965 · N8595A · DestroyedNTSB MIA66F0121Accident · No injuriesClosedBeechcraft 95-55 · Astonia, NCAug 11, 1965 · N1377Z · Substantial damageNTSB MIA66F0095Accident · Minor injuriesClosedBeechcraft 23 · Igh P0int, NCAug 10, 1965 · N8721M · Substantial damageNTSB MIA66F0119Accident · No injuriesClosedBeechcraft 23 · Asheville, NCAug 7, 1965 · N2387L · Substantial damageNTSB MIA66F0094Accident · No injuriesClosedMooney M20A · Charlotte, NCAug 7, 1965 · N6022X · Substantial damageNTSB UNK65X1523Accident · Minor injuriesClosedPiper PA-18A · Gumberry, NCAug 3, 1965 · N1445A · DestroyedNTSB MIA66F0127Accident · No injuriesClosedPiper J3C · Indian Trail, NCAug 1, 1965 · N70889 · Substantial damageNTSB MIA66F0071Accident · Minor injuriesClosedPiper J-3C · Stokesdale, NCJul 31, 1965 · N29074 · Substantial damageNTSB MIA66F0070Accident · No injuriesClosedChampion 7FC · Greensboro, NCJul 25, 1965 · N9019B · Substantial damageNTSB MIA66F0163Accident · Serious injuriesClosedFairchild M62A · Bragtown, NCJul 24, 1965 · N49752 · DestroyedNTSB MIA66F0052Accident · No injuriesClosedPiper PA-28 · Winston Salem, NCJul 17, 1965 · N8618W · Substantial damageNTSB MIA66F0049Accident · No injuriesClosedPiper PA-18A · Laurinburg, NCJul 14, 1965 · N8259E · DestroyedNTSB MIA66F0063Accident · Minor injuriesClosedTaylorcraft BC12D · Mineral Sps, NCJul 12, 1965 · N96185 · Substantial damageNTSB MIA66I0005Incident · No injuriesClosedMartin M-404 · Winston Salem, NCJul 9, 1965 · N40448 · Minor damageNTSB MIA66F0144Accident · Serious injuriesClosedStinson 108 · Booneville, NCJul 5, 1965 · N8450K · Substantial damageNTSB MIA66D0057Accident · No injuriesClosedCessna 210 · Faison, NCJun 27, 1965 · N9470X · Substantial damage