Final NTSB investigations, 1966

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
Final NTSB investigations, 1966 per year, 1962–2026: 171,584 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,511
19843,403
19853,051
19862,824
19872,757
19882,651
19892,478
19902,451
19912,391
19922,293
19932,244
19942,190
19952,216
19962,091
19972,038
19982,061
19992,069
20002,026
20011,876
20021,868
20031,928
20041,776
20051,826
20061,644
20071,809
20081,714
20091,613
20101,561
20111,612
20121,578
20131,317
20141,321
20151,317
20161,344
20171,334
20181,354
20191,309
20201,141
20211,216
20221,272
20231,216
20241,139
2025779
2026365

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.\"completionStatus\" = 'Completed'
  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