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 NYC67D0474Accident · No injuriesClosedCessna 150 · Morristown, NJDec 23, 1966 · N3516J · Substantial damage NTSB NYC67D0484Accident · No injuriesClosedPiper PA-28 · Hanover, NJDec 21, 1966 · N6883W · Substantial damage NTSB NYC67D0435Accident · No injuriesClosedCessna 120 · Jobstown, NJDec 21, 1966 · N4221N · Substantial damage NTSB NYC67D0406Accident · No injuriesClosedPiper PA-28 · Medford, NJDec 18, 1966 · N6427W · Substantial damage NTSB NYC67D0534Accident · No injuriesClosedStinson V-77 · Medford, NJDec 16, 1966 · N9362H · Substantial damage NTSB NYC67D0447Accident · No injuriesClosedCessna 150 · West Caldwell, NJDec 16, 1966 · N8224F · Substantial damage NTSB NYC67F0449Accident · No injuriesClosedBeech D18S · Williamstown, NJDec 11, 1966 · N158K · Substantial damage NTSB NYC67F0408Accident · No injuriesClosedPiper PA-28 · Red Bank, NJDec 4, 1966 · N7304W · Substantial damage NTSB NYC67F0389Accident · No injuriesClosedCessna 310L · Morristown, NJNov 29, 1966 · N2216F · Substantial damage NTSB NYC67I0084Incident · No injuriesClosedFairchild FH-227 · Newark, NJNov 23, 1966 · N7806M · No damage NTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNov 22, 1966 · N8990S · Substantial damage NTSB NYC67D0405Accident · No injuriesClosedPiper PA-30 · Bridgeport, NJNov 20, 1966 · N8126Y · Substantial damage NTSB NYC67D0383Accident · No injuriesClosedPiper PA28 · Bridgeton, NJNov 19, 1966 · N5779W · Substantial damage NTSB NYC67F0385Accident · No injuriesClosedNavion A · Denville, NJNov 13, 1966 · N999Q · Substantial damage NTSB NYC67F0382Accident · No injuriesClosedStinson 108-3 · Piscataway, NJNov 11, 1966 · N6847M · Substantial damage NTSB NYC67D0371Accident · No injuriesClosedChampion 7EC · Lakewood, NJNov 6, 1966 · N9857Y · Substantial damage NTSB NYC67A0071Accident · No injuriesClosedPiper PA-23 · Farmingdale, NJOct 30, 1966 · N5708Y · Substantial damage NTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJOct 29, 1966 · N4306Y · Substantial damage NTSB NYC67D0330Accident · No injuriesClosedBeech A23 · Linden, NJOct 23, 1966 · N1491L · Substantial damage NTSB NYC67F0308Accident · No injuriesClosedHelio H-391B · Manville, NJOct 20, 1966 · N6021 · Substantial damage NTSB NYC67F0337Accident · Minor injuriesClosedPiper PA-28 · So.Hackensack, NJOct 18, 1966 · N6769W · Destroyed NTSB NYC67F0316Accident · No injuriesClosedCessna 210E · So-Hackensack, NJOct 15, 1966 · N4988U · Substantial damage NTSB NYC67D0327Accident · No injuriesClosedLuscombe 8E · Middletown, NJOct 15, 1966 · N2419K · Substantial damage NTSB NYC67D0312Accident · No injuriesClosedCessna 150 · Franklin, NJOct 15, 1966 · N8122F · Substantial damage NTSB NYC67D0339Accident · No injuriesClosedStinson 108-1 · Linden, NJOct 13, 1966 · N40152 · Substantial damage NTSB NYC67D0338Accident · No injuriesClosedAeronca 7AC · Asbury Park, NJOct 13, 1966 · N83219 · Substantial damage NTSB NYC67D0322Accident · No injuriesClosedCessna 182 · Bridgeport, NJOct 9, 1966 · N5982B · Substantial damage NTSB NYC67F0297Accident · No injuriesClosedPiper PA-28 · Ocean City, NJOct 8, 1966 · N5339W · Substantial damage NTSB NYC67F0287Accident · No injuriesClosedCessna 310 · Morristown, NJOct 4, 1966 · N366J · Substantial damage NTSB NYC67F0289Accident · No injuriesClosedLuscombe 8B · West Milford, NJOct 2, 1966 · N45735 · Substantial damage NTSB NYC67D0290Accident · Minor injuriesClosedCessna 150 · Long Valley, NJSep 27, 1966 · N3853J · Destroyed NTSB NYC67F0275Accident · Minor injuriesClosedBoeing A75N1 · Pennington, NJSep 24, 1966 · N55518 · Destroyed NTSB NYC67F0251Accident · Minor injuriesClosedAeronca 7GCA · Warwick, NJSep 24, 1966 · N11088 · Substantial damage NTSB NYC67F0266Accident · No injuriesClosedBeech 95-55 · Newark, NJSep 23, 1966 · N1010X · Substantial damage NTSB NYC67D0279Accident · No injuriesClosedStinson 108-2 · So.Plainfield, NJSep 19, 1966 · N9774K · Substantial damage NTSB NYC67A0047Accident · No injuriesClosedLockheed 14N · Medford, NJSep 17, 1966 · N18138 · Substantial damage NTSB NYC67F0274Accident · Serious injuriesClosedStearman B75 · Seabrook, NJSep 16, 1966 · N9040H · Destroyed NTSB NYC67D0284Accident · No injuriesClosedCessna 310K · Teterboro, NJSep 13, 1966 · N735AD · Substantial damage NTSB NYC67F0364Accident · No injuriesClosedPiper PA-23 · Medford, NJSep 10, 1966 · N4923P · 2 aircraft · Substantial damage NTSB NYC67F0261Accident · No injuriesClosedBeech A23 · Medford, NJSep 10, 1966 · N1455L · Substantial damage NTSB NYC67D0198Accident · No injuriesClosedPiper PA-23 · Pittstown, NJSep 8, 1966 · N1343P · Substantial damage NTSB NYC67D0314Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJSep 6, 1966 · N6895W · Substantial damage NTSB NYC67D0257Accident · No injuriesClosedPiper PA-22 · Sandy Hook, NJSep 3, 1966 · N5683Z · Substantial damage NTSB NYC67F0267Accident · Minor injuriesClosedPiper PA-28 · S. Plainfield, NJAug 29, 1966 · N4549R · Substantial damage NTSB NYC67D0208Accident · No injuriesClosedPiper PA-24 · Millville, NJAug 27, 1966 · N5759P · Substantial damage NTSB NYC67D0209Accident · No injuriesClosedPiper PA-12 · Atlantic City, NJAug 24, 1966 · N7576H · Substantial damage NTSB NYC67F0205Accident · No injuriesClosedPiper PA-28 · Medford, NJAug 23, 1966 · N5774W · Substantial damage NTSB NYC67D0219Accident · No injuriesClosedAero Cmdr 1121 · Morristown, NJAug 23, 1966 · N252R · Substantial damage NTSB NYC67A0037Accident · No injuriesClosedSud Avia SE-210 · Newark, NJAug 22, 1966 · N1001U · Substantial damage NTSB NYC67F0223Accident · Minor injuriesClosedPiper PA-24 · Wayne, NJAug 20, 1966 · N5315P · Substantial damage