NTSB investigations, 1977, 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, 1977, 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\") = 1977
    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 NYC78FHD03Accident · No injuriesClosedBeech V35A · Ocean City, NJDec 29, 1977 · N9012V · Substantial damageNTSB NYC78DHD02Accident · Minor injuriesClosedPiper PA-28R · Lakewood, NJDec 26, 1977 · N55846 · Substantial damageNTSB NYC78FHD01Accident · Serious injuriesClosedPiper PA-34 · Berlin, NJDec 10, 1977 · N15129 · DestroyedNTSB NYC78FHM01Accident · No injuriesClosedHughes 369D · Monmouth, NJOct 27, 1977 · N8605F · DestroyedNTSB NYC78FA002Accident · 1 fatalClosedPiper PA-28 · Randolph, NJOct 26, 1977 · N3QA · DestroyedNTSB NYC77FHD32Accident · No injuriesClosedCessna 172H · Marlton, NJSep 18, 1977 · N2898L · Substantial damageNTSB NYC78FHM04Accident · No injuriesClosedHiller Acft UH-12C · Lincoln Park, NJSep 6, 1977 · N2686 · DestroyedNTSB NYC77FHD30Accident · Minor injuriesClosedBell 206L · Hightstown, NJSep 4, 1977 · N49575 · Substantial damageNTSB NYC77DHA34Accident · Serious injuriesClosedPiper J4A · Stillwater, NJAug 28, 1977 · N27879 · DestroyedNTSB NYC77FHD29Accident · No injuriesClosedPiper PA-18A · Ocean City, NJAug 25, 1977 · N1993A · Substantial damageNTSB NYC77FHO26Accident · Minor injuriesClosedPiper PA-28 · Ocean City, NJAug 22, 1977 · N1670J · DestroyedNTSB NYC77FHM23Accident · Minor injuriesClosedPiper PA-28R · Fairfield, NJAug 21, 1977 · N8591N · Substantial damageNTSB NYC77IA083Incident · No injuriesClosedLear 23 · Teterboro, NJAug 18, 1977 · N201BA · Minor damageNTSB NYC77FHM22Accident · No injuriesClosedPiper PA-28 · Teterboro, NJAug 15, 1977 · N33478 · Substantial damageNTSB LAX77IA062Incident · No injuriesClosedDouglas DC-10 · Trenton, NJAug 1, 1977 · N3002U · Minor damageNTSB NYC77FHD23Accident · No injuriesClosedBeech D-18S · Lakewood, NJJul 27, 1977 · N80341 · Substantial damageNTSB NYC77FHD22Accident · No injuriesClosedCessna 188 · Tabernacle, NJJul 18, 1977 · N91054 · Substantial damageNTSB NYC77DHA29Accident · No injuriesClosedCessna 172 · Bedminster, NJJul 17, 1977 · N12501 · Substantial damageNTSB NYC77DHO21Accident · No injuriesClosedEnstrom F28A · Toms River, NJJul 16, 1977 · N605HF · Substantial damageNTSB NYC77DHD20Accident · No injuriesClosedGrum Amer AA1-B · Lakewood, NJJul 16, 1977 · N8986L · Substantial damageNTSB NYC77FHM20Accident · Minor injuriesClosedCessna 150 · Teterboro, NJJul 14, 1977 · N10979 · Substantial damageNTSB NYC77FHD19Accident · Serious injuriesClosedCessna 150 · Atlantic Cy, NJJul 9, 1977 · N66746 · DestroyedNTSB NYC77FA071Accident · 1 fatalClosedPiper PA-28 · Ocean City, NJJul 9, 1977 · N4257Q · Substantial damageNTSB NYC77FHA24Accident · No injuriesClosedCessna 172B · Vernon, NJJul 3, 1977 · N6967X · Substantial damageNTSB NYC77FHD18Accident · Serious injuriesClosedAeronca 7CCM · Egg Harbor, NJJul 2, 1977 · N84248 · DestroyedNTSB NYC77DHA28Accident · No injuriesClosedPiper PA-28R · Princeton, NJJun 23, 1977 · N3859T · Substantial damageNTSB NYC77DHA26Accident · No injuriesClosedPiper PA-28 · Bedminster, NJJun 12, 1977 · N720FL · Substantial damageNTSB NYC77DHM19Accident · Minor injuriesClosedGrum Amer AA1 · Farmingdale, NJJun 11, 1977 · N5676L · DestroyedNTSB NYC77FHA23Accident · Serious injuriesClosedCessna 172 · Basking Ridge, NJJun 3, 1977 · N3831Q · Substantial damageNTSB NYC77FHM18Accident · Minor injuriesClosedPiper PA-28 · Totowa, NJMay 22, 1977 · N15377 · Substantial damageNTSB NYC77DHA20Accident · No injuriesClosedCessna 150 · Basking Ridge, NJMay 20, 1977 · N10912 · Substantial damageNTSB NYC77IA057Incident · Minor injuriesClosedBeech 24R · Millville, NJMay 14, 1977 · N6542R · Minor damageNTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJMay 3, 1977 · N5940L · DestroyedNTSB NYC77FHA18Accident · No injuriesClosedCessna 421B · Manville, NJApr 19, 1977 · N421RB · Substantial damageNTSB NYC77FHM17Accident · No injuriesClosedCessna 180 · Red Hook, NJMar 26, 1977 · N7853A · Substantial damageNTSB NYC77FHD28Accident · No injuriesClosedPiper PA-18 · Atlantic City, NJMar 24, 1977 · N8061C · Substantial damageNTSB NYC77FHM12Accident · No injuriesClosedCessna 182 · West Milford, NJMar 17, 1977 · N2474Q · Substantial damageNTSB NYC77DHD10Accident · No injuriesClosedPiper PA-28 · Atlantic City, NJMar 1, 1977 · N4493F · Substantial damageNTSB NYC77FHD08Accident · Minor injuriesClosedCessna 150 · Hammonton, NJFeb 23, 1977 · N6737G · Substantial damageNTSB NYC77DHA16Accident · No injuriesClosedBell 47G-4 · Blairstown, NJFeb 16, 1977 · N73292 · Substantial damageNTSB NYC77FHM10Accident · No injuriesClosedCessna 150M · Matawan, NJFeb 10, 1977 · N9371U · Substantial damageNTSB NYC77FHM09Accident · Serious injuriesClosedCessna 150J · Randolph, NJFeb 8, 1977 · N50815 · DestroyedNTSB NYC77FHM08Accident · No injuriesClosedMooney M20F · Lincoln Park, NJJan 20, 1977 · N6808V · Substantial damage