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 MIA67D0341Accident · No injuriesClosedErco 415-D · Logansville, GADec 19, 1966 · N99143 · Substantial damage NTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCDec 19, 1966 · N5303S · Destroyed NTSB FTW67F0347Accident · Minor injuriesClosedCessna 172G · Pearland, TXDec 19, 1966 · N3728L · Substantial damage NTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMDec 19, 1966 · N5038A · Substantial damage NTSB CHI67I0078Incident · Serious injuriesClosedBoeing 720 · Cleveland, OHDec 19, 1966 · N7226U · No damage NTSB CHI67F0438Accident · Serious injuriesClosedAero Comdr 680F · Elkhart, INDec 19, 1966 · N342WS · Destroyed NTSB CHI67F0411Accident · No injuriesClosedCessna 310D · Muskegon, MIDec 19, 1966 · N6890T · Substantial damage NTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHDec 19, 1966 · N2347U · Destroyed NTSB CHI67A0080Accident · No injuriesClosedBeech B95-B · Detroit, MIDec 19, 1966 · N9494S · Substantial damage NTSB CHI67A0079Accident · No injuriesClosedBeech D18S · Grand Rapids, MIDec 19, 1966 · N25Q · Substantial damage NTSB SEA67A0043Accident · No injuriesClosedBrantly B-2B · Wyola, MTDec 18, 1966 · N2183U · Substantial damage NTSB NYC67F0400Accident · No injuriesClosedPiper PA-18 · Augusta, MEDec 18, 1966 · N1516A · Substantial damage NTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYDec 18, 1966 · N3190X · Substantial damage NTSB NYC67D0425Accident · No injuriesClosedCessna 150 · Norwood, MADec 18, 1966 · N3078X · Substantial damage NTSB NYC67D0406Accident · No injuriesClosedPiper PA-28 · Medford, NJDec 18, 1966 · N6427W · Substantial damage NTSB MIA67F0317Accident · No injuriesClosedMooney M20C · Nashville, TNDec 18, 1966 · N6075Q · Substantial damage NTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CADec 18, 1966 · N3818K · Substantial damage NTSB FTW67F0360Accident · No injuriesClosedDehavilland 1142X · New Orleans, LADec 18, 1966 · N782R · Substantial damage NTSB FTW67D0359Accident · No injuriesClosedCessna 150 · Burleson, TXDec 18, 1966 · N6424F · Substantial damage NTSB FTW67A0065Accident · No injuriesClosedBell 204-B · Morgan City, LADec 18, 1966 · N8540F · Substantial damage NTSB DIA67F0011Accident · No injuriesClosedBeech D18S · Ampthill, VADec 18, 1966 · N80361 · Substantial damage NTSB DIA67F0003Accident · No injuriesClosedPiper PA-23 · Stevensville, MDDec 18, 1966 · N5472Y · Substantial damage NTSB DEN67D0187Accident · No injuriesClosedCessna 180 · Broomfield, CODec 18, 1966 · N3354D · Substantial damage NTSB CHI67F0396Accident · No injuriesClosedBeech 35-33 · Saginaw, MIDec 18, 1966 · N109VW · Destroyed NTSB CHI67D0436Accident · No injuriesClosedAeronca 15AC · Pt.Washington, WIDec 18, 1966 · N1401H · Substantial damage NTSB SEA67F0244Accident · Minor injuriesClosedPiper PA-28 · Tacoma, WADec 17, 1966 · N4545R · 2 aircraft · Substantial damage NTSB NYC67F0436Accident · No injuriesClosedCessna 210 · Newburyport, MADec 17, 1966 · N3940Y · Substantial damage NTSB NYC67D0480Accident · Minor injuriesClosedPiper PA-28 · Millcreek, PADec 17, 1966 · N5483Z · Substantial damage NTSB NYC67D0417Accident · No injuriesClosedAeronca 7AC · Mechanicsburg, PADec 17, 1966 · N82146 · No damage NTSB MKC67F0351Accident · No injuriesClosedCessna 150 · Columbia, MODec 17, 1966 · N3131X · Substantial damage NTSB MIA67F0388Accident · No injuriesClosedAeronca 11AC · Centre, ALDec 17, 1966 · N85873 · Substantial damage NTSB FTW67F0392Accident · No injuriesClosedPiper PA-16 · Odessa, TXDec 17, 1966 · N5790H · Substantial damage NTSB FTW67D0358Accident · No injuriesClosedBeech H35 · Dallas, TXDec 17, 1966 · N5032B · Substantial damage NTSB DIA67D0013Accident · No injuriesClosedPiper PA-12 · Lynchburg, VADec 17, 1966 · N3248M · Substantial damage NTSB DIA67D0005Accident · No injuriesClosedPiper PA-28 · Newport News, VADec 17, 1966 · N6438W · Substantial damage NTSB DEN67D0188Accident · No injuriesClosedCessna 185 · Watkins, CODec 17, 1966 · N9955X · Substantial damage NTSB CHI67F0405Accident · No injuriesClosedCessna 175A · Martinsville, INDec 17, 1966 · N6997E · Substantial damage NTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHDec 17, 1966 · N2424V · Substantial damage NTSB CHI67D0415Accident · No injuriesClosedPiper PA-22 · Huron, OHDec 17, 1966 · N4795Z · Substantial damage NTSB NYC67D0534Accident · No injuriesClosedStinson V-77 · Medford, NJDec 16, 1966 · N9362H · Substantial damage NTSB NYC67D0447Accident · No injuriesClosedCessna 150 · West Caldwell, NJDec 16, 1966 · N8224F · Substantial damage NTSB MIA67F0389Accident · No injuriesClosedPiper PA-28 · Andalusia, ALDec 16, 1966 · N6112W · Substantial damage NTSB MIA67F0342Accident · No injuriesClosedPiper PA-22 · West Columbia, SCDec 16, 1966 · N5482Z · Substantial damage NTSB LAX67D0245Accident · No injuriesClosedCessna 182 · Hesperia, CADec 16, 1966 · N2822F · Substantial damage NTSB FTW67D0459Accident · No injuriesClosedMooney M20C · Vanderpool, TXDec 16, 1966 · N78917 · Substantial damage NTSB DEN67D0189Accident · No injuriesClosedCessna 180 · Aurora, CODec 16, 1966 · N2904C · Substantial damage NTSB DEN67D0186Accident · Minor injuriesClosedAeronca 7AC · Layton, UTDec 16, 1966 · N81973 · Substantial damage NTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMDec 16, 1966 · N1362X · Destroyed NTSB CHI67F0424Accident · No injuriesClosedBeech H35 · Reed City, MIDec 16, 1966 · N8210D · Substantial damage NTSB CHI67A0077Accident · Serious injuriesClosedPiper PA-30B · Bloomington, ILDec 16, 1966 · N8162Y · Substantial damage