NTSB investigations, 1967, NE

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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.

Cases per year

19622026
NTSB investigations, 1967, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

Latest cases

Query with SQL
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
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  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.

NTSB MKC68F0430Accident · Minor injuriesClosedAeronca 11AC · Rockville, NEDec 23, 1967 · N3828E · DestroyedNTSB MKC68D0398Accident · No injuriesClosedCessna 180 · Millard, NEDec 23, 1967 · N5148E · Substantial damageNTSB MKC68A0041Accident · No injuriesClosedBrantly B-2A · Gordon, NEDec 23, 1967 · N5918X · DestroyedNTSB MKC68F0412Accident · No injuriesClosedCessna 182 · Omaha, NEDec 21, 1967 · N2893R · Substantial damageNTSB MKC68D0384Accident · No injuriesClosedAero Comdr 100 · Broken Bow, NEDec 19, 1967 · N2931T · Substantial damageNTSB MKC68D0379Accident · No injuriesClosedPiper PA-22 · Chadron, NEDec 6, 1967 · N3337B · Substantial damageNTSB MKC68F0385Accident · Serious injuriesClosedAero Comdr 680-FL · North Platte, NEDec 2, 1967 · N747NT · DestroyedNTSB MKC68D0351Accident · No injuriesClosedPiper PA-32 · Beaver City, NENov 22, 1967 · N3483W · Substantial damageNTSB MKC68F0366Accident · No injuriesClosedPiper PA-24 · Sutherland, NENov 20, 1967 · N6174P · DestroyedNTSB MKC68D0364Accident · No injuriesClosedPiper J3C-65 · Curtis, NENov 19, 1967 · N35210 · Substantial damageNTSB NYC68F0350Accident · No injuriesClosedPiper PA-24A · Omaha, NENov 13, 1967 · N6284P · Substantial damageNTSB MKC68F0347Accident · Serious injuriesClosedPiper PA-32 · Hemingford, NENov 12, 1967 · N4054W · DestroyedNTSB MKC68D0338Accident · No injuriesClosedPiper PA-18 · Whitman, NENov 12, 1967 · N5830Y · Substantial damageNTSB MKC68D0346Accident · No injuriesClosedCessna 172 · Blair, NENov 11, 1967 · N6976A · Substantial damageNTSB MKC68D0345Accident · No injuriesClosedCessna 172 · Newport, NENov 9, 1967 · N8241B · Substantial damageNTSB MKC68D0339Accident · No injuriesClosedPiper PA-22 · Lexington, NENov 8, 1967 · N8908D · Substantial damageNTSB MKC68F0332Accident · No injuriesClosedCessna 310 · Alliance, NENov 5, 1967 · N310S · Substantial damageNTSB MKC68D0315Accident · Minor injuriesClosedPiper J-3 · Gothenburg, NEOct 28, 1967 · N42663 · Substantial damageNTSB MKC68D0309Accident · No injuriesClosedCessna 210 · North Platte, NEOct 27, 1967 · N3780Y · Substantial damageNTSB MKC68F0325Accident · 1 fatalClosedCessna 172 · Lexington, NEOct 22, 1967 · N8727B · DestroyedNTSB MKC68F0299Accident · Minor injuriesClosedCessna 150H · Millard, NEOct 18, 1967 · N6549S · Substantial damageNTSB MKC68D0326Accident · No injuriesClosedLuscombe 8A · Craig, NEOct 14, 1967 · N2884K · Substantial damageNTSB MKC68D0275Accident · No injuriesClosedPiper PA-28 · Lewellen, NEOct 11, 1967 · N7515W · Substantial damageNTSB MKC68F0308Accident · No injuriesClosedPiper PA-24 · Gordon, NEOct 8, 1967 · N6232P · Substantial damageNTSB MKC68F0263Accident · Minor injuriesClosedCessna 150 · Omaha, NESep 29, 1967 · N7958Z · Substantial damageNTSB MKC68A0026Accident · No injuriesClosedBrantly B-2 · Merriman, NESep 28, 1967 · N5988X · Substantial damageNTSB MKC68F0298Accident · No injuriesClosedPiper PA-28 · Pender, NESep 25, 1967 · N6784W · Substantial damageNTSB MKC68D0270Accident · Minor injuriesClosedCessna 150 · Lodgepole, NESep 23, 1967 · N8262F · Substantial damageNTSB MKC68F0217Accident · No injuriesClosedPiper PA-25 · Mccool Junct, NESep 5, 1967 · N6450Z · Substantial damageNTSB DEN68A0016Accident · 1 fatalClosedN.American P-51D · Minden, NESep 3, 1967 · N2871D · DestroyedNTSB MKC68F0209Accident · Minor injuriesClosedChampion 7GCB · Haigler, NESep 2, 1967 · N5192T · DestroyedNTSB MKC68D0184Accident · No injuriesClosedCallair A-9 · Henderson, NEAug 30, 1967 · N3613G · Substantial damageNTSB MKC68F0211Accident · No injuriesClosedPiper PA-25 · Cozad, NEAug 25, 1967 · N6914Z · Substantial damageNTSB MKC68F0170Accident · No injuriesClosedPiper J-3 · Lincoln, NEAug 20, 1967 · N92244 · Substantial damageNTSB MKC68D0171Accident · No injuriesClosedPiper PA-22 · Wahoo, NEAug 15, 1967 · N7002B · Substantial damageNTSB MKC68D0087Accident · No injuriesClosedPiper PA-28 · Hemingford, NEAug 9, 1967 · N9325J · Substantial damageNTSB MKC68F0128Accident · Minor injuriesClosedCessna T-210G · Grand Island, NEAug 8, 1967 · N6886R · Substantial damageNTSB MKC68F0099Accident · No injuriesClosedCessna 180H · Oneill, NEAug 3, 1967 · N9913V · Substantial damageNTSB MKC68D0147Accident · Minor injuriesClosedPiper PA-25 · Kearney, NEJul 31, 1967 · N6275Z · Substantial damageNTSB MKC68D0161Accident · No injuriesClosedPiper PA-22 · Bridgeport, NEJul 27, 1967 · N8920D · Substantial damageNTSB MKC68F0092Accident · No injuriesClosedBeech A35 · So.Sioux City, NEJul 15, 1967 · N567B · Substantial damageNTSB MKC68D0086Accident · No injuriesClosedPiper PA-28 · Chadron, NEJul 15, 1967 · N8208W · Substantial damageNTSB MKC68F0102Accident · No injuriesClosedPiper PA-22 · Newman Grove, NEJul 3, 1967 · N2375P · Substantial damageNTSB MKC68D0038Accident · No injuriesClosedCessna 182C · Valentine, NEJul 1, 1967 · N8608T · Substantial damageNTSB MKC68F0140Accident · No injuriesClosedPiper PA-18 · Alliance, NEJun 28, 1967 · N1277A · Substantial damageNTSB MKC67A0091Accident · Serious injuriesClosedHughes 269B · Papillion, NEJun 28, 1967 · N9350F · DestroyedNTSB MKC68F0054Accident · No injuriesClosedBeech 35 · Sidney, NEJun 27, 1967 · N4842V · Substantial damageNTSB MKC68F0024Accident · Serious injuriesClosedFunk F23-A · Alliance, NEJun 26, 1967 · N1130Z · Substantial damageNTSB MKC68A0084Accident · Serious injuriesClosedDouglas DC-6B · 70e Hayes Cr., NEJun 20, 1967 · N37567 · No damageNTSB MKC68F0051Accident · No injuriesClosedPiper PA-18 · Chester, NEJun 17, 1967 · N1308A · Substantial damage