Skip to content

NTSB investigations, 1967

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") = 1967 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\") = 1967
  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") = 1967
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 MKC68A0041Accident · No injuriesClosedBrantly B-2A · Gordon, NEDec 23, 1967 · N5918X · Destroyed NTSB MIA68D0323Accident · No injuriesClosedBeech V35 · Pompano Beach, FLDec 23, 1967 · N6257V · Substantial damage NTSB LAX68F0264Accident · No injuriesClosedBeech E35 · Calipatria, CADec 23, 1967 · N7390B · Substantial damage NTSB LAX68D0269Accident · No injuriesClosedBeech A35 · Oxnard, CADec 23, 1967 · N8595A · Substantial damage NTSB LAX68D0253Incident · No injuriesClosedDehaviland DHC-2 · Llano, CADec 23, 1967 · CF-ROM · Substantial damage NTSB LAX68A0062Accident · Minor injuriesClosedBensen B8M · Rialto, CADec 23, 1967 · N1659 · Substantial damage NTSB FTW68F0418Accident · No injuriesClosedCessna 177 · San Antonio, TXDec 23, 1967 · N2258Y · Substantial damage NTSB FTW68D0401Accident · No injuriesClosedBeech A23 · Pryor, OKDec 23, 1967 · N3515R · Substantial damage NTSB DIA68D0141Accident · No injuriesClosedLuscombe 8A · Melfa, VADec 23, 1967 · N72039 · Substantial damage NTSB CHI68F0515Accident · Minor injuriesClosedPiper PA-28 · Jackson, OHDec 23, 1967 · N9910W · Substantial damage NTSB CHI68D0524Accident · No injuriesClosedCessna 150 · Hales Corners, WIDec 23, 1967 · N6431T · Substantial damage NTSB UNK68X0116Accident · 4 fatalClosedCessna 210 · Naucalpan, MexicoDec 22, 1967 · N3701Y · Destroyed NTSB OAK68F0260Accident · No injuriesClosedPiper PA-32 · Truckee, CADec 22, 1967 · N1099J · Substantial damage NTSB NYC68D0347Accident · No injuriesClosedCessna 310D · Lebanon, NHDec 22, 1967 · N818V · Substantial damage NTSB NYC68D0317Accident · No injuriesClosedCessna 337 · Belle Vernon, PADec 22, 1967 · N2464S · Substantial damage NTSB MIA68F0395Accident · No injuriesClosedBeech F35 · Centerville, TNDec 22, 1967 · N337AA · Substantial damage NTSB MIA68F0351Accident · No injuriesClosedBeech 23 · Birmingham, ALDec 22, 1967 · N2374L · Substantial damage NTSB MIA68A0058Accident · 2 fatalClosedCessna 170B · Warm Springs, GADec 22, 1967 · N1953C · Destroyed NTSB LAX68D0306Accident · Minor injuriesClosedCessna 150 · Calif.City, CADec 22, 1967 · N3589J · Substantial damage NTSB FTW68F0408Accident · Minor injuriesClosedCessna 150 · Angleton, TXDec 22, 1967 · N8898S · Destroyed NTSB FTW68D0458Accident · No injuriesClosedCessna 182 · Aspermont, TXDec 22, 1967 · N9360X · Substantial damage NTSB DIA68A0042Accident · 2 fatalClosedPiper PA-24 · Robbinsville, NCDec 22, 1967 · N6238P · Destroyed NTSB CHI68F0512Accident · Serious injuriesClosedBeech D18S · Beloit, ILDec 22, 1967 · N120R · Substantial damage NTSB CHI68A0056Accident · 3 fatalClosedMooney M20F · Knox, INDec 22, 1967 · N2779W · Destroyed NTSB UNK68X0115Incident · No injuriesClosedPiper PA-23 · Caborca, MexicoDec 21, 1967 · N5271Y · Minor damage NTSB OAK68D0314Accident · No injuriesClosedPiper PA-22 · Travis Afb, CADec 21, 1967 · N4901Z · Substantial damage NTSB NYC68A0082Accident · 2 fatalClosedBell 47J-2 · New York City, NYDec 21, 1967 · N73251 · Destroyed NTSB MKC68F0412Accident · No injuriesClosedCessna 182 · Omaha, NEDec 21, 1967 · N2893R · Substantial damage NTSB LAX68D0275Accident · No injuriesClosedBeech V35 · Eloy, AZDec 21, 1967 · N5605S · Substantial damage NTSB FTW68F0407Accident · Serious injuriesClosedMooney M-22 · Kerrville, TXDec 21, 1967 · N7710M · Destroyed NTSB DIA68A0027Accident · No injuriesClosedSikorsky H-19G · Lebanon, VADec 21, 1967 · N1562 · Substantial damage NTSB DEN68F0172Accident · No injuriesClosedPiper PA-24 · Littleton, CODec 21, 1967 · N5133P · Substantial damage NTSB DEN68D0170Accident · Minor injuriesClosedPiper PA-24 · Willard, NMDec 21, 1967 · N8004P · Substantial damage NTSB DEN68A0027Accident · 2 fatalClosedDouglas DC-3C · Denver, CODec 21, 1967 · N65276 · Destroyed NTSB CHI68A0055Accident · No injuriesClosedBeech C45H · Chicago, ILDec 21, 1967 · N2122 · Substantial damage NTSB UNK68X0114Accident · No injuriesClosedCessna 150 · Buckner B Okinawa, JADec 20, 1967 · N2290J · Substantial damage NTSB OAK68F0265Accident · No injuriesClosedCessna 310B · Concord, CADec 20, 1967 · N5365A · Substantial damage NTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68A0081Accident · No injuriesClosedBeech 65-B80 · Beverly, MADec 20, 1967 · N207E · Substantial damage NTSB MKC68D0389Accident · No injuriesClosedCessna 172 · Ames, KSDec 20, 1967 · N7048T · Substantial damage NTSB MKC68D0374Accident · No injuriesClosedCessna 150F · Severy, KSDec 20, 1967 · N6778F · Substantial damage NTSB MIA68D0391Accident · No injuriesClosedCessna 150F · Venice, FLDec 20, 1967 · N8454G · Substantial damage NTSB MIA68A0056Accident · No injuriesClosedBell 47G · Miami, FLDec 20, 1967 · N2867B · Substantial damage NTSB MIA68A0055Accident · No injuriesClosedDehavilland 114 · Mayaguez, PRDec 20, 1967 · N13663 · Substantial damage NTSB LAX68F0256Accident · No injuriesClosedLuscombe 8E · Fullerton, CADec 20, 1967 · N2243B · Substantial damage NTSB LAX68D0245Accident · No injuriesClosedBell 47J-2 · Sunflower, AZDec 20, 1967 · N922NA · Substantial damage NTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARDec 20, 1967 · N5904Y · Substantial damage NTSB FTW68D0406Accident · No injuriesClosedCessna 172 · Springdale, ARDec 20, 1967 · N3724R · Substantial damage NTSB CHI68F0551Accident · No injuriesClosedBeech 95-A55 · Lebanon, ILDec 20, 1967 · N511JL · Substantial damage NTSB CHI68D0510Accident · No injuriesClosedCessna 172 · Greenwood, INDec 20, 1967 · N4033F · Substantial damage