NTSB investigations: Piper PA-23-160, IL
16 cases on aircraft the registry lists as Piper PA-23-160. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2004 | 1 |
| 2005 | 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 ('7102304'))
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 ('7102304'))
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 CHI06FA030Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Bloomington, ILThe aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB CHI94LA351Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · West Chicago, ILthe pilot's failure to use the manual hydraulic pump to lower the landing gear. Factors were the failure of the fuel selector handle, the subsequent fuel starvation, and the pilot's failure to properly crossfeed and restart the left engine.NTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…NTSB CHI80FEE38Accident · No injuriesClosedPiper PA-23 · Waukegan, ILNTSB CHI78FA045Accident · 3 fatalClosedPiper PA-23 · Belleville, ILNTSB CHI77FEE52Accident · No injuriesClosedPiper PA-23 · Morris, ILNTSB CHI74FEV46Accident · No injuriesClosedPiper PA-23 · Sparta, ILNTSB CHI74DEE50Accident · No injuriesClosedPiper PA-23 · Wheeling, ILNTSB CHI73FEE42Accident · No injuriesClosedPiper PA-23 · Schaumburg, ILNTSB CHI72AC061Accident · 1 fatalClosedPiper PA-23 · St.Charles, ILNTSB CHI69F0221Accident · No injuriesClosedPiper PA-23 · Wheeling, ILNTSB CHI68F0601Accident · No injuriesClosedPiper PA-23 · Northbrook, ILNTSB CHI68D0130Accident · No injuriesClosedPiper PA-23 · Chicago, ILNTSB CHI66F0644Accident · No injuriesClosedPiper PA-23 · Elgin, ILNTSB UNK64X3137Accident · No injuriesClosedPiper PA23 · Quincy, IL