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 MIA67D0375Accident · Minor injuriesClosedCessna 150F · Opa Locka, FLDec 11, 1966 · N1115T · Substantial damage NTSB LAX67F0233Accident · No injuriesClosedPiper PA-20 · Yuma, AZDec 11, 1966 · N5596H · Substantial damage NTSB LAX67F0222Accident · No injuriesClosedBeech 23 · Holbrook, AZDec 11, 1966 · N1963F · Substantial damage NTSB DIA67F0001Accident · No injuriesClosedPiper PA-15 · Wakefield, VADec 11, 1966 · N4477H · Substantial damage NTSB CHI67F0388Accident · No injuriesClosedPiper PA-28 · Plymouth, MIDec 11, 1966 · N7503W · Substantial damage NTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MIDec 11, 1966 · N3178X · Substantial damage NTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damage NTSB OAK67D0191Accident · No injuriesClosedCessna 182 · Halawa, HIDec 10, 1966 · N5332B · Substantial damage NTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDDec 10, 1966 · N8813D · Destroyed NTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damage NTSB MKC67D0533Accident · No injuriesClosedCessna 206 · Kansas City, KSDec 10, 1966 · N2679X · Substantial damage NTSB MIA67F0366Accident · No injuriesClosedPiper PA-24 · Miami, FLDec 10, 1966 · N2276P · Substantial damage NTSB LAX67F0228Accident · No injuriesClosedBeech A35 · San Diego, CADec 10, 1966 · N482B · Substantial damage NTSB LAX67D0257Accident · No injuriesClosedGlobe GC-1B · Riverside, CADec 10, 1966 · N80664 · Substantial damage NTSB LAX67D0235Accident · No injuriesClosedPiper PA-22 · Williams, AZDec 10, 1966 · N3507P · Substantial damage NTSB FTW67F0345Accident · Minor injuriesClosedPiper J3C-65 · Tulsa, OKDec 10, 1966 · N56274 · Substantial damage NTSB DIA67F0014Accident · No injuriesClosedPiper PA-28 · Friendship, MDDec 10, 1966 · N7959W · Substantial damage NTSB CHI67F0392Accident · Serious injuriesClosedPiper J5A · Houghton, MIDec 10, 1966 · N32787 · Destroyed NTSB OAK67F0189Accident · Serious injuriesClosedCessna 150 · Antioch, CADec 9, 1966 · N1218Y · Destroyed NTSB MKC67A0038Accident · 1 fatalClosedAero Comdr 680E · Minneapolis, MNDec 9, 1966 · N8496C · Destroyed NTSB FTW67F0356Accident · No injuriesClosedBeech P35 · Enid, OKDec 9, 1966 · N8915M · Substantial damage NTSB DEN67F0177Accident · No injuriesClosedMooney M20A · Albuquerque, NMDec 9, 1966 · N8320E · Substantial damage NTSB DEN67D0181Accident · No injuriesClosedCessna 320 · Farmington, NMDec 9, 1966 · N3049T · Substantial damage NTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORDec 8, 1966 · N37368 · Destroyed NTSB MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSDec 8, 1966 · N7862F · Substantial damage NTSB MKC67D0347Accident · No injuriesClosedPiper PA-20 · Philip, SDDec 8, 1966 · N1510A · Substantial damage NTSB MIA67F0350Accident · No injuriesClosedPiper PA-23 · Charleston, SCDec 8, 1966 · N6162Y · Substantial damage NTSB MIA67D0345Accident · No injuriesClosedCessna 150 · Arcadia, FLDec 8, 1966 · N7315X · Substantial damage NTSB MIA67D0328Accident · No injuriesClosedMooney M20E · Chapel Hill, NCDec 8, 1966 · N6077Q · Substantial damage NTSB LAX67A0057Accident · 1 fatalClosedPiper J-3C · Carlsbad, CADec 8, 1966 · N92032 · Substantial damage NTSB FTW67F0344Accident · No injuriesClosedPiper PA-23 · Fort Worth, TXDec 8, 1966 · N1408P · Substantial damage NTSB FTW67A0063Accident · 1 fatalClosedCessna 150 · New Orleans, LADec 8, 1966 · 7Q-YFC · Destroyed NTSB DIA67D0051Accident · No injuriesClosedBeech G35 · Rising Sun, MDDec 8, 1966 · N4619D · Substantial damage NTSB OAK67D0187Accident · Minor injuriesClosedCessna 150 · Sunnyvale, CADec 7, 1966 · N5937T · Substantial damage NTSB OAK67A0051Accident · No injuriesClosedContinental MII · Madera, CADec 7, 1966 · N6355X · Substantial damage NTSB MKC67F0338Accident · No injuriesClosedPiper PA-24 · Omaha, NEDec 7, 1966 · N6001P · Substantial damage NTSB MIA67F0326Accident · No injuriesClosedAero Comdr 500 · Vicksburg, MSDec 7, 1966 · N6231B · Substantial damage NTSB LAX67F0234Accident · No injuriesClosedBeech B35 · Long Beach, CADec 7, 1966 · N399R · Substantial damage NTSB LAX67F0230Accident · No injuriesClosedN.American SNJ-6 · Shafter, CADec 7, 1966 · N611F · Substantial damage NTSB LAX67D0221Accident · No injuriesClosedCessna 172 · Mojave, CADec 7, 1966 · N8848U · Substantial damage NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · Destroyed NTSB NYC67F0415Accident · No injuriesClosedNavion A · Washington, DCDec 6, 1966 · N91662 · Substantial damage NTSB FTW67D0322Accident · No injuriesClosedCessna U206 · Oklahoma Cty, OKDec 6, 1966 · N8001Z · Substantial damage NTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · Destroyed NTSB DEN67A0035Accident · 2 fatalClosedBeech 65-88 · Woods Cross, UTDec 6, 1966 · N886E · Destroyed NTSB CHI67F0434Accident · No injuriesClosedCessna 210-5 · Waupun, WIDec 6, 1966 · N8047Z · Substantial damage NTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILDec 6, 1966 · N6088R · Substantial damage NTSB NYC67F0368Accident · No injuriesClosedPiper PA-24 · Auburn, MEDec 5, 1966 · N7216P · Substantial damage NTSB NYC67A0091Accident · No injuriesClosedPiper PA-23 · Lock Haven, PADec 5, 1966 · N5625U · Substantial damage