Skip to content

NTSB investigations, 1966

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMDec 29, 1966 · N6693F · Destroyed NTSB CHI67A0082Accident · Minor injuriesClosedBeech C-45G · Detroit, MIDec 29, 1966 · N21454 · Substantial damage NTSB OAK67F0216Accident · Serious injuriesClosedBoeing B75N1 · Paso Robles, CADec 28, 1966 · N67343 · Destroyed NTSB OAK67F0211Accident · No injuriesClosedBeech J35 · Oceano, CADec 28, 1966 · N8259D · Substantial damage NTSB NYC67F0471Accident · Minor injuriesClosedBellanca 14-13 · Tridelphia, WVDec 28, 1966 · N74264 · Substantial damage NTSB NYC67D0461Accident · No injuriesClosedMooney MK21 · East Boston, MADec 28, 1966 · N9254M · Substantial damage NTSB NYC67A0095Accident · No injuriesClosedGrumman G-159 · Richmond, VADec 28, 1966 · N908LN · Substantial damage NTSB MKC67D0397Accident · No injuriesClosedPiper PA-28 · Liberal, KSDec 28, 1966 · N8192W · Substantial damage NTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSDec 28, 1966 · N3699D · Substantial damage NTSB MKC67D0368Accident · No injuriesClosedCessna 182 · Maple Plain, MNDec 28, 1966 · N6384A · Substantial damage NTSB MIA67D0344Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 28, 1966 · N4709X · Substantial damage NTSB FTW67F0428Accident · No injuriesClosedBeech F35 · Cotulla, TXDec 28, 1966 · N4233B · Substantial damage NTSB DEN67D0184Accident · No injuriesClosedCessna 210 · Seibert, CODec 28, 1966 · N7487E · Substantial damage NTSB ANC67A0050Accident · Minor injuriesClosedBell 47G-2A · Kenai, AKDec 28, 1966 · N73220 · Substantial damage NTSB OAK67D0200Accident · No injuriesClosedCessna 150 · Ely, NVDec 27, 1966 · N3915U · Substantial damage NTSB LAX67D0256Accident · No injuriesClosedCessna 150G · Essex, CADec 27, 1966 · N3861J · Substantial damage NTSB FTW67D0397Accident · No injuriesClosedPiper PA-28 · Bogalusa, LADec 27, 1966 · N7866W · Substantial damage NTSB DIA67D0019Accident · No injuriesClosedPiper PA-22 · Laurel, MDDec 27, 1966 · N5413Z · Substantial damage NTSB SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTDec 26, 1966 · N2747W · Destroyed NTSB MKC67F0376Accident · Serious injuriesClosedChampion 7AC · Moose Lake, MNDec 26, 1966 · N82838 · Substantial damage NTSB MKC67F0364Accident · No injuriesClosedMooney M20A · Vermillion, SDDec 26, 1966 · N6054X · Substantial damage NTSB MKC67D0415Accident · No injuriesClosedBeech K35 · Great Bend, KSDec 26, 1966 · N3089C · Substantial damage NTSB MKC67D0384Accident · No injuriesClosedCessna 120 · Buyek, MNDec 26, 1966 · N72775 · Substantial damage NTSB MIA67F0398Accident · No injuriesClosedBeech 95-A55 · Bessemer, ALDec 26, 1966 · N1449G · Substantial damage NTSB MIA67F0365Accident · No injuriesClosedBeech B35 · Jacksonville, FLDec 26, 1966 · N5139C · Substantial damage NTSB MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNDec 26, 1966 · N4663F · Substantial damage NTSB LAX67D0237Accident · No injuriesClosedSchweizer I-26 · Torrey Pine, CADec 26, 1966 · N8608R · Destroyed NTSB LAX67D0236Accident · No injuriesClosedPiper PA-32 · El Centro, CADec 26, 1966 · N3575W · Substantial damage NTSB FTW67D0470Accident · No injuriesClosedPiper PA-24 · Lyford, TXDec 26, 1966 · N6028P · Substantial damage NTSB FTW67D0377Accident · Serious injuriesClosedPiper PA-28 · Boise City, OKDec 26, 1966 · N9314J · Destroyed NTSB FTW67D0361Accident · No injuriesClosedCessna 172 · Grand Saline, TXDec 26, 1966 · N5810A · Substantial damage NTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damage NTSB CHI67F0401Accident · No injuriesClosedPiper PA-22 · Onsted, MIDec 26, 1966 · N4849Z · Substantial damage NTSB CHI67D0508Accident · No injuriesClosedCessna 150 · Lombard, ILDec 26, 1966 · N8002F · Substantial damage NTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INDec 26, 1966 · N2558U · Substantial damage NTSB SEA67D0272Accident · No injuriesClosedChampion 7GCB · Great Falls, MTDec 25, 1966 · N9601S · Substantial damage NTSB NYC67F0438Accident · No injuriesClosedLuscombe 8E · Aliquippa, PADec 25, 1966 · N2527K · Destroyed NTSB MKC67D0349Accident · Minor injuriesClosedCessna 210F · Fort Dodge, IADec 25, 1966 · N1870F · Substantial damage NTSB MIA67F0343Accident · No injuriesClosedCessna 172 · Miami, FLDec 25, 1966 · N1480F · Substantial damage NTSB MIA67D0347Accident · No injuriesClosedCessna 150 · Montrose, GADec 25, 1966 · N8600S · Substantial damage NTSB FTW67D0396Accident · No injuriesClosedCessna 180 · Nacogdoches, TXDec 25, 1966 · N9047C · Substantial damage NTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damage NTSB CHI67F0422Accident · No injuriesClosedBeech 35 · Roselle, ILDec 25, 1966 · N3745N · Substantial damage NTSB SEA67D0218Accident · No injuriesClosedNavion A · Boise, IDDec 24, 1966 · N5235K · Substantial damage NTSB MKC67D0370Accident · No injuriesClosedCessna 150F · Alta Vista, IADec 24, 1966 · N2431J · Substantial damage NTSB MIA67F0539Accident · No injuriesClosedChampion 7GCAA · Tallahassee, FLDec 24, 1966 · N8370V · Substantial damage NTSB MIA67D0463Accident · No injuriesClosedCessna 182 · Huntsville, ALDec 24, 1966 · N2600G · Substantial damage NTSB MIA67D0368Accident · Minor injuriesClosedCessna 172 · Jacksonville, FLDec 24, 1966 · N1868Y · Substantial damage NTSB FTW67F0376Accident · Serious injuriesClosedPiper PA-25 · Moreauville, LADec 24, 1966 · N6642Z · Destroyed NTSB FTW67D0395Accident · Minor injuriesClosedAeronca 7FC · Houston, TXDec 24, 1966 · N9817Y · Substantial damage