NTSB investigations, 1968, NJ

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

19632026
NTSB investigations, 1968, 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\") = 1968
    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 NYC69I0066Incident · No injuriesClosedDouglas DC-8 · Newark, NJDec 23, 1968 · N8779 · Minor damageNTSB NYC69F0278Accident · Serious injuriesClosedCessna 411 · Teterboro, NJDec 6, 1968 · N162A · DestroyedNTSB NYC69A0061Accident · 1 fatalClosedPiper PA-24 · New Foundland, NJDec 5, 1968 · N5668P · DestroyedNTSB NYC69D0260Accident · No injuriesClosedLuscombe 8F · Pluckimen, NJDec 1, 1968 · N805B · Substantial damageNTSB NYC69D0257Accident · No injuriesClosedCessna 150 · Aptistown, NJNov 11, 1968 · N8467J · Substantial damageNTSB NYC69A0051Accident · 2 fatalClosedSwift Globe GC-1B · Willingboro, NJNov 3, 1968 · N9030M · DestroyedNTSB NYC69D0266Accident · No injuriesClosedBeech 35-C33 · Burlington, NJNov 2, 1968 · N5861S · Substantial damageNTSB NYC69F0210Accident · Serious injuriesClosedCessna 150J · Morristown, NJOct 15, 1968 · N50589 · Substantial damageNTSB NYC69F0203Accident · No injuriesClosedCessna 177 · Newton, NJOct 13, 1968 · N3189T · DestroyedNTSB NYC69F0237Accident · No injuriesClosedPiper PA-23 · Neptune, NJOct 7, 1968 · N5426Y · Substantial damageNTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJOct 6, 1968 · N1870J · 2 aircraft · Substantial damageNTSB NYC69F0242Accident · 1 fatalClosedBensen B8M · Mickleton, NJSep 28, 1968 · N8713R · DestroyedNTSB NYC69F0226Accident · No injuriesClosedMidgt Mstng MM1 · Newfoundland, NJSep 28, 1968 · N731GF · DestroyedNTSB NYC69A0042Accident · 1 fatalClosedCessna 150 · Clementon, NJSep 28, 1968 · N7071S · DestroyedNTSB NYC69D0163Accident · No injuriesClosedCessna 210 · Basking Ridge, NJSep 18, 1968 · N9519X · Substantial damageNTSB NYC69F0180Accident · 1 fatalClosedBensen B8M · Bridgeton, NJSep 14, 1968 · N2190 · DestroyedNTSB NYC69A0027Accident · 2 fatalClosedPiper PA-28 · Manahawkin, NJSep 4, 1968 · N8000W · DestroyedNTSB NYC69D0139Accident · Minor injuriesClosedAeronca 7AC · Whitehouse, NJSep 1, 1968 · N84927 · Substantial damageNTSB NYC69F0186Accident · No injuriesClosedGlobe GC-1B · Medford, NJAug 31, 1968 · N599Z · Substantial damageNTSB NYC69D0162Accident · No injuriesClosedPiper PA-24 · Atlantic City, NJAug 31, 1968 · N9006P · Substantial damageNTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJAug 30, 1968 · N2199C · Substantial damageNTSB NYC69F0150Accident · No injuriesClosedCessna 182A · So.Vineland, NJAug 27, 1968 · N6340B · DestroyedNTSB NYC69D0214Accident · No injuriesClosedAeronca 7DC · Madison, NJAug 21, 1968 · N85713 · Minor damageNTSB NYC69D0166Accident · No injuriesClosedBeech A23 · Robbinsville, NJAug 21, 1968 · N8859M · Substantial damageNTSB NYC69F0127Accident · No injuriesClosedCessna 150 · Flemington, NJAug 15, 1968 · N84623 · Substantial damageNTSB NYC69D0068Accident · No injuriesClosedPiper PA-28 · Basking Ridge, NJAug 5, 1968 · N6842W · Substantial damageNTSB NYC69F0097Accident · No injuriesClosedAero Comdr 520 · Medford, NJJul 25, 1968 · N222E · Substantial damageNTSB NYC69D0111Accident · No injuriesClosedBeech 35-B33 · Moorestown, NJJul 20, 1968 · N795AA · Substantial damageNTSB NYC69F0088Accident · Serious injuriesClosedScheibe SF27M · Hopewell Tnshp, NJJul 17, 1968 · N6301 · Substantial damageNTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJJul 17, 1968 · N6486F · Substantial damageNTSB NYC69F0093Accident · No injuriesClosedPiper PA-25 · Great Meadows, NJJul 16, 1968 · N6444Z · Substantial damageNTSB NYC69F0084Accident · Serious injuriesClosedCessna 177 · Red Bank, NJJul 13, 1968 · N2259Y · DestroyedNTSB NYC69F0050Accident · Serious injuriesClosedCessna 150F · Ringwood, NJJul 12, 1968 · N7951F · Substantial damageNTSB NYC69F0034Accident · Minor injuriesClosedCessna 310H · Totowa, NJJun 29, 1968 · N1101Q · DestroyedNTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJJun 6, 1968 · N8367G · Substantial damageNTSB NYC68A0125Accident · 1 fatalClosedCessna 172 · Berlin, NJJun 2, 1968 · N7372T · DestroyedNTSB NYC68F0484Accident · Minor injuriesClosedCessna 182 · Medford, NJMay 31, 1968 · N8761U · Substantial damageNTSB NYC68D0501Accident · No injuriesClosedCessna 175 · Sussex, NJMay 25, 1968 · N7130M · Substantial damageNTSB NYC68I0119Incident · No injuriesClosedDouglas DC-9 · Newark, NJMay 18, 1968 · N1060 · Minor damageNTSB NYC68F0465Accident · No injuriesClosedCessna 150 · Millville, NJMay 15, 1968 · N1137Y · DestroyedNTSB NYC68D0491Accident · No injuriesClosedLuscombe 8A · Seaside, NJMay 14, 1968 · N23075 · Substantial damageNTSB NYC68F0474Accident · No injuriesClosedPiper PA-24 · Medford, NJMay 11, 1968 · N8865P · Substantial damageNTSB NYC68F0485Accident · No injuriesClosedBeech 95-B55 · Atlantic City, NJMay 10, 1968 · N7901M · Substantial damageNTSB NYC68F0495Accident · No injuriesClosedPiper J-4 · Berlin, NJMay 5, 1968 · N27858 · Substantial damageNTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJMay 5, 1968 · N8561J · Substantial damageNTSB NYC68F0481Accident · 1 fatalClosedErcoupe 415-C · Williamstown, NJApr 28, 1968 · N93331 · DestroyedNTSB NYC68A0117Accident · Serious injuriesClosedDouglas DC-8 · Atlantic City, NJApr 28, 1968 · N1820 · DestroyedNTSB NYC68F0469Accident · No injuriesClosedAlon A2 · Millville, NJApr 27, 1968 · N6593Q · Substantial damageNTSB NYC68D0450Accident · No injuriesClosedCessna 177 · Lavallette, NJApr 21, 1968 · N3310T · Substantial damageNTSB NYC68D0451Accident · No injuriesClosedCessna 150 · Medford, NJApr 20, 1968 · N8901S · Substantial damage