Skip to content

NTSB investigations, NJ

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DCA81AA028Accident · 2 fatalClosedPiper PA-34 · E.Rutherford, NJSep 23, 1981 · N8110R · 2 aircraft · Destroyed NTSB DCA81AA027Accident · No injuriesClosedLockheed L-1011 · Colts Neck, NJSep 22, 1981 · N309EA · Substantial damage NTSB NYC81FHM16Accident · No injuriesClosedCessna 150M · Caldwell, NJSep 20, 1981 · N7614U · Substantial damage NTSB NYC81FHA23Accident · No injuriesClosedCessna 177 · Stillwater, NJSep 19, 1981 · N29363 · Substantial damage NTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJSep 9, 1981 · N8622R · Substantial damage NTSB NYC81FA081Accident · 1 fatalClosedPiper PA-28R · Randolph, NJSep 8, 1981 · N9021K · Destroyed NTSB NYC81DHD37Accident · Minor injuriesClosedPiper PA-28R · Manahawkin, NJSep 4, 1981 · N6SD · Destroyed NTSB NYC81FHA21Accident · Minor injuriesClosedCessna 152 · Sparta, NJAug 30, 1981 · N25313 · Substantial damage NTSB NYC81FHD36Accident · Serious injuriesClosedMorrisey 2150A · Port Republic, NJAug 28, 1981 · N5133V · Substantial damage NTSB NYC81FHM15Accident · Minor injuriesClosedGyro Sport 1-39 · Lincoln Park, NJAug 23, 1981 · N39GN · Substantial damage NTSB NYC81FHD34Accident · Minor injuriesClosedCessna T188C · Woodstown, NJAug 14, 1981 · N2165J · Substantial damage NTSB NYC81FHM13Accident · No injuriesClosedPiper PA-18 · Colts Neck, NJAug 9, 1981 · N6879B · Substantial damage NTSB NYC81DHD35Accident · No injuriesClosedPiper PA-28R · Robbinsville, NJAug 7, 1981 · N3978X · Substantial damage NTSB NYC81FHD31Accident · No injuriesClosedPiper PA-28R · Lumberton, NJJul 29, 1981 · N3737T · Substantial damage NTSB NYC81FHD32Accident · Minor injuriesClosedMooney M20E · Bridgeport, NJJul 26, 1981 · N9223M · Substantial damage NTSB NYC81FHM12Accident · No injuriesClosedCessna 172N · Ridgefield Prk, NJJul 17, 1981 · N5120K · Substantial damage NTSB NYC81FHD30Accident · Serious injuriesClosedPiper PA-18 · Atlantic City, NJJul 10, 1981 · N9292D · Substantial damage NTSB NYC81FHM14Accident · No injuriesClosedPiper PA-18 · Colts Neck, NJJul 7, 1981 · N6879B · Substantial damage NTSB NYC81FHM09Accident · Minor injuriesClosedEngr & Rsch 415-D · Matawan, NJJun 27, 1981 · N24AP · Substantial damage NTSB NYC81FA068Accident · 3 fatalClosedBeech A24R · Manahawkin, NJJun 27, 1981 · N9713Q · Destroyed NTSB NYC81FA067Accident · Minor injuriesClosedCessna 172 · Bridgeport, NJJun 25, 1981 · N8852B · Substantial damage NTSB NYC81FA064Accident · No injuriesClosedMooney M20K · Atlantic City, NJJun 24, 1981 · N231AN · Substantial damage NTSB NYC81DA065Accident · No injuriesClosedCessna 182 · Pittstown, NJJun 23, 1981 · N1539M · Substantial damage NTSB NYC81IA059Incident · No injuriesClosedPiper PA-34 · Newark, NJJun 16, 1981 · N7678C · Minor damage NTSB NYC81FHD28Accident · Minor injuriesClosedCessna 150 · Hamilton Sq, NJJun 13, 1981 · N704PQ · Destroyed NTSB DCA81IA016Incident · No injuriesClosedDehavilland DHC-7 · Atlantic City, NJJun 10, 1981 · C-GNBX-X · Minor damage NTSB NYC81FHA15Accident · No injuriesClosedBeech V35B · Stockton, NJJun 7, 1981 · N16RD · Substantial damage NTSB NYC81IA054Accident · Serious injuriesClosedPiper PA-28 · Skullville, NJJun 6, 1981 · N2888S · Destroyed NTSB NYC81IA051Incident · No injuriesClosedSwearingen SA226 · Newark, NJMay 29, 1981 · N105UR · 2 aircraft · Minor damage NTSB NYC81FHM07Accident · No injuriesClosedPiper PA-28 · New Milford, NJMay 25, 1981 · N2257Q · Substantial damage NTSB NYC81FHD26Accident · No injuriesClosedStearman PT-17 · Salem, NJMay 22, 1981 · N92X · Destroyed NTSB NYC81FHM06Accident · Minor injuriesClosedPiper PA-28 · West Milford, NJMay 18, 1981 · N2049A · Substantial damage NTSB NYC81FHD23Accident · No injuriesClosedCessna 172N · Elmer, NJMay 15, 1981 · N9914E · Substantial damage NTSB NYC81FA047Accident · 4 fatalClosedCessna 177B · Forked River, NJMay 10, 1981 · N16083 · Destroyed NTSB NYC82IHD22Accident · Serious injuriesClosedPiper PA-28 · Bridgeport, NJMay 8, 1981 · N2613R · Substantial damage NTSB NYC81DHA12Accident · Minor injuriesClosedSchweizer 1-35C · Blairstown, NJMay 3, 1981 · N2705H · Destroyed NTSB NYC81FHD20Accident · No injuriesClosedPorterfield FP-65 · Robbinsville, NJApr 27, 1981 · N117F · Substantial damage NTSB NYC81DHA09Accident · Minor injuriesClosedSikorsky S-55B · Stillwater, NJApr 21, 1981 · N17754 · Destroyed NTSB NYC81FHM03Accident · Minor injuriesClosedPiper PA-28 · Franklin Lakes, NJApr 17, 1981 · N15942 · Destroyed NTSB NYC81FA039Accident · No injuriesClosedStinson 108-1 · Manahawkin, NJApr 13, 1981 · N9075K · Destroyed NTSB NYC81FHD16Accident · Minor injuriesClosedPiper PA-28 · Smithville, NJMar 15, 1981 · N44610 · Destroyed NTSB NYC81FHD15Accident · Minor injuriesClosedMooney M20K · Atlantic City, NJMar 10, 1981 · N4092H · Destroyed NTSB NYC81FHD14Accident · Minor injuriesClosedBeech 35-B33 · Camden, NJFeb 28, 1981 · N9691Y · Destroyed NTSB NYC81FA029Accident · 4 fatalClosedMooney M20F · Montgomery Twp, NJFeb 22, 1981 · N1919T · Destroyed NTSB NYC81DHD11Accident · Minor injuriesClosedChampion 7GCBC · Normandy Beach, NJJan 24, 1981 · N9666S · Destroyed NTSB NYC81FA021Accident · 1 fatalClosedCessna 150 · Montclair, NJJan 19, 1981 · N19088 · Substantial damage NTSB NYC81DHA06Accident · No injuriesClosedPiper PA-28 · Bedminster, NJDec 27, 1980 · N44055 · Substantial damage NTSB NYC81FHD09Accident · No injuriesClosedDehavilland DHC-1 · Ocean City, NJDec 6, 1980 · N65237 · Destroyed NTSB NYC81FHA04Accident · Minor injuriesClosedCessna 172 · Andover, NJNov 27, 1980 · N739PL · Substantial damage NTSB NYC81DHA05Accident · No injuriesClosedHughes 300C · Whitehouse, NJNov 25, 1980 · N58281 · Substantial damage