NTSB investigations: Piper PA-28-180, PR
12 cases on aircraft the registry lists as Piper PA-28-180. 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 | 2 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 2010 | 1 |
| 2017 | 1 |
Latest 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\" = 'PR' 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 ('7102808'))
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" = 'PR' 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 ('7102808'))
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 ERA17LA227Accident · No injuriesLimited investigationFinal reportPiper PA28 · San Juan, PRA partial loss of engine power during initial climb for reasons that could not be determined and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA10CA152Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Patillas, PRThe student pilot’s decision to abort the takeoff with insufficient runway remaining.NTSB MIA80FKA07Accident · No injuriesClosedPiper PA-28 · Lares, PRNTSB MIA79FKA10Accident · No injuriesClosedPiper PA-28 · Mayaguez, PRNTSB MIA74FKA08Accident · No injuriesClosedPiper PA-28 · Culebra, PRNTSB MIA71AM089Accident · 4 fatalClosedPiper PA-28 · Yabucoa, PRNTSB MIA70F0190Accident · Minor injuriesClosedPiper PA-28 · Ciales, PRNTSB MIA68F0352Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRNTSB MIA67F0425Accident · Minor injuriesClosedPiper PA-28 · Fajardo, PRNTSB MIA67F0370Accident · No injuriesClosedPiper PA-28 · Arecibo, PRNTSB UNK64X4027Accident · Minor injuriesClosedPiper PA28 · Parguera, PRNTSB UNK64X2055Accident · No injuriesClosedPiper PA28 · Lobos Island, PR