Skip to content

NTSB investigations, 1966

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67D0375Accident · No injuriesClosedPiper PA-28 · Enid, OKDec 24, 1966 · N8412W · Substantial damage NTSB DCA67R0001Accident · 4 fatalClosedCanadair CL-44 · Tourane, VMDec 24, 1966 · N228SW · Destroyed NTSB CHI67D0455Accident · No injuriesClosedBeech A23-24 · Winneconne, WIDec 24, 1966 · N7987L · Substantial damage NTSB CHI67D0384Accident · Minor injuriesClosedBeech A35 · Concord, OHDec 24, 1966 · N717B · Substantial damage NTSB OAK67D0186Accident · No injuriesClosedCessna 210 · Adin, CADec 23, 1966 · N7328E · Substantial damage NTSB OAK67D0184Accident · No injuriesClosedStinson 108 · Columbia, CADec 23, 1966 · N97358 · Substantial damage NTSB NYC67F0444Accident · No injuriesClosedCessna 150 · Broadbrook, CTDec 23, 1966 · N5558E · Substantial damage NTSB NYC67D0474Accident · No injuriesClosedCessna 150 · Morristown, NJDec 23, 1966 · N3516J · Substantial damage NTSB NYC67A0094Accident · No injuriesClosedBrantly B-2B · Riverdale, MDDec 23, 1966 · N2277U · Substantial damage NTSB MKC67D0360Accident · No injuriesClosedPiper PA-28 · Duluth, MNDec 23, 1966 · N7147R · Substantial damage NTSB LAX67F0250Accident · No injuriesClosedFairchild 24 · Pacoima, CADec 23, 1966 · N77618 · Substantial damage NTSB LAX67F0242Accident · No injuriesClosedMooney M20E · Torrance, CADec 23, 1966 · N2651W · Substantial damage NTSB LAX67D0232Accident · No injuriesClosedBeech B35 · Hawthorne, CADec 23, 1966 · N5008C · Substantial damage NTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CADec 23, 1966 · N3556R · 2 aircraft · Substantial damage NTSB FTW67F0393Accident · No injuriesClosedPiper PA-23 · Austin, TXDec 23, 1966 · N4367P · Substantial damage NTSB FTW67D0374Accident · No injuriesClosedCessna 150B · Enid, OKDec 23, 1966 · N7390X · Substantial damage NTSB DEN67D0192Accident · No injuriesClosedPiper PA-28 · Etna, WYDec 23, 1966 · N9301J · Substantial damage NTSB CHI67A0083Accident · No injuriesClosedScheutzow B · Brunswick, OHDec 23, 1966 · N592A · Substantial damage NTSB OAK67F0209Accident · No injuriesClosedCessna 172 · Bishop, CADec 22, 1966 · N3579S · Destroyed NTSB NYC67F0434Accident · No injuriesClosedBeech V35 · Wallkill, NYDec 22, 1966 · N5617S · Substantial damage NTSB MKC67F0344Accident · No injuriesClosedCessna 150 · Cleveland, NDDec 22, 1966 · N5912E · Substantial damage NTSB MIA67D0408Accident · No injuriesClosedCessna 150 · Havana, FLDec 22, 1966 · N8276S · Substantial damage NTSB DEN67A0038Accident · No injuriesClosedBeech E18S · Albuquerque, NMDec 22, 1966 · N820 · Substantial damage NTSB CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILDec 22, 1966 · N4429U · Substantial damage NTSB CHI67F0413Accident · No injuriesClosedBeech 35 · Grand Rapids, MIDec 22, 1966 · N2820V · Substantial damage NTSB CHI67F0387Accident · No injuriesClosedPiper PA-24 · Ann Arbor, MIDec 22, 1966 · N6102P · Substantial damage NTSB SEA67F0233Accident · Minor injuriesClosedNavion B · Hillsboro, ORDec 21, 1966 · N5351K · Substantial damage NTSB NYC67D0484Accident · No injuriesClosedPiper PA-28 · Hanover, NJDec 21, 1966 · N6883W · Substantial damage NTSB NYC67D0435Accident · No injuriesClosedCessna 120 · Jobstown, NJDec 21, 1966 · N4221N · Substantial damage NTSB MKC67F0387Accident · No injuriesClosedPiper PA-23 · Augusta, KSDec 21, 1966 · N2236P · Substantial damage NTSB CHI67D0421Accident · No injuriesClosedBeech B95 · Napoleon, OHDec 21, 1966 · N9646R · Substantial damage NTSB ANC67A0049Accident · No injuriesClosedCessna 180 · Bethel, AKDec 21, 1966 · N7741A · Substantial damage NTSB SEA67D0266Accident · No injuriesClosedAeronca 7AC · Circle, MTDec 20, 1966 · N2849E · Substantial damage NTSB OAK67A0056Accident · 10 fatalClosedLockheed 18 · Baja, MexicoDec 20, 1966 · N2222B · Destroyed NTSB NYC67F0411Accident · No injuriesClosedCessna 411 · Erie, PADec 20, 1966 · N2214Z · Substantial damage NTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VADec 20, 1966 · N5161D · Substantial damage NTSB MKC67F0365Accident · Serious injuriesClosedChampion 7AC · Jamestown, NDDec 20, 1966 · N82279 · Destroyed NTSB MIA67F0325Accident · No injuriesClosedBeech D18S · San Juan, PRDec 20, 1966 · N703D · Substantial damage NTSB LAX67F0258Accident · Minor injuriesClosedFairchild 24H · Burbank, CADec 20, 1966 · N19126 · Substantial damage NTSB FTW67D0373Accident · No injuriesClosedBeech E35 · Dallas, TXDec 20, 1966 · N3317C · Substantial damage NTSB FTW67D0348Accident · No injuriesClosedCessna 182 · Muleshoe, TXDec 20, 1966 · N8399S · Substantial damage NTSB DEN67D0185Accident · No injuriesClosedCessna 172 · Crown Point, NMDec 20, 1966 · N4102Z · Substantial damage NTSB DEN67D0182Accident · No injuriesClosedCessna 310 · Rock Springs, WYDec 20, 1966 · N2257F · Substantial damage NTSB OAK67A0053Accident · Minor injuriesClosedPiper PA-32 · Cloverdale, CADec 19, 1966 · N3675W · Substantial damage NTSB MKC67F0394Accident · Serious injuriesClosedCessna 172E · Farmington, MODec 19, 1966 · N5732T · Destroyed NTSB MKC67F0374Accident · No injuriesClosedBeech A23 · Lincoln, NEDec 19, 1966 · N7997L · Substantial damage NTSB MKC67F0356Accident · No injuriesClosedNavion F · Hopkins, MNDec 19, 1966 · N5387K · Substantial damage NTSB MKC67D0432Accident · No injuriesClosedMooney M20C · Wichita, KSDec 19, 1966 · N2632W · Substantial damage NTSB MIA67F0373Accident · No injuriesClosedPiper PA-30 · Greenville, SCDec 19, 1966 · N8147Y · Substantial damage