Skip to content

NTSB investigations, 1966

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.

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 CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILDec 16, 1966 · N3725H · Destroyed NTSB CHI67A0075Accident · No injuriesClosedPiper PA-24 · Quincy, ILDec 16, 1966 · N5578P · Substantial damage NTSB ANC67F0094Accident · No injuriesClosedCessna U206A · Kenai, AKDec 16, 1966 · N4802F · Substantial damage NTSB OAK67D0179Accident · Minor injuriesClosedAeronca 11AC · Hilt, CADec 15, 1966 · N3509E · Substantial damage NTSB NYC67F0441Accident · No injuriesClosedPiper PA-23 · Waterford, CTDec 15, 1966 · N4249P · Substantial damage NTSB NYC67F0409Accident · No injuriesClosedNavion A · Warwick, RIDec 15, 1966 · N91454 · Substantial damage NTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damage NTSB MKC67D0373Accident · No injuriesClosedPiper PA-22 · Macon, MODec 15, 1966 · N3555P · Substantial damage NTSB MIA67D0336Accident · No injuriesClosedPiper PA-28 · Merritt Isle, FLDec 15, 1966 · N4548R · Substantial damage NTSB LAX67D0248Accident · No injuriesClosedCessna 172 · Shafter, CADec 15, 1966 · N6228E · Substantial damage NTSB CHI67F0397Accident · Serious injuriesClosedCessna 210E · Minford, OHDec 15, 1966 · N377Y · Destroyed NTSB CHI67D0429Accident · No injuriesClosedPiper PA-23 · Madison, WIDec 15, 1966 · N3139P · Substantial damage NTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damage NTSB OAK67F0203Accident · No injuriesClosedCessna 175 · Fair Oaks, CADec 14, 1966 · N8170T · Substantial damage NTSB MIA67F0468Accident · No injuriesClosedPiper PA-24 · Pensacola, FLDec 14, 1966 · N6992P · Substantial damage NTSB MIA67D0369Accident · Minor injuriesClosedCessna 310 · Egg Isl., Burkina FasoDec 14, 1966 · N630F · Destroyed NTSB FTW67D0346Accident · No injuriesClosedBeech J35 · Lawton, OKDec 14, 1966 · N8355D · Substantial damage NTSB FTW67A0064Accident · 1 fatalClosedBoeing NA75A · Alamo, TXDec 14, 1966 · N73878 · Destroyed NTSB DEN67I0036Incident · No injuriesClosedConvair 580 · Salt Lake City, UTDec 14, 1966 · N73155 · Substantial damage NTSB NYC67D0442Accident · No injuriesClosedPiper PA-22 · Wappingers Fls., NYDec 13, 1966 · N5802Z · Substantial damage NTSB NYC67D0418Accident · No injuriesClosedPiper PA-30 · Plymouth, MADec 13, 1966 · N7801Y · Substantial damage NTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damage NTSB MIA67F0337Accident · No injuriesClosedCessna 310D · Orlando, FLDec 13, 1966 · N1188 · Substantial damage NTSB LAX67F0240Accident · No injuriesClosedBellanca 14-19 · Tucson, AZDec 13, 1966 · N7678B · Substantial damage NTSB LAX67F0231Accident · No injuriesClosedBeech 95-A55 · Compton, CADec 13, 1966 · N821B · Substantial damage NTSB LAX67D0249Accident · No injuriesClosedHelio H-250 · New Cuyama, CADec 13, 1966 · N5444E · Substantial damage NTSB LAX67D0219Accident · No injuriesClosedBeech A23 · Santa Susan, CADec 13, 1966 · N5667S · Substantial damage NTSB CHI67F0425Accident · No injuriesClosedPiper PA-23 · Muskegon, MIDec 13, 1966 · N4194P · Destroyed NTSB UNK67X0106Accident · No injuriesClosedLear Jet 23 · Las Vegas, NVDec 12, 1966 · N416LJ · Substantial damage NTSB SEA67F0231Accident · No injuriesClosedCessna 182H · Harrisburg, ORDec 12, 1966 · N2449X · Substantial damage NTSB SEA67A0042Accident · No injuriesClosedHiller UH-12C · Rosalia, WADec 12, 1966 · N5316V · Substantial damage NTSB MKC67F0388Accident · No injuriesClosedCessna 310K · Kansas City, MODec 12, 1966 · N6959L · Substantial damage NTSB MIA67F0352Accident · No injuriesClosedCessna 210C · Miami, FLDec 12, 1966 · N3639Y · Substantial damage NTSB MIA67F0320Accident · No injuriesClosedPiper PA-22 · Starkville, MSDec 12, 1966 · N4989Z · Substantial damage NTSB LAX67A0058Accident · Serious injuriesClosedBell 47G-3B · Grand Canyon, AZDec 12, 1966 · N73208 · Substantial damage NTSB FTW67F0372Accident · 1 fatalClosedGlobe GC-1B · Bellville, TXDec 12, 1966 · N80521 · Destroyed NTSB FTW67D0357Accident · No injuriesClosedCessna 172 · Odessa, TXDec 12, 1966 · N1459F · Substantial damage NTSB DIA67F0018Accident · Minor injuriesClosedCessna 182E · Stony Point, VADec 12, 1966 · N2994Y · Destroyed NTSB DEN67F0180Accident · No injuriesClosedCessna 310C · Albuquerque, NMDec 12, 1966 · N1737H · Substantial damage NTSB CHI67F0402Accident · No injuriesClosedCessna 175 · St.Charles, ILDec 12, 1966 · N7005M · Substantial damage NTSB CHI67A0074Accident · 1 fatalClosedBensen B8-M · Dowagiac, MIDec 12, 1966 · N24133 · Destroyed NTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OHDec 12, 1966 · N7921L · Destroyed NTSB OAK67F0198Accident · Serious injuriesClosedTaylorcraft BC12-D · Fair Oaks, CADec 11, 1966 · N43515 · Substantial damage NTSB OAK67F0194Accident · No injuriesClosedCessna 150 · Minden, NVDec 11, 1966 · N6770F · Substantial damage NTSB OAK67D0193Accident · No injuriesClosedAeronca 7CCM · Fallon, NVDec 11, 1966 · N82265 · Substantial damage NTSB NYC67F0449Accident · No injuriesClosedBeech D18S · Williamstown, NJDec 11, 1966 · N158K · Substantial damage NTSB NYC67F0433Accident · No injuriesClosedMooney M20A · Port Jefferson, NYDec 11, 1966 · N8383E · Substantial damage NTSB NYC67F0413Accident · No injuriesClosedBeech A23 · Woodbridge, VADec 11, 1966 · N2395W · Substantial damage NTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · Destroyed NTSB MKC67D0354Accident · No injuriesClosedCessna 150F · Warren, MNDec 11, 1966 · N7199F · Substantial damage