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 NYC68D0205Accident · No injuriesClosedCessna 150 · Moorestown, NJSep 12, 1967 · N7898E · Destroyed NTSB NYC68F0140Accident · Minor injuriesClosedAeronca 7BCM · Princeton, NJSep 9, 1967 · N94577 · Substantial damage NTSB NYC68F0171Accident · No injuriesClosedCessna 310 · Teterboro, NJSep 4, 1967 · N215A · Substantial damage NTSB NYC68D0114Accident · No injuriesClosedCessna 172 · Andover, NJAug 28, 1967 · N3251L · Substantial damage NTSB NYC68F0151Accident · No injuriesClosedMooney M20C · Neptune, NJAug 27, 1967 · N1399W · Substantial damage NTSB NYC68F0141Accident · No injuriesClosedPiper PA-22 · Red Bank, NJAug 27, 1967 · N2608P · Substantial damage NTSB NYC68D0128Accident · No injuriesClosedPiper PA-28 · Columbia, NJAug 27, 1967 · N9277J · Substantial damage NTSB NYC68F0138Accident · No injuriesClosedPiper PA-22 · Vincentown, NJAug 21, 1967 · N2952P · Substantial damage NTSB NYC68F0144Accident · No injuriesClosedAeronca 65-C · Vincentown, NJAug 20, 1967 · N23927 · Substantial damage NTSB NYC68I0028Incident · No injuriesClosedLockheed L-1049 · Newark, NJAug 18, 1967 · N6206G · Minor damage NTSB NYC68F0100Accident · No injuriesClosedPiper PA-28 · Red Bank, NJAug 7, 1967 · N5175W · Substantial damage NTSB NYC68F0112Accident · Minor injuriesClosedTemco D-16A · Wayne, NJAug 6, 1967 · N122N · Substantial damage NTSB NYC68F0092Accident · No injuriesClosedBoeing A75 · Bridgeton, NJAug 5, 1967 · N49645 · Substantial damage NTSB NYC68F0104Accident · 2 fatalClosedPiper PA-30 · Masonville, NJJul 30, 1967 · N7932Y · Destroyed NTSB NYC68F0094Accident · Serious injuriesClosedPiper PA-23 · Middletown, NJJul 28, 1967 · N5380 · Destroyed NTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJJul 26, 1967 · N2779S · Substantial damage NTSB NYC68D0111Accident · No injuriesClosedPiper PA-12 · Woodbine, NJJul 26, 1967 · N2907M · Substantial damage NTSB NYC68D0099Accident · No injuriesClosedPiper PA-28 · Clinton, NJJul 25, 1967 · N6808 · Substantial damage NTSB NYC68D0088Accident · No injuriesClosedCessna 182 · Wayne, NJJul 22, 1967 · N2758F · Substantial damage NTSB NYC68A0013Accident · 1 fatalClosedBeech H-35 · Belleville, NJJul 21, 1967 · N5442D · Destroyed NTSB DIA68F0028Accident · No injuriesClosedPiper PA-28 · Charlotte, NJJul 17, 1967 · N6661W · Substantial damage NTSB NYC68A0005Accident · No injuriesClosedBrantly B-2 · Medford, NJJul 10, 1967 · N5976X · Substantial damage NTSB NYC68D0071Accident · Minor injuriesClosedPiper PA-18 · Bricktown, NJJul 9, 1967 · N8559C · Substantial damage NTSB NYC68D0059Accident · No injuriesClosedBeech A23 · Caldwell, NJJul 7, 1967 · N4782J · Substantial damage NTSB NYC68F0035Accident · Serious injuriesClosedPiper PA-23 · W.Milford, NJJun 30, 1967 · N6354Y · Destroyed NTSB NYC68F0044Accident · No injuriesClosedCessna 182E · Teterboro, NJJun 29, 1967 · N3147Y · Substantial damage NTSB NYC67A0190Accident · 2 fatalClosedErcoupe 415C · Berlin, NJJun 28, 1967 · N99035 · Destroyed NTSB NYC68F0037Accident · Minor injuriesClosedMooney M20E · Millville, NJJun 26, 1967 · N79374 · Substantial damage NTSB NYC68F0032Accident · No injuriesClosedCessna 150 · Pittstown, NJJun 26, 1967 · N6608T · Substantial damage NTSB NYC67A0186Accident · No injuriesClosedConvair CV-880 · Newark, NJJun 24, 1967 · N8815E · Substantial damage NTSB NYC68F0020Accident · No injuriesClosedCessna 172F · East Hanover, NJJun 11, 1967 · N8808U · Substantial damage NTSB NYC68D0009Accident · No injuriesClosedPiper PA-22S · Hackensack, NJJun 8, 1967 · N9174D · Substantial damage NTSB NYC68F0021Accident · Minor injuriesClosedBeech E18S · Millville, NJJun 7, 1967 · N157SC · Destroyed NTSB NYC68F0010Accident · No injuriesClosedCessna 320E · Teterboro, NJJun 5, 1967 · N3463Q · Substantial damage NTSB NYC68F0022Accident · Serious injuriesClosedChampion 7ECA · Bridgeton, NJJun 4, 1967 · N11030 · Destroyed NTSB NYC67D0674Accident · No injuriesClosedPiper J-3 · Readington, NJJun 4, 1967 · N98570 · Substantial damage NTSB NYC67A0172Accident · 1 fatalClosedGrumman TBM-3E · Tuckerton, NJJun 2, 1967 · N9595C · Destroyed NTSB NYC68D0019Accident · No injuriesClosedBeech H35 · Clark, NJMay 30, 1967 · N161SG · Substantial damage NTSB NYC68D0007Accident · No injuriesClosedErco 415-D · Colts Neck, NJMay 28, 1967 · N2118H · Substantial damage NTSB NYC67D0694Accident · No injuriesClosedGlobe GC-1B · Moorestown, NJMay 28, 1967 · N78111 · Substantial damage NTSB NYC67A0169Accident · 1 fatalClosedNavion A · Manville, NJMay 28, 1967 · N322EG · Destroyed NTSB NYC67D0661Accident · No injuriesClosedCessna 150 · Colts Neck, NJMay 21, 1967 · N6215T · Substantial damage NTSB NYC68D0006Accident · Minor injuriesClosedCessna 170B · Berlin, NJMay 20, 1967 · N2984D · Substantial damage NTSB NYC67F0700Accident · Serious injuriesClosedPiper PA-28 · Ocean City, NJMay 20, 1967 · N9572W · Substantial damage NTSB NYC67F0662Accident · No injuriesClosedMooney M20C · So.Hackensack, NJMay 5, 1967 · N6814U · Substantial damage NTSB NYC67D0660Accident · No injuriesClosedBoeing A75N1 · Mays Landing, NJMay 4, 1967 · N2535R · Substantial damage NTSB NYC67D0699Accident · No injuriesClosedCessna 150 · Sewell, NJApr 29, 1967 · N3976J · Substantial damage NTSB NYC67I0150Incident · No injuriesClosedVertol 107-II · Newark, NJApr 28, 1967 · N6674D · Minor damage NTSB NYC67D0638Accident · No injuriesClosedCessna 182 · Millville, NJApr 23, 1967 · N9244X · Substantial damage NTSB NYC67D0613Accident · No injuriesClosedPiper PA-28 · Sussex, NJApr 23, 1967 · N6099W · Substantial damage