NTSB investigations, 1967, NJ

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.

Cases per year

19632026
NTSB investigations, 1967, NJ per year, 1963–2026: 2,550 cases
19634
1964107
1965112
1966129
1967134
196860
196976
197085
197183
197267
197359
197471
197557
197651
197743
197855
197957
198054
198157
198244
198345
198449
198547
198638
198743
198844
198933
199026
199129
199228
199345
199427
199525
199633
199736
199824
199935
200038
200121
200237
200319
200421
200544
200632
200723
200828
200925
201014
201119
201217
201313
201420
201514
201621
201721
201814
201914
20206
202117
202214
202314
202411
202511
202610

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\" = 'NJ' 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 NYC68D0375Accident · No injuriesClosedStinson 108-3 · Berlin, NJDec 23, 1967 · N97062 · Substantial damageNTSB NYC68D0326Accident · Minor injuriesClosedPiper PA-23 · Sea Side Heght, NJDec 17, 1967 · N3005P · Substantial damageNTSB NYC68A0075Accident · No injuriesClosedBeech D18S · Newark, NJNov 29, 1967 · N6032V · Substantial damageNTSB NYC68D0298Accident · No injuriesClosedCessna 337 · Rio Grande, NJNov 22, 1967 · N5312S · Substantial damageNTSB NYC68D0289Accident · No injuriesClosedRyan ST-3KR · Berlin, NJNov 18, 1967 · N48928 · Substantial damageNTSB NYC68F0292Accident · No injuriesClosedCessna 310 · Carlstadt, NJNov 17, 1967 · N193R · Substantial damageNTSB NYC68A0073Accident · 2 fatalClosedPiper PA-28 · Lakewood, NJNov 17, 1967 · N4492J · DestroyedNTSB NYC68D0297Accident · No injuriesClosedPiper PA-23 · Ewing, NJNov 16, 1967 · N4490P · Substantial damageNTSB NYC68A0072Accident · Minor injuriesClosedBell 47G · Newark Apt Fac, NJNov 16, 1967 · N940B · Substantial damageNTSB NYC68F0274Accident · Serious injuriesClosedCessna 150E · Morganville, NJNov 5, 1967 · N3927U · DestroyedNTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJOct 30, 1967 · N89161 · DestroyedNTSB NYC68F0270Accident · No injuriesClosedBeech V35 · Teterboro, NJOct 29, 1967 · N215Y · Substantial damageNTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damageNTSB NYC68D0242Accident · No injuriesClosedPiper PA-28 · Princeton, NJOct 28, 1967 · N6334R · Substantial damageNTSB NYC68D0234Accident · No injuriesClosedPiper PA-28 · Red Bank, NJOct 24, 1967 · N7266W · Substantial damageNTSB NYC68D0273Accident · No injuriesClosedPiper PA-22 · Little Ferry, NJOct 23, 1967 · N9408D · Substantial damageNTSB NYC68F0251Accident · No injuriesClosedBeech A23 · Medford, NJOct 21, 1967 · N5956S · No damageNTSB NYC68F0243Accident · No injuriesClosedCessna 182 · Moorestown, NJOct 21, 1967 · N9237X · Substantial damageNTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJOct 21, 1967 · N2901S · Substantial damageNTSB NYC68A0063Accident · No injuriesClosedMooney M20F · Teterboro, NJOct 21, 1967 · N6436Q · Substantial damageNTSB NYC68A0062Accident · 2 fatalClosedCessna 172 · So.Hackensack, NJOct 19, 1967 · N2473L · DestroyedNTSB DIA68F0103Accident · Minor injuriesClosedPiper PA-28 · Laurel, NJOct 17, 1967 · N8372W · DestroyedNTSB NYC68F0239Accident · Serious injuriesClosedNavion A · Carlstadt, NJOct 15, 1967 · N4532K · Substantial damageNTSB NYC68F0237Accident · No injuriesClosedPiper PA-22 · Salem, NJOct 15, 1967 · N1242C · Substantial damageNTSB NYC68D0285Accident · No injuriesClosedAeronca 7AC · Millville, NJOct 14, 1967 · N82415 · Substantial damageNTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJOct 11, 1967 · N6884F · DestroyedNTSB NYC68F0215Accident · No injuriesClosedCessna 182 · Hanover, NJOct 6, 1967 · N8343S · Substantial damageNTSB NYC68A0056Accident · No injuriesClosedBeech E18S · Newark, NJOct 5, 1967 · N73V · Substantial damageNTSB NYC68F0212Accident · Serious injuriesClosedPiper PA-20 · Belford, NJSep 30, 1967 · N7741K · DestroyedNTSB NYC68D0179Accident · No injuriesClosedPiper PA-24 · Hackettstown, NJSep 30, 1967 · N6663P · Substantial damageNTSB NYC68F0202Accident · No injuriesClosedBeech D95A · Teterboro, NJSep 27, 1967 · N5350 · Substantial damageNTSB NYC68D0223Accident · Serious injuriesClosedCessna 140A · Atlantic City, NJSep 26, 1967 · N9469A · No damageNTSB NYC68F0196Accident · Serious injuriesClosedBellanca 14-13 · So.Plainfield, NJSep 22, 1967 · N6503N · Substantial damageNTSB NYC68D0204Accident · No injuriesClosedCessna 172H · Mays Landing, NJSep 20, 1967 · N3281L · Substantial damageNTSB NYC68A0048Accident · 1 fatalClosedCessna 150 · Vincentown, NJSep 20, 1967 · N8627S · DestroyedNTSB NYC68D0194Accident · Minor injuriesClosedPiper PA-12 · East Hanover, NJSep 13, 1967 · N7604H · Substantial damageNTSB NYC68D0205Accident · No injuriesClosedCessna 150 · Moorestown, NJSep 12, 1967 · N7898E · DestroyedNTSB NYC68F0140Accident · Minor injuriesClosedAeronca 7BCM · Princeton, NJSep 9, 1967 · N94577 · Substantial damageNTSB NYC68F0171Accident · No injuriesClosedCessna 310 · Teterboro, NJSep 4, 1967 · N215A · Substantial damageNTSB NYC68D0114Accident · No injuriesClosedCessna 172 · Andover, NJAug 28, 1967 · N3251L · Substantial damageNTSB NYC68F0151Accident · No injuriesClosedMooney M20C · Neptune, NJAug 27, 1967 · N1399W · Substantial damageNTSB NYC68F0141Accident · No injuriesClosedPiper PA-22 · Red Bank, NJAug 27, 1967 · N2608P · Substantial damageNTSB NYC68D0128Accident · No injuriesClosedPiper PA-28 · Columbia, NJAug 27, 1967 · N9277J · Substantial damageNTSB NYC68F0138Accident · No injuriesClosedPiper PA-22 · Vincentown, NJAug 21, 1967 · N2952P · Substantial damageNTSB NYC68F0144Accident · No injuriesClosedAeronca 65-C · Vincentown, NJAug 20, 1967 · N23927 · Substantial damageNTSB NYC68I0028Incident · No injuriesClosedLockheed L-1049 · Newark, NJAug 18, 1967 · N6206G · Minor damageNTSB NYC68F0100Accident · No injuriesClosedPiper PA-28 · Red Bank, NJAug 7, 1967 · N5175W · Substantial damageNTSB NYC68F0112Accident · Minor injuriesClosedTemco D-16A · Wayne, NJAug 6, 1967 · N122N · Substantial damageNTSB NYC68F0092Accident · No injuriesClosedBoeing A75 · Bridgeton, NJAug 5, 1967 · N49645 · Substantial damageNTSB NYC68F0104Accident · 2 fatalClosedPiper PA-30 · Masonville, NJJul 30, 1967 · N7932Y · Destroyed