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 NYC66D0647Accident · No injuriesClosedBeechcraft B50 · Newark, NJApr 21, 1966 · N550MS · Substantial damage NTSB NYC66F0639Accident · No injuriesClosedCessna 150 · Morristown, NJApr 17, 1966 · N6291T · Substantial damage NTSB NYC66F0619Accident · No injuriesClosedCessna 210 · Flemington, NJApr 16, 1966 · N6688X · Substantial damage NTSB NYC66D0717Accident · No injuriesClosedPiper PA-28 · Rancocas, NJApr 16, 1966 · N6969W · Substantial damage NTSB NYC66F0658Accident · No injuriesClosedBeech E50 · Newark, NJApr 11, 1966 · N517S · Substantial damage NTSB NYC66I0107Incident · No injuriesClosedDouglas DC-8 · Nburlington, NJApr 1, 1966 · N8033U · Minor damage NTSB NYC66D0590Accident · No injuriesClosedCessna 182 · Medford, NJMar 31, 1966 · N5648B · Substantial damage NTSB NYC66D0599Accident · No injuriesClosedPiper PA-22 · Salem, NJMar 23, 1966 · N3537Z · Substantial damage NTSB NYC66D0541Accident · No injuriesClosedCessna 150 · Whitesville, NJMar 16, 1966 · N5990E · Substantial damage NTSB NYC66D0575Accident · No injuriesClosedPiper PA-28 · Atlantic City, NJMar 15, 1966 · N5033W · Substantial damage NTSB NYC66D0570Accident · No injuriesClosedPiper PA-28 · So Hackensack, NJMar 10, 1966 · N7270W · Substantial damage NTSB NYC66F0532Accident · No injuriesClosedCessna 320D · Morristown, NJMar 2, 1966 · N4118T · Substantial damage NTSB NYC66D0574Accident · No injuriesClosedCessna 182 · Toms River, NJMar 2, 1966 · N2384G · Substantial damage NTSB NYC66D0572Accident · No injuriesClosedCessna 150 · Totowa, NJFeb 27, 1966 · N8160S · Substantial damage NTSB NYC66F0504Accident · No injuriesClosedCessna 310D · Bridgeport, NJFeb 12, 1966 · N6876T · Substantial damage NTSB NYC66F0484Accident · No injuriesClosedPiper PA-23 · Somerville, NJFeb 11, 1966 · N4490P · Substantial damage NTSB NYC66D0535Accident · Minor injuriesClosedPiper J3 · Cherry Hill, NJFeb 7, 1966 · N6384H · Substantial damage NTSB NYC66D0511Accident · No injuriesClosedPiper PA-22 · Moorestown, NJFeb 7, 1966 · N3340Z · Substantial damage NTSB NYC66D0503Accident · No injuriesClosedCessna 150 · Teterboro, NJFeb 6, 1966 · N4233U · Substantial damage NTSB NYC66A0082Accident · No injuriesClosedConvair CV-440 · Atlantic City, NJFeb 2, 1966 · N103 · Substantial damage NTSB NYC66D0476Accident · No injuriesClosedCessna 150 · Pittstown, NJJan 29, 1966 · N7819Z · Substantial damage NTSB NYC66D0447Accident · No injuriesClosedCessna 150B · Pittstown, NJJan 29, 1966 · N1153Y · Substantial damage NTSB NYC66D0475Accident · No injuriesClosedPiper PA-28 · Morristown, NJJan 26, 1966 · N6235W · Substantial damage NTSB NYC66F0446Accident · No injuriesClosedCessna 150 · Bernardsville, NJJan 22, 1966 · N6223R · Substantial damage NTSB NYC66A0077Accident · 1 fatalClosedPiper PA-24 · Rockaway, NJJan 22, 1966 · N6844P · Destroyed NTSB NYC66F0456Accident · No injuriesClosedCessna 310J · Morristown, NJJan 12, 1966 · N3044L · Substantial damage NTSB NYC66D0450Accident · No injuriesClosedPiper PA-24 · Ocean City, NJJan 4, 1966 · N8865P · Substantial damage NTSB NYC66F0412Accident · Serious injuriesClosedCessna 150 · Medford, NJDec 29, 1965 · N6157T · Substantial damage NTSB NYC66F0421Accident · Minor injuriesClosedPiper PA-22 · Neptune, NJDec 28, 1965 · N3364Z · Substantial damage NTSB NYC66F0413Accident · Minor injuriesClosedAeronca 7AC · Fort Lee, NJDec 26, 1965 · N84838 · Substantial damage NTSB NYC66D0490Accident · No injuriesClosedPiper PA-12 · Morganville, NJDec 19, 1965 · N92713 · Substantial damage NTSB NYC66F0417Accident · No injuriesClosedCessna 320 · Teterboro, NJDec 18, 1965 · N145MP · Substantial damage NTSB NYC66D0397Accident · No injuriesClosedBeechcraft A-23 · Princeton, NJDec 10, 1965 · N3534R · Substantial damage NTSB MKC66F0313Accident · No injuriesClosedMooney M20E · Bloomfield, NJDec 8, 1965 · N1287X · Substantial damage NTSB NYC66F0380Accident · No injuriesClosedErcoupe 415-CD · So Plainfield, NJDec 7, 1965 · N2833H · Substantial damage NTSB NYC66D0379Accident · No injuriesClosedCessna 195B · Salem, NJDec 6, 1965 · N3028B · Substantial damage NTSB NYC66D0372Accident · No injuriesClosedBeechcraft A-23 · Robinsville, NJNov 28, 1965 · N3513R · Substantial damage NTSB NYC66D0480Accident · No injuriesClosedPiper PA-28 · Pitman, NJNov 25, 1965 · N5814W · Substantial damage NTSB NYC66D0374Accident · No injuriesClosedPiper PA-28 · Rancocas, NJNov 25, 1965 · N6288W · Substantial damage NTSB NYC66A0058Accident · Serious injuriesClosedSikorsky S-52-3 · Carlstadt, NJNov 20, 1965 · N74816 · Destroyed NTSB NYC66A0055Accident · 1 fatalClosedCessna 150 · Fairfield, NJNov 15, 1965 · N3576J · Destroyed NTSB NYC66F0382Accident · No injuriesClosedHelio 391B · Morristown, NJNov 14, 1965 · N4141D · Substantial damage NTSB NYC66F0354Accident · Serious injuriesClosedLuscombe 8A · Sparta, NJNov 14, 1965 · N71885 · Destroyed NTSB NYC66D0366Accident · Minor injuriesClosedPiper PA-22 · Salem, NJNov 10, 1965 · N8695C · Substantial damage NTSB NYC66F0381Accident · No injuriesClosedBeechcraft F35 · Fairchild, NJNov 9, 1965 · N4289B · Substantial damage NTSB NYC66F0351Accident · No injuriesClosedPiper PA-23 · Princeton, NJNov 6, 1965 · N4491P · Substantial damage NTSB NYC66F0361Accident · Serious injuriesClosedPiper PA-23 · Mt.Holly, NJNov 3, 1965 · N6136 · Destroyed NTSB NYC66F0317Accident · No injuriesClosedCessna 150 · Paramus, NJOct 31, 1965 · N6677T · Substantial damage NTSB NYC66D0367Accident · No injuriesClosedPiper PA-22 · Vineland, NJOct 19, 1965 · N9586D · Substantial damage NTSB NYC66F0302Accident · No injuriesClosedWaco UPF-7 · Manville, NJOct 17, 1965 · N29305 · Destroyed