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 NYC70D0118Accident · No injuriesClosedAmerican AA-1 · Vincentown, NJAug 10, 1969 · N5656L · Substantial damage NTSB NYC70A0022Accident · No injuriesClosedPiper PA-28R · Ocean City, NJAug 7, 1969 · N3853T · Substantial damage NTSB NYC70D0113Accident · No injuriesClosedTaylorcraft L-2 · Tuckahoe, NJAug 6, 1969 · N46112 · Substantial damage NTSB NYC70D0104Accident · No injuriesClosedPiper PA-28 · Vincentown, NJJul 31, 1969 · N5747F · Substantial damage NTSB NYC70D0075Accident · No injuriesClosedCessna 310 · Atco, NJJul 31, 1969 · N3654D · Substantial damage NTSB NYC70F0117Accident · No injuriesClosedCessna 310D · Atlantic City, NJJul 30, 1969 · N6740T · Substantial damage NTSB DCA70A0002Accident · 5 fatalClosedBoeing 707 · Pomona, NJJul 26, 1969 · N787TW · Destroyed NTSB NYC70D0100Accident · No injuriesClosedCessna 150 · Pennington, NJJul 25, 1969 · N60952 · Substantial damage NTSB NYC70D0034Accident · No injuriesClosedCessna 182 · Manville, NJJul 13, 1969 · N91636 · Substantial damage NTSB NYC70A0007Accident · 2 fatalClosedPiper PA-22 · Bridgeport, NJJul 8, 1969 · N4847Z · Destroyed NTSB NYC70F0043Accident · Minor injuriesClosedPiper PA-28 · Pittstown, NJJul 7, 1969 · N6462J · Substantial damage NTSB NYC70F0035Accident · Minor injuriesClosedLuscombe 8A · Washington, NJJul 5, 1969 · N2687K · Destroyed NTSB NYC70D0024Accident · No injuriesClosedPiper PA-22 · Pluckemin, NJJul 4, 1969 · N56122 · Substantial damage NTSB NYC70A0005Accident · 2 fatalClosedPiper PA-18 · Sewell, NJJul 4, 1969 · N9362D · Destroyed NTSB NYC70A0001Accident · 1 fatalClosedTaylorcraft BF12 · Phillipsburg, NJJul 1, 1969 · N36427 · Destroyed NTSB NYC69A0114Accident · 2 fatalClosedPiper PA-30 · Rancocas, NJJun 30, 1969 · N8609Y · Destroyed NTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJJun 29, 1969 · N2970J · Substantial damage NTSB NYC69A0113Accident · No injuriesClosedBeech D18S · Morristown, NJJun 27, 1969 · N208Z · Substantial damage NTSB NYC69A0112Accident · 2 fatalClosedCessna 310N · Blairstown, NJJun 18, 1969 · N4163Q · Destroyed NTSB NYC70D0029Accident · No injuriesClosedSchleicher K8B · Blairstown, NJJun 14, 1969 · N6660D · Substantial damage NTSB NYC69F0474Accident · No injuriesClosedBellanca 17-30 · Morristown, NJJun 11, 1969 · N4836V · Substantial damage NTSB NYC70F0023Accident · No injuriesClosedPiper PA-28R · Clifton, NJJun 4, 1969 · N9493N · Substantial damage NTSB NYC70F0057Accident · Serious injuriesClosedLuscombe 8A · Cross Keys, NJJun 1, 1969 · N1391K · Substantial damage NTSB NYC70D0005Accident · Minor injuriesClosedStinson 108-2 · Red Bank, NJMay 30, 1969 · N9344K · Substantial damage NTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJMay 30, 1969 · N4792P · Substantial damage NTSB NYC70D0018Accident · No injuriesClosedGrumman G-164A · Chatsworth, NJMay 29, 1969 · N909X · Substantial damage NTSB NYC70F0086Accident · Minor injuriesClosedAeronca 7AC · Moorestown, NJMay 17, 1969 · N81744 · Destroyed NTSB NYC69F0446Accident · No injuriesClosedPiper PA-18A · Mays Landing, NJMay 17, 1969 · N3690A · Substantial damage NTSB NYC69F0466Accident · No injuriesClosedBeech 23 · Colts Neck, NJMay 16, 1969 · N3557R · Substantial damage NTSB NYC69D0458Accident · No injuriesClosedCessna 195 · Pennington, NJMay 16, 1969 · N177US · Substantial damage NTSB NYC69D0457Accident · No injuriesClosedCessna 172 · Lakewood, NJMay 10, 1969 · N78445 · Substantial damage NTSB NYC69A0103Accident · 2 fatalClosedCurtiss-Wrt C-46 · Medford, NJMay 7, 1969 · N1243N · Destroyed NTSB NYC69A0102Accident · 1 fatalClosedAeronca 7AC · Landing, NJMay 5, 1969 · N3033E · Destroyed NTSB NYC69F0460Incident · No injuriesClosedAero Comdr 560E · Morristown, NJMay 4, 1969 · N6895S · Minor damage NTSB NYC69D0431Accident · No injuriesClosedMitsubishi MU-2B · Bridgeport, NJApr 27, 1969 · N3561X · Substantial damage NTSB NYC69F0427Accident · Serious injuriesClosedCessna 172I · West Milford, NJApr 26, 1969 · N35800 · Substantial damage NTSB NYC69F0418Accident · No injuriesClosedChampion 7ECA · Pennington, NJApr 12, 1969 · N1895G · Substantial damage NTSB NYC69D0374Accident · No injuriesClosedCessna 150 · Flemington, NJMar 23, 1969 · N4288U · Substantial damage NTSB NYC69D0419Accident · No injuriesClosedCessna 177A · Bay Head, NJMar 22, 1969 · N30304 · Substantial damage NTSB NYC69D0370Accident · No injuriesClosedCessna 150 · Whitehouse, NJMar 17, 1969 · N22439 · Substantial damage NTSB NYC69D0463Accident · No injuriesClosedPiper PA-28 · Medford, NJMar 16, 1969 · N7386W · Substantial damage NTSB NYC69A0088Accident · 3 fatalClosedBeech 35 · Medford, NJMar 16, 1969 · N3104V · Destroyed NTSB NYC69D0387Accident · No injuriesClosedCessna 140 · Medford, NJMar 8, 1969 · N2507N · Substantial damage NTSB NYC69D0326Accident · No injuriesClosedStinson 108-3 · Basking Ridge, NJFeb 25, 1969 · N713C · Substantial damage NTSB NYC69D0362Accident · No injuriesClosedBeech D35 · Lakewood, NJFeb 17, 1969 · N135Y · Substantial damage NTSB NYC69D0351Accident · No injuriesClosedCessna 120 · Medford, NJFeb 16, 1969 · N77363 · Substantial damage NTSB NYC69I0081Incident · No injuriesClosedDehavilland DHC-6 · Red Bank, NJFeb 12, 1969 · N376MA · No damage NTSB NYC69A0078Accident · 1 fatalClosedPiper PA-23 · Middletown, NJFeb 5, 1969 · N5230Y · Destroyed NTSB NYC69F0319Accident · No injuriesClosedPiper PA-30 · Sussex, NJFeb 4, 1969 · N7617Y · Substantial damage NTSB NYC69D0335Accident · No injuriesClosedCessna 150 · Atlantic City, NJFeb 4, 1969 · N22410 · Substantial damage