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 FTW67F0352Accident · No injuriesClosedAlon A-2 · El Paso, TXNov 24, 1966 · N6596Q · Substantial damage NTSB FTW67F0335Accident · No injuriesClosedTaylorcraft DC0-65 · Grapeland, TXNov 24, 1966 · N50630 · Substantial damage NTSB FTW67D0351Accident · Minor injuriesClosedCessna 150 · Dell City, TXNov 24, 1966 · N3657J · Destroyed NTSB CHI67D0399Accident · Minor injuriesClosedPiper PA-22 · Sycamore, OHNov 24, 1966 · N9641D · Substantial damage NTSB SEA67D0226Accident · No injuriesClosedBeech 35 · Madras, ORNov 23, 1966 · N3854N · Substantial damage NTSB SEA67A0038Accident · 2 fatalClosedCessna 182H · Frances, WANov 23, 1966 · N2047X · Destroyed NTSB OAK67F0192Accident · Minor injuriesClosedCessna 172G · San Jose, CANov 23, 1966 · N4363L · Substantial damage NTSB OAK67D0173Accident · No injuriesClosedLuscombe 8E · Novato, CANov 23, 1966 · N1350B · Substantial damage NTSB NYC67I0084Incident · No injuriesClosedFairchild FH-227 · Newark, NJNov 23, 1966 · N7806M · No damage NTSB NYC67F0403Accident · No injuriesClosedMooney M20C · Smithfield, RINov 23, 1966 · N1384W · Substantial damage NTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANov 23, 1966 · N4202Z · Destroyed NTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANov 23, 1966 · N4562P · Destroyed NTSB NYC67A0082Accident · No injuriesClosedPiper PA-24 · Berwick, PANov 23, 1966 · N8912P · Substantial damage NTSB MKC67F0353Accident · Serious injuriesClosedMooney M20E · Council Blfs, IANov 23, 1966 · N79354 · Destroyed NTSB MKC67A0036Accident · 2 fatalClosedCessna 172G · Elkhorn, IANov 23, 1966 · N4170L · Destroyed NTSB MIA67D0318Accident · No injuriesClosedDehavilland 114 · San Juan, PRNov 23, 1966 · N3999A · Substantial damage NTSB LAX67D0217Accident · No injuriesClosedBeech 35-C33 · Van Nuys, CANov 23, 1966 · N9579Q · Substantial damage NTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNov 23, 1966 · N1422F · Substantial damage NTSB DIA67A0001Accident · Minor injuriesClosedBrantly 305 · Manassas, VANov 23, 1966 · N2204U · Substantial damage NTSB DEN67A0033Accident · 1 fatalClosedStinson 108-1 · Sterling, CONov 23, 1966 · N880C · Destroyed NTSB CHI67F0383Accident · No injuriesClosedN.American 265-40 · Evansville, INNov 23, 1966 · N355MJ · Substantial damage NTSB ANC67D0065Accident · No injuriesClosedMaule MA4210 · Anchorage, AKNov 23, 1966 · N9823M · Substantial damage NTSB SEA67D0201Accident · No injuriesClosedCessna 150 · Colton, WANov 22, 1966 · N8974S · Substantial damage NTSB NYC67D0454Accident · No injuriesClosedN.American T-28A · Windsor Lock, CTNov 22, 1966 · N101TZ · Substantial damage NTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNov 22, 1966 · N8990S · Substantial damage NTSB NYC67A0087Accident · No injuriesClosedCessna 182B · Block Island, RINov 22, 1966 · N2570G · Substantial damage NTSB MIA67F0295Accident · No injuriesClosedBeech B50 · Nashville, TNNov 22, 1966 · N3665B · Substantial damage NTSB LAX67F0215Accident · No injuriesClosedBeech H35 · Tucson, AZNov 22, 1966 · N5478D · Substantial damage NTSB CHI67A0067Accident · 4 fatalClosedPiper PA-28 · Madison, WINov 22, 1966 · N7901W · Destroyed NTSB SEA67A0037Accident · No injuriesClosedAir-Space 18A · Hoquiam, WANov 21, 1966 · N6130S · Substantial damage NTSB NYC67F0396Accident · No injuriesClosedRearwin 185 · Yorktown Hts, NYNov 21, 1966 · N93245 · Substantial damage NTSB NYC67F0354Accident · No injuriesClosedPiper PA-32 · Norwood, MANov 21, 1966 · N3831W · Substantial damage NTSB MKC67D0352Accident · No injuriesClosedCessna 172 · Bixby, MONov 21, 1966 · N5607R · Destroyed NTSB MKC67D0285Accident · No injuriesClosedPiper J-3 · Bonner Sprgs, KSNov 21, 1966 · N27020 · Substantial damage NTSB MIA67A0059Accident · 1 fatalClosedHawker-Sdly DH 125 · Freeport Bahamas (Atlantic Ocean)Nov 21, 1966 · N235KC · Destroyed NTSB LAX67F0213Accident · Minor injuriesClosedBoeing A75 · Yuma, AZNov 21, 1966 · N56841 · Substantial damage NTSB LAX67F0128Accident · No injuriesClosedCessna 150 · Pacoima, CANov 21, 1966 · N7166F · Substantial damage NTSB LAX67A0052Accident · Minor injuriesClosedHughes 269A · Van Nuys, CANov 21, 1966 · N8751F · Substantial damage NTSB DIA67F0002Accident · Minor injuriesClosedCessna 150F · Hagerstown, MDNov 21, 1966 · N8075S · Substantial damage NTSB CHI67F0374Accident · Serious injuriesClosedCessna 180 · Half Day, ILNov 21, 1966 · N9300C · Destroyed NTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNov 20, 1966 · N39230 · Substantial damage NTSB SEA67D0191Accident · No injuriesClosedPiper PA-18 · Rudyard, MTNov 20, 1966 · N9136D · Substantial damage NTSB NYC67F0378Accident · No injuriesClosedMaule M4 · Mt Pleasant, PANov 20, 1966 · N4724T · Substantial damage NTSB NYC67D0405Accident · No injuriesClosedPiper PA-30 · Bridgeport, NJNov 20, 1966 · N8126Y · Substantial damage NTSB NYC67D0401Accident · Serious injuriesClosedPiper PA-18 · Richland, NYNov 20, 1966 · N3258P · Destroyed NTSB MKC67D0346Accident · No injuriesClosedPiper PA-22 · Independence, MONov 20, 1966 · N7159D · Substantial damage NTSB MKC67D0311Accident · No injuriesClosedAeronca 7AC · Prairie Farm, WINov 20, 1966 · N85569 · Substantial damage NTSB MKC67A0035Accident · 1 fatalClosedCessna 150 · Creve Coeur, MONov 20, 1966 · N6791F · Destroyed NTSB MIA67A0058Accident · 3 fatalClosedMartin M-404 · New Bern, NCNov 20, 1966 · N40406 · Destroyed NTSB FTW67D0350Accident · Minor injuriesClosedMooney M20E · Chihuahua, MexicoNov 20, 1966 · N2746W · Substantial damage