NTSB investigations, 1969, 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, 1969, 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\") = 1969
    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 NYC70F0245Accident · Minor injuriesClosedPiper PA-28 · East Hanover, NJDec 21, 1969 · N6707W · DestroyedNTSB NYC70D0229Accident · No injuriesClosedCessna 150 · Lakewood, NJDec 18, 1969 · N60412 · Substantial damageNTSB NYC70D0228Accident · No injuriesClosedCessna 120 · Hancocks Brdge, NJDec 11, 1969 · N72147 · Substantial damageNTSB NYC70F0223Accident · No injuriesClosedCessna 172 · Newton, NJDec 7, 1969 · N6156E · Substantial damageNTSB NYC70D0216Accident · No injuriesClosedLuscombe 8A · Moorestown, NJNov 29, 1969 · N2259K · Substantial damageNTSB NYC70A0055Accident · No injuriesClosedDouglas DC-8 · Newark, NJNov 28, 1969 · N8610 · Substantial damageNTSB NYC70A0054Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNov 25, 1969 · N1805J · 2 aircraft · Substantial damageNTSB NYC70D0002Accident · No injuriesClosedBrantly B-2 · Millville, NJNov 23, 1969 · N4997C · DestroyedNTSB NYC70A0051Accident · No injuriesClosedCessna U206 · Pittstown, NJNov 16, 1969 · N2193F · Substantial damageNTSB NYC70F0194Accident · Minor injuriesClosedBellanca 17-30 · Princeton, NJNov 13, 1969 · N7349V · DestroyedNTSB NYC70D0208Accident · No injuriesClosedCessna 310L · Woodbine, NJNov 11, 1969 · N3288X · Substantial damageNTSB NYC70D0206Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNov 7, 1969 · N6864W · Substantial damageNTSB NYC70F0250Accident · Serious injuriesClosedSchemp SH-1 · Hanover, NJOct 26, 1969 · N103AH · 2 aircraft · Substantial damageNTSB NYC70F0189Accident · Minor injuriesClosedPiper PA-28 · Teterboro, NJOct 12, 1969 · N95127 · DestroyedNTSB NYC70F0167Accident · No injuriesClosedCessna 421 · Newark, NJSep 21, 1969 · N3147K · Substantial damageNTSB NYC70D0162Accident · Minor injuriesClosedTrager T-3 · Millville, NJSep 14, 1969 · N9098 · Substantial damageNTSB NYC70F0161Accident · 1 fatalClosedCessna 337C · Toms River, NJSep 12, 1969 · N2651S · DestroyedNTSB NYC70F0139Accident · No injuriesClosedCessna 310 · Lakewood, NJSep 6, 1969 · N3077D · Substantial damageNTSB NYC70D0149Accident · No injuriesClosedChampion 7AC · Salem, NJAug 30, 1969 · N82415 · Substantial damageNTSB NYC70F0091Accident · Minor injuriesClosedLuscombe 8E · Basking Ridge, NJAug 23, 1969 · N2646K · Substantial damageNTSB NYC70I0025Incident · No injuriesClosedDouglas DC-9 · Atlantic City, NJAug 19, 1969 · N8919E · No damageNTSB NYC70D0077Accident · No injuriesClosedAeronca 7FC · Basking Ridge, NJAug 11, 1969 · N9893B · Substantial damageNTSB NYC70D0118Accident · No injuriesClosedAmerican AA-1 · Vincentown, NJAug 10, 1969 · N5656L · Substantial damageNTSB NYC70A0022Accident · No injuriesClosedPiper PA-28R · Ocean City, NJAug 7, 1969 · N3853T · Substantial damageNTSB NYC70D0113Accident · No injuriesClosedTaylorcraft L-2 · Tuckahoe, NJAug 6, 1969 · N46112 · Substantial damageNTSB NYC70D0104Accident · No injuriesClosedPiper PA-28 · Vincentown, NJJul 31, 1969 · N5747F · Substantial damageNTSB NYC70D0075Accident · No injuriesClosedCessna 310 · Atco, NJJul 31, 1969 · N3654D · Substantial damageNTSB NYC70F0117Accident · No injuriesClosedCessna 310D · Atlantic City, NJJul 30, 1969 · N6740T · Substantial damageNTSB DCA70A0002Accident · 5 fatalClosedBoeing 707 · Pomona, NJJul 26, 1969 · N787TW · DestroyedNTSB NYC70D0100Accident · No injuriesClosedCessna 150 · Pennington, NJJul 25, 1969 · N60952 · Substantial damageNTSB NYC70D0034Accident · No injuriesClosedCessna 182 · Manville, NJJul 13, 1969 · N91636 · Substantial damageNTSB NYC70A0007Accident · 2 fatalClosedPiper PA-22 · Bridgeport, NJJul 8, 1969 · N4847Z · DestroyedNTSB NYC70F0043Accident · Minor injuriesClosedPiper PA-28 · Pittstown, NJJul 7, 1969 · N6462J · Substantial damageNTSB NYC70F0035Accident · Minor injuriesClosedLuscombe 8A · Washington, NJJul 5, 1969 · N2687K · DestroyedNTSB NYC70D0024Accident · No injuriesClosedPiper PA-22 · Pluckemin, NJJul 4, 1969 · N56122 · Substantial damageNTSB NYC70A0005Accident · 2 fatalClosedPiper PA-18 · Sewell, NJJul 4, 1969 · N9362D · DestroyedNTSB NYC70A0001Accident · 1 fatalClosedTaylorcraft BF12 · Phillipsburg, NJJul 1, 1969 · N36427 · DestroyedNTSB NYC69A0114Accident · 2 fatalClosedPiper PA-30 · Rancocas, NJJun 30, 1969 · N8609Y · DestroyedNTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJJun 29, 1969 · N2970J · Substantial damageNTSB NYC69A0113Accident · No injuriesClosedBeech D18S · Morristown, NJJun 27, 1969 · N208Z · Substantial damageNTSB NYC69A0112Accident · 2 fatalClosedCessna 310N · Blairstown, NJJun 18, 1969 · N4163Q · DestroyedNTSB NYC70D0029Accident · No injuriesClosedSchleicher K8B · Blairstown, NJJun 14, 1969 · N6660D · Substantial damageNTSB NYC69F0474Accident · No injuriesClosedBellanca 17-30 · Morristown, NJJun 11, 1969 · N4836V · Substantial damageNTSB NYC70F0023Accident · No injuriesClosedPiper PA-28R · Clifton, NJJun 4, 1969 · N9493N · Substantial damageNTSB NYC70F0057Accident · Serious injuriesClosedLuscombe 8A · Cross Keys, NJJun 1, 1969 · N1391K · Substantial damageNTSB NYC70D0005Accident · Minor injuriesClosedStinson 108-2 · Red Bank, NJMay 30, 1969 · N9344K · Substantial damageNTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJMay 30, 1969 · N4792P · Substantial damageNTSB NYC70D0018Accident · No injuriesClosedGrumman G-164A · Chatsworth, NJMay 29, 1969 · N909X · Substantial damageNTSB NYC70F0086Accident · Minor injuriesClosedAeronca 7AC · Moorestown, NJMay 17, 1969 · N81744 · DestroyedNTSB NYC69F0446Accident · No injuriesClosedPiper PA-18A · Mays Landing, NJMay 17, 1969 · N3690A · Substantial damage