NTSB investigations, 1979, 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, 1979, 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\") = 1979
    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 NYC80FHM06Accident · Serious injuriesClosedCessna 150 · Teaneck, NJDec 29, 1979 · N50741 · Substantial damageNTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJDec 11, 1979 · N48470 · Substantial damageNTSB NYC80FHM04Accident · No injuriesClosedPiper PA-31 · Teterboro, NJNov 21, 1979 · N6569L · Substantial damageNTSB NYC80FA010Accident · 3 fatalClosedAerostar 601P · Charlstadt, NJNov 16, 1979 · N8099J · DestroyedNTSB NYC80FHD07Accident · No injuriesClosedHiller UH12B · Mount Holly, NJNov 6, 1979 · N10195 · Substantial damageNTSB NYC80DHD06Accident · No injuriesClosedStinson 108-2 · Toms River, NJNov 6, 1979 · N97247 · Substantial damageNTSB NYC80FHA02Accident · No injuriesClosedCessna 172H · Hackettstown, NJNov 4, 1979 · N1717F · Substantial damageNTSB NYC80FHM01Accident · No injuriesClosedCessna 152 · East Hanover, NJOct 23, 1979 · N65601 · Substantial damageNTSB NYC80FHD03Accident · Minor injuriesClosedHughes 369D · Trenton, NJOct 18, 1979 · N501RP · DestroyedNTSB NYC80FHM03Accident · Serious injuriesClosedPiper PA-28 · Morganville, NJOct 13, 1979 · N6692J · Substantial damageNTSB IAD79IA090Incident · No injuriesClosedPiper PA-31 · Morristown, NJSep 25, 1979 · N7697L · Minor damageNTSB NYC79FHM23Accident · No injuriesClosedCessna 150 · Fairfield, NJSep 19, 1979 · N45381 · Substantial damageNTSB NYC79FA079Accident · 1 fatalClosedCessna 150 · Pennington, NJSep 13, 1979 · N8481J · DestroyedNTSB NYC79FHA27Accident · No injuriesClosedAero Cmdr 112TC · Pittstown, NJSep 8, 1979 · N4537W · Substantial damageNTSB NYC79FHD22Accident · Minor injuriesClosedTeeny 2 · Bridgeport, NJSep 2, 1979 · N6773 · Substantial damageNTSB NYC79FHD20Accident · No injuriesClosedPiper PA-23 · Atlantic, NJAug 20, 1979 · N6968Y · Substantial damageNTSB NYC79FHA22Accident · No injuriesClosedCessna 310I · Reddington, NJAug 20, 1979 · N8127M · DestroyedNTSB NYC79FHA21Accident · Serious injuriesClosedCessna 170A · Sussex, NJAug 19, 1979 · N9902A · Substantial damageNTSB NYC79FA080Accident · 1 fatalClosedRyan PT-22 · Pittstown, NJAug 19, 1979 · N99994 · Substantial damageNTSB NYC79FA076Accident · No injuriesClosedRichard KR-2 · Asbury Park, NJAug 14, 1979 · N2262N · Substantial damageNTSB NYC79IA075Incident · No injuriesClosedLear Jet 35 · Newark, NJAug 13, 1979 · N35NB · Minor damageNTSB NYC79FA073Accident · Minor injuriesClosedTeal TSC1A2 · Bridgeport, NJAug 7, 1979 · N1342W · 2 aircraft · Substantial damageNTSB NYC79FHA19Accident · No injuriesClosedCessna 177 · Franklin, NJJul 30, 1979 · N2948X · Substantial damageNTSB NYC79FHD19Accident · Minor injuriesClosedCessna 172 · Ocean City, NJJul 29, 1979 · N9843V · Substantial damageNTSB NYC79FA064Accident · No injuriesClosedBell 206B · Alpine, NJJul 21, 1979 · N711GT · Substantial damageNTSB NYC79FHD18Accident · No injuriesClosedPiper PA-32 · Woodbine, NJJul 19, 1979 · N267RB · Substantial damageNTSB NYC79DA054Accident · No injuriesClosedTed Smith TS-600 · Atlantic City, NJJul 11, 1979 · N500TS · Substantial damageNTSB NYC79FHM22Accident · No injuriesClosedPiper PA-30 · Teterboro, NJJul 5, 1979 · N77324 · Substantial damageNTSB NYC79FA050Accident · 2 fatalClosedPiper PA-12 · Stillmanville, NJJun 27, 1979 · N4293M · DestroyedNTSB NYC79FHM21Accident · Serious injuriesClosedCessna 172M · Marlboro, NJJun 15, 1979 · N20325 · Substantial damageNTSB NYC79FHD16Accident · Minor injuriesClosedCessna A188B · Cedarville, NJJun 15, 1979 · N6443G · Substantial damageNTSB NYC79FHD15Accident · No injuriesClosedCessna 172N · Woodline, NJJun 12, 1979 · N738YD · Substantial damageNTSB NYC79FHM18Accident · No injuriesClosedCessna 172 · Matawan, NJMay 17, 1979 · N10622 · Substantial damageNTSB NYC79FHM19Accident · No injuriesClosedCessna 150 · Fairfield, NJMay 11, 1979 · N66781 · Substantial damageNTSB NYC79DHD14Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJMay 8, 1979 · N56118 · Substantial damageNTSB DCA79FA014Accident · 3 fatalClosedSikorsky S61-L · Newark, NJApr 18, 1979 · N618PA · Substantial damageNTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJApr 17, 1979 · N7318P · DestroyedNTSB NYC79FHM15Accident · No injuriesClosedBrantly B2 · Flanders, NJApr 1, 1979 · N5968X · Substantial damageNTSB NYC79FA033Accident · 2 fatalClosedPiper PA-28 · Allaire, NJApr 1, 1979 · N4897T · Substantial damageNTSB NYC79DHM24Accident · No injuriesClosedCessna 172 · Colts Neck, NJMar 30, 1979 · N9297H · Substantial damageNTSB NYC79FHD12Accident · No injuriesClosedBeech B24R · Robbinsville, NJMar 22, 1979 · N9162S · Substantial damageNTSB NYC79DHM13Accident · No injuriesClosedPiper PA-28 · Morristown, NJMar 22, 1979 · N7246F · Substantial damageNTSB NYC79FHD13Accident · No injuriesClosedCessna 337G · Lumberton, NJMar 21, 1979 · N53694 · Substantial damageNTSB NYC79FA031Accident · 1 fatalClosedPiper PA-28 · Pittstown, NJMar 19, 1979 · N526FL · Substantial damageNTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJMar 4, 1979 · N6630J · DestroyedNTSB NYC79FHM11Accident · Minor injuriesClosedStits Play · Montville, NJMar 3, 1979 · N2451 · Substantial damageNTSB NYC79FHD11Accident · No injuriesClosedCessna 152 · Robbinsville, NJMar 2, 1979 · N24843 · Substantial damageNTSB NYC79FHD10Accident · No injuriesClosedBell 47G-4A · Seaside Park, NJMar 2, 1979 · N1385X · Substantial damageNTSB NYC79DHM10Accident · No injuriesClosedCessna 172M · Lincoln Park, NJFeb 21, 1979 · N12801 · Substantial damageNTSB NYC79FHM07Accident · No injuriesClosedVargar 2150A · Flanders, NJFeb 3, 1979 · N8274J · Substantial damage