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 OAK67D0266Accident · Serious injuriesClosedMooney M20 · Las Vegas, NVNov 26, 1966 · N2554W · Substantial damage NTSB OAK67A0049Accident · No injuriesClosedBoeing 707 · Oakland, CANov 26, 1966 · N7521A · Substantial damage NTSB NYC67F0392Accident · Minor injuriesClosedPiper PA-22 · Voluntown, CTNov 26, 1966 · N3603A · Substantial damage NTSB MKC67F0355Accident · No injuriesClosedCessna 150F · Hopkins, MNNov 26, 1966 · N3520L · Substantial damage NTSB MKC67F0325Accident · No injuriesClosedCessna 195 · Humboldt, NENov 26, 1966 · N99T · Substantial damage NTSB MKC67F0319Accident · Serious injuriesClosedPiper PA-22 · Ames, IANov 26, 1966 · N1517P · Destroyed NTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNov 26, 1966 · N5274D · Substantial damage NTSB MIA67F0363Accident · No injuriesClosedPiper PA-24 · Auburn, ALNov 26, 1966 · N8371P · Substantial damage NTSB MIA67F0307Accident · No injuriesClosedN.American SNJ-5 · Picayune, MSNov 26, 1966 · N7987C · Substantial damage NTSB MIA67F0293Accident · No injuriesClosedBellanca 14-13- · Bessemer, ALNov 26, 1966 · N86761 · Substantial damage NTSB MIA67A0061Accident · Minor injuriesClosedDouglas A-26B · Dorchester, GANov 26, 1966 · N3157G · Destroyed NTSB LAX67F0212Accident · No injuriesClosedPiper PA-22 · San Diego, CANov 26, 1966 · N1720P · Substantial damage NTSB FTW67F0353Accident · No injuriesClosedCessna 182G · Spring Branch, TXNov 26, 1966 · N2315R · Substantial damage NTSB FTW67F0306Accident · No injuriesClosedCessna 150A · Abilene, TXNov 26, 1966 · N6669T · Destroyed NTSB FTW67D0390Accident · No injuriesClosedPiper PA-24 · Pumpville, TXNov 26, 1966 · N6568P · Substantial damage NTSB FTW67D0336Accident · No injuriesClosedStinson 108-3 · Houston, TXNov 26, 1966 · N798C · Substantial damage NTSB DEN67F0162Accident · Serious injuriesClosedCessna 337 · Albuquerque, NMNov 26, 1966 · N3377K · No damage NTSB DEN67F0156Accident · Minor injuriesClosedPiper PA-28 · Littleton, CONov 26, 1966 · N8509W · Substantial damage NTSB DEN67D0173Accident · No injuriesClosedPiper PA-28 · Aurora, CONov 26, 1966 · N7171R · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB DEN67D0163Accident · No injuriesClosedMooney M20C · Colorado Spg, CONov 26, 1966 · N3381X · Substantial damage NTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNov 26, 1966 · N6497T · Destroyed NTSB CHI67F0355Accident · No injuriesClosedPiper PA-22 · Adrian, MINov 26, 1966 · N5081Z · 2 aircraft · Substantial damage NTSB CHI67D0418Accident · Minor injuriesClosedCessna 172 · Kasbeer, ILNov 26, 1966 · N3588S · Substantial damage NTSB CHI67D0364Accident · No injuriesClosedPiper PA-32 · Richmond, INNov 26, 1966 · N3342N · Substantial damage NTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINov 26, 1966 · N226AA · Destroyed NTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNov 26, 1966 · N1439L · Destroyed NTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNov 26, 1966 · N9762R · Destroyed NTSB SEA67D0215Accident · Serious injuriesClosedPiper PA-22 · Gibbon, ORNov 25, 1966 · N5830D · Destroyed NTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · Destroyed NTSB OAK67F0196Accident · No injuriesClosedPiaggio 136-L2 · Oakland, CANov 25, 1966 · N40034 · Substantial damage NTSB OAK67D0172Accident · No injuriesClosedPiper PA-28 · Turlock, CANov 25, 1966 · N8403W · Substantial damage NTSB NYC67A0086Accident · No injuriesClosedBrantly B-2 · Belfast, NYNov 25, 1966 · N5958X · Substantial damage NTSB MKC67F0400Accident · Serious injuriesClosedCessna 310C · Neosho, MONov 25, 1966 · N1771H · Destroyed NTSB MKC67F0390Accident · No injuriesClosedMooney M20C · Faucett, MONov 25, 1966 · N9226M · Substantial damage NTSB MIA67D0327Accident · No injuriesClosedBeech 23 · Coakley Tn, Burkina FasoNov 25, 1966 · N5969S · Substantial damage NTSB MIA67D0292Accident · No injuriesClosedCessna 150 · Hollywood, FLNov 25, 1966 · N8274S · Substantial damage NTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNov 25, 1966 · N5791R · Destroyed NTSB LAX67F0208Accident · Minor injuriesClosedChampion 7ECA · Saticoy, CANov 25, 1966 · N5128T · Destroyed NTSB LAX67D0229Accident · No injuriesClosedBeech B35 · Santa Monica, CANov 25, 1966 · N424B · Substantial damage NTSB LAX67A0053Accident · No injuriesClosedBeech C50 · Tucson, AZNov 25, 1966 · N3700B · Substantial damage NTSB SEA67D0200Accident · Serious injuriesClosedCessna 175 · Kettle Falls, WANov 24, 1966 · CF-SFS · Destroyed NTSB NYC67F0402Accident · No injuriesClosedCessna 190 · Newburyport, MANov 24, 1966 · N4314N · Substantial damage NTSB NYC67D0395Accident · No injuriesClosedCessna 180 · Glens Falls, NYNov 24, 1966 · N9205T · Substantial damage NTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANov 24, 1966 · N88669 · Destroyed NTSB MIA67D0371Accident · No injuriesClosedBeech C-18S · Tortola Br., U.S. Virgin IslandsNov 24, 1966 · N6402C · Destroyed NTSB MIA67D0312Accident · No injuriesClosedPiper L-4 · Guntersville, ALNov 24, 1966 · N42933 · Substantial damage NTSB MIA67D0280Accident · No injuriesClosedMooney M20E · Ramseur, NCNov 24, 1966 · N5711Q · Substantial damage NTSB LAX67F0207Accident · No injuriesClosedBeech 35 · Wellton, AZNov 24, 1966 · N2710V · Substantial damage NTSB LAX67D0220Accident · No injuriesClosedBeech J35 · Goleta, CANov 24, 1966 · N735B · No damage