NTSB investigations: Piper PA-28-180, SD
12 cases on aircraft the registry lists as Piper PA-28-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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 2024 | 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\" = 'SD' 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 ('7102808'))
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" = 'SD' 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 ('7102808'))
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 CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB CHI90LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sturgis, SDPoor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.NTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.NTSB DEN83FTK05Accident · Serious injuriesFinal reportPiper PA28-180C · Sturgis Muni., SDThe acft crashed on the approach end to runway 11 during an aborted landing. The plt stated the acft was high so he applied full power and retracted the flaps. He said he retracted the flaps too fast and lost control of the acft. The nose gear was broken off,…NTSB DEN81FTK13Accident · 1 fatalClosedPiper PA-28 · Rapid City, SDNTSB MKC77FA037Accident · 3 fatalClosedPiper PA-28 · Eagle Butte, SDNTSB MKC75DTK08Accident · Minor injuriesClosedPiper PA-28 · Dupree, SDNTSB MKC71DDQ15Accident · No injuriesClosedPiper PA-28 · Winner, SDNTSB MKC70F0182Accident · Minor injuriesClosedPiper PA-28 · Cottonwood, SDNTSB MKC70F0045Accident · No injuriesClosedPiper PA-28 · Rapid City, SDNTSB MKC69F0289Accident · Minor injuriesClosedPiper PA-28 · Spearfish, SDNTSB UNK64X0424Accident · No injuriesClosedPiper PA28 · Bowdle, SD