Skip to content

NTSB investigations: Piper PA-23-250, IL

26 cases on aircraft the registry lists as Piper PA-23-250. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('7102308')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102308'))
  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 ('7102308'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN15IA385Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Joliet, ILA bird strike.Aug 27, 2015 · N900AM · Minor damage NTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…Oct 26, 2014 · N62791 · Substantial damage NTSB CHI03FA047Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Barrington Hill, ILThe pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors.Jan 7, 2003 · N74AA · Substantial damage NTSB CHI98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Peoria, ILan improper preflight inspection of the airplane by the pilot and the inadvertant stall/mush which was encountered. A factor associated with this accident was the pilot's decision to continue to use the emergency hydraulic hand pump rather than the CO2 bottle…Feb 23, 1998 · N54231 · Substantial damage NTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.May 31, 1990 · N32AC · Substantial damage NTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…Jan 18, 1988 · N40265 · Destroyed NTSB CHI87DEE02Accident · No injuriesFinal reportPiper PA-23-250 · Crestwood, ILThe aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft.Oct 9, 1986 · N6955Y · Substantial damage NTSB CHI82FA025Accident · No injuriesField investigationFinal reportPiper 23-250 · Wheeling, ILShortly after takeoff the pilot noticed a loss of oil pressure on both engines and initiated a left turn back to the airport. During landing the aircraft departed the right side of runway 12, collided with, and substantially damaged two Cessna 150'S and…Jan 10, 1982 · N6995Y · Destroyed NTSB CHI81DEE24Accident · Minor injuriesClosedPiper PA-23 · Morris, ILMar 29, 1981 · N100BA · Substantial damage NTSB CHI77FEE10Accident · No injuriesClosedPiper PA-23 · Streator, ILMar 2, 1977 · N6050Y · Substantial damage NTSB CHI73FEV31Accident · No injuriesClosedPiper PA-23 · Springfield, ILJun 27, 1973 · N4506P · Substantial damage NTSB CHI73FEE55Accident · No injuriesClosedPiper PA-23 · Elgin, ILMay 2, 1973 · N6903Y · Substantial damage NTSB CHI73FEE34Accident · No injuriesClosedPiper PA-23 · Joliet, ILDec 7, 1972 · N6500D · Substantial damage NTSB CHI72DEE39Accident · No injuriesClosedPiper PA-23 · Streator, ILNov 2, 1971 · N5511Y · Substantial damage NTSB CHI70FBQ04Accident · No injuriesClosedPiper PA-23 · Peoria, ILFeb 2, 1970 · N5855Y · Substantial damage NTSB CHI70F0271Accident · No injuriesClosedPiper PA-23 · Elliot, ILSep 20, 1969 · N463CC · Destroyed NTSB CHI70D0219Accident · No injuriesClosedPiper PA-23 · Northbrook, ILAug 17, 1969 · N6924Y · Substantial damage NTSB CHI69D0661Accident · No injuriesClosedPiper PA-23 · Lansing, ILMay 5, 1969 · N6575Y · Substantial damage NTSB CHI69D0574Accident · No injuriesClosedPiper PA-23 · Elgin, ILMar 17, 1969 · N6633Y · Substantial damage NTSB CHI69A0061Accident · 1 fatalClosedPiper PA-23 · Chicago, ILDec 12, 1968 · N4878P · Destroyed NTSB CHI69F0315Accident · No injuriesClosedPiper PA-23 · Danville, ILSep 5, 1968 · N524PR · Substantial damage NTSB CHI68F0469Accident · No injuriesClosedPiper PA-23 · Cottage Hill, ILDec 5, 1967 · N148AF · Substantial damage NTSB CHI67A0019Accident · No injuriesClosedPiper PA-23 · Chicago, ILAug 5, 1966 · N6093Y · Substantial damage NTSB CHI65F0162Accident · No injuriesClosedPiper PA-23 · Wheeling, ILMar 21, 1965 · N4537P · Substantial damage NTSB UNK64X1798Accident · No injuriesClosedPiper PA23 · Utica, ILMay 17, 1964 · N4603P · Substantial damage NTSB UNK64X0882Accident · No injuriesClosedPiper PA23 · Wheeling, ILMar 11, 1964 · N4506P · Substantial damage