NTSB investigations: Piper PA-28-235, IA
15 cases on aircraft the registry lists as Piper PA-28-235. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1978 | 1 |
| 1988 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2026 | 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\" = 'IA' 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 ('7102810'))
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" = 'IA' 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 ('7102810'))
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 CEN27LA019Accident · Minor injuriesClass 3 · LimitedInvestigation openPiper PA-28-235 · Cedar Rapids, IANTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.NTSB MKC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Leon, IAWhile cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine…NTSB MKC78FCD21Accident · Minor injuriesClosedPiper PA-28 · Fairfield, IANTSB MKC73DCD55Accident · No injuriesClosedPiper PA-28 · Wapello, IANTSB MKC73AK028Accident · 2 fatalClosedPiper PA-28 · Dubuque, IANTSB MKC73DCD14Accident · No injuriesClosedPiper PA-28 · Moorland, IANTSB MKC69F0231Accident · No injuriesClosedPiper PA-28 · Ottumwa, IANTSB MKC69A0023Accident · 2 fatalClosedPiper PA-28 · Osceola, IANTSB MKC68D0234Accident · No injuriesClosedPiper PA-28 · Swea City, IANTSB MKC67F0066Accident · Minor injuriesClosedPiper PA-28 · Onawa, IANTSB MKC65D0084Accident · No injuriesClosedPiper PA-28 · Sioux City, IANTSB UNK64X3082Accident · No injuriesClosedPiper PA28 · Iowa City, IA