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 NYC73FHD18Accident · No injuriesClosedBeech C-45H · Millville, NJOct 25, 1972 · N9904Z · Substantial damage NTSB NYC73INO54Accident · No injuriesClosedCessna 411 · Marlton, NJOct 24, 1972 · N4910T · Substantial damage NTSB NYC73DHD19Accident · No injuriesClosedPiper PA-24 · Marlton, NJOct 15, 1972 · N7130P · Substantial damage NTSB NYC73FHD16Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJOct 9, 1972 · N8996W · Substantial damage NTSB NYC73DHA09Accident · No injuriesClosedSwift GC-1B · Blairstown, NJOct 1, 1972 · N101R · Substantial damage NTSB NYC73FHM13Accident · No injuriesClosedStinson 108 · Flanders, NJSep 27, 1972 · N97775 · Substantial damage NTSB NYC73AN045Accident · 2 fatalClosedBeech E18S · Newark, NJSep 23, 1972 · N107T · Destroyed NTSB NYC73FHM12Accident · No injuriesClosedBell 47G-4A · Cranbury, NJSep 15, 1972 · N7857S · Substantial damage NTSB NYC73FHM11Accident · No injuriesClosedBellanca 260 · Sea Bright, NJSep 5, 1972 · N8812R · Substantial damage NTSB NYC73FHM10Accident · No injuriesClosedPiper PA-28 · East Hanover, NJSep 2, 1972 · N5318T · Substantial damage NTSB NYC73DHD10Accident · No injuriesClosedPiper PA-28 · Marlton, NJAug 16, 1972 · N8147N · Substantial damage NTSB NYC73FHM06Accident · No injuriesClosedPiper PA-30 · Fairfield, NJAug 8, 1972 · N8237Y · Substantial damage NTSB NYC73FHM04Accident · No injuriesClosedCessna 172L · Oakland, NJAug 8, 1972 · N4320Q · Substantial damage NTSB NYC73FHD06Accident · No injuriesClosedAmer Avco AA1A · Atco, NJAug 6, 1972 · N9363L · Substantial damage NTSB NYC73DHD09Accident · No injuriesClosedBeech V35 · Absecon, NJAug 6, 1972 · N2727T · Substantial damage NTSB NYC73IN017Incident · No injuriesClosedBeech 95-C55 · Fairfield, NJJul 27, 1972 · N945V · Minor damage NTSB NYC73FHD07Accident · No injuriesClosedAmer Avco AA1 · Atlantic City, NJJul 25, 1972 · N5654L · Substantial damage NTSB NYC73FHD04Accident · Minor injuriesClosedPiper PA-12 · Wildwood, NJJul 23, 1972 · N3721M · Destroyed NTSB NYC73FHD03Accident · No injuriesClosedCessna 150L · Ocean City, NJJul 23, 1972 · N6546G · Substantial damage NTSB NYC73DHD02Accident · No injuriesClosedPiper PA-28 · Albion, NJJul 23, 1972 · N1852T · Substantial damage NTSB NYC73DHD01Accident · Serious injuriesClosedPiper J-3 · Rio Grande, NJJul 11, 1972 · N92085 · Substantial damage NTSB NYC72FHM59Accident · Minor injuriesClosedCessna 150K · Mahwah, NJJun 28, 1972 · N6176G · Destroyed NTSB NYC72AN155Accident · 3 fatalClosedPiper PA-24 · Atlantic City, NJJun 18, 1972 · N6340P · Substantial damage NTSB NYC72AN153Accident · 2 fatalClosedCessna 177A · Columbia, NJJun 15, 1972 · N30025 · Destroyed NTSB NYC72FHM56Accident · No injuriesClosedBell 47G-5 · Freehold, NJJun 5, 1972 · N4101G · Substantial damage NTSB NYC72DHD41Accident · No injuriesClosedWoodbury Tapsik · Millville, NJJun 4, 1972 · N4506 · Substantial damage NTSB NYC72FHD40Accident · Minor injuriesClosedChampion 7ECA · Ocean City, NJMay 28, 1972 · N5148T · Substantial damage NTSB NYC72FHM55Accident · No injuriesClosedCessna 310H · Lincoln Park, NJMay 24, 1972 · N1095Q · Substantial damage NTSB NYC72FHM51Accident · No injuriesClosedPiper PA-28 · Clark, NJMay 23, 1972 · N3545K · Substantial damage NTSB NYC72FHD39Accident · No injuriesClosedBeech 35 · Woodbine, NJMay 13, 1972 · N2336J · Substantial damage NTSB NYC72AN140Accident · Minor injuriesClosedBeech B95 · Atlantic City, NJMay 3, 1972 · N8566M · Substantial damage NTSB NYC72AN138Accident · No injuriesClosedSwearingen SA26AT · Fairfield, NJMay 3, 1972 · CF-GRA · Substantial damage NTSB NYC72DHD37Accident · No injuriesClosedAeronca 7AC · Medford, NJApr 29, 1972 · N3025E · Substantial damage NTSB NYC72FHM45Accident · No injuriesClosedAero-Comdr 100 · Fairfield, NJApr 26, 1972 · N3406X · Substantial damage NTSB NYC72FHA37Accident · No injuriesClosedBensen B-8M · Readington, NJApr 19, 1972 · N5779 · Substantial damage NTSB NYC72IN132Incident · No injuriesClosedDouglas DC-8 · Newark, NJApr 18, 1972 · N787FT · Minor damage NTSB NYC72FHM42Accident · Minor injuriesClosedCessna 150H · Fort Lee, NJApr 16, 1972 · N7009S · Substantial damage NTSB NYC72AN129Accident · 3 fatalClosedMitsubishi MU-2G · Atlantic City, NJApr 16, 1972 · N132MA · Destroyed NTSB NYC72FHD35Accident · No injuriesClosedCessna 182M · Marlton, NJApr 12, 1972 · N91663 · Substantial damage NTSB NYC72FHM40Accident · Minor injuriesClosedCessna 150G · East Hanover, NJApr 2, 1972 · N2888S · Substantial damage NTSB NYC72FHD32Accident · No injuriesClosedSiai-Marche S20522 · Atlantic City, NJApr 1, 1972 · N736W · Substantial damage NTSB NYC72FHM36Accident · No injuriesClosedCessna 182 · Linden, NJMar 26, 1972 · N92316 · Substantial damage NTSB NYC72DHA36Accident · Minor injuriesClosedPiper PA-28 · Bedminister, NJMar 26, 1972 · N9723W · Substantial damage NTSB NYC72FHD33Accident · No injuriesClosedPiper PA-24 · Fort Dix, NJMar 25, 1972 · N7749P · Destroyed NTSB NYC72FHD34Accident · No injuriesClosedCessna 310C · Medford, NJMar 9, 1972 · N6688B · Substantial damage NTSB NYC72FHM35Accident · No injuriesClosedCessna 172E · Farmingdale, NJMar 8, 1972 · N5414T · Substantial damage NTSB NYC72FHD30Accident · No injuriesClosedPiper PA-22 · Medford, NJMar 4, 1972 · N2930Z · 2 aircraft · Substantial damage NTSB NYC72IN105Incident · No injuriesClosedBeech D18S · Wrightstown, NJMar 2, 1972 · N3544B · Minor damage NTSB NYC72FHM34Accident · No injuriesClosedPiper PA-28 · Teterboro, NJMar 2, 1972 · N5467S · Substantial damage NTSB NYC72FHM33Accident · Minor injuriesClosedCessna 150 · Morristown, NJFeb 29, 1972 · N5748G · Substantial damage