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 NYC74DHD42Accident · No injuriesClosedBrantly B-2B · Vincentown, NJJun 22, 1974 · N2192U · Substantial damage NTSB NYC74FHD43Accident · No injuriesClosedPiper PA-24 · Cape May, NJJun 21, 1974 · N9339P · Substantial damage NTSB NYC74DHM32Accident · No injuriesClosedBell 47G · Imlaystown, NJJun 18, 1974 · N7886S · Substantial damage NTSB NYC74AN112Accident · 2 fatalClosedPiper PA-28R · Sparta, NJJun 18, 1974 · N2716R · Destroyed NTSB NYC74FHD44Accident · 1 fatalClosedPiper PA-24 · Wrightstown, NJJun 15, 1974 · N5841P · Substantial damage NTSB NYC74DHD41Accident · No injuriesClosedPiper PA-28 · Marlton, NJJun 15, 1974 · N1866N · Substantial damage NTSB NYC74FHD39Accident · No injuriesClosedCessna 172M · East Windsor, NJJun 10, 1974 · N4382R · Substantial damage NTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJJun 10, 1974 · N11258 · Substantial damage NTSB NYC74AN108Accident · 2 fatalClosedBeech 23 · Sparta, NJJun 7, 1974 · N8717M · Destroyed NTSB NYC74AN103Accident · 1 fatalClosedMooney M20C · Matawan, NJJun 5, 1974 · N78944 · Destroyed NTSB NYC74FHM31Accident · Serious injuriesClosedCessna 150 · Colts Neck, NJMay 25, 1974 · N3127X · Substantial damage NTSB NYC74FHD38Accident · No injuriesClosedCessna 172L · Millville, NJMay 23, 1974 · N7907G · Substantial damage NTSB NYC74FHM28Accident · No injuriesClosedCessna 170A · Fairfield, NJMay 20, 1974 · N5461C · Substantial damage NTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJMay 20, 1974 · N1596Q · Substantial damage NTSB NYC75AN111Accident · Serious injuriesClosedCameron 1 · Solberg, NJMay 19, 1974 · N1446 · No damage NTSB NYC74FHA30Accident · No injuriesClosedCessna 172L · Whitehouse Stn, NJMay 16, 1974 · N7220Q · Substantial damage NTSB NYC74DHM19Accident · Serious injuriesClosedCessna 182G · Fairfield, NJMay 15, 1974 · N3191S · No damage NTSB NYC74FHM27Accident · Serious injuriesClosedCessna 150G · Hanover, NJMay 8, 1974 · N3231J · Destroyed NTSB NYC74DHD37Accident · Minor injuriesClosedCessna 172 · Smithville, NJMay 5, 1974 · N20529 · Substantial damage NTSB NYC74DHA28Accident · No injuriesClosedCessna 172 · Hillsboro, NJMay 4, 1974 · N46281 · Substantial damage NTSB NYC74FHD35Accident · Minor injuriesClosedPiper PA-28 · Bridgeport, NJApr 29, 1974 · N56192 · Substantial damage NTSB NYC74FHD34Accident · Serious injuriesClosedCessna 150L · Pennsauken, NJApr 21, 1974 · N6831G · Destroyed NTSB NYC74FHM26Accident · No injuriesClosedBell 206B · Hewitt, NJApr 20, 1974 · N4FL · Substantial damage NTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJApr 20, 1974 · N2899S · Substantial damage NTSB NYC74FHM24Accident · Minor injuriesClosedMooney M20B · Flanders, NJApr 13, 1974 · N74583 · Destroyed NTSB NYC74FHD31Accident · Serious injuriesClosedChampion 7FC · Marlton, NJApr 13, 1974 · N9893B · Destroyed NTSB NYC74DHA26Accident · No injuriesClosedCessna 150J · Stillwater, NJApr 13, 1974 · N61208 · Substantial damage NTSB NYC74DHM25Accident · No injuriesClosedCessna 177 · Lincoln Park, NJApr 6, 1974 · N652SR · Substantial damage NTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 31, 1974 · N10070 · Substantial damage NTSB NYC74FHD32Accident · No injuriesClosedCessna 172 · Toms River, NJMar 20, 1974 · N7062Q · Substantial damage NTSB NYC74IN080Incident · No injuriesClosedPiper PA-28 · Toms River, NJMar 15, 1974 · N5197S · Minor damage NTSB NYC74FHM18Accident · No injuriesClosedAero Comdr 500S · Teterboro, NJMar 7, 1974 · N9098N · No damage NTSB NYC74AN075Accident · 1 fatalClosedCessna 177 · Lambertville, NJMar 3, 1974 · N1985Q · Destroyed NTSB NYC74FHM17Accident · Serious injuriesClosedCessna 182L · Matawan, NJFeb 22, 1974 · N3342R · Substantial damage NTSB NYC74DHM14Accident · No injuriesClosedCessna 150 · Lincoln Park, NJDec 27, 1973 · N30425 · Substantial damage NTSB NYC74FHA23Accident · No injuriesClosedCessna 177B · Manville, NJDec 22, 1973 · N34832 · Substantial damage NTSB NYC74FHD28Accident · 1 fatalClosedTaylor Mono · Millville, NJDec 8, 1973 · N71RC · Destroyed NTSB NYC74FHM13Accident · Serious injuriesClosedCessna 150L · Linden, NJDec 7, 1973 · N1688Q · Substantial damage NTSB NYC74FHM12Accident · Minor injuriesClosedBrantly B-2 · North Bergen, NJNov 21, 1973 · N5946X · Destroyed NTSB NYC74FHD21Accident · No injuriesClosedCessna 150L · Pitman, NJNov 13, 1973 · N6535G · Substantial damage NTSB NYC74DHM11Accident · No injuriesClosedCessna 172 · Colts Neck, NJNov 11, 1973 · N6023A · Substantial damage NTSB NYC74FHM10Accident · Minor injuriesClosedBellanca 7ACA · Hanover, NJNov 7, 1973 · N62965 · Substantial damage NTSB NYC74FHA16Accident · Serious injuriesClosedTaylorcraft BC12-D · Montague, NJNov 4, 1973 · N39210 · Substantial damage NTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNov 3, 1973 · N8561J · Substantial damage NTSB NYC73AN038Accident · Serious injuriesClosedBeech V35A · Robbinsville, NJOct 28, 1973 · N2776A · Substantial damage NTSB NYC74FHD18Accident · No injuriesClosedPietenpol Aircam · Lakewood, NJOct 23, 1973 · N5392 · Substantial damage NTSB NYC74FHD12Accident · Minor injuriesClosedPiper PA-28 · Moorestown, NJOct 22, 1973 · N5443W · Substantial damage NTSB NYC74FHA13Accident · Minor injuriesClosedCessna 206A · Pittstown, NJOct 17, 1973 · N4639F · 2 aircraft · Destroyed NTSB NYC74DHM09Accident · Minor injuriesClosedCessna 172 · East Hanover, NJOct 5, 1973 · N1861Y · Substantial damage NTSB NYC74DHD17Accident · No injuriesClosedPiper PA-28 · Berlin, NJOct 5, 1973 · N5580U · Substantial damage