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 NYC79FHA09Accident · Serious injuriesClosedSchweizer SGS233 · Blairstown, NJFeb 3, 1979 · N33986 · Substantial damage NTSB NYC79FHM06Accident · Minor injuriesClosedCessna 150 · Matawan, NJJan 26, 1979 · N9473U · Substantial damage NTSB NYC79FHM04Accident · Minor injuriesClosedCessna 414 · Newark, NJJan 24, 1979 · N414TA · Substantial damage NTSB NYC79FHM04Accident · No injuriesClosedPiper PA-28 · Teterboro, NJJan 23, 1979 · N57369 · Substantial damage NTSB NYC79FHA08Accident · No injuriesClosedPiper PA-28R · West Milford, NJJan 18, 1979 · N7814W · Substantial damage NTSB NYC79FA018Accident · No injuriesClosedCessna T210 · Fairfied, NJJan 15, 1979 · N732RW · 2 aircraft · Substantial damage NTSB NYC79IA019Incident · No injuriesClosedLockheed L-1011 · Newark, NJJan 12, 1979 · N324EA · Minor damage NTSB NYC79DHD07Accident · Minor injuriesClosedCessna 172N · Robbinsville, NJDec 28, 1978 · N73749 · Substantial damage NTSB NYC79FHA05Accident · Minor injuriesClosedPiper PA-24 · Blairstown, NJDec 16, 1978 · N22CJ · Destroyed NTSB NYC79FHM03Accident · No injuriesClosedCessna 152 · Morristown, NJDec 11, 1978 · N25248 · Substantial damage NTSB NYC79FHD06Accident · Serious injuriesClosedLake LA-4 · North Beach, NJDec 2, 1978 · N1013L · Substantial damage NTSB NYC79IA013Incident · No injuriesClosedDouglas DC-9 · Newark, NJNov 27, 1978 · N1065T · Substantial damage NTSB NYC79FHD04Accident · No injuriesClosedPiper PA-38 · Albion, NJNov 12, 1978 · N9531T · Substantial damage NTSB NYC79FHD03Accident · No injuriesClosedPiper PA-30 · Lumberton, NJOct 14, 1978 · N7887Y · Substantial damage NTSB NYC79FHD02Accident · Minor injuriesClosedRyan ST-3KR · Albion, NJOct 11, 1978 · N48928 · Substantial damage NTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJOct 11, 1978 · N1690H · Destroyed NTSB NYC79FHM01Accident · Minor injuriesClosedPiper PA-28 · Caldwell, NJOct 1, 1978 · N9443W · Substantial damage NTSB NYC79FHD01Accident · Serious injuriesClosedBeech 35 · Wrightstown, NJOct 1, 1978 · N3898N · Substantial damage NTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJSep 23, 1978 · N90861 · Destroyed NTSB NYC78FHA35Accident · No injuriesClosedCessna 150 · Rock Hill, NJSep 20, 1978 · N63615 · Substantial damage NTSB NYC78FA092Accident · 5 fatalClosedPiper PA-32R · Robbinsville, NJSep 16, 1978 · N3930F · Destroyed NTSB NYC78FHM29Accident · No injuriesClosedPiper PA-23 · Marlboro, NJSep 10, 1978 · N1072P · Substantial damage NTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJSep 10, 1978 · N5459Q · 2 aircraft · Substantial damage NTSB NYC78FA087Accident · 1 fatalClosedCessna 150 · Dover, NJSep 3, 1978 · N704QG · Substantial damage NTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJSep 2, 1978 · N19590 · Substantial damage NTSB NYC78FHA33Accident · No injuriesClosedCessna 210T · Princeton, NJSep 1, 1978 · N761YL · Substantial damage NTSB NYC78FHM27Accident · No injuriesClosedHiller 12C · Neptune, NJAug 29, 1978 · N63MC · Substantial damage NTSB NYC78FHM26Accident · Serious injuriesClosedPiper PA-32 · Matawan, NJAug 27, 1978 · N9328C · Destroyed NTSB NYC78FA083Accident · Minor injuriesClosedPiper PA-28 · Sussex, NJAug 18, 1978 · N1876J · Substantial damage NTSB NYC78DHM25Accident · Minor injuriesClosedCessna C172H · Morristown, NJAug 17, 1978 · N2409L · Substantial damage NTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJJul 31, 1978 · N5808M · Destroyed NTSB NYC79FHD21Accident · Minor injuriesClosedErcoupe 415 · Manahawkin, NJJul 18, 1978 · N93677 · Substantial damage NTSB NYC78FHD19Accident · No injuriesClosedPiper PA-25 · Skulville, NJJul 11, 1978 · N6065Z · Substantial damage NTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJJul 9, 1978 · N1287S · 2 aircraft · Substantial damage NTSB NYC78FHA30Accident · Minor injuriesClosedTaylorcraft BC12-D · Manville, NJJul 1, 1978 · N5129M · Substantial damage NTSB NYC78FA068Accident · No injuriesClosedPiper PA-28 · Millville, NJJun 29, 1978 · N41916 · Substantial damage NTSB NYC78FHD18Accident · No injuriesClosedChampion 7KCAB · Point Pleasant, NJJun 28, 1978 · N6315N · Substantial damage NTSB NYC78DHA28Accident · No injuriesClosedBeech B19 · Basking Ridge, NJJun 17, 1978 · N1961W · Substantial damage NTSB NYC78FDH16Accident · Minor injuriesClosedGrum Amer AA5 · Cross Keys, NJMay 30, 1978 · N28426 · Substantial damage NTSB NYC78FHM17Accident · No injuriesClosedSwearingen SA26AT · Teterboro, NJMay 18, 1978 · N22GW · Substantial damage NTSB NYC78FHA22Accident · No injuriesClosedPiper PA-28 · Pittstown, NJMay 7, 1978 · N1584J · Substantial damage NTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJMay 2, 1978 · N18669 · Destroyed NTSB NYC78FHM14Accident · No injuriesClosedBellanca 7GCBC · Lincoln Park, NJApr 30, 1978 · N8876 · Substantial damage NTSB NYC78FHA21Accident · 1 fatalClosedBensen B8M · Pittstown, NJApr 29, 1978 · N5575 · Destroyed NTSB NYC78FHA20Accident · No injuriesClosedPiper PA-28 · Pittstown, NJApr 29, 1978 · N3614M · Substantial damage NTSB NYC78DHD15Accident · No injuriesClosedCessna 150 · Jobstown, NJApr 25, 1978 · N8569U · Substantial damage NTSB NYC78IA043Incident · No injuriesClosedBoeing 747 · Coyle, NJApr 16, 1978 · G-AWNI · Minor damage NTSB NYC78FHM13Accident · No injuriesClosedRallye 150ST · Teterboro, NJApr 14, 1978 · N304RA · Substantial damage NTSB NYC78FHD13Accident · Minor injuriesClosedBeech B-19 · Hammonton, NJApr 4, 1978 · N6544R · Substantial damage NTSB NYC78FHD11Accident · No injuriesClosedCessna 152 · Pitman, NJMar 28, 1978 · N49080 · Substantial damage