Skip to content

NTSB investigations: Piper PA-32-300, IL

17 cases on aircraft the registry lists as Piper PA-32-300. 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

19672026

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 ('7103212')) 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 ('7103212'))
  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 ('7103212'))
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 CHI96FA309Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Crystal Lake, ILthe pilot's inadequate fuel management and which resulted in fuel system exhaustion. The factors involved were the pilot's failure to refuel, inadequate preflight planning/preparation and the dark night conditions encountered.Aug 19, 1996 · N823PJ · Destroyed NTSB CHI93LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Galesburg, ILThe departing pilot's (N251NW) inadequate visual lookout while operating in VFR conditions at an uncontrolled airport. Factors related to the accident were: the departing pilot's diverted attention, and the arriving pilot's (N2632U) inadequate visual lookout.Jun 18, 1993 · N2632U · 2 aircraft · Substantial damage NTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateMay 14, 1993 · N2947E · Substantial damage NTSB CHI89LA197Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lebanon, ILFailure of the pilot to use all available runway and his misjudgement of the available distance (runway length) for landing. Contributing factors were: inadequate preflight planning/preparation, and the runway and terrain conditions.Sep 28, 1989 · N1165X · Substantial damage NTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.Apr 2, 1988 · N32076 · Destroyed NTSB CHI85LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Lacon, ILWhile on final apch moderate turbulence was experienced. A 200 to 300 foot verticle loss of alt occurred. The plt added pwr and increased the pitch attitude. Before alt could be regained the acft contacted a utility pole. The apch was being made to rwy 18.…Mar 5, 1985 · N3012L · Substantial damage NTSB CHI79FA036Accident · 6 fatalClosedPiper PA-32 · Dekalb, ILMar 19, 1979 · N4047R · Destroyed NTSB CHI79FEE18Accident · No injuriesClosedPiper PA-32 · West Chicago, ILDec 7, 1978 · N4175R · Substantial damage NTSB CHI79FA003Accident · No injuriesClosedPiper PA-32 · Chicago, ILOct 4, 1978 · N5909V · Substantial damage NTSB CHI79FA008Accident · Minor injuriesClosedPiper PA-32 · Lansing, ILSep 25, 1978 · N44295 · Substantial damage NTSB CHI78FEV30Accident · No injuriesClosedPiper PA-32 · Urbana, ILApr 9, 1978 · N1BQ · Substantial damage NTSB CHI76FEE66Accident · Minor injuriesClosedPiper PA-32 · Rockford, ILJul 23, 1976 · N4177W · Substantial damage NTSB CHI76FEE59Accident · No injuriesClosedPiper PA-32 · Dwight, ILMay 21, 1976 · N9424K · Substantial damage NTSB CHI76FEE45Accident · No injuriesClosedPiper PA-32 · Chicago, ILMar 11, 1976 · N1956T · Substantial damage NTSB CHI76FEE40Accident · No injuriesClosedPiper PA-32 · Sugar Grove, ILJan 29, 1976 · N8955N · Substantial damage NTSB CHI76DEE27Accident · No injuriesClosedPiper PA-32 · Lansing, ILOct 22, 1975 · N4078R · Substantial damage NTSB CHI67F0479Accident · No injuriesClosedPiper PA-28 · Elgin, ILFeb 10, 1967 · N4011W · Substantial damage