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 NYC69D0318Accident · No injuriesClosedMooney M21F · Whitehouse, NJJan 31, 1969 · N9321M · Substantial damage NTSB NYC69D0329Accident · No injuriesClosedBeech G35 · Millville, NJJan 27, 1969 · N46190 · Substantial damage NTSB NYC69A0074Accident · No injuriesClosedCessna 402 · Morristown, NJJan 16, 1969 · N3269Q · Substantial damage NTSB NYC69D0400Accident · No injuriesClosedBeech A23 · Millville, NJJan 5, 1969 · N3547R · Substantial damage NTSB NYC69I0066Incident · No injuriesClosedDouglas DC-8 · Newark, NJDec 23, 1968 · N8779 · Minor damage NTSB NYC69F0278Accident · Serious injuriesClosedCessna 411 · Teterboro, NJDec 6, 1968 · N162A · Destroyed NTSB NYC69A0061Accident · 1 fatalClosedPiper PA-24 · New Foundland, NJDec 5, 1968 · N5668P · Destroyed NTSB NYC69D0260Accident · No injuriesClosedLuscombe 8F · Pluckimen, NJDec 1, 1968 · N805B · Substantial damage NTSB NYC69D0257Accident · No injuriesClosedCessna 150 · Aptistown, NJNov 11, 1968 · N8467J · Substantial damage NTSB NYC69A0051Accident · 2 fatalClosedSwift Globe GC-1B · Willingboro, NJNov 3, 1968 · N9030M · Destroyed NTSB NYC69D0266Accident · No injuriesClosedBeech 35-C33 · Burlington, NJNov 2, 1968 · N5861S · Substantial damage NTSB NYC69F0210Accident · Serious injuriesClosedCessna 150J · Morristown, NJOct 15, 1968 · N50589 · Substantial damage NTSB NYC69F0203Accident · No injuriesClosedCessna 177 · Newton, NJOct 13, 1968 · N3189T · Destroyed NTSB NYC69F0237Accident · No injuriesClosedPiper PA-23 · Neptune, NJOct 7, 1968 · N5426Y · Substantial damage NTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJOct 6, 1968 · N1870J · 2 aircraft · Substantial damage NTSB NYC69F0242Accident · 1 fatalClosedBensen B8M · Mickleton, NJSep 28, 1968 · N8713R · Destroyed NTSB NYC69F0226Accident · No injuriesClosedMidgt Mstng MM1 · Newfoundland, NJSep 28, 1968 · N731GF · Destroyed NTSB NYC69A0042Accident · 1 fatalClosedCessna 150 · Clementon, NJSep 28, 1968 · N7071S · Destroyed NTSB NYC69D0163Accident · No injuriesClosedCessna 210 · Basking Ridge, NJSep 18, 1968 · N9519X · Substantial damage NTSB NYC69F0180Accident · 1 fatalClosedBensen B8M · Bridgeton, NJSep 14, 1968 · N2190 · Destroyed NTSB NYC69A0027Accident · 2 fatalClosedPiper PA-28 · Manahawkin, NJSep 4, 1968 · N8000W · Destroyed NTSB NYC69D0139Accident · Minor injuriesClosedAeronca 7AC · Whitehouse, NJSep 1, 1968 · N84927 · Substantial damage NTSB NYC69F0186Accident · No injuriesClosedGlobe GC-1B · Medford, NJAug 31, 1968 · N599Z · Substantial damage NTSB NYC69D0162Accident · No injuriesClosedPiper PA-24 · Atlantic City, NJAug 31, 1968 · N9006P · Substantial damage NTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJAug 30, 1968 · N2199C · Substantial damage NTSB NYC69F0150Accident · No injuriesClosedCessna 182A · So.Vineland, NJAug 27, 1968 · N6340B · Destroyed NTSB NYC69D0214Accident · No injuriesClosedAeronca 7DC · Madison, NJAug 21, 1968 · N85713 · Minor damage NTSB NYC69D0166Accident · No injuriesClosedBeech A23 · Robbinsville, NJAug 21, 1968 · N8859M · Substantial damage NTSB NYC69F0127Accident · No injuriesClosedCessna 150 · Flemington, NJAug 15, 1968 · N84623 · Substantial damage NTSB NYC69D0068Accident · No injuriesClosedPiper PA-28 · Basking Ridge, NJAug 5, 1968 · N6842W · Substantial damage NTSB NYC69F0097Accident · No injuriesClosedAero Comdr 520 · Medford, NJJul 25, 1968 · N222E · Substantial damage NTSB NYC69D0111Accident · No injuriesClosedBeech 35-B33 · Moorestown, NJJul 20, 1968 · N795AA · Substantial damage NTSB NYC69F0088Accident · Serious injuriesClosedScheibe SF27M · Hopewell Tnshp, NJJul 17, 1968 · N6301 · Substantial damage NTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJJul 17, 1968 · N6486F · Substantial damage NTSB NYC69F0093Accident · No injuriesClosedPiper PA-25 · Great Meadows, NJJul 16, 1968 · N6444Z · Substantial damage NTSB NYC69F0084Accident · Serious injuriesClosedCessna 177 · Red Bank, NJJul 13, 1968 · N2259Y · Destroyed NTSB NYC69F0050Accident · Serious injuriesClosedCessna 150F · Ringwood, NJJul 12, 1968 · N7951F · Substantial damage NTSB NYC69F0034Accident · Minor injuriesClosedCessna 310H · Totowa, NJJun 29, 1968 · N1101Q · Destroyed NTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJJun 6, 1968 · N8367G · Substantial damage NTSB NYC68A0125Accident · 1 fatalClosedCessna 172 · Berlin, NJJun 2, 1968 · N7372T · Destroyed NTSB NYC68F0484Accident · Minor injuriesClosedCessna 182 · Medford, NJMay 31, 1968 · N8761U · Substantial damage NTSB NYC68D0501Accident · No injuriesClosedCessna 175 · Sussex, NJMay 25, 1968 · N7130M · Substantial damage NTSB NYC68I0119Incident · No injuriesClosedDouglas DC-9 · Newark, NJMay 18, 1968 · N1060 · Minor damage NTSB NYC68F0465Accident · No injuriesClosedCessna 150 · Millville, NJMay 15, 1968 · N1137Y · Destroyed NTSB NYC68D0491Accident · No injuriesClosedLuscombe 8A · Seaside, NJMay 14, 1968 · N23075 · Substantial damage NTSB NYC68F0474Accident · No injuriesClosedPiper PA-24 · Medford, NJMay 11, 1968 · N8865P · Substantial damage NTSB NYC68F0485Accident · No injuriesClosedBeech 95-B55 · Atlantic City, NJMay 10, 1968 · N7901M · Substantial damage NTSB NYC68F0495Accident · No injuriesClosedPiper J-4 · Berlin, NJMay 5, 1968 · N27858 · Substantial damage NTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJMay 5, 1968 · N8561J · Substantial damage NTSB NYC68F0481Accident · 1 fatalClosedErcoupe 415-C · Williamstown, NJApr 28, 1968 · N93331 · Destroyed