NTSB investigations, 1967, MN

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

19642026
NTSB investigations, 1967, MN per year, 1964–2026: 3,233 cases
1964113
1965115
1966117
1967130
196895
1969113
197088
197180
197282
197377
197483
197598
197678
197792
197898
197976
198066
198189
198261
198368
198451
198557
198643
198740
198852
198950
199042
199159
199225
199340
199439
199537
199640
199737
199836
199933
200039
200140
200246
200340
200432
200531
200629
200725
200831
200929
201032
201128
201228
201333
201424
201515
201626
201720
201814
201916
202026
202112
202224
202334
202424
202522
202613

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\" = 'MN' 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 MKC68D0433Accident · No injuriesClosedCessna 150 · Duluth, MNDec 31, 1967 · N6230T · Substantial damageNTSB MKC68F0408Accident · No injuriesClosedBeech 95-B55 · Hibbing, MNDec 30, 1967 · N9574Y · Substantial damageNTSB MKC68F0469Accident · No injuriesClosedPiper PA-24 · Tamarack, MNDec 24, 1967 · N9118P · Substantial damageNTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNDec 16, 1967 · N2484J · Substantial damageNTSB MKC68F0428Accident · No injuriesClosedCessna 310B · St.Paul, MNDec 15, 1967 · N5347A · Substantial damageNTSB MKC68F0371Accident · No injuriesClosedNavion A · Willmar, MNDec 3, 1967 · N4861K · Substantial damageNTSB MKC68D0376Accident · No injuriesClosedCessna 150 · Wykoff, MNDec 3, 1967 · N8671J · Substantial damageNTSB MKC68F0393Accident · Serious injuriesClosedBeech A23 · Askov, MNNov 26, 1967 · N4726J · Substantial damageNTSB MKC68D0359Accident · No injuriesClosedPiper PA-28 · Grand Rapids, MNNov 24, 1967 · N507UM · Substantial damageNTSB MKC68F0363Accident · No injuriesClosedMooney 20E · Winsted, MNNov 19, 1967 · N5534Q · Substantial damageNTSB MKC68F0355Accident · Minor injuriesClosedAeronca 15AC · Markville, MNNov 19, 1967 · N1451H · Substantial damageNTSB MKC68D0357Accident · No injuriesClosedCessna 182 · Prior Lake, MNNov 18, 1967 · N3453F · Substantial damageNTSB MKC68F0335Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNNov 14, 1967 · N3017M · Substantial damageNTSB MKC68F0358Accident · No injuriesClosedCessna 172 · Hill City, MNNov 13, 1967 · N5686A · Substantial damageNTSB MKC68F0360Accident · No injuriesClosedPiper J-3 · St.Charles, MNNov 9, 1967 · N88173 · Substantial damageNTSB MKC68F0314Accident · No injuriesClosedPiper PA-28 · St.Peter, MNNov 9, 1967 · N6341R · Substantial damageNTSB MKC68D0356Accident · No injuriesClosedLuscombe 8A · Circle Pines, MNNov 9, 1967 · N71922 · Substantial damageNTSB MKC68F0333Accident · No injuriesClosedBeech 35 · Minneapolis, MNOct 30, 1967 · N3943N · Substantial damageNTSB MKC68F0311Accident · No injuriesClosedCessna 310 · Crystal, MNOct 28, 1967 · N659R · Substantial damageNTSB MKC68D0336Accident · No injuriesClosedAeronca 7AC · Buffalo, MNOct 23, 1967 · N82455 · Substantial damageNTSB MKC68F0273Accident · Minor injuriesClosedThorp T-18 · Anoka, MNOct 22, 1967 · N18117 · Substantial damageNTSB MKC68D0361Accident · No injuriesClosedLuscombe 8F · Brainerd, MNOct 21, 1967 · N1962B · Substantial damageNTSB MKC68D0276Accident · No injuriesClosedPiper PA-12 · Pipestone, MNOct 19, 1967 · N4061M · Substantial damageNTSB MKC68D0310Accident · No injuriesClosedChampion 7ECA · Caribou, MNOct 15, 1967 · N11040 · Substantial damageNTSB MKC68F0249Accident · No injuriesClosedMooney M20F · Callaway, MNOct 5, 1967 · N2918L · Substantial damageNTSB MKC68F0286Accident · No injuriesClosedBellanca 14-19 · Lake Elmo, MNOct 1, 1967 · N8511R · Substantial damageNTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNSep 28, 1967 · N3365J · Substantial damageNTSB MKC68F0242Accident · Minor injuriesClosedCessna 172 · Green Isle, MNSep 24, 1967 · N6389E · DestroyedNTSB MKC68D0289Accident · No injuriesClosedPiper PA-28 · Crystal, MNSep 24, 1967 · N9282J · Substantial damageNTSB MKC68F0241Accident · Serious injuriesClosedCessna 170B · Howard Lake, MNSep 17, 1967 · N2806C · Substantial damageNTSB MKC68D0334Accident · No injuriesClosedCessna 140 · Fairmont, MNSep 17, 1967 · N73081 · Substantial damageNTSB MKC68F0262Accident · No injuriesClosedBeech A23 · Mankato, MNSep 16, 1967 · N8891M · Substantial damageNTSB MKC67F0453Accident · No injuriesClosedPiper PA-28 · Barnesville, MNSep 15, 1967 · N4131J · Substantial damageNTSB MKC68F0260Accident · No injuriesClosedPiper PA-18 · Minneapolis, MNSep 14, 1967 · N211T · Substantial damageNTSB MKC68F0261Accident · No injuriesClosedCessna 182 · Hopkins, MNSep 13, 1967 · N8873X · Substantial damageNTSB MKC68F0236Accident · Serious injuriesClosedErnst Eaa Biplan · Cambridge, MNSep 4, 1967 · N530C · Substantial damageNTSB MKC68F0228Accident · Minor injuriesClosedPiper PA-25 · Fairfax, MNSep 2, 1967 · N6985Z · DestroyedNTSB MKC68F0207Accident · No injuriesClosedTaylorcraft BC12-D · Crane Lake, MNSep 2, 1967 · N5290M · Substantial damageNTSB MKC68F0188Accident · No injuriesClosedStits SA3B · Owatonna, MNSep 2, 1967 · N1079Z · Substantial damageNTSB MKC68D0225Accident · No injuriesClosedPiper PA-22 · Bemidji, MNSep 2, 1967 · N8963D · Substantial damageNTSB MKC68F0204Accident · Minor injuriesClosedPiper PA-12 · Cloquet, MNAug 27, 1967 · N2453M · DestroyedNTSB MKC68F0156Accident · Minor injuriesClosedClark 1000 · Owatonna, MNAug 27, 1967 · N78855 · Substantial damageNTSB MKC68F0208Accident · No injuriesClosedPiper PA-14 · Bemidji, MNAug 24, 1967 · N5158H · Substantial damageNTSB MKC68F0191Accident · No injuriesClosedPiper PA-24 · Alexandria, MNAug 22, 1967 · N6847P · Substantial damageNTSB MKC68F0175Accident · Serious injuriesClosedCessna 140 · Two Harbors, MNAug 20, 1967 · N1824V · Substantial damageNTSB MKC68D0471Accident · No injuriesClosedLuscombe 8E · Brainerd, MNAug 20, 1967 · N2882K · Substantial damageNTSB MKC68F0253Accident · No injuriesClosedBellanca 14-19 · Rothsay, MNAug 5, 1967 · N1282R · Substantial damageNTSB MKC68D0205Accident · Minor injuriesClosedCessna 180 · Princeton, MNJul 30, 1967 · N9171T · Substantial damageNTSB MKC68F0112Accident · No injuriesClosedRepublic RC-3 · Nisswa, MNJul 26, 1967 · N6342K · Substantial damageNTSB MKC68F0122Accident · No injuriesClosedMooney M20C · Goodland, MNJul 22, 1967 · N6040Q · Substantial damage