NTSB investigations: Piper PA-24, IL
13 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
| 1964 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1987 | 1 |
| 2004 | 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\" = 'IL' 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" = 'IL' 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 CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB CHI88LA031Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, ILEarlier in the day, the acft was flown from Danville to rochelle, IL. While on a return flt without refueling, the eng began losing power, so the plt moved the fuel selector to the rgt tank (which indcd 1/4 full) & power was restored. However, about 2 min…NTSB CHI80FEE07Accident · No injuriesClosedPiper PA-24 · Chicago, ILNTSB CHI76AC021Accident · 2 fatalClosedPiper PA-24 · Wheeling, ILNTSB CHI73DEE47Accident · No injuriesClosedPiper PA-24 · Roselle, ILNTSB CHI72AC094Accident · 4 fatalClosedPiper PA-24 · Ramsey, ILNTSB CHI72FEV30Accident · No injuriesClosedPiper PA-24 · Paloma, ILNTSB CHI70D0286Accident · No injuriesClosedPiper PA-24 · Kankakee, ILNTSB CHI69A0084Accident · 4 fatalClosedPiper PA-24 · Aledo, ILNTSB CHI69D0372Accident · No injuriesClosedPiper PA-24 · Roselle, ILNTSB CHI68F0135Accident · No injuriesClosedPiper PA-24 · Valmeyer, ILNTSB UNK65X0325Accident · No injuriesClosedPiper PA24 · Naperville, ILNTSB UNK65X0191Accident · No injuriesClosedPiper PA-24 · Benton, IL