NTSB investigations: Piper PA-28R-180, KS
9 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 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 2015 | 1 |
| 2019 | 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\" = 'KS' 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" = 'KS' 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 CEN20CA052Accident · No injuriesData collectionFinal reportPiper PA28R · Onaga, KSThe pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.NTSB CEN15LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-180 · Haviland, KSThe loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…NTSB MKC86LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Olathe, KSThe pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He…NTSB MKC81DCQ20Accident · No injuriesClosedPiper PA-28R · Baxter Springs, KSNTSB MKC78DCQ28Accident · Minor injuriesClosedPiper PA-28R · Smith Center, KSNTSB MKC71AK058Accident · 1 fatalClosedPiper PA-28R · Medicine Lge, KSNTSB MKC71DCQ16Accident · Minor injuriesClosedPiper PA-28R · Concordia, KSNTSB MKC70F0042Accident · Minor injuriesClosedPiper PA-28R · Olathe, KSNTSB MKC69F0210Accident · Serious injuriesClosedPiper PA-28 · Bonner Sprgs, KS