NTSB investigations, 1981, NC

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, 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\") = 1981
    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 ATL82FA030Accident · 2 fatalClosedPiper PA-32R · Wallace, NCDec 23, 1981 · N202DH · DestroyedNTSB ATL82FLJ03Accident · 1 fatalClosedDabbs B8M · Garland, NCNov 8, 1981 · N4256Y · DestroyedNTSB ATL82FA014Accident · 1 fatalClosedBalzer DSK-1 · Washington, NCNov 1, 1981 · N85RB · DestroyedNTSB ATL82FLJ02Accident · Serious injuriesClosedPiper PA-24 · Chapel Hill, NCOct 30, 1981 · N222JG · Substantial damageNTSB ATL82FLJ01Accident · Minor injuriesClosedCessna 150J · Knightdale, NCOct 14, 1981 · N5504G · Substantial damageNTSB ATL82FKM01Accident · Minor injuriesClosedCessna R182 · West Jefferson, NCOct 12, 1981 · N738VD · DestroyedNTSB ATL82FKM02Accident · No injuriesClosedGR Lakes 2T-1A2 · Pinnacle, NCOct 11, 1981 · N4008L · Substantial damageNTSB ATL82IA003Incident · No injuriesClosedBoeing 737 · Greensboro, NCOct 3, 1981 · N767N · Minor damageNTSB ATL81FLJ18Accident · Serious injuriesClosedCessna P206E · Wilmar, NCSep 28, 1981 · N5715J · DestroyedNTSB ATL81FLJ17Accident · 1 fatalClosedCessna 188B · Edenton, NCSep 8, 1981 · N53284 · DestroyedNTSB ATL81FLJ16Accident · Serious injuriesClosedScorpion 145 · Garner, NCSep 6, 1981 · N90336 · Substantial damageNTSB ATL81FA111Accident · 2 fatalClosedMooney M20C · Thomasville, NCAug 29, 1981 · N1278X · DestroyedNTSB ATL81DLJ15Accident · No injuriesClosedCessna 188 · Newton Grove, NCJul 30, 1981 · N8112G · DestroyedNTSB ATL81FLJ14Accident · Minor injuriesClosedCessna 172N · Roxboro, NCJul 24, 1981 · N739WD · DestroyedNTSB ATL81DLJ13Accident · No injuriesClosedPiper PA-28 · Salvo, NCJul 20, 1981 · N8391S · Substantial damageNTSB ATL81FA098Accident · 1 fatalClosedPiper PA-28 · Buckland, NCJul 19, 1981 · N7141C · DestroyedNTSB ATL81FA095Accident · Serious injuriesClosedCessna 172L · Banner Elk, NCJul 15, 1981 · N7166Q · DestroyedNTSB ATL81FKM14Accident · Serious injuriesClosedPiper PA-32R · Asheville, NCJul 13, 1981 · N17123 · Substantial damageNTSB ATL81FA094Accident · 1 fatalClosedPiper PA-31P · Wilmington, NCJul 11, 1981 · N7318L · DestroyedNTSB ATL81DLJ12Accident · No injuriesClosedCessna 188A · Bayboro, NCJul 7, 1981 · N9916G · DestroyedNTSB ATL81FLJ11Accident · Minor injuriesClosedErco 415-E · Southport, NCJun 29, 1981 · N2527H · Substantial damageNTSB ATL81DLJ10Accident · No injuriesClosedCessna 150M · Farmville, NCJun 21, 1981 · N714RM · Substantial damageNTSB ATL81FLJ09Accident · Serious injuriesClosedCessna 172K · Conetoe, NCJun 17, 1981 · N7327G · DestroyedNTSB ATL81DLJ08Accident · No injuriesClosedCessna 150 · Knightdale, NCJun 16, 1981 · N704ZQ · Substantial damageNTSB ATL81DKM13Accident · No injuriesClosedPiper PA-28 · Charlotte, NCJun 6, 1981 · N40045 · Substantial damageNTSB ATL81FA080Accident · 1 fatalClosedPiper PA-22 · Chapel Hill, NCJun 5, 1981 · N4414A · Substantial damageNTSB ATL81DLJ07Accident · Minor injuriesClosedPiper PA-28 · Windsor, NCJun 4, 1981 · N4466J · DestroyedNTSB ATL81DKM12Accident · No injuriesClosedCessna 172M · Concord, NCMay 28, 1981 · N21265 · Substantial damageNTSB ATL81FKM11Accident · Serious injuriesClosedTaylorcraft BC-12D · Indian Trail, NCMay 23, 1981 · N44073 · Substantial damageNTSB ATL81DKM10Accident · No injuriesClosedCessna 170 · Mocksville, NCMay 16, 1981 · N2538C · Substantial damageNTSB ATL81FLJ06Accident · No injuriesClosedPiper PA-34 · Raleigh, NCApr 27, 1981 · N1097X · Substantial damageNTSB ATL81FA069Accident · 1 fatalClosedCessna 337G · Greensboro, NCApr 27, 1981 · N9GK · DestroyedNTSB ATL81DKM09Accident · No injuriesClosedMooney M20C · Asheboro, NCApr 27, 1981 · N5505Q · Substantial damageNTSB ATL81DKM08Accident · Minor injuriesClosedCessna 172A · Maiden, NCApr 16, 1981 · N7468T · Substantial damageNTSB ATL81IA064Incident · No injuriesClosedNamc YS-11 · Charlotte, NCApr 13, 1981 · N259P · Minor damageNTSB ATL81DKM07Accident · Minor injuriesClosedBeech C23 · Greensboro, NCApr 11, 1981 · N24650 · DestroyedNTSB ATL81DKM06Accident · No injuriesClosedPiper PA-28 · Shiloh, NCApr 7, 1981 · N1453T · Substantial damageNTSB ATL81FLJ05Accident · Minor injuriesClosedCessna 172M · Belhaven, NCMar 25, 1981 · N9640Q · Substantial damageNTSB ATL81FKM05Accident · No injuriesClosedPiper PA-28 · Long Island, NCMar 25, 1981 · N8340C · Substantial damageNTSB ATL81FA056Accident · 1 fatalClosedCessna 182 · Raeford, NCMar 15, 1981 · N5505B · DestroyedNTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCMar 12, 1981 · N1301R · DestroyedNTSB ATL81DKM04Accident · No injuriesClosedPiper PA-22 · Morganton, NCMar 6, 1981 · N4765A · Substantial damageNTSB ATL81FA050Accident · 1 fatalClosedPiper PA-28 · Statesville, NCFeb 22, 1981 · N2552U · Substantial damageNTSB ATL81FKM03Accident · No injuriesClosedCessna 152 · Bear Creek, NCFeb 14, 1981 · N25808 · Substantial damageNTSB ATL81FA043Accident · 7 fatalClosedCessna 340A · Chapel Hill, NCFeb 7, 1981 · N8682K · DestroyedNTSB ATL81FLJ04Accident · Minor injuriesClosedStinson 108 · Havelock, NCFeb 1, 1981 · N97276 · Substantial damageNTSB ATL81DKM02Accident · No injuriesClosedCessna 210 · Marion, NCJan 3, 1981 · N6496C · Substantial damage