NTSB investigations, 1966

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year, 1962–2026: 180,581 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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
  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 SEA67F0232Accident · No injuriesClosedBeech A45 · Aurora, ORDec 31, 1966 · N6602C · Substantial damageNTSB SEA67D0228Accident · No injuriesClosedPiper PA-28 · Bellevue, WADec 31, 1966 · N5745W · Substantial damageNTSB OAK67F0239Accident · No injuriesClosedPiper PA-28 · Carmel Valley, CADec 31, 1966 · N6022W · Substantial damageNTSB NYC67D0439Accident · No injuriesClosedPiper PA-22 · Clarion, PADec 31, 1966 · N3547P · Substantial damageNTSB NYC67D042.Accident · No injuriesClosedPiper PA-22 · Jaffrey, NHDec 31, 1966 · N5805Z · Substantial damageNTSB MKC67F0383Accident · Minor injuriesClosedAeronca 7CCM · Phelphs, MNDec 31, 1966 · N4642E · Substantial damageNTSB MKC67D0395Accident · No injuriesClosedCessna 120 · Marion, IADec 31, 1966 · N2672N · Substantial damageNTSB MKC67D0385Accident · No injuriesClosedPiper PA-18 · Kempton, NDDec 31, 1966 · N9469D · Substantial damageNTSB MKC67D0375Accident · No injuriesClosedPiper PA-22 · Grundy Cntr, IADec 31, 1966 · N2486P · Substantial damageNTSB MKC67D0350Accident · No injuriesClosedCessna 210B · Lincoln, NEDec 31, 1966 · N9743X · Substantial damageNTSB MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GADec 31, 1966 · N2570F · Substantial damageNTSB MIA67F0348Accident · Minor injuriesClosedPiper PA-28 · Ocala, FLDec 31, 1966 · N8139W · Substantial damageNTSB MIA67F0339Accident · No injuriesClosedPiper PA-22 · Ellenton, FLDec 31, 1966 · N5828D · Substantial damageNTSB MIA67D0357Accident · No injuriesClosedCessna 170A · Cocoa, FLDec 31, 1966 · N1734D · Substantial damageNTSB MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GADec 31, 1966 · N3279V · DestroyedNTSB LAX67F0225Accident · No injuriesClosedPiper PA-24 · Hawthorne, CADec 31, 1966 · N8550P · Substantial damageNTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoDec 31, 1966 · N6879M · DestroyedNTSB DIA67F0009Accident · No injuriesClosedLuscombe 8F · Gaithersburg, MDDec 31, 1966 · N802B · Substantial damageNTSB DIA67D0006Accident · No injuriesClosedBeech D35 · Waynesboro, VADec 31, 1966 · N3000V · Substantial damageNTSB CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OHDec 31, 1966 · N3880R · Substantial damageNTSB SEA67F0245Accident · Serious injuriesClosedCessna 170A · Kalama, WADec 30, 1966 · N9237A · DestroyedNTSB NYC67F0574Accident · No injuriesClosedPiper PA-24 · Coraopolis, PADec 30, 1966 · N5276P · Substantial damageNTSB NYC67F0443Accident · No injuriesClosedCessna 320D · Morristown, NJDec 30, 1966 · N4118T · Substantial damageNTSB NYC67F0428Accident · No injuriesClosedPiper PA-24 · Selinsgrove, PADec 30, 1966 · N8999P · Substantial damageNTSB NYC67D0675Accident · No injuriesClosedCessna 172C · Greenville, PADec 30, 1966 · N8274X · Substantial damageNTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJDec 30, 1966 · N5563T · Substantial damageNTSB NYC67D0455Accident · No injuriesClosedCessna 150 · Sheffield, MADec 30, 1966 · N8663G · Substantial damageNTSB NYC67D0453Accident · No injuriesClosedCessna 150 · White Plains, NYDec 30, 1966 · N7950Z · Substantial damageNTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NEDec 30, 1966 · N2397V · Substantial damageNTSB MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSDec 30, 1966 · N79816 · DestroyedNTSB MIA67F0340Accident · Serious injuriesClosedCessna 180 · Vicksburg, MSDec 30, 1966 · N3191D · DestroyedNTSB MIA67F0335Accident · No injuriesClosedPiper PA-28 · Pikeville, NCDec 30, 1966 · N5028W · Substantial damageNTSB FTW67F0399Accident · Minor injuriesClosedCessna 150 · Palo Pinto, TXDec 30, 1966 · N7320X · Substantial damageNTSB FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKDec 30, 1966 · N6298T · Substantial damageNTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VADec 30, 1966 · N8556U · Substantial damageNTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Frederick, MDDec 30, 1966 · N6496W · Substantial damageNTSB DCA67R0002Accident · Minor injuriesClosedDouglas DC-7C · Saigon, VMDec 30, 1966 · N4059K · DestroyedNTSB CHI67F0433Accident · No injuriesClosedBellanca 14-13 · Warsaw, INDec 30, 1966 · N86771 · Substantial damageNTSB CHI67D0445Accident · No injuriesClosedPiper PA-22 · Toledo, OHDec 30, 1966 · N5389Z · Substantial damageNTSB OAK67F0202Accident · No injuriesClosedPiper PA-24 · Sacramento, CADec 29, 1966 · N6627P · Substantial damageNTSB OAK67D0180Accident · No injuriesClosedCessna 150 · Vallejo, CADec 29, 1966 · N4781X · Substantial damageNTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CADec 29, 1966 · N89981 · DestroyedNTSB OAK67A0054Accident · No injuriesClosedHughes 269A · Hayward, CADec 29, 1966 · N8832F · Substantial damageNTSB NYC67I0096Incident · No injuriesClosedFairchild F-27 · Bridgeport, CTDec 29, 1966 · N2705J · No damageNTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NEDec 29, 1966 · N6637H · Substantial damageNTSB MIA67F0354Accident · Minor injuriesClosedPiper PA-32 · San Juan, PRDec 29, 1966 · N3712W · Substantial damageNTSB MIA67D0367Accident · No injuriesClosedCessna 172 · Duncan Town, Burkina FasoDec 29, 1966 · N1352Y · Substantial damageNTSB FTW67D0379Accident · No injuriesClosedPitts 190 · Duncan, OKDec 29, 1966 · N97M · Substantial damageNTSB FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARDec 29, 1966 · N8009A · Substantial damageNTSB FTW67A0067Accident · No injuriesClosedCessna P206 · Chickasha, OKDec 29, 1966 · N2588X · Substantial damage