NTSB investigations: Piper PA-28R-200, KS
11 cases on aircraft the registry lists as Piper PA-28R-200. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2017 | 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 ('7102811'))
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 ('7102811'))
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 GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB CHI93FA135Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Kinsley, KSThe pilot initiated VFR flight into instrument meteorological conditions which resulted in a loss of aircraft control due to spatial disorientation. The adverse weather conditions were factors which contributed to the accident.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB MKC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gardner, KSThe pilot stated that he was landing on runway 8 with a right crosswind and had the right wing down for wind correction. The right wheel impacted a lip on the approach end of the runway, 6 inches below the level of the runway. The right gear collapsed, the…NTSB MKC84FA115Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Garden City, KSThe plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…NTSB MKC83FA066Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wichita, KSThe acft was cleared to make the approach and to descend not below 2300 ft. the pilot descended from 3000 after he reported passing hance, the final appoach fix. He descended to 2300 ft at 500 ft a minute and leveled the acft and lowered the landing gear. The…NTSB MKC81FCQ13Accident · Minor injuriesClosedPiper PA-28R · Agra, KSNTSB MKC73FCG29Accident · No injuriesClosedPiper PA-28R · Atchison, KSNTSB MKC73DCG20Accident · No injuriesClosedPiper PA-28 · Louisburg, KSNTSB MKC71FCG74Accident · No injuriesClosedPiper PA-28R · Garnett, KS