Skip to content

NTSB investigations: Piper PA-24-250, NJ

22 cases on aircraft the registry lists as Piper PA-24-250. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

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' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404')) 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'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
  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'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
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 ERA16LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Millville, NJThe total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.Dec 4, 2015 · N88F · Substantial damage NTSB NYC07LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hammonton, NJDisplacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.Oct 3, 2006 · N5097P · Substantial damage NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.Jul 1, 1994 · N6375P · Destroyed NTSB NYC88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blairstown, NJThe flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…May 7, 1988 · N6762P · Substantial damage NTSB NYC81FHD04Accident · Minor injuriesClosedPiper PA-24 · Delran Twnship, NJOct 25, 1980 · N5509P · Destroyed NTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJApr 17, 1979 · N7318P · Destroyed NTSB NYC79FHA05Accident · Minor injuriesClosedPiper PA-24 · Blairstown, NJDec 16, 1978 · N22CJ · Destroyed NTSB NYC76FHD09Accident · No injuriesClosedPiper PA-24 · Mt Laurel, NJSep 22, 1975 · N7609P · Substantial damage NTSB NYC74FHD44Accident · 1 fatalClosedPiper PA-24 · Wrightstown, NJJun 15, 1974 · N5841P · Substantial damage NTSB NYC73DHD19Accident · No injuriesClosedPiper PA-24 · Marlton, NJOct 15, 1972 · N7130P · Substantial damage NTSB NYC72FHD33Accident · No injuriesClosedPiper PA-24 · Fort Dix, NJMar 25, 1972 · N7749P · Destroyed NTSB NYC71FHD34Accident · No injuriesClosedPiper PA-24 · Trenton, NJJan 3, 1971 · N5456P · Substantial damage NTSB NYC68D0179Accident · No injuriesClosedPiper PA-24 · Hackettstown, NJSep 30, 1967 · N6663P · Substantial damage NTSB NYC67F0223Accident · Minor injuriesClosedPiper PA-24 · Wayne, NJAug 20, 1966 · N5315P · Substantial damage NTSB NYC66A0077Accident · 1 fatalClosedPiper PA-24 · Rockaway, NJJan 22, 1966 · N6844P · Destroyed NTSB NYC66F0186Accident · No injuriesClosedPiper PA-24 · Medford, NJAug 8, 1965 · N8107P · Substantial damage NTSB NYC66F0072Accident · No injuriesClosedPiper PA-24 · Totoway Ny, NJMay 23, 1965 · N5315P · Substantial damage NTSB NYC66F0015Accident · No injuriesClosedPiper PA-24 · Red Bank, NJApr 29, 1965 · N7318P · Destroyed NTSB NYC65F0166Accident · No injuriesClosedPiper PA-24 · Edison, NJApr 6, 1965 · N7029P · Destroyed NTSB UNK65X0715Accident · No injuriesClosedPiper PA24 · Ashland, NJNov 15, 1964 · N7645P · Substantial damage NTSB UNK64X2157Accident · No injuriesClosedPiper PA24 · Red Bank, NJJun 6, 1964 · N5515P · Substantial damage NTSB UNK64X1362Accident · No injuriesClosedPiper PA24 · Medford, NJApr 18, 1964 · N6844P · Substantial damage