Skip to content

NTSB investigations, NJ

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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.

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 c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC81FA011Accident · 4 fatalClosedCessna 177B · Bridgeport, NJNov 21, 1980 · N30854 · Destroyed NTSB NYC81FA008Accident · Serious injuriesClosedBoeing 727 · Newark, NJNov 11, 1980 · N462B · No damage NTSB NYC81FHD07Accident · Serious injuriesClosedCessna 177RG · Vineland, NJNov 7, 1980 · N610QR · Destroyed NTSB NYC81FHD05Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJOct 30, 1980 · N8135B · Substantial damage NTSB NYC81FHD04Accident · Minor injuriesClosedPiper PA-24 · Delran Twnship, NJOct 25, 1980 · N5509P · Destroyed NTSB NYC81IA006Incident · No injuriesClosedBell 206L · Atlantic City, NJOct 24, 1980 · N10 · Minor damage NTSB NYC81FHD03Accident · No injuriesClosedPiper PA-34 · Burlington, NJOct 13, 1980 · N1482X · Substantial damage NTSB NYC81DHA01Accident · No injuriesClosedAeronca 7DC · Pottstown, NJOct 11, 1980 · N1834E · Substantial damage NTSB NYC81IA002Incident · No injuriesClosedLockheed L1011 · Newark, NJOct 10, 1980 · N31015 · 2 aircraft · No damage NTSB NYC81FHD02Accident · No injuriesClosedBlimp EA-1 · Lakehurst, NJOct 8, 1980 · N5499A · Substantial damage NTSB NYC81DHD01Accident · No injuriesClosedCessna 172 · Woodbine, NJOct 6, 1980 · N9883J · Substantial damage NTSB NYC81FA001Accident · 2 fatalClosedLake 4-200 · Little Egg, NJOct 4, 1980 · N875SR · Destroyed NTSB NYC80FHD26Accident · No injuriesClosedPiper PA-28 · Berlin, NJSep 26, 1980 · N3668R · Destroyed NTSB NYC80FA085Accident · Minor injuriesClosedCessna 172N · Hammonton, NJSep 10, 1980 · N7333J · Substantial damage NTSB NYC80DHA29Accident · No injuriesClosedSchweizer SGS126 · Mt Salem, NJAug 16, 1980 · N83TT · Substantial damage NTSB NYC80FA071Accident · 2 fatalClosedPiper PA-24 · Atlantic City, NJAug 15, 1980 · N8783P · Destroyed NTSB NYC80FHD23Accident · No injuriesClosedCessna 150 · Little Egg Hbr, NJAug 10, 1980 · N7781F · Substantial damage NTSB NYC80FHM23Accident · No injuriesClosedPiper PA-28 · Hanover, NJAug 5, 1980 · N4819T · Substantial damage NTSB NYC80FHD22Accident · No injuriesClosedCessna 206 · Wildwood, NJJul 17, 1980 · N221YW · Substantial damage NTSB NYC80FHM21Accident · No injuriesClosedCessna 150L · Caldwell, NJJul 10, 1980 · N7971G · Destroyed NTSB NYC80DA081Accident · No injuriesClosedCessna 150 · Princetown, NJJul 8, 1980 · N7572U · Substantial damage NTSB NYC80FA050Accident · 5 fatalClosedPiper PA-28 · Ocean City, NJJul 4, 1980 · N6396J · Destroyed NTSB NYC80DHD21Accident · No injuriesClosedCessna 172 · Atlantic City, NJJul 4, 1980 · N3287E · Substantial damage NTSB NYC80DHA22Accident · No injuriesClosedCessna 172 · Pittstown, NJJun 28, 1980 · N4930E · Destroyed NTSB NYC80DHM16Accident · No injuriesClosedSchweizer SGS126 · Colts Neck, NJJun 21, 1980 · N3810A · Substantial damage NTSB NYC80FHA23Accident · No injuriesClosedPiper PA-23 · Somerville, NJJun 14, 1980 · N1442P · Substantial damage NTSB NYC80FHA15Accident · No injuriesClosedCessna 150 · Newton, NJJun 12, 1980 · N18016 · Substantial damage NTSB NYC80FHM17Accident · No injuriesClosedCessna 152 · Morristown, NJJun 11, 1980 · N757PN · Substantial damage NTSB NYC80FHD15Accident · Minor injuriesClosedBede 4 · Bridgeport, NJJun 5, 1980 · N600W · Substantial damage NTSB NYC80FA044Accident · 1 fatalClosedPiper PA-23 · Neptune, NJJun 4, 1980 · N646MA · Destroyed NTSB NYC80FA043Accident · 3 fatalClosedCessna 172G · Cape May, NJJun 2, 1980 · N3847L · Destroyed NTSB NYC80FHD17Accident · No injuriesClosedChampion 7GCBC · Williamstown, NJJun 1, 1980 · N1880G · Substantial damage NTSB NYC80DHA25Accident · No injuriesClosedGrum Amer AA-1 · Sussex, NJMay 31, 1980 · N1480R · Substantial damage NTSB NYC80FHM18Accident · No injuriesClosedCessna 150 · West Milford, NJMay 26, 1980 · N28135 · Substantial damage NTSB NYC80FHD11Accident · No injuriesClosedCessna 177RG · Normandy Beach, NJMay 20, 1980 · N2190Q · Substantial damage NTSB NYC80FHD14Accident · No injuriesClosedHarvard MK-4 · Turnersville, NJMay 10, 1980 · N20425 · Substantial damage NTSB NYC80FA040Accident · 4 fatalClosedCessna 411 · Vineland, NJMay 9, 1980 · N4973T · Destroyed NTSB NYC80FHA12Accident · No injuriesClosedPiper PA-28 · Pittstown, NJMay 2, 1980 · N212BM · Substantial damage NTSB NYC80FHA11Accident · No injuriesClosedBeech M35 · Somerville, NJMay 1, 1980 · N9792R · Substantial damage NTSB NYC80FHM15Accident · No injuriesClosedCessna 150L · Lincoln Park, NJApr 26, 1980 · N6508G · Destroyed NTSB NYC80FHM14Accident · Minor injuriesClosedCessna 152 · West Milford, NJApr 22, 1980 · N46825 · Substantial damage NTSB NYC80FHM11Accident · No injuriesClosedCessna 172 · New Milford, NJMar 16, 1980 · N560Z · Substantial damage NTSB NYC80FHM12Accident · No injuriesClosedPiper PA-32 · Morristown, NJMar 15, 1980 · N2947E · Substantial damage NTSB NYC80FA027Accident · 1 fatalClosedMooney M20C · Ogdensburg, NJMar 10, 1980 · N7171V · Destroyed NTSB NYC80FHD09Accident · No injuriesClosedCessna 172 · Cross Keys, NJMar 9, 1980 · N8070E · Substantial damage NTSB NYC80DHA05Accident · No injuriesClosedCessna 340 · Princeton, NJFeb 15, 1980 · N6303X · Substantial damage NTSB NYC80FHM09Accident · Serious injuriesClosedCessna 152 · Picatny Arsenl, NJFeb 10, 1980 · N24761 · Destroyed NTSB NYC80FHM08Accident · Serious injuriesClosedCessna 152 · Linden, NJFeb 6, 1980 · N49568 · Substantial damage NTSB NYC80FA023Accident · 1 fatalClosedGrum Amer AA-1B · Morganville, NJJan 30, 1980 · N9338L · Destroyed NTSB NYC80FA019Accident · 2 fatalClosedBeech B19 · Bogota, NJJan 19, 1980 · N1946W · Destroyed