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 UNK64X2211Incident · No injuriesClosedConvair CV-880 · Newark, NJJun 10, 1964 · N8813E · Minor damage NTSB UNK64X2203Accident · No injuriesClosedBeechcraft 23 · Medford, NJJun 9, 1964 · N2374Z · Substantial damage NTSB UNK64X2188Accident · No injuriesClosedPiper PA28 · Medford, NJJun 8, 1964 · N6075W · Destroyed NTSB UNK64X2178Accident · Serious injuriesClosedBeechcraft M23 · Basking Ridge, NJJun 7, 1964 · N2395L · Destroyed NTSB UNK64X2157Accident · No injuriesClosedPiper PA24 · Red Bank, NJJun 6, 1964 · N5515P · Substantial damage NTSB UNK64X2127Accident · No injuriesClosedCessna 150 · Sussex, NJJun 5, 1964 · N5739E · Substantial damage NTSB UNK64X2018Accident · Serious injuriesClosedPiper J3C · Fairfield, NJMay 30, 1964 · N23265 · Destroyed NTSB UNK64X1933Accident · No injuriesClosedCessna 140 · W Milford, NJMay 24, 1964 · N1931N · Substantial damage NTSB UNK64X1915Accident · No injuriesClosedErcoupe 415C · Cream Ridge, NJMay 23, 1964 · N94180 · Substantial damage NTSB UNK64X1891Accident · No injuriesClosedPiper PA16 · Patterson, NJMay 23, 1964 · N5685H · Substantial damage NTSB UNK64X1821Accident · No injuriesClosedBellanca 1413 · Fairfield, NJMay 18, 1964 · N74403 · Substantial damage NTSB UNK64X1812Accident · No injuriesClosedBrantly B2 · Manville, NJMay 17, 1964 · N5968X · Substantial damage NTSB UNK64X1704Accident · No injuriesClosedBeechcraft C18S · Teterboro, NJMay 10, 1964 · N344G · Substantial damage NTSB UNK64X1671Accident · No injuriesClosedBell 47G2A · West Milford, NJMay 8, 1964 · N73207 · Substantial damage NTSB UNK64X1663Accident · No injuriesClosedPiper PA28 · Milford, NJMay 8, 1964 · N5379W · Substantial damage NTSB UNK64X1634Accident · No injuriesClosedErcoupe 415C · Manville, NJMay 6, 1964 · N8396C · Substantial damage NTSB UNK64X1564Accident · No injuriesClosedPiper J3 · Moorestown, NJMay 2, 1964 · N98814 · Destroyed NTSB UNK64X1415Accident · No injuriesClosedAero Comm 680 · Newark, NJApr 22, 1964 · N41441 · Substantial damage NTSB UNK64X1362Accident · No injuriesClosedPiper PA24 · Medford, NJApr 18, 1964 · N6844P · Substantial damage NTSB UNK64X1356Accident · No injuriesClosedBoeing PT17 · Mays Landing, NJApr 18, 1964 · N2535R · Substantial damage NTSB UNK64X1285Accident · No injuriesClosedPiper PA18 · Towaco, NJApr 12, 1964 · N3697P · Substantial damage NTSB UNK64X1196Accident · 2 fatalClosedBeechcraft 35 · West Milford, NJApr 5, 1964 · N2745V · Destroyed NTSB UNK64X1075Accident · No injuriesClosedCessna 336 · S Plainfield, NJMar 28, 1964 · N1789Z · Substantial damage NTSB UNK64X1029Accident · No injuriesClosedStinson 108-1 · Vineland, NJMar 24, 1964 · N9110K · Destroyed NTSB UNK64X0915Accident · No injuriesClosedPiper PA12 · Pittstown, NJMar 14, 1964 · N3988M · Substantial damage NTSB UNK64X0845Accident · No injuriesClosedBeechcraft 23 · Woodstown, NJMar 8, 1964 · N2339L · Substantial damage NTSB UNK64X0716Accident · No injuriesClosedBellanca 14193A · S Plainfield, NJFeb 27, 1964 · N8812R · Substantial damage NTSB UNK64X0674Accident · No injuriesClosedCessna 140 · Berlin, NJFeb 23, 1964 · N89810 · Substantial damage NTSB UNK64X0664Accident · No injuriesClosedPiper PA28 · Greenwood Lake, NJFeb 22, 1964 · N7124W · Substantial damage NTSB UNK64X0631Accident · No injuriesClosedAeronca 7DC · Monomouth Arpt, NJFeb 21, 1964 · N85454 · Substantial damage NTSB UNK64X0535Accident · No injuriesClosedPiper PA23 · Newark, NJFeb 11, 1964 · N4086P · Substantial damage NTSB UNK64X0534Accident · No injuriesClosedCamair 480 · Red Bank, NJFeb 11, 1964 · N221 · Substantial damage NTSB UNK64X0495Accident · No injuriesClosedPiper PA22 · Teterboro, NJFeb 8, 1964 · N5660Z · Substantial damage NTSB UNK64X0445Accident · No injuriesClosedPiper PA28 · Haddonfield, NJFeb 2, 1964 · N5732W · Substantial damage NTSB UNK64X0405Accident · No injuriesClosedBeechcraft 23 · Morristown, NJJan 30, 1964 · N2318L · Substantial damage NTSB UNK64X0387Accident · No injuriesClosedPiper PA28 · Lumberton, NJJan 28, 1964 · N5707W · Substantial damage NTSB UNK64X0329Accident · No injuriesClosedLuscombe 8A · East Hanover, NJJan 23, 1964 · N2719K · Destroyed NTSB UNK64X0317Accident · No injuriesClosedPiper PA12 · Andover, NJJan 22, 1964 · N4164M · Substantial damage NTSB UNK64X0291Accident · No injuriesClosedPiper PA22 · Medford, NJJan 19, 1964 · N9522D · Substantial damage NTSB UNK64X0289Accident · No injuriesClosedCessna 140 · Pittstown, NJJan 19, 1964 · N72195 · Substantial damage NTSB UNK64X0277Accident · No injuriesClosedPiper PA22 · Moorestown, NJJan 18, 1964 · N5445Z · Substantial damage NTSB UNK64X0276Accident · No injuriesClosedCessna 150 · Berlin, NJJan 18, 1964 · N2011Z · Substantial damage NTSB UNK64X0274Accident · No injuriesClosedCessna 170A · Sussex, NJJan 18, 1964 · N5773C · Substantial damage NTSB UNK64X0234Accident · No injuriesClosedBeechcraft 35 · S Plainfield, NJJan 12, 1964 · N290AA · Substantial damage NTSB UNK64X0231Accident · No injuriesClosedNavion A · Lumberton, NJJan 12, 1964 · N4288K · Substantial damage NTSB UNK64X0126Accident · No injuriesClosedNo American SNJ5 · Basking Ridge, NJJan 3, 1964 · N9804C · Substantial damage NTSB NYC64A0024Accident · Serious injuriesClosedBoeing 707 · Mcguire Afbase, NJAug 13, 1963 · N719PA · No damage NTSB DCA63A0007Accident · No injuriesClosedDouglas DC-6B · Wildwood, NJMay 31, 1963 · N7919C · Substantial damage NTSB NYC63A0189Accident · No injuriesClosedConvair 340 · Atlantic City, NJMay 28, 1963 · N8427H · Substantial damage NTSB NYC63A0184Accident · No injuriesClosedConvair 340 · Newark, NJMay 8, 1963 · N3415 · Substantial damage