NTSB investigations: Piper PA-24-260, NJ
17 cases on aircraft the registry lists as Piper PA-24-260. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2021 | 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 ('7102406'))
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 ('7102406'))
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 ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.NTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.NTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.NTSB NYC88LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Readington, NJWhile attempting a go-around from a rejected landing in x-wind conditions the plt who had no landings in the last 90 days failed to initiate the go-around with sufficient time/distance to clear trees off the end of the rnwy. The acft struck the trees and was…NTSB NYC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Marlboro, NJWhile lndg on rwy 27, just bfr sunset, the acft was rprtd to be high & fast on the apch. Subsequently, it contd off the end of the rwy & collided with trees. The plt rprtd he was under stress due to recent death of his parents & the necessity to move the acft…NTSB NYC86FA214Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Ft. Dix, NJThe acft was headed sw on victor sixteen inbound to coyle VOR when the plt reported the loss of gyro instruments. The acft was at 6000 ft and in 'solid IFR weather.' The plt elected not to declare emergency and land when asked if he wanted to do so by ATC.…NTSB NYC80FA071Accident · 2 fatalClosedPiper PA-24 · Atlantic City, NJNTSB NYC75FHD38Accident · No injuriesClosedPiper PA-24 · Bridgeport, NJNTSB NYC74FHD43Accident · No injuriesClosedPiper PA-24 · Cape May, NJNTSB NYC72DHA13Accident · No injuriesClosedPiper PA-24 · Pittstown, NJNTSB NYC71FHM23Accident · Serious injuriesClosedPiper PA-24 · Moonachie, NJNTSB NYC71FHM11Accident · No injuriesClosedPiper PA-24 · Hanover, NJNTSB NYC69D0162Accident · No injuriesClosedPiper PA-24 · Atlantic City, NJNTSB NYC68F0474Accident · No injuriesClosedPiper PA-24 · Medford, NJNTSB NYC66D0450Accident · No injuriesClosedPiper PA-24 · Ocean City, NJNTSB NYC66F0105Accident · No injuriesClosedPiper PA-24 · Pluckemin, NJNTSB UNK65X0481Accident · No injuriesClosedPiper PA24 · Teterboro, NJ