NTSB investigations: Piper PA-24-250, SC
14 cases on aircraft the registry lists as Piper PA-24-250. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2022 | 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 ('7102404'))
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 ('7102404'))
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 ERA23LA052Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Columbia, SCThe pilot’s failure to maintain directional control during the crosswind landing.NTSB ATL03FA041Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Florence, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.NTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…NTSB ATL85LA268Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Florence, SCThe plt was unable to extend the landing gear & performed a gear-up landing. Post accident examination revealed that the nose gear door was restricting the movement of the landing gear due to improper repair of the landing gear door attachment.NTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…NTSB ATL83FA081Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Beaufort, SCWhile en route in IMC, the ATC controller noted that the acft began to reverse course & asked the plt if he was having a problem. The plt responded that the acft was in clouds, he was having problem with his artificial horizon & that he didn't realize he was…NTSB MIA72FLG33Accident · Serious injuriesClosedPiper PA-24 · Greenville, SCNTSB MIA70AM098Accident · No injuriesClosedLockheed T-33A · Myrtle Beach, SCNTSB MIA68A0100Accident · 2 fatalClosedPiper PA-24 · Lancaster, SCNTSB UNK65X1246Accident · Minor injuriesClosedPiper PA24 · Jamestown, SCNTSB UNK65X0514Accident · No injuriesClosedPiper PA24 · Columbia, SCNTSB UNK64X1669Accident · No injuriesClosedPiper PA24 · Cheraw, SC