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 NYC67F0256Accident · No injuriesClosedCessna 310I · Neptune, NJAug 19, 1966 · N8016M · Substantial damage NTSB NYC67D0250Accident · No injuriesClosedNavion L-17B · Allentown, NJAug 19, 1966 · N213NY · Substantial damage NTSB NYC67A0033Accident · No injuriesClosedBell 47G3B1 · Great Meadows, NJAug 19, 1966 · N8508F · Substantial damage NTSB NYC67F0239Accident · No injuriesClosedCessna 172 · Neptune, NJAug 18, 1966 · N5414T · Substantial damage NTSB NYC67F0228Accident · No injuriesClosedLuscombe 8A · Neptune, NJAug 17, 1966 · N77840 · Substantial damage NTSB NYC67D0212Accident · No injuriesClosedPiper PA-24 · Millville, NJAug 15, 1966 · N6733P · Substantial damage NTSB NYC67F0168Accident · No injuriesClosedWhitman T-WIND · Sussex, NJAug 14, 1966 · N370Y · Destroyed NTSB NYC67F0220Accident · No injuriesClosedNavion A · Carlstadt, NJAug 6, 1966 · N5205K · Substantial damage NTSB NYC67A0022Accident · Minor injuriesClosedHughes 269A · Robbinsville, NJAug 4, 1966 · N8906F · Destroyed NTSB NYC67A0020Accident · 4 fatalClosedPiper PA-23 · Atlantic City, NJJul 31, 1966 · N4941P · Destroyed NTSB NYC67F0234Accident · No injuriesClosedMooney M20C · Somerset, NJJul 30, 1966 · N6714U · Substantial damage NTSB NYC67A0021Accident · No injuriesClosedPiper PA-23 · Red Bank, NJJul 30, 1966 · N4073P · Substantial damage NTSB NYC67A0019Accident · Serious injuriesClosedCurtiss-Wrt C-46F · Port Elizabeth, NJJul 28, 1966 · N9905F · Destroyed NTSB NYC67F0156Accident · No injuriesClosedCessna 210 · Morristown, NJJul 27, 1966 · N7302E · Substantial damage NTSB NYC67D0138Accident · No injuriesClosedLuscombe 8A · Seaville, NJJul 27, 1966 · N1018K · Destroyed NTSB NYC67F0117Accident · No injuriesClosedBeech S35 · Atlantic City, NJJul 25, 1966 · N8888M · Substantial damage NTSB NYC67D0116Accident · No injuriesClosedPiper PA-22 · Bridgeport, NJJul 24, 1966 · N3228Z · Substantial damage NTSB NYC67F0126Accident · No injuriesClosedBoeing D75 · Colts Neck, NJJul 23, 1966 · N59269 · Substantial damage NTSB NYC67D0090Accident · No injuriesClosedPiper PA-18 · Bevans, NJJul 23, 1966 · N1343A · Substantial damage NTSB NYC67D0140Accident · No injuriesClosedGlobe GC-1B · Colts Neck, NJJul 20, 1966 · N80862 · Substantial damage NTSB NYC67F0143Accident · No injuriesClosedBeech A23A · Hanover, NJJul 15, 1966 · N2332W · Substantial damage NTSB NYC67D0080Accident · No injuriesClosedPiper J-3 · Erma, NJJul 11, 1966 · N46286 · Substantial damage NTSB NYC67D0144Accident · No injuriesClosedHelio 391B · Morristown, NJJul 10, 1966 · N4141D · Substantial damage NTSB NYC67A0010Accident · 2 fatalClosedAero Comdr 560-E · Parsippany, NJJul 10, 1966 · N3804C · Destroyed NTSB NYC67A0009Accident · 2 fatalClosedWaco 10 · Caldwel, NJJul 9, 1966 · N904H · Destroyed NTSB NYC67F0175Accident · No injuriesClosedBeech 35 · Colts Neck, NJJul 6, 1966 · N3909N · Substantial damage NTSB NYC67D0089Accident · No injuriesClosedBeech A35 · Red Bank, NJJul 6, 1966 · N610H · Substantial damage NTSB NYC67F0120Accident · No injuriesClosedCessna 150 · Atlantic City, NJJul 3, 1966 · N2583J · 2 aircraft · Substantial damage NTSB NYC67D0077Accident · No injuriesClosedCessna P206 · Cape May, NJJul 2, 1966 · N2506X · Substantial damage NTSB NYC67A0002Accident · 3 fatalClosedPiper PA-23 · Neptune, NJJul 1, 1966 · N2014P · Destroyed NTSB NYC67F0061Accident · Serious injuriesClosedPiper PA-23 · Hasbrouck Hght, NJJun 28, 1966 · N5350Y · Destroyed NTSB NYC67D0025Accident · No injuriesClosedBeech E18S · Linden, NJJun 23, 1966 · N299Z · Substantial damage NTSB NYC67D0099Accident · No injuriesClosedLuscombe 8F · Lincoln Park, NJJun 22, 1966 · N811B · Substantial damage NTSB NYC67F0085Accident · No injuriesClosedGlobe GC-1B · Fairfield, NJJun 20, 1966 · N90359 · Substantial damage NTSB NYC66A0153Accident · Minor injuriesClosedBell 47G-2A · Cranbury, NJJun 19, 1966 · N8458E · Substantial damage NTSB NYC67F0059Accident · No injuriesClosedBellanca 14-13 · Jobstown, NJJun 18, 1966 · N86785 · Substantial damage NTSB NYC67D0057Accident · No injuriesClosedPiper PA-22 · Hanover, NJJun 17, 1966 · N1918P · Substantial damage NTSB NYC67D0093Accident · No injuriesClosedPiper PA-32 · Bridgeport, NJJun 5, 1966 · N3572W · Substantial damage NTSB NYC66A0138Accident · 1 fatalClosedCessna 150F · Fairfield, NJMay 31, 1966 · N8782S · Destroyed NTSB NYC67F0051Accident · Serious injuriesClosedPiper J3C-65 · Pennington, NJMay 29, 1966 · N38541 · Substantial damage NTSB NYC66F0670Accident · No injuriesClosedPiper PA-12 · Princeton, NJMay 26, 1966 · N3081M · Substantial damage NTSB NYC66F0663Accident · No injuriesClosedPiper PA-28 · Bedminster, NJMay 23, 1966 · N6601W · Substantial damage NTSB NYC66F0657Accident · No injuriesClosedGlobe GC-1B · Princeton, NJMay 22, 1966 · N528H · Substantial damage NTSB NYC66A0133Accident · 2 fatalClosedBeech 95 · Nixon, NJMay 22, 1966 · N666T · Destroyed NTSB NYC66F0694Accident · No injuriesClosedBeech A23 · Colts Neck, NJMay 21, 1966 · N3534R · Substantial damage NTSB NYC66D0682Accident · Minor injuriesClosedPiper PA-22 · Salem, NJMay 7, 1966 · N7716D · Substantial damage NTSB NYC66D0687Accident · Minor injuriesClosedPiper PA22 · Columbus, NJApr 30, 1966 · N4302A · Substantial damage NTSB NYC66D0612Accident · No injuriesClosedHelio 391B · Washington, NJApr 28, 1966 · N4141D · Substantial damage NTSB NYC66F0635Accident · No injuriesClosedMaule M-4 · Sussex, NJApr 25, 1966 · N9827M · Substantial damage NTSB NYC66F0664Accident · No injuriesClosedPiper PA-30 · Teterboro, NJApr 22, 1966 · N7689Y · Substantial damage