NTSB investigations, 1978, 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, 1978, 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\") = 1978
    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 NYC79DHD07Accident · Minor injuriesClosedCessna 172N · Robbinsville, NJDec 28, 1978 · N73749 · Substantial damageNTSB NYC79FHA05Accident · Minor injuriesClosedPiper PA-24 · Blairstown, NJDec 16, 1978 · N22CJ · DestroyedNTSB NYC79FHM03Accident · No injuriesClosedCessna 152 · Morristown, NJDec 11, 1978 · N25248 · Substantial damageNTSB NYC79FHD06Accident · Serious injuriesClosedLake LA-4 · North Beach, NJDec 2, 1978 · N1013L · Substantial damageNTSB NYC79IA013Incident · No injuriesClosedDouglas DC-9 · Newark, NJNov 27, 1978 · N1065T · Substantial damageNTSB NYC79FHD04Accident · No injuriesClosedPiper PA-38 · Albion, NJNov 12, 1978 · N9531T · Substantial damageNTSB NYC79FHD03Accident · No injuriesClosedPiper PA-30 · Lumberton, NJOct 14, 1978 · N7887Y · Substantial damageNTSB NYC79FHD02Accident · Minor injuriesClosedRyan ST-3KR · Albion, NJOct 11, 1978 · N48928 · Substantial damageNTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJOct 11, 1978 · N1690H · DestroyedNTSB NYC79FHM01Accident · Minor injuriesClosedPiper PA-28 · Caldwell, NJOct 1, 1978 · N9443W · Substantial damageNTSB NYC79FHD01Accident · Serious injuriesClosedBeech 35 · Wrightstown, NJOct 1, 1978 · N3898N · Substantial damageNTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJSep 23, 1978 · N90861 · DestroyedNTSB NYC78FHA35Accident · No injuriesClosedCessna 150 · Rock Hill, NJSep 20, 1978 · N63615 · Substantial damageNTSB NYC78FA092Accident · 5 fatalClosedPiper PA-32R · Robbinsville, NJSep 16, 1978 · N3930F · DestroyedNTSB NYC78FHM29Accident · No injuriesClosedPiper PA-23 · Marlboro, NJSep 10, 1978 · N1072P · Substantial damageNTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJSep 10, 1978 · N5459Q · 2 aircraft · Substantial damageNTSB NYC78FA087Accident · 1 fatalClosedCessna 150 · Dover, NJSep 3, 1978 · N704QG · Substantial damageNTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJSep 2, 1978 · N19590 · Substantial damageNTSB NYC78FHA33Accident · No injuriesClosedCessna 210T · Princeton, NJSep 1, 1978 · N761YL · Substantial damageNTSB NYC78FHM27Accident · No injuriesClosedHiller 12C · Neptune, NJAug 29, 1978 · N63MC · Substantial damageNTSB NYC78FHM26Accident · Serious injuriesClosedPiper PA-32 · Matawan, NJAug 27, 1978 · N9328C · DestroyedNTSB NYC78FA083Accident · Minor injuriesClosedPiper PA-28 · Sussex, NJAug 18, 1978 · N1876J · Substantial damageNTSB NYC78DHM25Accident · Minor injuriesClosedCessna C172H · Morristown, NJAug 17, 1978 · N2409L · Substantial damageNTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJJul 31, 1978 · N5808M · DestroyedNTSB NYC79FHD21Accident · Minor injuriesClosedErcoupe 415 · Manahawkin, NJJul 18, 1978 · N93677 · Substantial damageNTSB NYC78FHD19Accident · No injuriesClosedPiper PA-25 · Skulville, NJJul 11, 1978 · N6065Z · Substantial damageNTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJJul 9, 1978 · N1287S · 2 aircraft · Substantial damageNTSB NYC78FHA30Accident · Minor injuriesClosedTaylorcraft BC12-D · Manville, NJJul 1, 1978 · N5129M · Substantial damageNTSB NYC78FA068Accident · No injuriesClosedPiper PA-28 · Millville, NJJun 29, 1978 · N41916 · Substantial damageNTSB NYC78FHD18Accident · No injuriesClosedChampion 7KCAB · Point Pleasant, NJJun 28, 1978 · N6315N · Substantial damageNTSB NYC78DHA28Accident · No injuriesClosedBeech B19 · Basking Ridge, NJJun 17, 1978 · N1961W · Substantial damageNTSB NYC78FDH16Accident · Minor injuriesClosedGrum Amer AA5 · Cross Keys, NJMay 30, 1978 · N28426 · Substantial damageNTSB NYC78FHM17Accident · No injuriesClosedSwearingen SA26AT · Teterboro, NJMay 18, 1978 · N22GW · Substantial damageNTSB NYC78FHA22Accident · No injuriesClosedPiper PA-28 · Pittstown, NJMay 7, 1978 · N1584J · Substantial damageNTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJMay 2, 1978 · N18669 · DestroyedNTSB NYC78FHM14Accident · No injuriesClosedBellanca 7GCBC · Lincoln Park, NJApr 30, 1978 · N8876 · Substantial damageNTSB NYC78FHA21Accident · 1 fatalClosedBensen B8M · Pittstown, NJApr 29, 1978 · N5575 · DestroyedNTSB NYC78FHA20Accident · No injuriesClosedPiper PA-28 · Pittstown, NJApr 29, 1978 · N3614M · Substantial damageNTSB NYC78DHD15Accident · No injuriesClosedCessna 150 · Jobstown, NJApr 25, 1978 · N8569U · Substantial damageNTSB NYC78IA043Incident · No injuriesClosedBoeing 747 · Coyle, NJApr 16, 1978 · G-AWNI · Minor damageNTSB NYC78FHM13Accident · No injuriesClosedRallye 150ST · Teterboro, NJApr 14, 1978 · N304RA · Substantial damageNTSB NYC78FHD13Accident · Minor injuriesClosedBeech B-19 · Hammonton, NJApr 4, 1978 · N6544R · Substantial damageNTSB NYC78FHD11Accident · No injuriesClosedCessna 152 · Pitman, NJMar 28, 1978 · N49080 · Substantial damageNTSB NYC78IA037Incident · No injuriesClosedBeech 99 · Newark, NJMar 27, 1978 · N339PL · Minor damageNTSB NYC78DHD10Accident · No injuriesClosedCessna 180 · Williamstown, NJMar 19, 1978 · N7814A · Substantial damageNTSB NYC78DHA19Accident · No injuriesClosedBeech A23 · Sussex, NJMar 19, 1978 · N3534R · Substantial damageNTSB NYC78FHM07Accident · No injuriesClosedCessna 150 · West Milford, NJFeb 26, 1978 · N1692Q · Substantial damageNTSB NYC78IA029Incident · No injuriesClosedNord 262A · Newark, NJFeb 22, 1978 · N26222 · Minor damageNTSB NYC78FHD06Accident · No injuriesClosedCessna 150 · Winslow, NJFeb 22, 1978 · N704UA · Substantial damageNTSB NYC78FHM06Accident · No injuriesClosedCessna 172 · Colts Neck, NJFeb 19, 1978 · N79957 · Substantial damage