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 MKC67D0412Accident · No injuriesClosedBeech P35 · Glenwood, MNDec 5, 1966 · N977Q · Substantial damage NTSB MIA67I0066Incident · No injuriesClosedFairchild F-27 · Miami, FLDec 5, 1966 · N7531 · Minor damage NTSB MIA67F0322Accident · Serious injuriesClosedChampion 402 · W.Hollywood, FLDec 5, 1966 · N9964Y · Destroyed NTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARDec 5, 1966 · N5393E · Destroyed NTSB DEN67D0179Accident · No injuriesClosedCessna 150 · Montrose, CODec 5, 1966 · N8804S · Substantial damage NTSB CHI67A0072Accident · 1 fatalClosedPiper PA-22 · Pataskala, OHDec 5, 1966 · N1725P · Destroyed NTSB ANC67D0078Accident · No injuriesClosedCessna 170B · Cordova, AKDec 5, 1966 · N3444D · Substantial damage NTSB SEA67D0199Accident · No injuriesClosedCessna 172 · Dubois, IDDec 4, 1966 · N1691F · Substantial damage NTSB OAK67F0230Accident · Serious injuriesClosedPiper PA-28 · Vacaville, CADec 4, 1966 · N7854W · Destroyed NTSB NYC67F0408Accident · No injuriesClosedPiper PA-28 · Red Bank, NJDec 4, 1966 · N7304W · Substantial damage NTSB NYC67F0391Accident · No injuriesClosedPiper J3C-65 · Farmington, MEDec 4, 1966 · N25972 · Substantial damage NTSB MKC67F0339Accident · No injuriesClosedCessna 195A · Hastings, NEDec 4, 1966 · N9869A · Substantial damage NTSB MKC67D0345Accident · No injuriesClosedPiper PA-18 · Kadoka, SDDec 4, 1966 · N9884D · Substantial damage NTSB MKC67D0340Accident · Minor injuriesClosedChampion 7FC · Riceville, IADec 4, 1966 · N9852Y · Substantial damage NTSB MKC67A0037Accident · 2 fatalClosedChampion 7DC · Anselmo, NEDec 4, 1966 · N4372E · Destroyed NTSB MIA67F0319Accident · No injuriesClosedPietenpol Camper · Homestead, FLDec 4, 1966 · N4632S · Substantial damage NTSB FTW67F0343Accident · Minor injuriesClosedTemco D-16A · Saginaw, TXDec 4, 1966 · N129N · Substantial damage NTSB FTW67D0371Accident · No injuriesClosedMooney M20A · Hermosillo, MexicoDec 4, 1966 · N1097C · Substantial damage NTSB FTW67D0355Accident · No injuriesClosedMooney M20A · Cumby, TXDec 4, 1966 · N6596B · Substantial damage NTSB FTW67A0060Accident · 1 fatalClosedCessna 182 · Ponca City, OKDec 4, 1966 · N8612T · Destroyed NTSB CHI67F0398Accident · No injuriesClosedPiper PA-22 · Elyria, OHDec 4, 1966 · N6859B · Substantial damage NTSB CHI67A0071Accident · No injuriesClosedViscount V-700 · Chicago, ILDec 4, 1966 · N7450 · Substantial damage NTSB SEA67D0203Accident · No injuriesClosedPiper PA-23 · Almira, WADec 3, 1966 · N4947P · Substantial damage NTSB OAK67D0174Accident · No injuriesClosedPiper PA-28 · Red Top, CADec 3, 1966 · N6345W · Substantial damage NTSB MKC67F0333Accident · No injuriesClosedPiper PA-22 · Ames, IADec 3, 1966 · N8421D · Substantial damage NTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNDec 3, 1966 · N9034B · Destroyed NTSB MKC67F0320Accident · No injuriesClosedPiper PA-20 · Paynesville, MNDec 3, 1966 · N7428K · Substantial damage NTSB MKC67D0372Accident · No injuriesClosedMaule M-4 · Gravois Mills, MODec 3, 1966 · N4747T · Substantial damage NTSB MKC67D0343Accident · No injuriesClosedPiper PA-28 · Lawrence, KSDec 3, 1966 · N6265W · Substantial damage NTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSDec 3, 1966 · N8080F · Substantial damage NTSB MKC67D0341Accident · No injuriesClosedCessna 150 · Springfield, MODec 3, 1966 · N4154U · Substantial damage NTSB MIA67D0324Accident · Minor injuriesClosedCessna 172 · Lakeland, GADec 3, 1966 · N7752X · Substantial damage NTSB MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSDec 3, 1966 · N7860Z · Substantial damage NTSB MIA67A0064Accident · 4 fatalClosedPiper PA-28 · St.Augustine, FLDec 3, 1966 · N8235W · Destroyed NTSB FTW67F0427Accident · No injuriesClosedPiper PA-22 · Kingsville, TXDec 3, 1966 · N6135D · Substantial damage NTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LADec 3, 1966 · N8185T · Destroyed NTSB CHI67F0426Accident · No injuriesClosedPiper PA-28 · Geneva, ILDec 3, 1966 · N8178W · Substantial damage NTSB CHI67F0410Accident · No injuriesClosedBeech 95-C55 · Frankfort, MIDec 3, 1966 · N824CP · Substantial damage NTSB CHI67D0389Accident · No injuriesClosedPiper PA-28 · Superior, WIDec 3, 1966 · N7721W · Substantial damage NTSB OAK67A0050Accident · No injuriesClosedCurtiss-Wrt C-46F · Honolulu, HIDec 2, 1966 · N7560U · Substantial damage NTSB NYC67F0421Accident · No injuriesClosedBeech G18S · Wheeling, WVDec 2, 1966 · N9711 · Substantial damage NTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VADec 2, 1966 · N3360F · Destroyed NTSB NYC67A0090Accident · 2 fatalClosedPiper PA-23 · Copenhagen, NYDec 2, 1966 · N512H · Destroyed NTSB MIA67F0321Accident · No injuriesClosedCessna 210 · Atlanta, GADec 2, 1966 · N2340F · Substantial damage NTSB MIA67A0063Accident · No injuriesClosedCessna 320D · Mcrae, GADec 2, 1966 · N4124T · Substantial damage NTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNDec 2, 1966 · N6857S · Destroyed NTSB LAX67I0056IncidentClosedBoeing 720B · Los Angeles, CADec 2, 1966 · N57205 · Substantial damage NTSB LAX67F0251Accident · Serious injuriesClosedCessna 210E · Blythe, CADec 2, 1966 · N2348F · Destroyed NTSB FTW67D0342Accident · No injuriesClosedPiper PA-24 · Spearman, TXDec 2, 1966 · N6344P · Substantial damage NTSB FTW67D0341Accident · No injuriesClosedPiper PA-22 · Buffalo, TXDec 2, 1966 · N4803A · Substantial damage