NTSB investigations: Piper PA-28R-180
8 cases on aircraft the registry lists as Piper PA-28R-180, 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
| 1982 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 1 |
| 1993 | 1 |
| 2004 | 2 |
| 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 ('7102809')
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 ('7102809')
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 MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.NTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…NTSB NYC04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Elyria, OHA loss of engine power for undetermined reasons.NTSB SEA93LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ephrata, WAUndetermined loss of power and the lack of suitable terrain. A factor contributing to the accident was dark night conditions.NTSB NYC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dansville, NYAbout 5 min after taking off, the eng began running rough, then lost power & would not restart. Subsequently, the acft was damaged drg an emerg lndg in a potato field. The acft was moved before aviation inspectors arrived. No fuel was fnd in the fuel pumps,…NTSB MIA86LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-R · Cedar Key, FLThe plt stated that he lost fuel pressure and all attempts to restart the acft were to no avail. He tried to make it to Cedar Key but was unable and ditched in the ocean waters 6 miles northwest of Cedar Key. Post crash examination of the fuel system revealed…NTSB FTW86LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-R-180 · Houston, TXPrivate pilot of a Piper PA-28R-180 departed runway 15 at west Houston airport (iws), Houston, Texas. Pilot stated he had departed runway 15 when engine quit at approximately 600 feet AGL. Pilot executed a forced landing approximately 2 miles off the…NTSB LAX82DA284Accident · No injuriesFinal reportPiper PA-28R · San Pedro, CAPilot was flying near catalina island and when he switched tanks the engine quit. Procedures to restart did not work so aircraft was ditched.