Skip to content

NTSB investigations, NJ

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC72FHD29Accident · No injuriesClosedPiper PA-28 · Vincentown, NJFeb 29, 1972 · N5977U · Substantial damage NTSB NYC72FHM32Accident · No injuriesClosedCessna 182 · Linden, NJFeb 28, 1972 · N9142G · Substantial damage NTSB NYC72FHM31Accident · No injuriesClosedPiper PA-28 · Morristown, NJFeb 20, 1972 · N2679T · Substantial damage NTSB NYC72IN094Incident · No injuriesClosedBeech 65-80 · Pomona, NJFeb 9, 1972 · N148 · Minor damage NTSB NYC72FHM29Accident · No injuriesClosedCessna 150 · Teterboro, NJFeb 6, 1972 · N6014G · Substantial damage NTSB NYC72FHM28Accident · Minor injuriesClosedMooney M20C · Farmingdale, NJJan 24, 1972 · N5921Q · Substantial damage NTSB NYC72FHD27Accident · No injuriesClosedAero Comdr 200-D · Vineland, NJJan 24, 1972 · N2957T · Substantial damage NTSB NYC72FHM26Accident · No injuriesClosedStinson 108 · Morganville, NJJan 22, 1972 · N745C · Substantial damage NTSB NYC72FHA29Accident · No injuriesClosedBeech A35 · Princeton, NJJan 7, 1972 · N670B · Substantial damage NTSB NYC72DHD28Accident · No injuriesClosedPiper PA-28 · Berlin, NJJan 7, 1972 · N5803U · Substantial damage NTSB NYC72FHM24Accident · Minor injuriesClosedCessna 150 · West Caldwell, NJDec 29, 1971 · N8735S · Substantial damage NTSB NYC72FHD24Accident · Minor injuriesClosedChampion 7FC · Moorestown, NJDec 23, 1971 · N9974Y · Substantial damage NTSB NYC72AN082Accident · Serious injuriesClosedPiper PA-23 · Haledon, NJDec 15, 1971 · N6685Y · Destroyed NTSB NYC72FHM23Accident · Serious injuriesClosedAero Comdr 500S · Morristown, NJDec 10, 1971 · N9128N · Destroyed NTSB NYC72FHM22Accident · No injuriesClosedCessna 150 · Linden, NJDec 10, 1971 · N61274 · Substantial damage NTSB NYC72FHD23Accident · No injuriesClosedCessna 177 · Sewell, NJNov 25, 1971 · N3258T · Substantial damage NTSB NYC72FHD22Accident · Minor injuriesClosedMooney M20F · Vineland, NJNov 24, 1971 · N9652M · Substantial damage NTSB NYC72FHM17Accident · No injuriesClosedPiper PA-28 · Belmar, NJNov 23, 1971 · N2171T · Substantial damage NTSB NYC72FHD21Accident · No injuriesClosedCessna 182J · Williamstown, NJNov 21, 1971 · N2733F · Substantial damage NTSB NYC72DHM15Accident · No injuriesClosedCessna 150 · Teterboro, NJNov 21, 1971 · N23072 · Substantial damage NTSB NYC72IN062Incident · No injuriesClosedDehavilland DHC-6 · Atlantic City, NJNov 3, 1971 · N669MA · Minor damage NTSB NYC72FHA22Accident · Minor injuriesClosedPiper PA-22 · Branchville, NJOct 31, 1971 · N8538C · Substantial damage NTSB NYC72DHD20Accident · No injuriesClosedPiper PA-28 · Millville, NJOct 31, 1971 · N1849J · Substantial damage NTSB NYC72FHM14Accident · No injuriesClosedCessna 150H · East Hanover, NJOct 27, 1971 · N6586S · Substantial damage NTSB NYC72FHA21Accident · No injuriesClosedBell 206A · Somerville, NJOct 21, 1971 · N273E · Substantial damage NTSB NYC72DHD18Accident · No injuriesClosedPiper PA-28R · Atlantic City, NJOct 20, 1971 · N4966J · Substantial damage NTSB NYC72FHD17Accident · No injuriesClosedBeech V35A · Atlantic City, NJOct 14, 1971 · N7040N · Substantial damage NTSB NYC72DHA19Accident · No injuriesClosedCessna 150 · Manville, NJOct 9, 1971 · N6426G · Substantial damage NTSB NYC72FHM12Accident · Serious injuriesClosedCessna 172E · Paramus, NJSep 19, 1971 · N3986S · Substantial damage NTSB NYC72FHM11Accident · No injuriesClosedPiper PA-22 · Marlboro, NJSep 14, 1971 · N8940D · Substantial damage NTSB NYC72FHD12Accident · Serious injuriesClosedBeech A23 · Atlantic City, NJSep 7, 1971 · N1416L · Substantial damage NTSB NYC72DHD16Accident · No injuriesClosedLuscombe 8A · Cross Keys, NJSep 6, 1971 · N1230K · Substantial damage NTSB NYC72AN036Accident · 2 fatalClosedPiper PA-28 · Princeton, NJSep 6, 1971 · N5923U · Destroyed NTSB NYC72AN035Accident · 1 fatalClosedPiper PA-24 · Quakertown, NJSep 6, 1971 · N6123P · Destroyed NTSB NYC72FHM09Accident · No injuriesClosedBeech A23A · Linden, NJSep 5, 1971 · N4700J · Substantial damage NTSB NYC72FHM08Accident · Serious injuriesClosedBensen B8M · New Shrewsbury, NJSep 3, 1971 · N2765 · Substantial damage NTSB NYC72FHD10Accident · Minor injuriesClosedPiper PA-28 · Berlin, NJSep 3, 1971 · N8841J · Substantial damage NTSB NYC72DHD06Accident · No injuriesClosedCessna 150 · Wildwood, NJAug 31, 1971 · N50741 · Substantial damage NTSB NYC72FHM06Accident · 1 fatalClosedBell 47G2A · Monmouth, NJAug 30, 1971 · N8464E · Destroyed NTSB NYC72DHA13Accident · No injuriesClosedPiper PA-24 · Pittstown, NJAug 29, 1971 · N9344P · Substantial damage NTSB NYC72AN031Accident · 2 fatalClosedBeech F33A · Andover, NJAug 29, 1971 · N9176Q · Substantial damage NTSB NYC72FHD14Accident · No injuriesClosedErco 415-C · Pemberton, NJAug 28, 1971 · N3771H · Substantial damage NTSB NYC72FHD08Accident · No injuriesClosedNaval Fcty N3N-3 · Atlantic City, NJAug 22, 1971 · N44745 · Substantial damage NTSB NYC72FHM03Accident · No injuriesClosedBeech 23 · Morganville, NJAug 15, 1971 · N2318Z · Substantial damage NTSB NYC72DHD05Accident · No injuriesClosedPiper PA-28 · Marlton, NJAug 9, 1971 · N8260N · Substantial damage NTSB NYC72AN013Accident · 2 fatalClosedPiper PA-28 · Wanaque, NJJul 29, 1971 · N5563W · Destroyed NTSB NYC72DHD03Accident · No injuriesClosedPiper PA-24 · Rio Grande, NJJul 27, 1971 · N7809P · Substantial damage NTSB NYC72DHD04Accident · No injuriesClosedPiper PA-28 · Ocean City, NJJul 18, 1971 · N3979R · Substantial damage NTSB NYC72FHA04Accident · Serious injuriesClosedPiper PA-23 · Sussex, NJJul 14, 1971 · N1251P · Substantial damage NTSB NYC72FHD02Accident · No injuriesClosedCessna 172 · Atlantic City, NJJul 10, 1971 · N8243B · Substantial damage