NTSB investigations: Piper PA-30, NJ
17 cases on aircraft the registry lists as Piper PA-30. 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.
Cases per year
| 1966 | 2 |
|---|---|
| 1967 | 2 |
| 1969 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2005 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('7103002'))
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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Millville, NJThe flight instructor's failure to lower the landing gear during landing.NTSB NYC00LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Morristown, NJThe pilot's failure to obtain proper takeoff airspeed and his failure to follow published emergency procedures. Factors related to the accident were the pilot's inadequate preflight and water contamination of the fuel system.NTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.NTSB BFO93LA110Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lincoln Park, NJThe pilot's failure to maintain directional control of the airplane during landing rollout, and his delay is performing the proper remedial action of bringing back the left throttle to idle during landing rollout.NTSB NYC84LA245Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manahawkin, NJThe acft descended out of control into trees and slid down an embankment. The plt said everything seemed normal on takeoff until the acft was put into a climb at about 93 mph at 50 ft AGL the acft began vibrating and veered about 90 degrees to the right. An…NTSB NYC83FA049Accident · 2 fatalField investigationFinal reportPiper PA-30 · Atlantic City, NJThe plt had landed at Atlantic City, NJ at aprx 1545 while en route to oxford, CT. Before taking off, he contacted two fss's and both advised that VFR flt was not recommended. The non-instrument rated plt took off at aprx 1920 local time with no flt plan. At…NTSB NYC79FHD03Accident · No injuriesClosedPiper PA-30 · Lumberton, NJNTSB NYC75FHM10Accident · No injuriesClosedPiper PA-30 · Newark, NJNTSB NYC74FHA10Accident · Minor injuriesClosedPiper PA-30 · Manville, NJNTSB NYC73FHD22Accident · No injuriesClosedPiper PA-30 · Moorestown, NJNTSB NYC73FHM06Accident · No injuriesClosedPiper PA-30 · Fairfield, NJNTSB NYC69A0114Accident · 2 fatalClosedPiper PA-30 · Rancocas, NJNTSB NYC69F0319Accident · No injuriesClosedPiper PA-30 · Sussex, NJNTSB NYC68F0104Accident · 2 fatalClosedPiper PA-30 · Masonville, NJNTSB NYC67F0452Accident · No injuriesClosedPiper PA-30 · Millville, NJNTSB NYC67D0405Accident · No injuriesClosedPiper PA-30 · Bridgeport, NJNTSB NYC66F0664Accident · No injuriesClosedPiper PA-30 · Teterboro, NJ