NTSB investigations: Piper PA-24, OH
19 cases on aircraft the registry lists as Piper PA-24. 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 | 2 |
|---|---|
| 1966 | 4 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 2 |
| 1985 | 1 |
| 1992 | 1 |
| 2009 | 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\" = 'OH' 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 ('7102402'))
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" = 'OH' 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 ('7102402'))
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 CEN09CA378Accident · No injuriesData collectionFinal reportPiper PA-24 · Urbana, OHA failure of the carburetor heat cable attach bracket which resulted in the inadvertent activation of carburetor heat and the subsequent loss of engine power during takeoff. Contributing to the accident was the pilot's operation of the aircraft with a known…NTSB BFO92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Carollton, OHThe pilot's inadequate starting procedure.NTSB CHI85FA137Accident · 1 fatalField investigationFinal reportPiper PA-24 · Toledo, OHThe plt was obsvd taking medication within 2 hrs bfr flt. A witness identified 1 pill as darvocet-n 100, since she took the same medication. When the plt started the eng, it went to a very hi RPM, as if the throttle was too FAR open. While taxiing to takeoff,…NTSB CHI75FEI46Accident · Serious injuriesClosedPiper PA-24 · Bowling Green, OHNTSB CHI75FEI40Accident · No injuriesClosedPiper PA-24 · Middlefield, OHNTSB CHI73FEI33Accident · No injuriesClosedPiper PA-24 · U.Sandusky, OHNTSB CHI73DEK11Accident · No injuriesClosedPiper PA-24 · Bryan, OHNTSB CHI73AC020Accident · 2 fatalClosedPiper PA-24 · Ada, OHNTSB CHI72FEG18Accident · No injuriesClosedPiper PA-24 · Piqua, OHNTSB CHI71AC067Accident · 2 fatalClosedPiper PA-24 · Thornville, OHNTSB CHI70F0209Accident · No injuriesClosedPiper PA-24 · Middletown, OHNTSB CHI70DGG09Accident · No injuriesClosedPiper PA-24 · Columbus, OHNTSB CHI68F0652Accident · No injuriesClosedPiper PA-24 · Chesapeake, OHNTSB CHI67D0369Accident · No injuriesClosedPiper PA-24 · N, OHNTSB CHI67F0194Accident · No injuriesClosedPiper PA-24 · Blue Ash, OHNTSB CHI67A0026Accident · 2 fatalClosedPiper PA-24 · New Lexingtn, OHNTSB CHI67D0250Accident · No injuriesClosedPiper PA-24 · Mcclure, OHNTSB CHI66F0120Accident · No injuriesClosedPiper PA-24 · Canton, OHNTSB CHI66F0111Accident · No injuriesClosedPiper PA-24 · Dayton, OH