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 NYC72FHD01Accident · Minor injuriesClosedLuscombe 8A · Marlton, NJJul 4, 1971 · N23086 · Substantial damage NTSB NYC71FHM34Accident · Minor injuriesClosedPiper PA-22 · So Orange, NJJun 27, 1971 · N8745C · Substantial damage NTSB NYC71DHD58Accident · Minor injuriesClosedPiper J-3 · Mickleton, NJJun 26, 1971 · N75356 · Destroyed NTSB NYC71FHM31Accident · Minor injuriesClosedCessna 172 · Fairfield, NJJun 20, 1971 · N7811G · Substantial damage NTSB NYC71FHA51Accident · 1 fatalClosedBell 47G2 · Branchville, NJJun 8, 1971 · N8426E · Destroyed NTSB NYC72AN091Accident · 1 fatalClosedN.American SNJ-4 · Cape May, NJJun 5, 1971 · N9735Z · Destroyed NTSB NYC71AN119Accident · 2 fatalClosedN.American SNJ-5 · North Cape May, NJJun 5, 1971 · N3626F · 2 aircraft · Destroyed NTSB NYC71AN118Accident · 1 fatalClosedN.American SNJ-5 · North Cape May, NJJun 5, 1971 · N1046C · 2 aircraft · Substantial damage NTSB NYC71FHD52Accident · Serious injuriesClosedCessna 150 · Evesham, NJJun 4, 1971 · N7067S · Destroyed NTSB NYC71FHD54Accident · Minor injuriesClosedCooney R-3 · Woodbine, NJJun 1, 1971 · N91TC · Substantial damage NTSB NYC71DHD51Accident · No injuriesClosedCessna 150 · Atlantic City, NJMay 28, 1971 · N60767 · Substantial damage NTSB NYC71DHD60Accident · No injuriesClosedBoeing A75 · Wildwood Crest, NJMay 26, 1971 · N9080H · Substantial damage NTSB NYC71FHA49Accident · No injuriesClosedCessna 172 · Clinton, NJMay 19, 1971 · N2566Y · Substantial damage NTSB NYC71FHD49Accident · No injuriesClosedBell 47G2A1 · Berlin, NJMay 18, 1971 · N73953 · Substantial damage NTSB NYC71AN113Accident · Serious injuriesClosedDouglas DC-8 · Newark, NJMay 18, 1971 · N812E · No damage NTSB NYC71FHA44Accident · No injuriesClosedCessna 172 · Blairstown, NJMay 11, 1971 · N46475 · Substantial damage NTSB NYC71FHD47Accident · Minor injuriesClosedChampion 7AC · Bargaintown, NJMay 9, 1971 · N3032E · Destroyed NTSB NYC71DHD50Accident · No injuriesClosedBeech 23 · Atlantic City, NJMay 5, 1971 · N2357L · Substantial damage NTSB NYC71DHM26Accident · No injuriesClosedPiper J-3 · Colts Neck, NJApr 23, 1971 · N88074 · Substantial damage NTSB NYC71DHD46Accident · Serious injuriesClosedBell 47G4 · Mays Ldg, NJApr 19, 1971 · N73944 · Destroyed NTSB NYC71IN103Incident · No injuriesClosedM-Saulnier MS894A · Morristown, NJApr 13, 1971 · N1516W · Minor damage NTSB NYC71DHD45Accident · No injuriesClosedAeronca L-16A · Pennington, NJApr 4, 1971 · N9432H · Substantial damage NTSB NYC71FHM23Accident · Serious injuriesClosedPiper PA-24 · Moonachie, NJMar 30, 1971 · N9087P · Destroyed NTSB NYC71FHA41Accident · No injuriesClosedErcoupe 415D · Whitehouse, NJMar 27, 1971 · N93969 · Substantial damage NTSB NYC71DHD44Accident · No injuriesClosedCessna 150 · Rio Grande, NJMar 26, 1971 · N1969Z · Substantial damage NTSB NYC71FHM22Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 22, 1971 · N5761G · Substantial damage NTSB NYC71AN094Accident · 4 fatalClosedPiper PA-24 · Atlantic City, NJMar 20, 1971 · N6987P · Destroyed NTSB NYC71IN092Incident · No injuriesClosedDouglas DC9-10 · Newark, NJMar 19, 1971 · N1066T · No damage NTSB NYC71DHD42Accident · Minor injuriesClosedCessna 170B · Toms River, NJMar 12, 1971 · N3258A · Substantial damage NTSB NYC71FN089Accident · 2 fatalClosedPiper PA-22 · Teterboro, NJFeb 28, 1971 · N3710A · Destroyed NTSB NYC71DHD39Incident · Minor injuriesClosedCessna 172 · Riverdale, NJFeb 16, 1971 · N5511R · Minor damage NTSB NYC71FHA31Accident · No injuriesClosedCessna 150 · Milford, NJFeb 6, 1971 · N23405 · Substantial damage NTSB NYC71FHM17Accident · No injuriesClosedBeech G35 · Morristown, NJJan 31, 1971 · N4667D · Substantial damage NTSB NYC71DHD36Accident · No injuriesClosedPiper PA-28 · Pennington, NJJan 24, 1971 · N8890J · Substantial damage NTSB NYC71DHD37Accident · No injuriesClosedRyan Navion · Hammonton, NJJan 23, 1971 · N75881 · Substantial damage NTSB NYC71FHM15Accident · Serious injuriesClosedMooney M20F · Morristown, NJJan 21, 1971 · N9393M · Substantial damage NTSB NYC71AN082Accident · 1 fatalClosedCessna 411 · Little Ferry, NJJan 19, 1971 · N7386U · Destroyed NTSB NYC71DHD35Accident · Minor injuriesClosedNavion A · Vincentown, NJJan 16, 1971 · N91520 · Destroyed NTSB NYC71AN078Accident · 2 fatalClosedCessna 150 · Edison, NJJan 9, 1971 · N60942 · 2 aircraft · Destroyed NTSB NYC71DHA29Accident · No injuriesClosedCessna 150 · Manville, NJJan 8, 1971 · N5942G · Substantial damage NTSB NYC71FHD34Accident · No injuriesClosedPiper PA-24 · Trenton, NJJan 3, 1971 · N5456P · Substantial damage NTSB NYC71FHA26Accident · No injuriesClosedCessna 150K · Manville, NJJan 3, 1971 · N6170G · Substantial damage NTSB NYC71FHA25Accident · No injuriesClosedPiper PA-22 · Basking Ridge, NJJan 3, 1971 · N8620D · Substantial damage NTSB NYC71FHM12Accident · No injuriesClosedPiper PA-28 · Morganville, NJDec 27, 1970 · N8233N · Substantial damage NTSB NYC71FHM11Accident · No injuriesClosedPiper PA-24 · Hanover, NJDec 15, 1970 · N9120P · Substantial damage NTSB NYC71IN104Incident · No injuriesClosedBoeing 707 · Atlantic City, NJDec 5, 1970 · N460PA · Minor damage NTSB NYC71AN065Accident · 1 fatalClosedPiper PA-28 · Bridgeport, NJNov 29, 1970 · N6652J · Destroyed NTSB NYC71FHA22Accident · No injuriesClosedBeech A23 · Basking Ridge, NJNov 21, 1970 · N2360Q · Substantial damage NTSB NYC71AN055Accident · 1 fatalClosedCessna 150H · Mountain Lakes, NJNov 7, 1970 · N6676S · Substantial damage NTSB NYC71DHM08Accident · No injuriesClosedCessna 180 · Morganville, NJNov 1, 1970 · N750N · Substantial damage