NTSB investigations: Piper PA-28-151, IL
16 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1974 | 2 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2020 | 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 ('7102805', '7104223'))
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 ('7102805', '7104223'))
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 CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.NTSB CHI90LA169Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ILFuel exhaustion. A factor in the accident was inaccurate fuel consumption calculations by the pilot.NTSB CHI90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeport, ILThe pilot-in-command's failure to properly judge the clearance between his airplane and a parked vehicle.NTSB CHI89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fairview Hts., ILFuel exhaustion due inaccurate fuel consumption calculations.NTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…NTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…NTSB CHI81DEE31Accident · No injuriesClosedPiper PA-28 · Chicago, ILNTSB CHI78FEE34Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI78DEE26Accident · No injuriesClosedPiper PA-28 · Rockton, ILNTSB CHI77FA058Accident · 1 fatalClosedPiper PA-28 · Clayton, ILNTSB CHI76DEV51Accident · No injuriesClosedPiper PA-28 · Newton, ILNTSB CHI75AC084Accident · 2 fatalClosedPiper PA-28 · Peoria, ILNTSB CHI75FEE32Accident · Minor injuriesClosedPiper PA-28 · Lansing, ILNTSB CHI75AC018Accident · 2 fatalClosedPiper PA-28 · Donnellson, IL