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 NYC71FHA38Accident · Minor injuriesClosedCessna 177 · Basking Ridge, NJMay 12, 1970 · N2984X · Destroyed NTSB NYC70FHD23Accident · Serious injuriesClosedNavion A · Medford, NJMay 6, 1970 · N4828K · Substantial damage NTSB NYC70FHD20Accident · No injuriesClosedPiper PA-28 · Medford, NJMay 2, 1970 · N9694J · Substantial damage NTSB NYC70DHD22Accident · No injuriesClosedCessna 150 · Wildwood, NJMay 1, 1970 · N7948E · Substantial damage NTSB NYC70DHD21Accident · No injuriesClosedCessna 150 · Medford, NJApr 30, 1970 · N60485 · Substantial damage NTSB NYC70DHD17Accident · No injuriesClosedMooney M20C · Berlin, NJApr 26, 1970 · N9721M · Substantial damage NTSB NYC70DHA09Accident · No injuriesClosedCessna 150 · Sussex, NJApr 25, 1970 · N61208 · Substantial damage NTSB NYC70AN115Accident · No injuriesClosedBell 47J-2 · Piscataway, NJApr 22, 1970 · N73949 · Substantial damage NTSB NYC70DHD16Accident · No injuriesClosedPiper PA-28 · Moorestown, NJApr 12, 1970 · N1849J · Substantial damage NTSB NYC70FHM13Accident · No injuriesClosedMaule M-4 · Linden, NJApr 8, 1970 · N9843M · Substantial damage NTSB NYC70FHM10Incident · No injuriesClosedBeech D-18S · Teterboro, NJApr 6, 1970 · N2500 · Minor damage NTSB NYC70DHD15Accident · Minor injuriesClosedPiper PA-28 · Newfield, NJApr 5, 1970 · N6667W · Substantial damage NTSB NYC70DHD19Accident · No injuriesClosedAeronca 7AC · Ocean City, NJMar 28, 1970 · N2937E · Substantial damage NTSB NYC70FHM11Accident · Minor injuriesClosedPiper PA-22 · Northvale, NJMar 19, 1970 · N8104C · Destroyed NTSB NYC70DHA08Accident · No injuriesClosedCessna 150 · Somerville, NJMar 19, 1970 · N50248 · 2 aircraft · Substantial damage NTSB NYC70AN102Accident · 4 fatalClosedCessna 402 · Elizabeth, NJMar 18, 1970 · N3218Q · Destroyed NTSB NYC70FHD11Accident · No injuriesClosedCessna 337 · Wrightstown, NJMar 7, 1970 · N85972 · Substantial damage NTSB NYC70FHD09Accident · 1 fatalClosedBensen B-8M · Bridgeton, NJMar 1, 1970 · N59324 · Destroyed NTSB NYC70FHM07Accident · No injuriesClosedCessna 150 · Woodbridge, NJFeb 20, 1970 · N5546G · Substantial damage NTSB NYC70IN082Incident · No injuriesClosedGrumman G-159 · Pomona, NJFeb 5, 1970 · N376 · No damage NTSB NYC70DHD05Accident · No injuriesClosedBeech N35 · Millville, NJFeb 5, 1970 · N1203Z · Substantial damage NTSB NYC70DHA05Accident · No injuriesClosedCessna 185 · Blairstown, NJJan 25, 1970 · N2639Z · Substantial damage NTSB NYC70FHM04Accident · Serious injuriesClosedPiper PA-28 · Westwood, NJJan 19, 1970 · N4371J · Substantial damage NTSB NYC70AN071Accident · No injuriesClosedDehavilland DH125 · Morristown, NJJan 13, 1970 · N162A · Substantial damage NTSB NYC70DHA03Accident · No injuriesClosedPiper PA-28 · Bedminster, NJJan 11, 1970 · N98254 · Substantial damage NTSB NYC70AN067Accident · No injuriesClosedMitsubishi MU-2B · Teterboro, NJJan 5, 1970 · N11WF · Substantial damage NTSB NYC70DHD02Accident · No injuriesClosedCessna 177 · Vineland, NJJan 4, 1970 · N3310T · Substantial damage NTSB NYC70AN066Accident · 2 fatalClosedPiper PA-24 · Cape May, NJJan 4, 1970 · N8485P · Destroyed NTSB NYC70F0245Accident · Minor injuriesClosedPiper PA-28 · East Hanover, NJDec 21, 1969 · N6707W · Destroyed NTSB NYC70D0229Accident · No injuriesClosedCessna 150 · Lakewood, NJDec 18, 1969 · N60412 · Substantial damage NTSB NYC70D0228Accident · No injuriesClosedCessna 120 · Hancocks Brdge, NJDec 11, 1969 · N72147 · Substantial damage NTSB NYC70F0223Accident · No injuriesClosedCessna 172 · Newton, NJDec 7, 1969 · N6156E · Substantial damage NTSB NYC70D0216Accident · No injuriesClosedLuscombe 8A · Moorestown, NJNov 29, 1969 · N2259K · Substantial damage NTSB NYC70A0055Accident · No injuriesClosedDouglas DC-8 · Newark, NJNov 28, 1969 · N8610 · Substantial damage NTSB NYC70A0054Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNov 25, 1969 · N1805J · 2 aircraft · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedBrantly B-2 · Millville, NJNov 23, 1969 · N4997C · Destroyed NTSB NYC70A0051Accident · No injuriesClosedCessna U206 · Pittstown, NJNov 16, 1969 · N2193F · Substantial damage NTSB NYC70F0194Accident · Minor injuriesClosedBellanca 17-30 · Princeton, NJNov 13, 1969 · N7349V · Destroyed NTSB NYC70D0208Accident · No injuriesClosedCessna 310L · Woodbine, NJNov 11, 1969 · N3288X · Substantial damage NTSB NYC70D0206Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNov 7, 1969 · N6864W · Substantial damage NTSB NYC70F0250Accident · Serious injuriesClosedSchemp SH-1 · Hanover, NJOct 26, 1969 · N103AH · 2 aircraft · Substantial damage NTSB NYC70F0189Accident · Minor injuriesClosedPiper PA-28 · Teterboro, NJOct 12, 1969 · N95127 · Destroyed NTSB NYC70F0167Accident · No injuriesClosedCessna 421 · Newark, NJSep 21, 1969 · N3147K · Substantial damage NTSB NYC70D0162Accident · Minor injuriesClosedTrager T-3 · Millville, NJSep 14, 1969 · N9098 · Substantial damage NTSB NYC70F0161Accident · 1 fatalClosedCessna 337C · Toms River, NJSep 12, 1969 · N2651S · Destroyed NTSB NYC70F0139Accident · No injuriesClosedCessna 310 · Lakewood, NJSep 6, 1969 · N3077D · Substantial damage NTSB NYC70D0149Accident · No injuriesClosedChampion 7AC · Salem, NJAug 30, 1969 · N82415 · Substantial damage NTSB NYC70F0091Accident · Minor injuriesClosedLuscombe 8E · Basking Ridge, NJAug 23, 1969 · N2646K · Substantial damage NTSB NYC70I0025Incident · No injuriesClosedDouglas DC-9 · Atlantic City, NJAug 19, 1969 · N8919E · No damage NTSB NYC70D0077Accident · No injuriesClosedAeronca 7FC · Basking Ridge, NJAug 11, 1969 · N9893B · Substantial damage