NTSB investigations: Piper PA-22-150, NJ
12 cases on aircraft the registry lists as Piper PA-22-150. 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 | 4 |
| 1967 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 2014 | 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 ('7102210'))
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 ('7102210'))
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 ERA15CA043Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Old Bridge, NJThe pilot's loss of control while landing the tailwheel-equipped airplane in gusting wind conditions, which resulted in a ground loop.NTSB NYC87LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Allaire, NJDuring landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged.NTSB NYC84LA250Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · E. Hanover, NJThe acft made a forced landing shortly after takeoff when the engine lost power. At about 400 ft AGL the engine sputtered and stopped. The fuel tanks were switched by the plt and the engine made a slight pwr gain and quit again. A landing was made in a marshy…NTSB NYC72FHD30Accident · No injuriesClosedPiper PA-22 · Medford, NJNTSB NYC71FHM04Accident · Minor injuriesClosedPiper PA-22 · West Milford, NJNTSB NYC68F0141Accident · No injuriesClosedPiper PA-22 · Red Bank, NJNTSB NYC68F0138Accident · No injuriesClosedPiper PA-22 · Vincentown, NJNTSB NYC67D0116Accident · No injuriesClosedPiper PA-22 · Bridgeport, NJNTSB NYC66D0682Accident · Minor injuriesClosedPiper PA-22 · Salem, NJNTSB NYC66D0687Accident · Minor injuriesClosedPiper PA22 · Columbus, NJNTSB NYC66D0599Accident · No injuriesClosedPiper PA-22 · Salem, NJNTSB NYC65F0085Accident · No injuriesClosedPiper PA-22 · Totowa, NJ