NTSB investigations: Piper PA-22-150, KY
14 cases on aircraft the registry lists as Piper PA-22-150. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 2 |
| 1999 | 1 |
| 2003 | 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 ('7102210'))
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 ('7102210'))
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 NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.NTSB NYC99FA236Accident · 2 fatalField investigationFinal reportPiper PA 22-150 · Goshen, KYA loss of engine power for undetermined reasons which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the down-sloping terrain.NTSB IAD78FLQ20Accident · Serious injuriesClosedPiper PA-22 · Hazard, KYNTSB IAD78FLQ14Accident · Minor injuriesClosedPiper PA-22 · Crestview Hill, KYNTSB IAD76FLQ10Accident · No injuriesClosedPiper PA-22 · Lagrange, KYNTSB IAD74FLQ40Accident · Minor injuriesClosedPiper PA-22 · Elizabethtown, KYNTSB CHI72FLQ21Accident · No injuriesClosedPiper PA-22 · Albany, KYNTSB CHI72DLQ02Accident · No injuriesClosedPiper PA-22 · Russell Sprgs, KYNTSB CHI71DGJ04Accident · No injuriesClosedPiper PA-22 · Somerset, KYNTSB CHI69D0097Accident · No injuriesClosedPiper PA-22 · Salyersville, KYNTSB CHI67A0130Accident · Serious injuriesClosedPiper PA-22 · Barrier, KYNTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYNTSB CHI66D0737Accident · No injuriesClosedPiper PA-22 · Flemingsburg, KYNTSB CHI66F0079Accident · No injuriesClosedPiper PA-22 · Columbia, KY