NTSB investigations: Piper PA-24-250, KY
16 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 | 3 |
| 1966 | 1 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1992 | 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\" = 'KY' 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" = 'KY' 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 BFO92LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Falmouth, KYThe pilot misjudged the airplane's altitude and distance in reference to the runway. Contributing to the accident was the fuel system leak.NTSB ATL88FA040Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Lewisburg, KYThe pilot experienced a loss of engine power at 5500 feet. He was not able to start the engine after completing an emergency procedure. The pilot established an approach to a landing area, and stalled the aircraft on short final. The aircraft moved about 30…NTSB ATL85LA066Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Knox, KYN6666P, contacted the ground 100 yds short of rwy 36 during landing at Ft Knox, KY, while on a personal flight. The acft sustained substantial damage to the nose, left main landing gear, both wings and the propeller. Investigation revealed the acft exceeded…NTSB IAD79FLQ19Accident · Minor injuriesClosedPiper PA-24 · Somerset, KYNTSB IAD76FLQ24Accident · Serious injuriesClosedPiper PA-24 · Cold Springs, KYNTSB IAD74FLQ01Accident · No injuriesClosedPiper PA-24 · Louisville, KYNTSB CHI72FLQ48Accident · Minor injuriesClosedPiper PA-24 · Winchester, KYNTSB CHI72AC014Accident · 2 fatalClosedPiper PA-24 · Bardstown, KYNTSB CHI71DLQ19Accident · No injuriesClosedPiper PA-24 · Frankfort, KYNTSB CHI67D0620Accident · No injuriesClosedPiper PA-24 · London, KYNTSB CHI67D0246Accident · No injuriesClosedPiper PA-24 · Lancaster, KYNTSB CHI66F0083Accident · No injuriesClosedPiper PA-24 · Winchester, KYNTSB CHI66F0001Accident · No injuriesClosedPiper PA-24 · Louisville, KYNTSB CHI65F0096Accident · No injuriesClosedPiper PA-24 · Monticello, KYNTSB UNK64X2677Accident · No injuriesClosedPiper PA24 · Lexington, KYNTSB UNK64X0894Accident · No injuriesClosedPiper PA24 · Louisville, KY