NTSB investigations: Piper PA-28R-180, OK
14 cases on aircraft the registry lists as Piper PA-28R-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
| 1968 | 1 |
|---|---|
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2004 | 1 |
| 2010 | 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\" = 'OK' 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 ('7102809'))
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" = 'OK' 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 ('7102809'))
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 CEN10LA303Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Kingfisher, OKThe pilot's inadequate airspeed while landing, which led to an aerodynamic stall and a hard landing.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.NTSB FTW91LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Eufaula, OKA restriction in the movement of the right rudder pedal. The restriction resulted from a passenger's inadvertent placement of an object on the cockpit's floor.NTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…NTSB FTW79DPJ03Accident · No injuriesClosedPiper PA-28R · Chattanooga, OKNTSB FTW76FPJ07Accident · Minor injuriesClosedPiper PA-28R · Cushing, OKNTSB FTW72FPJ41Accident · Minor injuriesClosedPiper PA-28R · Lindsay, OKNTSB FTW72DPM03Accident · No injuriesClosedPiper PA-28 · New Mannford, OKNTSB FTW70DPM01Accident · No injuriesClosedPiper PA-28R · Okmulgee, OKNTSB FTW70F0194Accident · Serious injuriesClosedPiper PA-28R · Mooreland, OKNTSB FTW69D0356Accident · No injuriesClosedPiper PA-28 · Claremore, OKNTSB FTW69F0279Accident · No injuriesClosedPiper PA-28 · Tulsa, OK