NTSB investigations, 1966, NC

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1966, 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\") = 1966
    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 MIA67F0335Accident · No injuriesClosedPiper PA-28 · Pikeville, NCDec 30, 1966 · N5028W · Substantial damageNTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damageNTSB MIA67D0328Accident · No injuriesClosedMooney M20E · Chapel Hill, NCDec 8, 1966 · N6077Q · Substantial damageNTSB MIA67D0280Accident · No injuriesClosedMooney M20E · Ramseur, NCNov 24, 1966 · N5711Q · Substantial damageNTSB MIA67A0058Accident · 3 fatalClosedMartin M-404 · New Bern, NCNov 20, 1966 · N40406 · DestroyedNTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNov 5, 1966 · N4459M · Substantial damageNTSB MIA67A0284Accident · No injuriesClosedBeech P35 · Eagle Springs, NCOct 25, 1966 · N9602Y · Substantial damageNTSB MIA67F0233Accident · Minor injuriesClosedBeech F35 · Rutherfordton, NCOct 22, 1966 · N277P · Substantial damageNTSB MIA67A0051Accident · 1 fatalClosedBensen B8M · Morrisville, NCOct 22, 1966 · N4683S · DestroyedNTSB MIA67F0218Accident · No injuriesClosedBoeing IB75A · Palmyra, NCOct 14, 1966 · N49647 · Substantial damageNTSB MIA67F0229Accident · No injuriesClosedDehaviland DH104 · Charlotte, NCOct 9, 1966 · N477PM · Substantial damageNTSB MIA67F0199Accident · No injuriesClosedCessna 120 · Morganton, NCOct 8, 1966 · N4003N · Substantial damageNTSB MIA67D0206Accident · No injuriesClosedMooney M20C · Wilkesbord, NCOct 6, 1966 · N2713W · Substantial damageNTSB MIA67F0183Accident · No injuriesClosedMooney M20E · Buies Creek, NCOct 2, 1966 · N1937Y · Substantial damageNTSB MIA67D0238Accident · No injuriesClosedCessna 182J · Wallace, NCSep 30, 1966 · N2916F · Substantial damageNTSB MIA67A0037Accident · 4 fatalClosedCessna 170A · N.Wilkesboro, NCSep 25, 1966 · N5744C · DestroyedNTSB MIA67F0198Accident · No injuriesClosedPiper PA-24 · Charlotte, NCSep 22, 1966 · N6335P · Substantial damageNTSB MIA67F0230Accident · 1 fatalClosedPiper PA-18 · Aurora, NCSep 13, 1966 · N9375D · DestroyedNTSB MIA67F0156Accident · No injuriesClosedTaylorcraft BL-55 · Rutherfordton, NCSep 11, 1966 · N27593 · Substantial damageNTSB MIA67D0243Accident · No injuriesClosedCessna 182E · Manteo, NCSep 6, 1966 · N2907Y · Substantial damageNTSB MIA67F0157Accident · No injuriesClosedPiper J3C-65 · Sanford, NCSep 5, 1966 · N91998 · Substantial damageNTSB MIA67D0137Accident · Minor injuriesClosedCessna 150E · Cherokee, NCSep 5, 1966 · N3083J · DestroyedNTSB MIA67F0147Accident · No injuriesClosedAlon A-2 · Jacksonville, NCSep 4, 1966 · N5475E · Substantial damageNTSB MIA67A0033Accident · 4 fatalClosedMooney M20E · Andrews, NCSep 4, 1966 · N7835V · DestroyedNTSB MIA67D0174Accident · No injuriesClosedPiper PA-24 · Bryson City, NCAug 20, 1966 · N8736P · Substantial damageNTSB MIA67F0102Accident · No injuriesClosedBeech D50 · Charlotte, NCAug 12, 1966 · N4303D · Substantial damageNTSB MIA67F0071Accident · No injuriesClosedCessna 182 · Charlotte, NCJul 29, 1966 · N2938F · Substantial damageNTSB MIA67D0099Accident · No injuriesClosedLear Jet 23 · Manteo, NCJul 29, 1966 · N332PC · Substantial damageNTSB MIA67F0084Accident · No injuriesClosedErcoupe 415-C · Greensboro, NCJul 27, 1966 · N99476 · Substantial damageNTSB MIA67D0087Accident · No injuriesClosedPiper PA-24 · Beaufort, NCJul 26, 1966 · N8350P · Substantial damageNTSB MIA67A0015Accident · 2 fatalClosedMooney M20C · Jacksonville, NCJul 25, 1966 · N5730Q · DestroyedNTSB MIA67A0014Accident · 1 fatalClosedAir Space 18A · Arden, NCJul 24, 1966 · N6157S · DestroyedNTSB MIA67D0088Accident · Minor injuriesClosedAlon A-2 · Washington, NCJul 23, 1966 · N5486E · Substantial damageNTSB MIA67A0008Accident · 1 fatalClosedPiper J3C-65 · Burlington, NCJul 17, 1966 · N2147M · DestroyedNTSB MIA67F0058Accident · No injuriesClosedBeech D18S · Winston Salem, NCJul 14, 1966 · N80361 · Substantial damageNTSB MIA67F0010Accident · Minor injuriesClosedCessna 210D · Selma, NCJul 6, 1966 · N3909Y · Substantial damageNTSB MIA67F0011Accident · No injuriesClosedCessna 150 · Clinton, NCJul 5, 1966 · N7030F · Substantial damageNTSB MIA67A0002Accident · 4 fatalClosedFairchild 24W · Banner Elk, NCJul 5, 1966 · N3777C · DestroyedNTSB MIA67F0005Accident · No injuriesClosedPiper J3 · Erwin, NCJul 4, 1966 · N42463 · Substantial damageNTSB MIA67D0063Accident · No injuriesClosedPiper PA-22 · Lewisburg, NCJul 4, 1966 · N2703P · Substantial damageNTSB MIA67F0003Accident · No injuriesClosedAeronca 7FC · Greensboro, NCJul 2, 1966 · N9961Y · Substantial damageNTSB MIA67D0001Accident · No injuriesClosedCessna 182A · Lake Lure, NCJul 2, 1966 · N4785D · Substantial damageNTSB MIA66D0628Accident · No injuriesClosedCessna 172 · Bakersville, NCJun 29, 1966 · N7234T · Substantial damageNTSB MIA67F0005Accident · No injuriesClosedTaylorcraft BC12D · Mooresville, NCJun 26, 1966 · N39275 · Substantial damageNTSB MIA67A0152Accident · 2 fatalClosedCessna 172 · Hatteras, NCJun 26, 1966 · N4106F · DestroyedNTSB MIA66F0615Accident · Minor injuriesClosedWaco UPF7 · Mooresville, NCJun 26, 1966 · N173E · Substantial damageNTSB MIA66D0616Accident · No injuriesClosedPiper PA28 · Statesville, NCJun 23, 1966 · N5323W · Substantial damageNTSB MIA66D0612Accident · No injuriesClosedCessna 172 · High Point, NCJun 21, 1966 · N7315T · Substantial damageNTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCJun 15, 1966 · N3656M · Substantial damageNTSB MIA66D0619Accident · No injuriesClosedBeech E18S · Hatteras, NCJun 15, 1966 · N5637D · Substantial damage