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 NYC74DHD16Accident · No injuriesClosedMooney M20F · Williamston, NJSep 13, 1973 · N3501X · Substantial damage NTSB NYC74FHA10Accident · Minor injuriesClosedPiper PA-30 · Manville, NJSep 11, 1973 · N7419Y · Substantial damage NTSB NYC74FHM07Accident · Minor injuriesClosedCessna 310F · Neptune, NJSep 9, 1973 · N5809X · Substantial damage NTSB NYC74FHM06Accident · No injuriesClosedCessna 172 · Farmingdale, NJSep 2, 1973 · N7069G · Substantial damage NTSB NYC74FHD15Accident · No injuriesClosedPiper PA-28 · Berlin, NJAug 29, 1973 · N8260N · Substantial damage NTSB NYC74FHM03Accident · No injuriesClosedEnstrom F-28A · Teterboro, NJAug 25, 1973 · N15SB · Substantial damage NTSB NYC74FHD08Accident · No injuriesClosedFokker DR-1 · Woodbine, NJAug 12, 1973 · N1917 · Substantial damage NTSB NYC74DHD07Accident · No injuriesClosedCessna 172H · Vineland, NJAug 6, 1973 · N2468L · Substantial damage NTSB NYC74DHD04Accident · No injuriesClosedCessna 182 · Berlin, NJJul 27, 1973 · N9237X · Substantial damage NTSB NYC74FHD06Accident · No injuriesClosedBell 47G-4A · Barnegat, NJJul 19, 1973 · N886S · Substantial damage NTSB NYC74FHD13Accident · No injuriesClosedBeech C35 · Rio Grand, NJJul 17, 1973 · N5998C · Substantial damage NTSB NYC74DHD03Accident · No injuriesClosedGrumman G-164 · Pittsgrove, NJJul 17, 1973 · N662U · Substantial damage NTSB NYC74DHD02Accident · No injuriesClosedSopwith Camel · Woodbine, NJJul 17, 1973 · N1917N · Substantial damage NTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJJul 16, 1973 · N17065 · Substantial damage NTSB NYC74FHM02Accident · Minor injuriesClosedPiper PA-28 · Marboro, NJJul 12, 1973 · N7747N · Substantial damage NTSB NYC74FHM01Accident · Minor injuriesClosedBellanca 17-30 · Linden, NJJul 1, 1973 · N6672V · Destroyed NTSB NYC73FHD38Accident · No injuriesClosedEaa Biplane P-2 · Medford, NJJun 17, 1973 · N5134 · Substantial damage NTSB NYC74FHD20Accident · 1 fatalClosedJeanie 2 Teenie · Tuckerton, NJJun 9, 1973 · N6186 · Destroyed NTSB NYC73FHM33Accident · Serious injuriesClosedCessna 150K · Hackensack, NJJun 9, 1973 · N5684G · Substantial damage NTSB NYC73AN149Accident · 3 fatalClosedMooney M20F · Atlantic City, NJJun 3, 1973 · N9582M · Destroyed NTSB NYC73FHM32Accident · No injuriesClosedCessna 172K · Marlboro, NJMay 22, 1973 · N7483G · Substantial damage NTSB NYC73FHM31Accident · Serious injuriesClosedGlobe GC-1B · Fairfield, NJMay 13, 1973 · N3394K · Destroyed NTSB NYC73FHA25Accident · No injuriesClosedWaco UPF-7 · Bedminster, NJMay 6, 1973 · N29927 · Substantial damage NTSB NYC73FHM29Accident · No injuriesClosedPiper PA-28 · Clark, NJApr 22, 1973 · N4433T · Substantial damage NTSB NYC73FHD32Accident · Minor injuriesClosedCessna 150G · Rancocas, NJApr 21, 1973 · N3480J · Destroyed NTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJApr 21, 1973 · N19344 · Substantial damage NTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJApr 17, 1973 · N3636S · Substantial damage NTSB NYC73AN132Accident · 6 fatalClosedBeech 65-A80 · Bricktown, NJApr 16, 1973 · N456WM · Destroyed NTSB NYC73DHD30Accident · No injuriesClosedPiper PA-28 · Williamstown, NJApr 6, 1973 · N4203T · Substantial damage NTSB NYC73DHA20Accident · No injuriesClosedCessna 182A · Pittstown, NJMar 29, 1973 · N4921D · Substantial damage NTSB NYC73AN127Accident · 1 fatalClosedPiper J4A · Pennington, NJMar 29, 1973 · N32780 · Destroyed NTSB NYC73FHM23Accident · No injuriesClosedPiper PA-24 · Carlstadt, NJMar 24, 1973 · N8537P · Substantial damage NTSB NYC73FHA18Accident · No injuriesClosedPiper PA-28 · Pittstown, NJMar 24, 1973 · N8244W · Substantial damage NTSB NYC73FHM25Accident · No injuriesClosedCessna 172 · Farmingdale, NJMar 20, 1973 · N8354L · Substantial damage NTSB NYC73FHM22Accident · No injuriesClosedCessna 150L · Lincoln Park, NJMar 1, 1973 · N18562 · Substantial damage NTSB NYC73FHD37Accident · 1 fatalClosedPiper PA-28 · Forked River, NJFeb 28, 1973 · N5033W · Substantial damage NTSB NYC73FHA16Accident · No injuriesClosedPiper PA-28 · Pittstown, NJFeb 24, 1973 · N1432T · Substantial damage NTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJFeb 14, 1973 · N18210 · Substantial damage NTSB NYC73AN109Accident · No injuriesClosedPiper PA-28 · Farmingdale, NJJan 30, 1973 · N1835J · 2 aircraft · No damage NTSB NYC73IN105Incident · No injuriesClosedPiper PA-31P · Linden, NJJan 26, 1973 · N6840L · Minor damage NTSB NYC73DHD73Accident · No injuriesClosedPiper PA-28 · Toms River, NJJan 20, 1973 · N15377 · Substantial damage NTSB NYC73FHD22Accident · No injuriesClosedPiper PA-30 · Moorestown, NJJan 12, 1973 · N8452Y · Substantial damage NTSB NYC73AN097Accident · 3 fatalClosedCessna 177B · Pittstown, NJJan 7, 1973 · N30910 · Destroyed NTSB NYC73AN125Accident · No injuriesClosedLockheed 1011 · Atlantic City, NJDec 28, 1972 · N305EA · Substantial damage NTSB NYC73FHM20Accident · No injuriesClosedCessna 150 · S.Hackensack, NJDec 3, 1972 · N5546G · Substantial damage NTSB NYC73FHM17Accident · Minor injuriesClosedCessna 150H · Newfoundland, NJNov 19, 1972 · N50271 · Substantial damage NTSB NYC73FHA12Accident · 1 fatalClosedBensen Gyro B8M · Reddington, NJNov 12, 1972 · N59391 · Substantial damage NTSB NYC73DHD15Accident · No injuriesClosedCessna 150 · Hammaton, NJNov 11, 1972 · N1625Q · Substantial damage NTSB NYC73FHM16Accident · Minor injuriesClosedPiper PA-22 · Colts Neck, NJNov 10, 1972 · N5376Z · Substantial damage NTSB NYC73FHA10Accident · No injuriesClosedCessna 150K · Manville, NJOct 31, 1972 · N8411M · Substantial damage