Skip to content

NTSB investigations, NJ

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 UNK65X0731Accident · 1 fatalClosedCessna 172F · Shrewsbury, NJNov 15, 1964 · N8274U · Destroyed NTSB UNK65X0728Accident · 4 fatalClosedBeech C18S · Fairfield, NJNov 15, 1964 · N39Q · Destroyed NTSB UNK65X0715Accident · No injuriesClosedPiper PA24 · Ashland, NJNov 15, 1964 · N7645P · Substantial damage NTSB UNK65X0685Accident · No injuriesClosedPiper PA-22 · Bedminster, NJNov 13, 1964 · N4533Z · Substantial damage NTSB UNK65X0497Accident · Minor injuriesClosedNavion A · Manchester, NJOct 31, 1964 · N91627 · Substantial damage NTSB UNK65X0481Accident · No injuriesClosedPiper PA24 · Teterboro, NJOct 30, 1964 · N8555P · Substantial damage NTSB UNK65X0459Accident · No injuriesClosedCessna 150 · Colts Neck, NJOct 28, 1964 · N5990E · Substantial damage NTSB UNK65X0443Incident · No injuriesClosedLockheed L-188 · Woodstown, NJOct 26, 1964 · N5001K · Minor damage NTSB UNK65X0421Accident · No injuriesClosedPiper PA23 · Cape May, NJOct 25, 1964 · N4415P · Substantial damage NTSB UNK65X0375Accident · No injuriesClosedPiper J3C65 · Lincoln Park, NJOct 22, 1964 · N42201 · Substantial damage NTSB UNK65X0144Accident · No injuriesClosedPiper PA28 · Lumberton, NJOct 4, 1964 · N6135W · Substantial damage NTSB UNK64X4161Accident · No injuriesClosedStinson 10A · Pemberton, NJSep 26, 1964 · N36701 · Substantial damage NTSB UNK64X4094Accident · No injuriesClosedCessna 150 · Hanover, NJSep 22, 1964 · N4491U · Substantial damage NTSB UNK64X4091Incident · No injuriesClosedDouglas DC-3 · Atlantic City, NJSep 22, 1964 · N58 · No damage NTSB UNK64X4090Incident · No injuriesClosedDouglas DC-3 · Atlantic City, NJSep 22, 1964 · N58 · No damage NTSB UNK64X4009Accident · No injuriesClosedCessna 150 · Hanover, NJSep 16, 1964 · N7791E · Substantial damage NTSB UNK64X4007Accident · No injuriesClosedForney F1 · Red Bank, NJSep 16, 1964 · N7530C · Substantial damage NTSB UNK64X3947Accident · No injuriesClosedBeechcraft D18S · Linden, NJSep 12, 1964 · N85R · Substantial damage NTSB UNK64X3896Accident · No injuriesClosedChampion 7FC · S Plainfield, NJSep 10, 1964 · N9857Y · Substantial damage NTSB UNK64X3827Accident · No injuriesClosedPiper PA28 · Readington, NJSep 6, 1964 · N7371W · Substantial damage NTSB UNK64X3817Accident · No injuriesClosedPiper PA24 · Princeton, NJSep 6, 1964 · N6074P · Substantial damage NTSB UNK64X3735Accident · No injuriesClosedPiper PA28 · Cape May, NJSep 2, 1964 · N5707W · Substantial damage NTSB UNK64X3717Accident · 1 fatalClosedTaylorcraft BC12D · Berlin, NJSep 1, 1964 · N43582 · Destroyed NTSB UNK64X3684Accident · No injuriesClosedAero Comm 520 · Morristown, NJAug 30, 1964 · N63G · Substantial damage NTSB UNK64X3672Accident · No injuriesClosedTaylorcraft BC12D · Cross Keys, NJAug 29, 1964 · N5175M · Destroyed NTSB UNK64X3608Accident · Minor injuriesClosedNavion Ryan · Atlantic City, NJAug 26, 1964 · N8628H · Substantial damage NTSB UNK64X3581Accident · No injuriesClosedPiper PA28 · Red Bank, NJAug 25, 1964 · N7266W · Substantial damage NTSB UNK64X3563Accident · Minor injuriesClosedPiper PA28 · Pittstown, NJAug 23, 1964 · N5237W · Substantial damage NTSB UNK64X3433Accident · 2 fatalClosedBeech 35-33 · South Plainfld, NJAug 16, 1964 · N290AA · Destroyed NTSB UNK64X3407Accident · Serious injuriesClosedRyan ST3KR · Fairfield, NJAug 15, 1964 · N666K · Destroyed NTSB UNK64X3338Accident · No injuriesClosedAero Comm 500 · Red Bank, NJAug 12, 1964 · N8430C · Substantial damage NTSB UNK64X3303Accident · No injuriesClosedSchweizer 222 · Fairfield, NJAug 9, 1964 · N91842 · Destroyed NTSB UNK64X3293Accident · No injuriesClosedCessna 150 · Asbury Park, NJAug 9, 1964 · N5708E · Substantial damage NTSB UNK64X3264Accident · No injuriesClosedCessna 210 · Andover, NJAug 8, 1964 · N7437E · Substantial damage NTSB UNK64X3106Accident · No injuriesClosedPiper PA18 · Pluckemin, NJJul 29, 1964 · N8217C · Substantial damage NTSB UNK64X2932Accident · Minor injuriesClosedPiper PA22 · Brigantine, NJJul 19, 1964 · N1138C · Substantial damage NTSB UNK64X2926Accident · No injuriesClosedErcoure 415C · Hanover, NJJul 19, 1964 · N99288 · Substantial damage NTSB UNK64X2922Accident · No injuriesClosedCessna 182 · Long Beach Is, NJJul 19, 1964 · N3749U · Substantial damage NTSB UNK64X2909Accident · 1 fatalClosedPiper PA18 · Colts Neck, NJJul 18, 1964 · N305T · Destroyed NTSB UNK64X2745Accident · No injuriesClosedPiper PA28 · Lincoln Park, NJJul 10, 1964 · N8752W · Substantial damage NTSB UNK64X2665Accident · Minor injuriesClosedTaylorcraft BL65 · Patterson, NJJul 5, 1964 · N28387 · Destroyed NTSB UNK64X2654Accident · No injuriesClosedNavion Navy · Pitman, NJJul 5, 1964 · N4379K · Substantial damage NTSB UNK64X2617Accident · No injuriesClosedBeechcraft M23 · Princeton, NJJul 3, 1964 · N2339Q · Destroyed NTSB UNK64X2609Accident · Serious injuriesClosedHughes 269A · Burlington, NJJul 2, 1964 · N8779F · Destroyed NTSB UNK64X2516Accident · Minor injuriesClosedCessna 172 · Little York, NJJun 27, 1964 · N8653B · Destroyed NTSB UNK64X2456Accident · 1 fatalClosedCessna 182 · Oceanport, NJJun 23, 1964 · N4043D · Destroyed NTSB UNK64X2360Accident · Serious injuriesClosedHughes 269A · Red Bank, NJJun 18, 1964 · N8734F · Destroyed NTSB UNK64X2326Accident · No injuriesClosedCessna 195B · Bridgeport, NJJun 17, 1964 · N3028B · Substantial damage NTSB UNK64X2292Accident · No injuriesClosedErcoupe 415C · S Plainfield, NJJun 14, 1964 · N94088 · Substantial damage NTSB UNK64X2220Accident · No injuriesClosedBenson B8M · Manville, NJJun 10, 1964 · N371Y · Substantial damage