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 DEN67A0034Accident · No injuriesClosedBell 47G3B1 · Holloman Ab, NMDec 2, 1966 · N1384X · Substantial damage NTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MIDec 2, 1966 · N6041R · Substantial damage NTSB SEA67A0040Accident · No injuriesClosedBell 47G-2 · Maple Valley, WADec 1, 1966 · N2865B · Substantial damage NTSB OAK67D0178Accident · Minor injuriesClosedPiper PA-28 · Snelling, CADec 1, 1966 · N6330W · Substantial damage NTSB NYC67F0393Accident · No injuriesClosedBeech G35 · Gaithersburg, MDDec 1, 1966 · N227B · Substantial damage NTSB NYC67F0380Accident · No injuriesClosedAeronca 7DC · Williamsburg, VADec 1, 1966 · N4486E · Substantial damage NTSB LAX67F0216Accident · No injuriesClosedSIAI March. S-205 · Phoenix, AZDec 1, 1966 · N4780G · Substantial damage NTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKDec 1, 1966 · N16085 · Substantial damage NTSB DEN67D0174Accident · Minor injuriesClosedLuscombe 8A · Greeley, CODec 1, 1966 · N77831 · Substantial damage NTSB NYC67D0386Accident · No injuriesClosedPiper PA-23 · Waldorf, MDNov 30, 1966 · N5574Y · Substantial damage NTSB MIA67D0338Accident · No injuriesClosedCessna 150F · Decatur, ALNov 30, 1966 · N7797F · Substantial damage NTSB LAX67A0054Accident · 1 fatalClosedCessna 150 · Santee, CANov 30, 1966 · N6955F · Destroyed NTSB FTW67D0354Accident · Minor injuriesClosedErcoupe 415-C · Pecos, TXNov 30, 1966 · N87082 · Substantial damage NTSB FTW67D0321Accident · No injuriesClosedCessna 310" · Houma, LANov 30, 1966 · N6686B · Substantial damage NTSB DIA67A0002Accident · No injuriesClosedCessna 310F · Chantilly, VANov 30, 1966 · N6778X · Substantial damage NTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CONov 30, 1966 · N3817J · Substantial damage NTSB ANC67A0048Accident · Minor injuriesClosedPiper PA-14 · Homer, AKNov 30, 1966 · N4236H · Substantial damage NTSB NYC67F0389Accident · No injuriesClosedCessna 310L · Morristown, NJNov 29, 1966 · N2216F · Substantial damage NTSB NYC67D0397Accident · No injuriesClosedNavion G · West Chester, PANov 29, 1966 · N2443T · Substantial damage NTSB NYC67A0089Accident · No injuriesClosedConvair 340 · New Cumberland, PANov 29, 1966 · N3414 · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB LAX67A0055Accident · No injuriesClosedPiper PA-24 · Buckeye, AZNov 29, 1966 · N7824P · Substantial damage NTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNov 29, 1966 · N77565 · Substantial damage NTSB FTW67D0340Accident · No injuriesClosedCessna 320B · Alief, TXNov 29, 1966 · N9836L · Substantial damage NTSB FTW67D0320Accident · No injuriesClosedCessna 150G · Beaumont, TXNov 29, 1966 · N2463J · Substantial damage NTSB CHI67D0373Accident · No injuriesClosedCessna 182 · Indianapolis, INNov 29, 1966 · N3006F · Substantial damage NTSB ANC67D0068Accident · No injuriesClosedPiper PA-28 · Fairbanks, AKNov 29, 1966 · N7599R · Substantial damage NTSB MKC67F0335Accident · No injuriesClosedPiper PA-24 · Republic, MONov 28, 1966 · N6264P · Substantial damage NTSB LAX67F0226Accident · No injuriesClosedLuscombe 8A · Phoenix, AZNov 28, 1966 · N45694 · Substantial damage NTSB FTW67D0338Accident · No injuriesClosedCessna 210 · Enid, OKNov 28, 1966 · N6593X · Substantial damage NTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNov 28, 1966 · N4054P · Substantial damage NTSB CHI67F0381Accident · Minor injuriesClosedPiper PA-23 · Springboro, OHNov 28, 1966 · N3175P · Substantial damage NTSB CHI67F0372Accident · Serious injuriesClosedBeech G35 · Warrenville, ILNov 28, 1966 · N4422D · Substantial damage NTSB CHI67F0358Accident · No injuriesClosedBeech F35 · Erlanger, KYNov 28, 1966 · N5057B · Substantial damage NTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damage NTSB ANC67I0047Incident · No injuriesClosedDouglas DC-3A · Nome, AKNov 28, 1966 · N21748 · Minor damage NTSB SEA67F0227Accident · No injuriesClosedBeech A23 · Portland, ORNov 27, 1966 · N2374W · Substantial damage NTSB OAK67F0185Accident · 1 fatalClosedCessna 172 · Wailau, HINov 27, 1966 · N1677Y · Destroyed NTSB NYC67F0462Accident · Minor injuriesClosedLuscombe 8A · Norwood, MANov 27, 1966 · N71280 · Substantial damage NTSB NYC67F0388Accident · No injuriesClosedBeech A35 · Mcdonough, NYNov 27, 1966 · N449B · Substantial damage NTSB LAX67F0224Accident · No injuriesClosedBeech G35 · Van Nuys, CANov 27, 1966 · N4502D · Substantial damage NTSB LAX67D0201Accident · No injuriesClosedErcoupe 415C · Chino, CANov 27, 1966 · N99257 · Substantial damage NTSB FTW67F0370Accident · Serious injuriesClosedBeech D45 · Kingsville, TXNov 27, 1966 · N4946C · Destroyed NTSB FTW67D0391Accident · No injuriesClosedPiper PA-28 · San Antonio, TXNov 27, 1966 · N6319R · Substantial damage NTSB FTW67D0337Accident · No injuriesClosedBellanca 260 · Miami, TXNov 27, 1966 · N7624E · Substantial damage NTSB CHI67F0368Accident · Serious injuriesClosedPiper PA-17 · Stanton, MINov 27, 1966 · N4671H · Substantial damage NTSB CHI67F0365Accident · Minor injuriesClosedCessna U206 · Holly, MINov 27, 1966 · N2184F · Substantial damage NTSB ANC67D0074Accident · No injuriesClosedPiper PA-18A · Aniak, AKNov 27, 1966 · N9918D · Substantial damage NTSB ANC67A0046Accident · No injuriesClosedCessna 180 · Anchorage, AKNov 27, 1966 · N4576B · Substantial damage NTSB SEA67D0219Accident · No injuriesClosedBeech A23-19 · Billings, MTNov 26, 1966 · N5775V · Substantial damage