NTSB investigations: Piper PA-23-250, NJ
14 cases on aircraft the registry lists as Piper PA-23-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.
Cases per year
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2006 | 1 |
| 2007 | 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 ('7102308'))
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 ('7102308'))
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 NYC07LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bernardsville, NJThe failure by unidentified maintenance personnel to follow appropriate procedures when attaching the No. 3 cylinder, which was replaced subsequent to the engine overhaul and not entered in the logbook, resulting in fatigue failures of the cylinder studs.NTSB NYC06CA080Accident · Serious injuriesData collectionFinal reportPiper PA23-250 · Morristown, NJThe pilot's premature shutdown of both engines, which resulted in a forced landing short of the runway. A factor was a landing gear malfunction indication for undetermined reasons.NTSB NYC97FA172Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Baptistown, NJfailure of the pilot to maintain control of the airplane for undetermined reason(s), while operating it at low altitude.NTSB NYC93FA066Accident · 6 fatalField investigationFinal reportPiper PA-23-250 · Elmwood Park, NJInadequate maintenance and inspection of the fuel injector system resulting in a loss of power of the left engine, and the failure of the pilot to maintain minimum control speed which resulted in a flat spin. A factor which contributed to the accident was the…NTSB NYC88LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic City, NJThe Piper PA-23-250 made an instrument approach to the airport. The pilot said he lowered the landing gear prior to touchdown, however, both propellers struck the runway. The pilot tried to make a go-around and the aircraft started to veer to the left. The…NTSB NYC80FA044Accident · 1 fatalClosedPiper PA-23 · Neptune, NJNTSB NYC79FHD20Accident · No injuriesClosedPiper PA-23 · Atlantic, NJNTSB NYC72AN082Accident · Serious injuriesClosedPiper PA-23 · Haledon, NJNTSB NYC70DHA14Accident · No injuriesClosedPiper PA-23 · Manville, NJNTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJNTSB NYC69A0078Accident · 1 fatalClosedPiper PA-23 · Middletown, NJNTSB NYC67A0071Accident · No injuriesClosedPiper PA-23 · Farmingdale, NJNTSB NYC67F0061Accident · Serious injuriesClosedPiper PA-23 · Hasbrouck Hght, NJNTSB NYC66A0008Accident · 1 fatalClosedPiper PA-23 · Jersey City, NJ