NTSB investigations: Piper PA-28R-200, SC
13 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
| 1973 | 1 |
|---|---|
| 1975 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 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\" = 'SC' 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" = 'SC' 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 ERA12LA267Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eastover, SCInadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…NTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB ATL04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Columbia, SCThe pilot's mismanagement of the fuel supply, and his inadequate preflight planning which resulted in fuel exhaustion.NTSB ATL83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hampton, SCThe left main landing gear of the aircraft collapsed during a hard landing. The pilot stated that he cleared tall pine trees north of the runway at about 90 mhp (78 KTS). Shortly thereafter the aircraft started to sink 'real fast'. The pilot stated that he…NTSB ATL83FLG03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Cleveland, SCThe plt stated he was VFR on top of a broken cloud layer & decided to descend through an opening. After descending clear of the clouds he was in a pass with hills on each side & not enough room to turn around. He continued north along the highway hoping the…NTSB ATL81FA041Accident · No injuriesClosedPiper PA-28R · Roebuck, SCNTSB ATL80DLG10Accident · No injuriesClosedPiper PA-28R · Sumter, SCNTSB MIA79FLG22Accident · Minor injuriesClosedPiper PA-28 · Ridgeland, SCNTSB MIA76DLG20Accident · Minor injuriesClosedPiper PA-28R · Florence, SCNTSB MIA76FLG16Accident · Minor injuriesClosedPiper PA-28R · Surfside, SCNTSB MIA75FLG22Accident · No injuriesClosedPiper PA-28R · Myrtle Beach, SCNTSB MIA74FLG17Accident · No injuriesClosedPiper PA-28R · Winnsboro, SC