Skip to content

NTSB investigations, NJ

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 NYC66F0291Accident · No injuriesClosedHoward DGA-15 · Manville, NJOct 15, 1965 · N9926H · Substantial damage NTSB NYC66D0295Accident · No injuriesClosedCessna 172 · Moorestown, NJOct 14, 1965 · N7320T · Substantial damage NTSB NYC66F0285Accident · No injuriesClosedCessna 180 · Medford, NJOct 13, 1965 · N4520B · Substantial damage NTSB NYC66F0311Accident · No injuriesClosedCessna 172 · Farmingdale, NJOct 12, 1965 · N7091T · Substantial damage NTSB NYC66F0325Accident · No injuriesClosedPiper PA-28 · Teterboro, NJOct 11, 1965 · N6527W · Substantial damage NTSB NYC66F0282Accident · No injuriesClosedCessna 150D · Farmingdale, NJOct 11, 1965 · N4473U · Substantial damage NTSB NYC66F0260Accident · No injuriesClosedCessna 210E · Bedminster, NJOct 10, 1965 · N4905U · Substantial damage NTSB NYC66F0262Accident · No injuriesClosedCessna 320 · So Hackensack, NJSep 30, 1965 · N145MP · Substantial damage NTSB NYC66I0042Incident · No injuriesClosedBoeing B-727 · Newark, NJSep 29, 1965 · N7029U · No damage NTSB NYC66F0276Accident · No injuriesClosedAeronca 57D · Carlstadt, NJSep 19, 1965 · N4380E · Substantial damage NTSB NYC66D0310Accident · No injuriesClosedCessna 150 · So Plainfield, NJSep 17, 1965 · N3936U · Substantial damage NTSB NYC66F0240Accident · No injuriesClosedBeechcraft S-35 · Teterboro, NJSep 9, 1965 · N225SR · Substantial damage NTSB NYC66D0209Accident · No injuriesClosedPiper PA-22 · Andover, NJSep 1, 1965 · N3450A · Substantial damage NTSB NYC66F0192Accident · No injuriesClosedBeechcraft 35 · Somerville, NJAug 28, 1965 · N2783V · Destroyed NTSB NYC66A0025Accident · 3 fatalClosedBeechcraft 95-55 · Salem, NJAug 21, 1965 · N5872S · Destroyed NTSB NYC66F0203Accident · No injuriesClosedPiper PA-22 · Vincentown, NJAug 12, 1965 · N1417A · Substantial damage NTSB NYC66F0186Accident · No injuriesClosedPiper PA-24 · Medford, NJAug 8, 1965 · N8107P · Substantial damage NTSB NYC66F0152Accident · No injuriesClosedBeechcraft E-18S · Red Bank, NJAug 5, 1965 · N1814 · Substantial damage NTSB NYC66D0138Accident · No injuriesClosedSchweizer SGU-2 · Flatbrookville, NJAug 5, 1965 · N8609R · Substantial damage NTSB NYC66F0156Accident · No injuriesClosedCessna 170B · Middletown, NJJul 28, 1965 · N6073V · Substantial damage NTSB NYC66D0131Accident · No injuriesClosedPiper PA-28 · Mt Holly, NJJul 28, 1965 · N6608P · Substantial damage NTSB NYC66F0086Accident · No injuriesClosedCessna 172 · Basking Ridge, NJJul 27, 1965 · N2654U · Substantial damage NTSB NYC66D0171Accident · No injuriesClosedCessna 182 · Frenchtown, NJJul 26, 1965 · N3422U · Substantial damage NTSB NYC66D0077Accident · No injuriesClosedCessna 150 · Sussex, NJJul 26, 1965 · N4233U · Substantial damage NTSB NYC66F0105Accident · No injuriesClosedPiper PA-24 · Pluckemin, NJJul 25, 1965 · N8610P · Substantial damage NTSB NYC66D0134Accident · No injuriesClosedCessna 172 · Atlantic City, NJJul 25, 1965 · N6456E · Substantial damage NTSB NYC66F0113Accident · No injuriesClosedPiper J-3 · New Market, NJJul 20, 1965 · N42346 · Substantial damage NTSB NYC66A0011Accident · 2 fatalClosedAeronca 7AC · Ford, NJJul 20, 1965 · N83211 · Destroyed NTSB NYC66D0107Accident · No injuriesClosedGlobe GC-1B · Mt Holly, NJJul 18, 1965 · N78111 · Substantial damage NTSB NYC66A0008Accident · 1 fatalClosedPiper PA-23 · Jersey City, NJJul 15, 1965 · N4536P · Destroyed NTSB NYC66D0067Accident · No injuriesClosedPiper PA-11 · Pennington, NJJul 13, 1965 · N4728M · Substantial damage NTSB NYC66F0046Accident · No injuriesClosedCessna 150 · Whitehouse, NJJul 6, 1965 · N5708E · Substantial damage NTSB NYC66D0196Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJJul 6, 1965 · N6275W · Substantial damage NTSB NYC66D0039Accident · No injuriesClosedCessna 182 · Flemington, NJJul 2, 1965 · N2732G · Substantial damage NTSB NYC66D0061Accident · No injuriesClosedPiper PA-28 · Moorestown, NJJun 27, 1965 · N8325W · Substantial damage NTSB NYC66F0045Accident · No injuriesClosedPiper PA-23 · Newark, NJJun 23, 1965 · N1304P · Substantial damage NTSB NYC65A0153Accident · 2 fatalClosedPiper PA-18 · Fairfield, NJJun 21, 1965 · N3697P · Destroyed NTSB NYC66F0035Accident · No injuriesClosedBeechcraft 65-A80 · Teterboro, NJJun 12, 1965 · N312PE · Substantial damage NTSB NYC65D0244Accident · No injuriesClosedPiper PA-28 · Walpack, NJJun 11, 1965 · N8691W · Substantial damage NTSB NYC65D0246Accident · No injuriesClosedPiper PA-20 · Vineland, NJJun 8, 1965 · N7018K · Substantial damage NTSB NYC65F0207Accident · No injuriesClosedCessna 150E · Teterboro, NJJun 5, 1965 · N3576J · Substantial damage NTSB NYC66F0050Accident · Serious injuriesClosedNavion A · Bridgeport, NJMay 31, 1965 · N4611K · Substantial damage NTSB NYC66D0062Accident · No injuriesClosedPiper PA-12 · Neptune, NJMay 30, 1965 · N3413M · Substantial damage NTSB NYC65D0247Accident · No injuriesClosedPiper PA-18A · Pitman, NJMay 30, 1965 · N9362D · Substantial damage NTSB NYC65D0221Accident · No injuriesClosedChampion 7FC · Lumberton, NJMay 25, 1965 · N7546E · Substantial damage NTSB NYC66F0072Accident · No injuriesClosedPiper PA-24 · Totoway Ny, NJMay 23, 1965 · N5315P · Substantial damage NTSB NYC65F0201Accident · No injuriesClosedPiper PA-22 · Manville, NJMay 23, 1965 · N4753Z · Substantial damage NTSB NYC65D0217Accident · No injuriesClosedPiper PA-28 · Sussex, NJMay 20, 1965 · N7814W · Substantial damage NTSB NYC65D0224Accident · Minor injuriesClosedPiper PA-28 · Ocean City, NJMay 16, 1965 · N6449W · Substantial damage NTSB NYC65A0139Accident · 1 fatalClosedPiper PA-22 · Lodi-Garfield, NJMay 14, 1965 · N5342Z · 2 aircraft · Destroyed