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 NYC75FHA35Accident · Minor injuriesClosedMooney M20C · Basking Ridge, NJApr 11, 1975 · N7863V · Substantial damage NTSB NYC75DHA37Accident · No injuriesClosedSchweizer SGS126 · Blairstown, NJMar 26, 1975 · N2740Z · Substantial damage NTSB NYC75FHD38Accident · No injuriesClosedPiper PA-24 · Bridgeport, NJMar 21, 1975 · N9081P · Substantial damage NTSB NYC75FHA33Accident · No injuriesClosedCessna 150 · Blairstown, NJMar 10, 1975 · N6137G · Substantial damage NTSB NYC75FHD32Accident · Minor injuriesClosedCessna 172 · Atlantic City, NJMar 6, 1975 · N7953U · Substantial damage NTSB NYC75AN088Accident · 2 fatalClosedBellanca 17-30 · Newton, NJMar 2, 1975 · N4723V · Destroyed NTSB NYC75FHD34Accident · No injuriesClosedPiper PA-28R · Marlton, NJFeb 28, 1975 · N4681J · No damage NTSB NYC75FHD35Accident · Minor injuriesClosedCessna 150G · Manahawkin, NJFeb 19, 1975 · N2487J · Destroyed NTSB NYC75DHA30Accident · No injuriesClosedCessna 150 · Blairstown, NJFeb 11, 1975 · N5687G · Substantial damage NTSB NYC75DHA31Accident · No injuriesClosedCessna 172I · Tranquility, NJFeb 9, 1975 · N8410L · Substantial damage NTSB NYC75FHA29Accident · Serious injuriesClosedRyan ST-3KR · Sussex, NJFeb 2, 1975 · N59502 · Substantial damage NTSB NYC75AN083Accident · 2 fatalClosedLockheed PV-1 · Egg Harbor, NJFeb 1, 1975 · N234YU · Destroyed NTSB NYC75DHM14Accident · No injuriesClosedPiper PA-28 · Caldwell, NJJan 27, 1975 · N4342T · Substantial damage NTSB NYC75DHA28Accident · No injuriesClosedCessna 170A · Pittstown, NJDec 28, 1974 · N7A · Substantial damage NTSB NYC75DHA25Accident · No injuriesClosedCessna 172 · Manville, NJDec 28, 1974 · N6966A · Substantial damage NTSB NYC75FHD26Accident · Minor injuriesClosedPiper PA-23 · Ocean City, NJNov 24, 1974 · N1MV · Substantial damage NTSB NYC75DHM12Accident · No injuriesClosedCessna 172 · Morristown, NJNov 24, 1974 · N13682 · Substantial damage NTSB NYC75DHA21Accident · No injuriesClosedCessna 150 · Readington, NJNov 2, 1974 · N5459Q · Substantial damage NTSB NYC75AN054Accident · No injuriesClosedHiller Acft FH1100 · Bridgeport, NJOct 29, 1974 · N372FH · Substantial damage NTSB NYC75FHM10Accident · No injuriesClosedPiper PA-30 · Newark, NJOct 11, 1974 · N7940Y · Substantial damage NTSB NYC75FHD15Accident · No injuriesClosedBoeing A75N1 · Pennington, NJOct 10, 1974 · N9283H · Substantial damage NTSB NYC75AN045Accident · 1 fatalClosedCessna 195 · Albion, NJOct 10, 1974 · N3461V · Destroyed NTSB NYC75DHD22Accident · No injuriesClosedCessna 150 · Smithville, NJOct 7, 1974 · N3386J · Substantial damage NTSB NYC75FHD25Accident · Minor injuriesClosedCessna 170 · Marlton, NJOct 5, 1974 · N3860V · Destroyed NTSB NYC75AN044Accident · 1 fatalClosedCessna 172 · Anglesea, NJSep 28, 1974 · N4250F · Destroyed NTSB NYC75DHD20Accident · No injuriesClosedPiper PA-28 · Vincetown, NJSep 25, 1974 · N43078 · Substantial damage NTSB NYC75AN040Accident · No injuriesClosedBell 206B · Colonia, NJSep 24, 1974 · N500WL · Substantial damage NTSB NYC75AN038Accident · 4 fatalClosedBeech D50E · Clarksburg, NJSep 19, 1974 · N565T · Destroyed NTSB NYC75FHM07Accident · No injuriesClosedBell 206B · Moonachie, NJSep 10, 1974 · N59563 · Substantial damage NTSB NYC75DHM06Accident · No injuriesClosedBeech A23A · Colts Neck, NJAug 30, 1974 · N3696Q · Substantial damage NTSB NYC75FHD17Accident · Minor injuriesClosedPiper J-3 · Bridgeport, NJAug 27, 1974 · N42843 · Substantial damage NTSB NYC75AN019Accident · No injuriesClosedCessna 402B · Boonton, NJAug 20, 1974 · N4090L · Substantial damage NTSB NYC75FHA13Accident · No injuriesClosedBeech D95A · Pittstown, NJAug 8, 1974 · N7955M · Substantial damage NTSB NYC75AN018Accident · 1 fatalClosedBerger ONE · Bayville, NJAug 6, 1974 · N76SM · Destroyed NTSB NYC75FHA10Accident · No injuriesClosedBeech A55 · Bedminster, NJAug 4, 1974 · N8510M · Destroyed NTSB NYC75DHM05Accident · No injuriesClosedChampion 7GCAA · Asbury Park, NJAug 3, 1974 · N5249X · Substantial damage NTSB NYC75FHA07Accident · No injuriesClosedPiper PA-23 · Middleville, NJAug 1, 1974 · N2008P · Substantial damage NTSB NYC75DHD09Accident · No injuriesClosedLuscombe 8A · Marlton, NJJul 26, 1974 · N1610K · Substantial damage NTSB NYC75FHD11Accident · No injuriesClosedBoeing B75N1 · Indian Mills, NJJul 25, 1974 · N64590 · Substantial damage NTSB NYC75AN012Accident · 4 fatalClosedPiper PA-28R · Toms River, NJJul 25, 1974 · N43100 · 2 aircraft · Destroyed NTSB NYC74FHA09Accident · No injuriesClosedN.American SNJ-5 · Pittstown, NJJul 21, 1974 · N3617F · Substantial damage NTSB NYC75FHD08Accident · Minor injuriesClosedCessna 177 · Smithville, NJJul 20, 1974 · N3101T · Substantial damage NTSB NYC75FHD05Accident · No injuriesClosedHelicorp D · Trenton, NJJul 16, 1974 · N8219 · Substantial damage NTSB NYC75FHA02Accident · No injuriesClosedRallye 220 · Pittstown, NJJul 13, 1974 · N49BF · Substantial damage NTSB NYC75DHD03Accident · No injuriesClosedBeech D17S · Medford, NJJul 12, 1974 · N51121 · Substantial damage NTSB NYC75FHD04Accident · No injuriesClosedPiper PA-28 · Toms River, NJJul 9, 1974 · N15480 · Substantial damage NTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJJul 7, 1974 · N5498Q · Minor damage NTSB NYC75DHM03Accident · No injuriesClosedBryan RS-15 · Randolph, NJJul 4, 1974 · N24876 · Substantial damage NTSB NYC74FHA35Accident · Minor injuriesClosedPiper PA-28 · Sussex, NJJun 29, 1974 · N4536T · Substantial damage NTSB NYC74FHM34Accident · No injuriesClosedEnstrom F-28A · Teterboro, NJJun 22, 1974 · N9591 · Substantial damage