NTSB investigations: Piper PA-28-160
6 cases on aircraft the registry lists as Piper PA-28-160, where the first occurrence was “Loss of engine power”. 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
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102806')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102806')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 NYC05LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Cameron, WVA loss of engine power due to carburetor icing, which resulted in a forced landing. A factor in this accident was the carburetor icing conditions.NTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.NTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.NTSB FTW94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Tulsa, OKThe loss of engine power for undetermined reasons. The lack of terrain suitable for a forced landing was a factor.NTSB LAX87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Redlands, CADuring a pleasure cross-country flt, the plt reported that he was descending from 8500 ft MSL to 4000 ft MSL with power reduced to 2000 RPM. The plt stated that he did not use the carburetor heat while descending. When pwr was added, the eng did not respond.…NTSB ATL86LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Dozier, ALThe private plt and his pax were on a night cross country flt when he ran one fuel tank dry and the eng sputtered. He switched to the other tank and the eng caught for a few seconds then quit. He let down over a heavily forested area and stalled the acft into…