Skip to content

NTSB investigations, NJ

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 NYC76FHA23Accident · No injuriesClosedCessna 150 · Reading, NJMar 20, 1976 · N8086F · Destroyed NTSB NYC76FHA21Accident · Serious injuriesClosedPiper PA-28 · Pittstown, NJMar 14, 1976 · N16257 · Destroyed NTSB NYC76AN082Accident · Minor injuriesClosedSikorsky S-62 · Sayreville, NJMar 11, 1976 · N978 · Substantial damage NTSB NYC76FN071Accident · 2 fatalClosedCessna 150 · Long Valley, NJJan 31, 1976 · N99ST · Destroyed NTSB NYC76FHD17Accident · Minor injuriesClosedBeech E18S · Manahawkin, NJJan 29, 1976 · N3730B · Substantial damage NTSB NYC76FHD16Accident · No injuriesClosedAlon A-2 · Ocean City, NJJan 10, 1976 · N5656F · Substantial damage NTSB NYC76AN062Accident · 2 fatalClosedCessna 150M · Buena, NJDec 28, 1975 · N2928V · 2 aircraft · Destroyed NTSB NYC76DHA19Accident · No injuriesClosedBellanca 7ECA · Califon, NJDec 25, 1975 · N57668 · Substantial damage NTSB NYC76FHM17Accident · Serious injuriesClosedCessna 150 · Fairfield, NJDec 11, 1975 · N19145 · Substantial damage NTSB NYC76FHM16Accident · No injuriesClosedCessna 150 · Wayne Township, NJDec 8, 1975 · N3386V · Substantial damage NTSB NYC76DHA17Accident · No injuriesClosedSchweizer 1-26A · Hainesburg, NJNov 11, 1975 · N862R · Substantial damage NTSB NYC76AN045Accident · 6 fatalClosedPiper PA-23 · Whitehouse Sta, NJOct 25, 1975 · N54005 · Destroyed NTSB NYC76FHM14Accident · Minor injuriesClosedCessna 150H · Lincoln Park, NJOct 23, 1975 · N6443S · Substantial damage NTSB NYC76FHA13Accident · Minor injuriesClosedBeech J35 · Basking Ridge, NJOct 16, 1975 · N8398D · Destroyed NTSB NYC76FHM12Accident · Serious injuriesClosedCessna 182 · Linden, NJSep 28, 1975 · N20712 · Destroyed NTSB NYC76FHD09Accident · No injuriesClosedPiper PA-24 · Mt Laurel, NJSep 22, 1975 · N7609P · Substantial damage NTSB NYC76FHA13Accident · Minor injuriesClosedSchreder HP-11 · Blairstown, NJSep 20, 1975 · N571A · Destroyed NTSB NYC76FHA09Accident · No injuriesClosedCessna 150 · Blairstown, NJSep 7, 1975 · N18676 · Destroyed NTSB NYC76DHM10Accident · No injuriesClosedPiper PA-12 · Asbury Park, NJAug 30, 1975 · N4145M · Substantial damage NTSB NYC76DHD08Accident · Serious injuriesClosedHughes 369 · Trenton, NJAug 28, 1975 · N9075FV · Minor damage NTSB NYC76AHA07Accident · No injuriesClosedCessna 182M · Basking Ridge, NJAug 12, 1975 · N92099 · Substantial damage NTSB NYC76FHM06Accident · Minor injuriesClosedEnstrom 280 · Mahwah, NJAug 11, 1975 · N22BV · Substantial damage NTSB NYC76FHD05Accident · No injuriesClosedAero Comdr 100 · Atlantic City, NJAug 10, 1975 · N2967T · Substantial damage NTSB NYC76DHM08Accident · No injuriesClosedPiper PA-28 · Fairfield, NJAug 9, 1975 · N1463T · Substantial damage NTSB NYC76DHD06Accident · No injuriesClosedCessna 182 · Ocean City, NJAug 9, 1975 · N2605R · Substantial damage NTSB NYC76AN018Accident · No injuriesClosedCessna 150 · Readington, NJAug 2, 1975 · N11205 · 2 aircraft · Substantial damage NTSB NYC76FHM05Accident · Serious injuriesClosedBellanca 7GCAA · New Shrewsbury, NJJul 29, 1975 · N5216X · Substantial damage NTSB NYC76DHM09Accident · No injuriesClosedCessna 172 · Marlboro, NJJul 27, 1975 · N79227 · Substantial damage NTSB NYC76FHD02Accident · No injuriesClosedBeech C23 · Smithville, NJJul 23, 1975 · N2172W · Substantial damage NTSB NYC76AN008Accident · 2 fatalClosedCessna 150L · Florham Park, NJJul 17, 1975 · N11215 · Destroyed NTSB NYC76DHD04Accident · No injuriesClosedHelicorp D · Trenton, NJJul 15, 1975 · N8219 · Substantial damage NTSB NYC76DHA01Accident · No injuriesClosedCessna 172 · Basking Ridge, NJJul 2, 1975 · N12493 · Substantial damage NTSB NYC7KFHD56Accident · Serious injuriesClosedStinson L-5 · Millville, NJJun 25, 1975 · N69887 · Substantial damage NTSB NYC75AN123Accident · No injuriesClosedCessna 150 · Teterboro, NJJun 22, 1975 · N10979 · 2 aircraft · Substantial damage NTSB NYC75IN121Incident · No injuriesClosedBeech E18S · Newark, NJJun 20, 1975 · N5639D · Minor damage NTSB NYC75FHA46Accident · Serious injuriesClosedBeech 95-C55 · Basking Ridge, NJJun 20, 1975 · N245UC · Destroyed NTSB NYC75FHA45Accident · No injuriesClosedN.American Navion · Andover, NJJun 7, 1975 · N8667H · Substantial damage NTSB NYC75AN115Accident · 1 fatalClosedPiper PA-12 · Mount Laurel, NJJun 6, 1975 · N3192M · Destroyed NTSB NYC75FHD51Accident · No injuriesClosedAeronca 7BCM · Pennington, NJJun 3, 1975 · N9324H · Substantial damage NTSB NYC75FHD47Accident · No injuriesClosedCessna 310N · Trenton, NJJun 1, 1975 · N4145Q · Substantial damage NTSB NYC75FHD48Accident · No injuriesClosedPiper PA-25 · Monroeville, NJMay 30, 1975 · N4887Y · Substantial damage NTSB NYC75FHM21Accident · Minor injuriesClosedStinson 108-3 · Teterboro, NJMay 28, 1975 · N6961M · Substantial damage NTSB NYC75DHD50Accident · No injuriesClosedHiller Acft UH-12D · Cape May, NJMay 28, 1975 · N67117 · Destroyed NTSB NYC75AN109Accident · 2 fatalClosedAlon A-2 · Vineland, NJMay 23, 1975 · N6562Q · Substantial damage NTSB NYC75DHA44Accident · No injuriesClosedSchweizer 2-22 · Pittstown, NJMay 18, 1975 · N684U · Substantial damage NTSB NYC75DHM19Accident · No injuriesClosedCessna 177 · West Milford, NJMay 17, 1975 · N30018 · Substantial damage NTSB NYC75FHD43Accident · Serious injuriesClosedPiper PA-28R · Lindenwold, NJMay 7, 1975 · N41331 · Destroyed NTSB NYC75FHA38Accident · Minor injuriesClosedAero Comdr 100 · Manville, NJMay 2, 1975 · N2932T · Substantial damage NTSB NYC75DHA39Accident · No injuriesClosedSchweizer I-26E · Blairstown, NJApr 26, 1975 · N1103S · Substantial damage NTSB NYC75DHM17Accident · Minor injuriesClosedPiper PA-28 · Marlboro, NJApr 17, 1975 · N1899T · Destroyed