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 NYC68A0117Accident · Serious injuriesClosedDouglas DC-8 · Atlantic City, NJApr 28, 1968 · N1820 · Destroyed NTSB NYC68F0469Accident · No injuriesClosedAlon A2 · Millville, NJApr 27, 1968 · N6593Q · Substantial damage NTSB NYC68D0450Accident · No injuriesClosedCessna 177 · Lavallette, NJApr 21, 1968 · N3310T · Substantial damage NTSB NYC68D0451Accident · No injuriesClosedCessna 150 · Medford, NJApr 20, 1968 · N8901S · Substantial damage NTSB NYC68F0449Accident · Minor injuriesClosedChampion 7EC · So.Plainfield, NJApr 7, 1968 · N8550E · Substantial damage NTSB NYC68D0496Accident · Minor injuriesClosedAeronca 7CCM · Carlstadt, NJApr 6, 1968 · N3108E · Destroyed NTSB NYC68D0406Accident · No injuriesClosedCessna 210 · Manville, NJMar 30, 1968 · N9591T · Substantial damage NTSB NYC68D0416Accident · No injuriesClosedKitty Hawk B-4 · Manville, NJMar 11, 1968 · N34V · Substantial damage NTSB NYC68F0420Accident · Minor injuriesClosedPiper PA-22 · Red Bank, NJMar 2, 1968 · N5925Z · Substantial damage NTSB NYC68F0392Accident · No injuriesClosedPiper PA-28 · Shrewsbury, NJFeb 16, 1968 · N9136W · Substantial damage NTSB NYC68A0096Accident · No injuriesClosedPiper PA-23 · Red Bank, NJFeb 2, 1968 · N5917Y · Substantial damage NTSB NYC68F0372Accident · Minor injuriesClosedCessna 150 · Hanover, NJFeb 1, 1968 · N6265T · Substantial damage NTSB NYC68A0094Accident · 2 fatalClosedPiper PA-28 · Mendham, NJJan 31, 1968 · N4826L · Destroyed NTSB NYC68A0085Accident · No injuriesClosedDouglas DC-8F · Mcguire Afb, NJJan 1, 1968 · N4906C · Substantial damage NTSB NYC68D0375Accident · No injuriesClosedStinson 108-3 · Berlin, NJDec 23, 1967 · N97062 · Substantial damage NTSB NYC68D0326Accident · Minor injuriesClosedPiper PA-23 · Sea Side Heght, NJDec 17, 1967 · N3005P · Substantial damage NTSB NYC68A0075Accident · No injuriesClosedBeech D18S · Newark, NJNov 29, 1967 · N6032V · Substantial damage NTSB NYC68D0298Accident · No injuriesClosedCessna 337 · Rio Grande, NJNov 22, 1967 · N5312S · Substantial damage NTSB NYC68D0289Accident · No injuriesClosedRyan ST-3KR · Berlin, NJNov 18, 1967 · N48928 · Substantial damage NTSB NYC68F0292Accident · No injuriesClosedCessna 310 · Carlstadt, NJNov 17, 1967 · N193R · Substantial damage NTSB NYC68A0073Accident · 2 fatalClosedPiper PA-28 · Lakewood, NJNov 17, 1967 · N4492J · Destroyed NTSB NYC68D0297Accident · No injuriesClosedPiper PA-23 · Ewing, NJNov 16, 1967 · N4490P · Substantial damage NTSB NYC68A0072Accident · Minor injuriesClosedBell 47G · Newark Apt Fac, NJNov 16, 1967 · N940B · Substantial damage NTSB NYC68F0274Accident · Serious injuriesClosedCessna 150E · Morganville, NJNov 5, 1967 · N3927U · Destroyed NTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJOct 30, 1967 · N89161 · Destroyed NTSB NYC68F0270Accident · No injuriesClosedBeech V35 · Teterboro, NJOct 29, 1967 · N215Y · Substantial damage NTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damage NTSB NYC68D0242Accident · No injuriesClosedPiper PA-28 · Princeton, NJOct 28, 1967 · N6334R · Substantial damage NTSB NYC68D0234Accident · No injuriesClosedPiper PA-28 · Red Bank, NJOct 24, 1967 · N7266W · Substantial damage NTSB NYC68D0273Accident · No injuriesClosedPiper PA-22 · Little Ferry, NJOct 23, 1967 · N9408D · Substantial damage NTSB NYC68F0251Accident · No injuriesClosedBeech A23 · Medford, NJOct 21, 1967 · N5956S · No damage NTSB NYC68F0243Accident · No injuriesClosedCessna 182 · Moorestown, NJOct 21, 1967 · N9237X · Substantial damage NTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJOct 21, 1967 · N2901S · Substantial damage NTSB NYC68A0063Accident · No injuriesClosedMooney M20F · Teterboro, NJOct 21, 1967 · N6436Q · Substantial damage NTSB NYC68A0062Accident · 2 fatalClosedCessna 172 · So.Hackensack, NJOct 19, 1967 · N2473L · Destroyed NTSB DIA68F0103Accident · Minor injuriesClosedPiper PA-28 · Laurel, NJOct 17, 1967 · N8372W · Destroyed NTSB NYC68F0239Accident · Serious injuriesClosedNavion A · Carlstadt, NJOct 15, 1967 · N4532K · Substantial damage NTSB NYC68F0237Accident · No injuriesClosedPiper PA-22 · Salem, NJOct 15, 1967 · N1242C · Substantial damage NTSB NYC68D0285Accident · No injuriesClosedAeronca 7AC · Millville, NJOct 14, 1967 · N82415 · Substantial damage NTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJOct 11, 1967 · N6884F · Destroyed NTSB NYC68F0215Accident · No injuriesClosedCessna 182 · Hanover, NJOct 6, 1967 · N8343S · Substantial damage NTSB NYC68A0056Accident · No injuriesClosedBeech E18S · Newark, NJOct 5, 1967 · N73V · Substantial damage NTSB NYC68F0212Accident · Serious injuriesClosedPiper PA-20 · Belford, NJSep 30, 1967 · N7741K · Destroyed NTSB NYC68D0179Accident · No injuriesClosedPiper PA-24 · Hackettstown, NJSep 30, 1967 · N6663P · Substantial damage NTSB NYC68F0202Accident · No injuriesClosedBeech D95A · Teterboro, NJSep 27, 1967 · N5350 · Substantial damage NTSB NYC68D0223Accident · Serious injuriesClosedCessna 140A · Atlantic City, NJSep 26, 1967 · N9469A · No damage NTSB NYC68F0196Accident · Serious injuriesClosedBellanca 14-13 · So.Plainfield, NJSep 22, 1967 · N6503N · Substantial damage NTSB NYC68D0204Accident · No injuriesClosedCessna 172H · Mays Landing, NJSep 20, 1967 · N3281L · Substantial damage NTSB NYC68A0048Accident · 1 fatalClosedCessna 150 · Vincentown, NJSep 20, 1967 · N8627S · Destroyed NTSB NYC68D0194Accident · Minor injuriesClosedPiper PA-12 · East Hanover, NJSep 13, 1967 · N7604H · Substantial damage