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 NYC80FHM06Accident · Serious injuriesClosedCessna 150 · Teaneck, NJDec 29, 1979 · N50741 · Substantial damage NTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJDec 11, 1979 · N48470 · Substantial damage NTSB NYC80FHM04Accident · No injuriesClosedPiper PA-31 · Teterboro, NJNov 21, 1979 · N6569L · Substantial damage NTSB NYC80FA010Accident · 3 fatalClosedAerostar 601P · Charlstadt, NJNov 16, 1979 · N8099J · Destroyed NTSB NYC80FHD07Accident · No injuriesClosedHiller UH12B · Mount Holly, NJNov 6, 1979 · N10195 · Substantial damage NTSB NYC80DHD06Accident · No injuriesClosedStinson 108-2 · Toms River, NJNov 6, 1979 · N97247 · Substantial damage NTSB NYC80FHA02Accident · No injuriesClosedCessna 172H · Hackettstown, NJNov 4, 1979 · N1717F · Substantial damage NTSB NYC80FHM01Accident · No injuriesClosedCessna 152 · East Hanover, NJOct 23, 1979 · N65601 · Substantial damage NTSB NYC80FHD03Accident · Minor injuriesClosedHughes 369D · Trenton, NJOct 18, 1979 · N501RP · Destroyed NTSB NYC80FHM03Accident · Serious injuriesClosedPiper PA-28 · Morganville, NJOct 13, 1979 · N6692J · Substantial damage NTSB IAD79IA090Incident · No injuriesClosedPiper PA-31 · Morristown, NJSep 25, 1979 · N7697L · Minor damage NTSB NYC79FHM23Accident · No injuriesClosedCessna 150 · Fairfield, NJSep 19, 1979 · N45381 · Substantial damage NTSB NYC79FA079Accident · 1 fatalClosedCessna 150 · Pennington, NJSep 13, 1979 · N8481J · Destroyed NTSB NYC79FHA27Accident · No injuriesClosedAero Cmdr 112TC · Pittstown, NJSep 8, 1979 · N4537W · Substantial damage NTSB NYC79FHD22Accident · Minor injuriesClosedTeeny 2 · Bridgeport, NJSep 2, 1979 · N6773 · Substantial damage NTSB NYC79FHD20Accident · No injuriesClosedPiper PA-23 · Atlantic, NJAug 20, 1979 · N6968Y · Substantial damage NTSB NYC79FHA22Accident · No injuriesClosedCessna 310I · Reddington, NJAug 20, 1979 · N8127M · Destroyed NTSB NYC79FHA21Accident · Serious injuriesClosedCessna 170A · Sussex, NJAug 19, 1979 · N9902A · Substantial damage NTSB NYC79FA080Accident · 1 fatalClosedRyan PT-22 · Pittstown, NJAug 19, 1979 · N99994 · Substantial damage NTSB NYC79FA076Accident · No injuriesClosedRichard KR-2 · Asbury Park, NJAug 14, 1979 · N2262N · Substantial damage NTSB NYC79IA075Incident · No injuriesClosedLear Jet 35 · Newark, NJAug 13, 1979 · N35NB · Minor damage NTSB NYC79FA073Accident · Minor injuriesClosedTeal TSC1A2 · Bridgeport, NJAug 7, 1979 · N1342W · 2 aircraft · Substantial damage NTSB NYC79FHA19Accident · No injuriesClosedCessna 177 · Franklin, NJJul 30, 1979 · N2948X · Substantial damage NTSB NYC79FHD19Accident · Minor injuriesClosedCessna 172 · Ocean City, NJJul 29, 1979 · N9843V · Substantial damage NTSB NYC79FA064Accident · No injuriesClosedBell 206B · Alpine, NJJul 21, 1979 · N711GT · Substantial damage NTSB NYC79FHD18Accident · No injuriesClosedPiper PA-32 · Woodbine, NJJul 19, 1979 · N267RB · Substantial damage NTSB NYC79DA054Accident · No injuriesClosedTed Smith TS-600 · Atlantic City, NJJul 11, 1979 · N500TS · Substantial damage NTSB NYC79FHM22Accident · No injuriesClosedPiper PA-30 · Teterboro, NJJul 5, 1979 · N77324 · Substantial damage NTSB NYC79FA050Accident · 2 fatalClosedPiper PA-12 · Stillmanville, NJJun 27, 1979 · N4293M · Destroyed NTSB NYC79FHM21Accident · Serious injuriesClosedCessna 172M · Marlboro, NJJun 15, 1979 · N20325 · Substantial damage NTSB NYC79FHD16Accident · Minor injuriesClosedCessna A188B · Cedarville, NJJun 15, 1979 · N6443G · Substantial damage NTSB NYC79FHD15Accident · No injuriesClosedCessna 172N · Woodline, NJJun 12, 1979 · N738YD · Substantial damage NTSB NYC79FHM18Accident · No injuriesClosedCessna 172 · Matawan, NJMay 17, 1979 · N10622 · Substantial damage NTSB NYC79FHM19Accident · No injuriesClosedCessna 150 · Fairfield, NJMay 11, 1979 · N66781 · Substantial damage NTSB NYC79DHD14Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJMay 8, 1979 · N56118 · Substantial damage NTSB DCA79FA014Accident · 3 fatalClosedSikorsky S61-L · Newark, NJApr 18, 1979 · N618PA · Substantial damage NTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJApr 17, 1979 · N7318P · Destroyed NTSB NYC79FHM15Accident · No injuriesClosedBrantly B2 · Flanders, NJApr 1, 1979 · N5968X · Substantial damage NTSB NYC79FA033Accident · 2 fatalClosedPiper PA-28 · Allaire, NJApr 1, 1979 · N4897T · Substantial damage NTSB NYC79DHM24Accident · No injuriesClosedCessna 172 · Colts Neck, NJMar 30, 1979 · N9297H · Substantial damage NTSB NYC79FHD12Accident · No injuriesClosedBeech B24R · Robbinsville, NJMar 22, 1979 · N9162S · Substantial damage NTSB NYC79DHM13Accident · No injuriesClosedPiper PA-28 · Morristown, NJMar 22, 1979 · N7246F · Substantial damage NTSB NYC79FHD13Accident · No injuriesClosedCessna 337G · Lumberton, NJMar 21, 1979 · N53694 · Substantial damage NTSB NYC79FA031Accident · 1 fatalClosedPiper PA-28 · Pittstown, NJMar 19, 1979 · N526FL · Substantial damage NTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJMar 4, 1979 · N6630J · Destroyed NTSB NYC79FHM11Accident · Minor injuriesClosedStits Play · Montville, NJMar 3, 1979 · N2451 · Substantial damage NTSB NYC79FHD11Accident · No injuriesClosedCessna 152 · Robbinsville, NJMar 2, 1979 · N24843 · Substantial damage NTSB NYC79FHD10Accident · No injuriesClosedBell 47G-4A · Seaside Park, NJMar 2, 1979 · N1385X · Substantial damage NTSB NYC79DHM10Accident · No injuriesClosedCessna 172M · Lincoln Park, NJFeb 21, 1979 · N12801 · Substantial damage NTSB NYC79FHM07Accident · No injuriesClosedVargar 2150A · Flanders, NJFeb 3, 1979 · N8274J · Substantial damage