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 NYC77FHD08Accident · Minor injuriesClosedCessna 150 · Hammonton, NJFeb 23, 1977 · N6737G · Substantial damage NTSB NYC77DHA16Accident · No injuriesClosedBell 47G-4 · Blairstown, NJFeb 16, 1977 · N73292 · Substantial damage NTSB NYC77FHM10Accident · No injuriesClosedCessna 150M · Matawan, NJFeb 10, 1977 · N9371U · Substantial damage NTSB NYC77FHM09Accident · Serious injuriesClosedCessna 150J · Randolph, NJFeb 8, 1977 · N50815 · Destroyed NTSB NYC77FHM08Accident · No injuriesClosedMooney M20F · Lincoln Park, NJJan 20, 1977 · N6808V · Substantial damage NTSB NYC77DHA10Accident · No injuriesClosedCessna 182K · Pittstown, NJDec 31, 1976 · N2675R · Substantial damage NTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJDec 26, 1976 · N9573R · Substantial damage NTSB DCA77AA006Accident · 3 fatalClosedDehavilland DHC-6 · Wildwood, NJDec 12, 1976 · N101AC · Destroyed NTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJDec 4, 1976 · N15698 · Destroyed NTSB NYC77FHM05Accident · No injuriesClosedCessna 210 · Flanders, NJNov 20, 1976 · N210TM · Substantial damage NTSB NYC76FHA03Accident · Minor injuriesClosedMooney M20E · Manville, NJOct 29, 1976 · N5962Q · Destroyed NTSB NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJOct 22, 1976 · N7986U · Substantial damage NTSB NYC76DHD41Accident · No injuriesClosedAeronca 7AC · Smithville, NJAug 22, 1976 · N82415 · Substantial damage NTSB NYC76FHD39Accident · Serious injuriesClosedPiper PA-28 · W Deptford, NJAug 21, 1976 · N4336F · Destroyed NTSB NYC76DHD40Accident · No injuriesClosedPiper PA-28 · Berlin, NJAug 21, 1976 · N1830T · Substantial damage NTSB NYC76FHM35Accident · Serious injuriesClosedPiper PA-28 · Succasunna, NJAug 20, 1976 · N6581J · Substantial damage NTSB NYC76FHA48Accident · No injuriesClosedBeech C23 · Pluckimen, NJAug 13, 1976 · N2172W · Substantial damage NTSB NYC76FHD43Accident · No injuriesClosedPiper PA-16 · Fairton, NJAug 12, 1976 · N5346H · Substantial damage NTSB NYC76FHA47Accident · Minor injuriesClosedCessna 150K · Hillsboro, NJAug 12, 1976 · N6170G · Substantial damage NTSB NYC76FHD37Accident · No injuriesClosedBeech D18S · Manahawkin, NJAug 6, 1976 · N8989 · Substantial damage NTSB NYC76DHD36Accident · No injuriesClosedEnstrom F-28A · Barnegat Light, NJAug 5, 1976 · N15SB · Destroyed NTSB NYC76FHD35Accident · No injuriesClosedGrum Amer AA-5 · Ocean City, NJAug 3, 1976 · N9569L · Substantial damage NTSB NYC76FHA45Accident · Minor injuriesClosedCessna 172M · East Amwell, NJAug 3, 1976 · N80084 · Substantial damage NTSB NYC76DHD33Accident · Minor injuriesClosedPiper PA-25 · Ocean City, NJJul 28, 1976 · N6065Z · Substantial damage NTSB NYC76AM114Accident · 2 fatalClosedCessna 150J · W Caldwell, NJJul 24, 1976 · N5546G · Destroyed NTSB NYC76AN113Accident · 5 fatalClosedBeech V35 · West Milford, NJJul 18, 1976 · N5600S · Destroyed NTSB NYC76FHM32Accident · Serious injuriesClosedBeech C35 · Marlboro, NJJul 17, 1976 · N1802D · Destroyed NTSB NYC76FHD32Accident · Minor injuriesClosedCessna 195 · Lakewood, NJJul 15, 1976 · N3878V · Substantial damage NTSB NYC76FHD31Accident · Serious injuriesClosedTwin Engine D-16A · Millville, NJJul 9, 1976 · N113K · Destroyed NTSB NYC76FHA40Accident · No injuriesClosedPiper PA-12 · Whitehouse, NJJun 13, 1976 · N2919M · Substantial damage NTSB NYC76DHA39Accident · No injuriesClosedPiper PA-28 · Pittstown, NJJun 12, 1976 · N95087 · Substantial damage NTSB NYC76FHA37Accident · Minor injuriesClosedCessna 172 · Blairstown, NJJun 10, 1976 · N4643L · Destroyed NTSB NYC76AN104Accident · Minor injuriesClosedEnstrom F-28A · Island Beach, NJJun 8, 1976 · N9259 · Substantial damage NTSB NYC76DHD29Accident · No injuriesClosedBreezy JCK-1 · Bridgeport, NJJun 4, 1976 · N114A · Substantial damage NTSB NYC76DHA34Accident · No injuriesClosedMaule M5210C · Andover, NJMay 31, 1976 · N296X · Substantial damage NTSB NYC76FHM25Accident · No injuriesClosedPiper PA-28 · Fairfield, NJMay 8, 1976 · N1930T · Substantial damage NTSB NYC76FHM26Accident · No injuriesClosedAeronca S7CCM · Moonachie, NJMay 2, 1976 · N2450E · Substantial damage NTSB NYC76FHA28Accident · No injuriesClosedBellanca 8KCAB · Sussex, NJApr 29, 1976 · N36435 · Destroyed NTSB NYC76FHM31Accident · No injuriesClosedAero Comdr 500B · Morristown, NJApr 22, 1976 · N471A · Substantial damage NTSB NYC76FHM23Accident · No injuriesClosedPiper PA-22 · Hanover, NJApr 20, 1976 · N5014Z · Substantial damage NTSB NYC76FHD26Accident · No injuriesClosedAeronca 7AC · Smithville, NJApr 17, 1976 · N3032E · Substantial damage NTSB NYC76FHD25Accident · No injuriesClosedEnstrom F-28A · Brigantine, NJApr 17, 1976 · N426RD · Substantial damage NTSB NYC76FHD28Accident · Serious injuriesClosedPiper PA-24 · Cross Keys, NJApr 16, 1976 · N6733P · Substantial damage NTSB NYC76FHA32Accident · No injuriesClosedCessna 170A · Pittstown, NJApr 11, 1976 · N7A · Substantial damage NTSB NYC76FHD24Accident · Minor injuriesClosedPiper PA-28 · Vincetown, NJApr 5, 1976 · N44716 · Destroyed NTSB NYC76DHD21Accident · No injuriesClosedPiper J-3 · Bridgeton, NJMar 29, 1976 · N7497H · Substantial damage NTSB NYC76FHD19Accident · No injuriesClosedCessna 182P · Smithville, NJMar 28, 1976 · N4685K · Substantial damage NTSB NYC76AHD20Accident · No injuriesClosedStarduster SA-100 · Hammonton, NJMar 27, 1976 · N22GT · Substantial damage NTSB NYC76AN090Accident · 1 fatalClosedPiper PA-28 · Franklin, NJMar 26, 1976 · N6901W · 2 aircraft · Substantial damage NTSB NYC76FHM20Accident · Serious injuriesClosedCessna 150H · Fairfield, NJMar 22, 1976 · N6674S · Substantial damage