Skip to content

NTSB investigations: Piper PA-12, NJ

21 cases on aircraft the registry lists as Piper PA-12. 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 ('7101202')) 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 ('7101202'))
  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 ('7101202'))
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 ERA22FA315Accident · 1 fatalClass 3 · FieldFinal reportPiper PA12 · Middle Township, NJThe pilot’s exceedance of the airplane’s critical angle of attack during a missed banner pickup, which resulted in an aerodynamic stall/spin and loss of control at an altitude too low to recover.Jul 16, 2022 · N3703M · Substantial damage NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.Jul 26, 2012 · N4361M · Substantial damage NTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.Aug 18, 2009 · N7556H · Substantial damage NTSB CHI08LA215Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Rio Grande, NJA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Jul 26, 2008 · N4361M · Substantial damage NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.Aug 5, 1992 · N4280M · Substantial damage NTSB NYC82DA180Accident · No injuriesFinal reportPiper PA-12 · Long Branch, NJEven though he had performed several banner pick-ups during the afternoon the pilot did no refueling. After 4 hours of towing banners the engine quit. The pilot stated the gauges read 1/3 full of fuel. The pilot ditched the aircraft which sank and has not…Aug 2, 1982 · N2705M · Destroyed NTSB NYC79FA050Accident · 2 fatalClosedPiper PA-12 · Stillmanville, NJJun 27, 1979 · N4293M · Destroyed NTSB NYC76FHA40Accident · No injuriesClosedPiper PA-12 · Whitehouse, NJJun 13, 1976 · N2919M · Substantial damage NTSB NYC76DHM10Accident · No injuriesClosedPiper PA-12 · Asbury Park, NJAug 30, 1975 · N4145M · Substantial damage NTSB NYC75AN115Accident · 1 fatalClosedPiper PA-12 · Mount Laurel, NJJun 6, 1975 · N3192M · Destroyed NTSB NYC73FHD04Accident · Minor injuriesClosedPiper PA-12 · Wildwood, NJJul 23, 1972 · N3721M · Destroyed NTSB NYC71FHD20Accident · No injuriesClosedPiper PA-12 · Cape May C.Hse, NJAug 18, 1970 · N4280M · Substantial damage NTSB NYC68D0194Accident · Minor injuriesClosedPiper PA-12 · East Hanover, NJSep 13, 1967 · N7604H · Substantial damage NTSB NYC68D0111Accident · No injuriesClosedPiper PA-12 · Woodbine, NJJul 26, 1967 · N2907M · Substantial damage NTSB NYC67D0450Accident · No injuriesClosedPiper PA-12 · Pittstown, NJJan 22, 1967 · N3988M · Substantial damage NTSB NYC67D0209Accident · No injuriesClosedPiper PA-12 · Atlantic City, NJAug 24, 1966 · N7576H · Substantial damage NTSB NYC66F0670Accident · No injuriesClosedPiper PA-12 · Princeton, NJMay 26, 1966 · N3081M · Substantial damage NTSB NYC66D0490Accident · No injuriesClosedPiper PA-12 · Morganville, NJDec 19, 1965 · N92713 · Substantial damage NTSB NYC66D0062Accident · No injuriesClosedPiper PA-12 · Neptune, NJMay 30, 1965 · N3413M · Substantial damage NTSB UNK64X0915Accident · No injuriesClosedPiper PA12 · Pittstown, NJMar 14, 1964 · N3988M · Substantial damage NTSB UNK64X0317Accident · No injuriesClosedPiper PA12 · Andover, NJJan 22, 1964 · N4164M · Substantial damage