NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 ATL81DLJ03Accident · Serious injuriesClosedCessna 182G · Apex, NCDec 9, 1980 · N2116R · No damageNTSB ATL81DKM01Accident · No injuriesClosedBaby GR LKS 1 · Greensboro, NCDec 7, 1980 · N66JM · Substantial damageNTSB ATL81FLJ01Accident · No injuriesClosedCessna 152 · Fort Bragg, NCDec 6, 1980 · N24327 · Substantial damageNTSB ATL81DLJ02Accident · No injuriesClosedBensen B8M · Spring Lake, NCDec 6, 1980 · N8053Y · Substantial damageNTSB ATL80DKM28Accident · Minor injuriesClosedPiper PA-28 · East Bend, NCOct 12, 1980 · N805MA · Substantial damageNTSB ATL81IA004Incident · No injuriesClosedFairchild F-27 · Raliegh, NCOct 9, 1980 · N112TA · Minor damageNTSB ATL80DLJ25Accident · Minor injuriesClosedCessna 172 · Zebulon, NCOct 4, 1980 · N5389T · Substantial damageNTSB ATL80DLJ24Accident · No injuriesClosedBeech 23 · Chapel Hill, NCSep 13, 1980 · N23111 · Substantial damageNTSB ATL80FA097Accident · 1 fatalClosedPiper PA-28R · Troy, NCSep 11, 1980 · N4809T · DestroyedNTSB ATL80DKM27Accident · No injuriesClosedPiper PA-28 · Charlotte, NCSep 5, 1980 · N8090G · Substantial damageNTSB ATL80IA089Incident · No injuriesClosedPiper PA-32 · Raeford, NCSep 3, 1980 · N2252Q · Minor damageNTSB ATL80DKM26Accident · No injuriesClosedDehavilland DHC-1B · Huntersville, NCSep 1, 1980 · N12BH · Substantial damageNTSB ATL80DLJ18Accident · No injuriesClosedCessna 188B · Elizabeth City, NCAug 23, 1980 · N731CX · Substantial damageNTSB ATL80DLJ21Accident · No injuriesClosedPiper PA-25 · Kenly, NCAug 20, 1980 · N7416Z · Substantial damageNTSB ATL80FLJ23Accident · No injuriesClosedPiper PA-25 · Hope Mills, NCAug 19, 1980 · N8550L · Substantial damageNTSB ATL80FLJ22Accident · No injuriesClosedGrumman G-164C · Grantham, NCAug 18, 1980 · N6770K · Substantial damageNTSB ATL80FLG18Accident · 1 fatalClosedHughes 269B · Whiteville, NCAug 18, 1980 · N9435F · DestroyedNTSB ATL80FLJ20Accident · No injuriesClosedCessna 150 · Mebane, NCAug 14, 1980 · N704FD · Substantial damageNTSB ATL80DKM23Accident · Serious injuriesClosedStarduster SA-300 · Horse Shoe, NCAug 12, 1980 · N1214 · DestroyedNTSB ATL80FA084Accident · 2 fatalClosedBellanca 7KCAB · Lake Norman, NCAug 10, 1980 · N1644G · DestroyedNTSB ATL80FKM24Accident · Minor injuriesClosedCessna 150 · Bryson City, NCAug 7, 1980 · N60556 · Substantial damageNTSB ATL80DKM22Accident · No injuriesClosedPiper PA-28 · Liberty, NCAug 5, 1980 · N8340C · Substantial damageNTSB ATL80DKM25Accident · Minor injuriesClosedPiper PA-38 · Morganton, NCAug 1, 1980 · N9362T · DestroyedNTSB ATL80FLJ19Accident · No injuriesClosedCessna 188B · Rowland, NCJul 31, 1980 · N9623G · Substantial damageNTSB ATL80FLJ15Accident · No injuriesClosedPiper PA-38 · Pinehurst, NCJul 17, 1980 · N4248E · Substantial damageNTSB ATL80DA075Accident · No injuriesClosedPiper PA-23 · Banner Elk, NCJul 15, 1980 · N6145Y · 2 aircraft · Substantial damageNTSB ATL80IA062Incident · Minor injuriesClosedDouglas DC-8 · Greensboro, NCJun 25, 1980 · N2985U · Minor damageNTSB ATL80FLJ17Accident · Minor injuriesClosedBeech B19 · Kinston, NCJun 23, 1980 · N60BW · Substantial damageNTSB ATL80FA051Accident · 2 fatalClosedCessna 172 · Salisbury, NCJun 8, 1980 · N8866B · DestroyedNTSB ATL80FLJ16Accident · No injuriesClosedCessna A188B · Harlowe, NCJun 3, 1980 · N53192 · Substantial damageNTSB ATL80FLJ14Accident · Minor injuriesClosedQuickie KN05 · Manteo, NCMay 28, 1980 · N80661 · Substantial damageNTSB ATL80FKM20Accident · Minor injuriesClosedBeech TC-45J · Maiden, NCMay 28, 1980 · N704M · Substantial damageNTSB ATL80DKM19Accident · No injuriesClosedPiper PA-28 · Gastonia, NCMay 25, 1980 · N9337C · Substantial damageNTSB ATL80FLJ13Accident · No injuriesClosedBoeing A75N1 · Wenoma, NCMay 24, 1980 · N26M · Substantial damageNTSB ATL80DKM18Accident · No injuriesClosedNavion A · Mooresville, NCMay 19, 1980 · N91679 · Substantial damageNTSB ATL80DKM17Accident · No injuriesClosedAeronca 7BCM · Greensboro, NCMay 1, 1980 · N2KT · Substantial damageNTSB IAD80FLJ12Accident · Minor injuriesClosedCessna 182 · Henderson, NCApr 25, 1980 · N2145R · Substantial damageNTSB IAD80FLJ09Accident · Minor injuriesClosedCessna 150 · Richlands, NCApr 14, 1980 · N9308U · Substantial damageNTSB IAD80DKM16Accident · No injuriesClosedCurtis-Wrt D4D · Candor, NCApr 13, 1980 · N434N · Substantial damageNTSB IAD80FA037Accident · 1 fatalClosedCessna 401 · Linville, NCApr 7, 1980 · N9912F · DestroyedNTSB IAD80DKM15Accident · Minor injuriesClosedCessna 175 · Morgantown, NCApr 7, 1980 · N7077M · Substantial damageNTSB IAD80DKM14Accident · No injuriesClosedBeech A36 · Albemarle, NCApr 6, 1980 · N5036M · Substantial damageNTSB IAD80DKM13Accident · No injuriesClosedPiper PA-28 · Mayodan, NCApr 2, 1980 · N16248 · DestroyedNTSB IAD80FA031Accident · 1 fatalClosedPiper PA-30 · Charlotte, NCMar 20, 1980 · N8547Y · DestroyedNTSB IAD80FKM12Accident · Minor injuriesClosedCessna 152 · Mayodan, NCMar 19, 1980 · N89192 · Substantial damageNTSB IAD80DKM11Accident · No injuriesClosedBalloon WKS AX-7 · East Bend, NCMar 16, 1980 · N4051Y · Substantial damageNTSB IAD80FLJ11Accident · No injuriesClosedPiper PA-28R · Raleigh Durham, NCMar 14, 1980 · N3061R · Substantial damageNTSB IAD80FLJ10Accident · No injuriesClosedPiper PA-32R · Redford, NCMar 3, 1980 · N2252Q · Substantial damageNTSB IAD80FKM10Accident · 1 fatalClosedStits Playby · China Grove, NCFeb 27, 1980 · N3732 · DestroyedNTSB IAD80FA025Accident · 2 fatalClosedCessna 152 · Vale, NCFeb 18, 1980 · N25488 · Destroyed