Skip to content

NTSB investigations: Piper PA-30, IL

36 cases on aircraft the registry lists as Piper PA-30. 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 ('7103002')) 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 ('7103002'))
  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 ('7103002'))
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 CEN26FA064Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-30 · West Chicago, ILOn December 17, 2025, about 1349 central standard time, a Piper PA-30 airplane, N8693Y, was substantially damaged when it was involved in an accident near West Chicago, Illinois. The pilot and pilot-rated passenger were fatally injured. The airplane was…Dec 17, 2025 · N8693Y · Substantial damage NTSB CEN16FA276Accident · 1 fatalField investigationFinal reportPiper PA 30 · Plainfield, ILThe pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load…Jul 21, 2016 · N7409Y · Destroyed NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.May 11, 2006 · N8585Y · Substantial damage NTSB CHI88LA022Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Decatur, ILThe aircraft experienced a landing with the gear retracted. The pilot stated that he perceived the yellow light indication for the landing gear to mean 'down', instead of looking for a green light.Nov 10, 1987 · N7865Y · Substantial damage NTSB CHI82DA250Accident · No injuriesFinal reportPiper PA-30-160 · Salem, ILPilot stated he had 3 green gear lights. During touchdown and roll the landing gear collapsed. The landing gear control switch collar was defective and if the pilot did not hold the gear selector in the down position it may have returned to off before the…Jul 15, 1982 · N7047Y · Substantial damage NTSB CHI81FEE49Accident · No injuriesClosedPiper PA-30 · Aurora, ILJul 28, 1981 · N7676Y · Substantial damage NTSB CHI80FEE11Accident · No injuriesClosedPiper PA-30 · Chicago, ILDec 6, 1979 · N7119Y · Substantial damage NTSB CHI79FEE16Accident · No injuriesClosedPiper PA-30 · Kankakee, ILDec 16, 1978 · N8143Y · Substantial damage NTSB CHI78FEE58Accident · No injuriesClosedPiper PA-30 · Wheeling, ILJul 26, 1978 · N8788Y · Substantial damage NTSB CHI78DEE57Accident · No injuriesClosedPiper PA-30 · Monee, ILMar 6, 1978 · N8665Y · Substantial damage NTSB CHI76AC075Accident · 4 fatalClosedPiper PA-30 · Joliet, ILJul 1, 1976 · N7332Y · Destroyed NTSB CHI75AC092Accident · 4 fatalClosedPiper PA-30 · Marion, ILMay 31, 1975 · N7833Y · Destroyed NTSB CHI75FEE08Accident · No injuriesClosedPiper PA-30 · Chicago, ILAug 1, 1974 · N1188Y · Substantial damage NTSB CHI75AC010Accident · 2 fatalClosedPiper PA-30 · Urbana, ILJul 22, 1974 · N8724Y · Destroyed NTSB CHI74FEE66Accident · No injuriesClosedPiper PA-30 · Lansing, ILApr 17, 1974 · N7536Y · Substantial damage NTSB CHI74FEV32Accident · No injuriesClosedPiper PA-30 · Peoria, ILDec 23, 1973 · N7087Y · Substantial damage NTSB CHI72FEE83Accident · No injuriesClosedPiper PA-30 · Elgin, ILJun 19, 1972 · N7612Y · Destroyed NTSB CHI72DEV27Accident · No injuriesClosedPiper PA-30 · Urbana, ILApr 12, 1972 · N1188Y · Substantial damage NTSB CHI72AC077Accident · 2 fatalClosedPiper PA-30 · Vandalia, ILMar 29, 1972 · N8543Y · Destroyed NTSB CHI72FEV21Accident · No injuriesClosedPiper PA-30 · Effingham, ILJan 17, 1972 · N7216Y · Substantial damage NTSB CHI72FEV08Accident · No injuriesClosedPiper PA-30 · Bloomington, ILAug 6, 1971 · N7696Y · Substantial damage NTSB CHI70FBD22Accident · No injuriesClosedPiper PA-30 · Dixon, ILApr 3, 1970 · N7875Y · Substantial damage NTSB CHI70F0186Accident · No injuriesClosedPiper PA-30 · Chicago, ILAug 16, 1969 · N8492Y · Substantial damage NTSB CHI69F0085Accident · No injuriesClosedPiper PA-30 · Clinton, ILJul 8, 1968 · N7656Y · Substantial damage NTSB CHI68F0742Accident · No injuriesClosedPiper PA-30 · Wheeling, ILMay 11, 1968 · N7805Y · Substantial damage NTSB CHI68A0082Accident · 2 fatalClosedPiper PA-30 · Alton, ILMar 16, 1968 · N7643Y · Destroyed NTSB CHI68F0563Accident · No injuriesClosedPiper PA-30 · Bloomington, ILJan 24, 1968 · N7626Y · Substantial damage NTSB CHI67A0077Accident · Serious injuriesClosedPiper PA-30B · Bloomington, ILDec 16, 1966 · N8162Y · Substantial damage NTSB CHI67F0030Accident · No injuriesClosedPiper PA30 · Decatur, ILOct 24, 1966 · N7160Y · Substantial damage NTSB CHI67F0450Accident · No injuriesClosedPiper PA-30 · Albion, ILApr 26, 1966 · N7966Y · Substantial damage NTSB CHI66F0145Accident · No injuriesClosedPiper PA-30 · Wheeling, ILJul 23, 1965 · N7805Y · Substantial damage NTSB CHI66F0085Accident · No injuriesClosedPiper PA-30 · Chicago, ILJun 24, 1965 · N7544Y · Substantial damage NTSB CHI65F0139Accident · Minor injuriesClosedPiper PA-30 · Urbana, ILMar 9, 1965 · N7495Y · Substantial damage NTSB UNK65X1081Accident · No injuriesClosedPiper PA30 · Chicago, ILDec 21, 1964 · N7495Y · Substantial damage NTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, ILDec 1, 1964 · N7057Y · Destroyed NTSB UNK64X2695Accident · No injuriesClosedPiper PA30 · Lansing, ILJul 7, 1964 · N7139Y · Substantial damage