Fatal NTSB investigations: Piper PA-24-250, PA
7 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1985 | 1 |
| 1989 | 1 |
Where
Latest 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\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'PA' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.NTSB NYC85FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Tioga, PAThe plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested…NTSB NYC75AN029Accident · 4 fatalClosedPiper PA-24 · Phillipsburg, PANTSB NYC72AN102Accident · 4 fatalClosedPiper PA-24 · Delmont, PANTSB NYC69A0076Accident · 2 fatalClosedPiper PA-24 · New Holland, PANTSB NYC69A0026Accident · 3 fatalClosedPiper PA-24 · Dallas, PANTSB NYC66A0089Accident · 4 fatalClosedPiper PA-24 · Hellam, PA