NTSB investigations, 1974, 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, 1974, 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\") = 1974
    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 IAD75FLJ16Accident · Minor injuriesClosedCessna 150L · Burlington, NCDec 25, 1974 · N5274Q · Substantial damageNTSB IAD75DLJ15Accident · No injuriesClosedBeech 95-B55 · Cape Hatteras, NCDec 9, 1974 · N8921M · Substantial damageNTSB IAD75FLJ14Accident · Minor injuriesClosedCessna 150 · Wilmington, NCNov 25, 1974 · N8489G · Substantial damageNTSB IAD75AI032Accident · 2 fatalClosedCessna 150J · Morganton, NCNov 24, 1974 · N60581 · DestroyedNTSB IAD75A1031|IAD75AI031Accident · 1 fatalClosedLuscombe 8A · Polkton, NCNov 23, 1974 · N2853K · 2 aircraft · Minor damageNTSB IAD75FLJ13Accident · No injuriesClosedCessna 150L · New River, NCNov 22, 1974 · N1256Q · Substantial damageNTSB IAD75DKM14Accident · 1 fatalClosedBaby Ace E · Asheville, NCNov 16, 1974 · N3556 · Substantial damageNTSB IAD75DLJ12Accident · No injuriesClosedCessna 177RG · Chapel Hill, NCNov 14, 1974 · N2097Q · Substantial damageNTSB IAD75AI028Accident · 1 fatalClosedCessna 172K · Charlotte, NCNov 7, 1974 · N84718 · DestroyedNTSB IAD75FKM13Accident · Serious injuriesClosedCessna 172M · Statesville, NCNov 2, 1974 · N1635V · DestroyedNTSB IAD75FLJ11Accident · Minor injuriesClosedCessna 150J · Kenly, NCOct 20, 1974 · N60397 · Substantial damageNTSB IAD75AI026Accident · 2 fatalClosedLuscombe 8E · Stedman, NCOct 17, 1974 · N1915K · DestroyedNTSB IAD75AI023Accident · 3 fatalClosedPiper PA-23 · Bryson City, NCOct 13, 1974 · N6980Y · DestroyedNTSB IAD75II020Incident · No injuriesClosedDassault Falcon · Southern Pines, NCOct 7, 1974 · N4350M · Minor damageNTSB IAD75DKM11Accident · No injuriesClosedCessna 177 · Waynesville, NCOct 1, 1974 · N3294T · Substantial damageNTSB IAD75AI017Accident · 1 fatalClosedCessna 140 · Greensboro, NCSep 28, 1974 · N77339 · DestroyedNTSB IAD75AI015Accident · 2 fatalClosedPiper PA-23 · Pinnacle, NCSep 26, 1974 · N2193P · DestroyedNTSB IAD75DKM10Accident · No injuriesClosedCessna 172K · Indian Trail, NCSep 18, 1974 · N46494 · Substantial damageNTSB IAD75AI013Accident · 2 fatalClosedPiper PA-28 · Raleigh, NCSep 17, 1974 · N9441J · DestroyedNTSB IAD75FLJ08Accident · No injuriesClosedCessna A188 · Pollocksville, NCSep 11, 1974 · N3552Q · DestroyedNTSB DCA75AZ009Accident · 71 fatalClosedDouglas DC9-31 · Charlotte, NCSep 11, 1974 · N8984E · DestroyedNTSB IAD75DLJ02Accident · No injuriesClosedCallair A-9 · Beaulahville, NCSep 6, 1974 · N8271H · Substantial damageNTSB IAD75FLJ10Accident · No injuriesClosedBoeing A75-N1 · Grantham, NCSep 2, 1974 · N4442N · DestroyedNTSB IAD75AI009Accident · 2 fatalClosedBoeing A75L3 · Waynesville, NCSep 1, 1974 · N5118N · DestroyedNTSB IAD75DKM09Accident · No injuriesClosedPiper PA-22 · Salisbury, NCAug 24, 1974 · N29062 · Substantial damageNTSB IAD75FLJ09Accident · Minor injuriesClosedCessna 140 · Angier, NCAug 23, 1974 · N2685N · Substantial damageNTSB IAD75AI007Accident · 2 fatalClosedCessna 210 · Duck, NCAug 16, 1974 · N9456X · DestroyedNTSB IAD75FKM08Accident · Minor injuriesClosedPiper PA-28 · Winston Salem, NCAug 15, 1974 · N15880 · DestroyedNTSB IAD75DLJ06Accident · Serious injuriesClosedBellanca 14-13 · Fayetteville, NCAug 11, 1974 · N74375 · Substantial damageNTSB IAD75FLJ07Accident · Minor injuriesClosedPiper 28-140 · Raleigh, NCAug 9, 1974 · N8797N · Substantial damageNTSB IAD74DLJ05Accident · No injuriesClosedCessna 150 · Chocowinity, NCAug 4, 1974 · N19007 · Substantial damageNTSB IAD75DLJ04Accident · No injuriesClosedPiper PA-25 · Lagrange, NCAug 3, 1974 · N6548Z · Substantial damageNTSB IAD75FIJ03Accident · Serious injuriesClosedCallair A-9 · Rowland, NCAug 1, 1974 · N8236H · DestroyedNTSB IAD75DKM07Accident · No injuriesClosedPiper PA-30 · Asheville, NCJul 29, 1974 · N7910Y · Substantial damageNTSB IAD75AI004Accident · 2 fatalClosedBellanca 7GCBC · Archdale, NCJul 28, 1974 · N8953 · DestroyedNTSB IAD75DKM06Accident · No injuriesClosedPiper PA-30 · Charlotte, NCJul 20, 1974 · N7660Y · Substantial damageNTSB IAD75AI002Accident · 1 fatalClosedCessna 182H · Burnsville, NCJul 16, 1974 · N2350X · DestroyedNTSB IAD75DKM04Accident · Minor injuriesClosedPiper PA-22 · Monroe, NCJul 14, 1974 · N9422D · Substantial damageNTSB IAD75DKM05Accident · Minor injuriesClosedPiper PA-28 · Lake Lure, NCJul 13, 1974 · N56449 · Substantial damageNTSB IAD75DKM03Accident · No injuriesClosedBell 47G-5 · Charlotte, NCJul 12, 1974 · N7089J · Substantial damageNTSB IAD75DKM02Accident · No injuriesClosedCessna 172 · Advance, NCJul 7, 1974 · N12215 · Substantial damageNTSB IAD75DKM01Accident · Minor injuriesClosedHughes 269A · Shelby, NCJul 7, 1974 · N8934F · Substantial damageNTSB IAD75DLJ01Accident · No injuriesClosedCurtis-Wrt 16 · Gibsonville, NCJul 4, 1974 · N422W · Substantial damageNTSB IAD74DKM58Accident · Serious injuriesClosedChampion 7KCAB · Laurel Springs, NCJun 29, 1974 · N7525F · DestroyedNTSB IAD74AI071Accident · 2 fatalClosedCessna 150L · Fayetteville, NCJun 29, 1974 · N19266 · Substantial damageNTSB IAD74DLJ48Accident · No injuriesClosedCessna 150 · Ft Bragg, NCJun 25, 1974 · N19293 · Substantial damageNTSB IAD74DKM57Accident · No injuriesClosedAeronca 11AC · Taylorsville, NCJun 25, 1974 · N3404E · Substantial damageNTSB IAD74DKM59Accident · No injuriesClosedCessna 182 · Statesville, NCJun 23, 1974 · N2357X · Substantial damageNTSB IAD74FKM60Accident · No injuriesClosedBellanca 14-192 · Wallberg, NCJun 19, 1974 · N7603E · Substantial damageNTSB IAD74AI069Accident · 2 fatalClosedHughes 269B · Reidsville, NCJun 19, 1974 · N5918F · Destroyed