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 NYC66D0033Accident · No injuriesClosedBeechcraft M-23 · Mooreston, NJMay 9, 1965 · N2326Q · Substantial damage NTSB NYC65D0204Accident · No injuriesClosedCessna 120 · Marlton, NJMay 6, 1965 · N3542V · Substantial damage NTSB NYC65F0192Accident · No injuriesClosedStinson 10 · Pompton Plains, NJMay 2, 1965 · N26285 · Substantial damage NTSB NYC65A0133Accident · 1 fatalClosedPiper PA-28 · Newton, NJMay 1, 1965 · N6178W · Destroyed NTSB NYC66F0015Accident · No injuriesClosedPiper PA-24 · Red Bank, NJApr 29, 1965 · N7318P · Destroyed NTSB NYC65F0214Accident · Serious injuriesClosedTaylorcraft L2 · Salem, NJApr 27, 1965 · N50135 · Substantial damage NTSB NYC65F0164Accident · No injuriesClosedMooney M-18L · Fairfield, NJApr 25, 1965 · N111C · Destroyed NTSB NYC65D0168Accident · No injuriesClosedNardi FN333 · Secaucus, NJApr 17, 1965 · N632 · Substantial damage NTSB NYC65F0110Accident · No injuriesClosedLuscombe 8E · Pluckemin, NJApr 15, 1965 · N2646K · Substantial damage NTSB NYC65F0182Accident · No injuriesClosedBeechcraft B-33 · Pennington, NJApr 11, 1965 · N9559Y · Substantial damage NTSB NYC65D0175Accident · No injuriesClosedCessna 172 · Blackwood, NJApr 10, 1965 · N6049A · Substantial damage NTSB NYC65F0166Accident · No injuriesClosedPiper PA-24 · Edison, NJApr 6, 1965 · N7029P · Destroyed NTSB NYC65F0240Accident · No injuriesClosedCessna 150B · Marlton, NJApr 4, 1965 · N1284Y · Substantial damage NTSB NYC65F0091Accident · No injuriesClosedGlobe GC-1B · Readington, NJApr 4, 1965 · N78125 · Substantial damage NTSB NYC65F0105Accident · No injuriesClosedCessna T-50 · Manville, NJApr 3, 1965 · N60978 · Destroyed NTSB NYC65D0162Accident · No injuriesClosedPiper PA-20 · Lakewood, NJMar 30, 1965 · N7641K · Substantial damage NTSB NYC65F0090Accident · No injuriesClosedCessna 150E · Manalapan, NJMar 23, 1965 · N6143T · Destroyed NTSB NYC65F0118Accident · No injuriesClosedGlobe GC-1B · Ashbury Park, NJMar 21, 1965 · N78260 · Substantial damage NTSB NYC65D0189Accident · No injuriesClosedPiper PA-23 · Cape May, NJMar 20, 1965 · N3143P · Substantial damage NTSB NYC65D0161Accident · No injuriesClosedCessna 172F · Marlton, NJMar 16, 1965 · N8437U · Substantial damage NTSB NYC65F0075Accident · No injuriesClosedPiper PA-22 · Manville, NJMar 15, 1965 · N4656Z · Substantial damage NTSB NYC65F0059Accident · Minor injuriesClosedStinson 108-2 · Rocky Hill, NJMar 14, 1965 · N9622K · Substantial damage NTSB NYC65D0127Accident · No injuriesClosedCessna 140 · Pitman, NJMar 14, 1965 · N76391 · Substantial damage NTSB NYC65F0080Accident · No injuriesClosedCessna 150 · Hanover, NJMar 13, 1965 · N3511J · Substantial damage NTSB NYC65D0104Accident · No injuriesClosedPiper PA-22 · Teterboro, NJMar 9, 1965 · N5660Z · Substantial damage NTSB NYC65F0097Accident · No injuriesClosedPiper PA-22 · Teterboro, NJMar 7, 1965 · N5952Z · Substantial damage NTSB NYC65D0128Accident · No injuriesClosedCessna 150D · Millville, NJMar 3, 1965 · N4143U · Substantial damage NTSB NYC65F0155Accident · No injuriesClosedFairchild M-62A · Albion, NJFeb 28, 1965 · N49966 · Destroyed NTSB NYC65F0143Accident · No injuriesClosedCessna 195 · Millville, NJFeb 21, 1965 · N10323 · 2 aircraft · Substantial damage NTSB NYC65D0089Accident · No injuriesClosedBeechraft M-23 · Morristown, NJFeb 19, 1965 · N8751M · Substantial damage NTSB NYC65F0126Accident · No injuriesClosedBeechcraft 23 · Medford, NJFeb 15, 1965 · N2336J · Substantial damage NTSB UNK65X1385Accident · No injuriesClosedPiper PA28 · Morristown, NJFeb 2, 1965 · N6276W · Destroyed NTSB NYC65F0039Accident · No injuriesClosedCessna 150 · Hanover, NJJan 31, 1965 · N6504T · Substantial damage NTSB NYC65F0025Accident · No injuriesClosedErcoupe 415D · Medford, NJJan 30, 1965 · N3281H · Substantial damage NTSB NYC65F0085Accident · No injuriesClosedPiper PA-22 · Totowa, NJJan 28, 1965 · N2707P · Substantial damage NTSB NYC65F0037Accident · No injuriesClosedPiper PA23 · Red Bank, NJJan 23, 1965 · N4076P · Substantial damage NTSB UNK65X1238Accident · No injuriesClosedGlove GC1B · Hanover, NJJan 6, 1965 · N8084O · Substantial damage NTSB UNK65X1226Accident · No injuriesClosedNavion NAV4 · Hanover, NJJan 3, 1965 · N4154K · Substantial damage NTSB UNK65X1210Accident · No injuriesClosedPiper PA16 · Woodstown, NJJan 1, 1965 · N5346H · Substantial damage NTSB UNK65X1186Incident · No injuriesClosedDouglas DC-8 · Newark, NJDec 29, 1964 · N8601 · No damage NTSB UNK65X1066Accident · No injuriesClosedCessna 170B · Blairstown, NJDec 20, 1964 · N4524C · Substantial damage NTSB UNK65X1018Accident · No injuriesClosedCessna 172 · Teterboro, NJDec 15, 1964 · N5413T · Substantial damage NTSB UNK65X1009Accident · No injuriesClosedPiper PA28 · Lumberton, NJDec 14, 1964 · N8743W · Substantial damage NTSB UNK65X0959Accident · No injuriesClosedPiper PA28 · Lincoln Park, NJDec 9, 1964 · N6050W · Substantial damage NTSB UNK65X0949Accident · No injuriesClosedBell 47G4 · Bedminster, NJDec 7, 1964 · N73996 · Substantial damage NTSB UNK65X0892Accident · No injuriesClosedPiper PA22 · Newark, NJDec 1, 1964 · N9738B · Substantial damage NTSB UNK65X0865Accident · No injuriesClosedCessna 172 · Blackwood, NJNov 28, 1964 · N6049A · Substantial damage NTSB UNK65X0827Incident · No injuriesClosedCaravelle SE-210 · Newark, NJNov 25, 1964 · N1014U · Minor damage NTSB NYC65A0078Accident · 4 fatalClosedBeechcraft M35 · Millville, NJNov 25, 1964 · N939Y · Destroyed NTSB UNK65X0759Incident · No injuriesClosedDouglas DC-6 · Robbinsville, NJNov 20, 1964 · N37501 · Minor damage