NTSB investigations: Piper PA-23, IL
16 cases on aircraft the registry lists as Piper PA-23. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 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\" = '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 ('7102302'))
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 ('7102302'))
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 CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…NTSB CHI79FEV29Accident · No injuriesClosedPiper PA-23 · Champaign, ILNTSB CHI78FEE64Accident · No injuriesClosedPiper PA-23 · Frankfort, ILNTSB CHI76FEE54Accident · No injuriesClosedPiper PA-23 · Crestwood, ILNTSB CHI75DEE37Accident · No injuriesClosedPiper PA-23 · Monee, ILNTSB CHI74AC009Accident · 1 fatalClosedPiper PA-23 · Chicago, ILNTSB CHI72FEE77Accident · No injuriesClosedPiper PA-23 · Spring Grove, ILNTSB CHI72FEV22Accident · Serious injuriesClosedPiper PA-23 · Springfield, ILNTSB CHI71FBD38Accident · No injuriesClosedPiper PA-23 · Chicago, ILNTSB CHI69D0330Accident · No injuriesClosedPiper PA-23 · Northbrook, ILNTSB CHI68A0092Accident · 1 fatalClosedPiper PA-23 · Warrensburg, ILNTSB CHI67F0606Accident · Serious injuriesClosedPiper PA-23 · Alsip, ILNTSB CHI68F0475Accident · No injuriesClosedPiper PA-23 · Cobden, ILNTSB CHI67F0062Accident · No injuriesClosedPiper PA-23 · East St Louis, ILNTSB UNK64X3835Accident · 3 fatalClosedPiper PA23 · Markham, ILNTSB UNK64X2000Accident · No injuriesClosedPiper PA23 · Elgin, IL