NTSB investigations: Piper PA-28, CA
12 cases on aircraft the registry lists as Piper PA-28. 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 | 5 |
| 1968 | 1 |
| 1970 | 2 |
| 1974 | 1 |
| 1985 | 1 |
| 2016 | 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\" = 'CA' 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 ('7102801'))
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" = 'CA' 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 ('7102801'))
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 WPR16FA103Accident · Serious injuriesField investigationFinal reportPiper PA28 · Pomona, CAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB LAX85LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Springville, CAAfter overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…NTSB OAK74AP067Accident · 2 fatalClosedPiper PA-28 · Glen Ellen, CANTSB OAK70FVM23Accident · No injuriesClosedPiper PA-28 · San Jose, CANTSB LAX70FUQ21Accident · No injuriesClosedPiper PA-28 · Santa Susana, CANTSB OAK69D0063Accident · No injuriesClosedPiper PA-28 · Novato, CANTSB LAX66D0142Accident · No injuriesClosedPiper PA-28 · Ridgecrest, CANTSB LAX66D0086Accident · No injuriesClosedPiper PA-28 · Santa Susana, CANTSB OAK65F0066Accident · Serious injuriesClosedPiper PA28 · Vacaville, CANTSB LAX65F0045Accident · Serious injuriesClosedPiper PA-28 · Acton, CANTSB OAK65A0055Accident · 4 fatalClosedPiper PA28 · Hayward, CANTSB UNK64X2295Accident · 1 fatalClosedPiper PA-28 · Monterey, CA