NTSB investigations: Piper PA-28RT-201, IL
6 cases on aircraft the registry lists as Piper PA-28RT-201. 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
| 1980 | 1 |
|---|---|
| 1982 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 2004 | 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 ('7102818'))
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 ('7102818'))
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 CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…NTSB CHI96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wheeling, ILthe pilot's misjudgment of the landing flare.NTSB CHI93LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Streator, ILThe pilot's failure to perform a go-around. The tailwind and the pilot's selection of the downwind runway were factor.NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…NTSB CHI80DEE31Accident · No injuriesClosedPiper PA28RT · West Chicago, IL