NTSB investigations: Piper PA-28-151, NJ
13 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1977 | 2 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 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 ('7102805', '7104223'))
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 ('7102805', '7104223'))
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 NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.NTSB NYC02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Cross Keys, NJThe pilot's delayed decision to abort the landing.NTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.NTSB BFO92LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB NYC90LA204Accident · No injuriesLimited investigationFinal reportPiper 28R · Farmingdale, NJThe failure of the pilot of N8564F to insure the runway was clear prior to crossing.NTSB NYC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Matawan, NJThe pilot's inadequate action after encountering tailwind conditions during landing.NTSB NYC87LA235Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Lakewood, NJWhile returning to the arpt aft flying for abt 30 mins, the eng lost pwr. The plt attempted to restart the eng by checking the fuel tank gauges, carb heat, mags, etc but with no success. During the forced lndg, the acft was stalled into trees. No fuel was…NTSB NYC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bridgeport, NJThe pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees.NTSB NYC82DA048Accident · No injuriesFinal reportPiper PA-28-151 · Pittstown, NJAfter arriving from alexandria, NJ with an instructor pilot, the student made two practice landing at the Pittstown airport without incident. However, on a subsequent solo flight, the student pilot landed long on the 2000 ft runway. He stated that he ran off…NTSB NYC81FHD16Accident · Minor injuriesClosedPiper PA-28 · Smithville, NJNTSB NYC78FA002Accident · 1 fatalClosedPiper PA-28 · Randolph, NJNTSB NYC77DHD10Accident · No injuriesClosedPiper PA-28 · Atlantic City, NJ