NTSB investigations, 1976, NC

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

19622026
NTSB investigations, 1976, 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\") = 1976
    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 IAD77DLJ03Accident · No injuriesClosedCessna 180 · Rougemont, NCDec 30, 1976 · N2464C · Substantial damageNTSB IAD77FLJ06Accident · Serious injuriesClosedTaylorcraft BC12-D · Durants Neck, NCDec 28, 1976 · N95923 · DestroyedNTSB IAD77FLJ01Accident · Minor injuriesClosedPiper PA-23 · Angier, NCDec 18, 1976 · N1054P · Substantial damageNTSB IAD77DKM09Accident · No injuriesClosedPiper PA-28R · Bryson City, NCDec 17, 1976 · N333T · Substantial damageNTSB IAD77DKM08Accident · Minor injuriesClosedStarduster T00 · Gastonia, NCDec 11, 1976 · N2453 · Substantial damageNTSB IAD77DKM07Accident · No injuriesClosedCessna 182 · Hickory, NCDec 9, 1976 · N42116 · Substantial damageNTSB IAD77FA015Accident · 4 fatalClosedCessna 210 · Oxford, NCNov 28, 1976 · N360WL · DestroyedNTSB IAD77FA013Accident · 3 fatalClosedCessna 310 · Black Mountain, NCNov 16, 1976 · N3625D · DestroyedNTSB IAD77FA012Accident · 4 fatalClosedPiper PA-28 · Wise, NCNov 12, 1976 · N2693T · DestroyedNTSB IAD77FLJ05Accident · Minor injuriesClosedCessna 150 · Woodland, NCNov 5, 1976 · N63283 · Substantial damageNTSB IAD77DKM06Accident · No injuriesClosedCessna 150 · Banner Elk, NCOct 29, 1976 · N88656 · Substantial damageNTSB IAD77DKM04Accident · No injuriesClosedCessna 182 · Gastonia, NCOct 29, 1976 · N3463F · Substantial damageNTSB IAD77FA009Accident · 2 fatalClosedBellanca 17-30A · Nakina, NCOct 24, 1976 · N8799V · DestroyedNTSB IAD77DKM05Accident · No injuriesClosedCessna 172 · Wadesboro, NCOct 24, 1976 · N19815 · Substantial damageNTSB IAD77FKM03Accident · 3 fatalClosedBalloon 1 · Charlotte, NCOct 21, 1976 · NONE · DestroyedNTSB IAD77IA006Incident · No injuriesClosedMitsubishi MU-2K · Charlotte, NCOct 16, 1976 · N500BJ · Minor damageNTSB IAD77FLJ02Accident · No injuriesClosedHiller UH-12D · Morrisville, NCOct 12, 1976 · N67089 · Substantial damageNTSB IAD77DKM02Accident · No injuriesClosedCessna 172 · Bryson City, NCOct 12, 1976 · N2005Y · DestroyedNTSB IAD77FA004Accident · No injuriesClosedPiper PA-32R · Wilmington, NCOct 11, 1976 · N5765R · Substantial damageNTSB IAD77FA005Accident · 4 fatalClosedPiper PA-34 · Busick, NCOct 9, 1976 · N15025 · DestroyedNTSB IAD76FKM01Accident · No injuriesClosedPiper PA-25 · Charlotte, NCOct 3, 1976 · HI-271 · Substantial damageNTSB IAD76FKM47Accident · No injuriesClosedPiper PA-30 · Charlotte, NCSep 25, 1976 · N4GR · Substantial damageNTSB IAD76II100Incident · No injuriesClosedDouglas DC-3C · Gastonia, NCSep 22, 1976 · N83FA · Minor damageNTSB IAD76FLJ38Accident · Serious injuriesClosedErcoupe 415C · Magnolia, NCSep 19, 1976 · N2566H · Substantial damageNTSB IAD76FLJ28Accident · No injuriesClosedCessna A188B · Battleboro, NCSep 16, 1976 · N4845R · Substantial damageNTSB IAD76FLJ37Accident · No injuriesClosedBeech A23 · Beaufort, NCSep 14, 1976 · N4751J · Substantial damageNTSB IAD76DKM46Accident · No injuriesClosedCessna 150 · Ashville, NCSep 11, 1976 · N50261 · Substantial damageNTSB IAD76DKM45Accident · Minor injuriesClosedCessna 170A · Concord, NCSep 6, 1976 · N2556V · Substantial damageNTSB IAD76FLJ35Accident · No injuriesClosedCessna 188B · Dunn, NCAug 30, 1976 · N8983G · DestroyedNTSB IAD76FLJ34Accident · No injuriesClosedPiper PA-18A · Lagrange, NCAug 28, 1976 · N5887D · DestroyedNTSB IAD76AI095Accident · 1 fatalClosedPiper PA-22 · Mooresville, NCAug 26, 1976 · N5182Z · DestroyedNTSB IAD76DKM44Accident · No injuriesClosedPiper PA-24 · Waynesville, NCAug 22, 1976 · N740W · Substantial damageNTSB IAD76FLJ33Accident · No injuriesClosedCessna 172 · Apex, NCAug 17, 1976 · N5539R · Substantial damageNTSB IAD76AI092Accident · 5 fatalClosedCessna 172K · Bryson City, NCAug 9, 1976 · N78479 · DestroyedNTSB IAD76AI088Accident · 1 fatalClosedPiper J3C · Troy, NCJul 31, 1976 · N3353N · DestroyedNTSB IAD76II087Incident · No injuriesClosedCessna 402A · Charlotte, NCJul 29, 1976 · N4511Q · Minor damageNTSB IAD76FLJ32Accident · No injuriesClosedStinson 108 · Durham, NCJul 27, 1976 · N9432K · Substantial damageNTSB IAD76DKM42Accident · Minor injuriesClosedCessna 150 · Bessemer City, NCJul 25, 1976 · N9194U · Substantial damageNTSB IAD76DKM40Accident · No injuriesClosedPiper PA-30 · Boone, NCJul 22, 1976 · N8803Y · Substantial damageNTSB IAD76FLJ31Accident · No injuriesClosedCessna 177 · Wilson, NCJul 21, 1976 · N34902 · Substantial damageNTSB IAD76FKM41Accident · Serious injuriesClosedPiper PA-28 · Asheboro, NCJul 21, 1976 · N1875T · DestroyedNTSB IAD76FKM43Accident · No injuriesClosedM-Saulnier MS894A · Cliffside, NCJul 13, 1976 · N44BF · Substantial damageNTSB IAD76AI082Accident · 3 fatalClosedBellanca 17-31A · Jacksonville, NCJul 4, 1976 · N8211R · DestroyedNTSB IAD76AI080Accident · 1 fatalClosedCessna 182M · Beaufort, NCJul 3, 1976 · N71432 · DestroyedNTSB IAD76AI078Accident · 1 fatalClosedCessna 172 · St Pauls, NCJul 3, 1976 · N4319L · DestroyedNTSB IAD76FLJ26Accident · Serious injuriesClosedScamp WT16 · Holly Springs, NCJul 2, 1976 · N14GA · Substantial damageNTSB IAD76FKM39Accident · Minor injuriesClosedPiper PA-23 · Huntersville, NCJul 1, 1976 · N5112Y · Substantial damageNTSB IAD76DKM38Accident · No injuriesClosedCessna 310 · Greensboro, NCJul 1, 1976 · N5133J · Substantial damageNTSB IAD76FLJ25Accident · No injuriesClosedCessna 402B · Wilmington, NCJun 27, 1976 · N4088L · Substantial damageNTSB IAD76DKM37Accident · No injuriesClosedGrum Amer AA-5 · Rutherfordton, NCJun 19, 1976 · N6076L · Substantial damage