NTSB investigations: Piper PA-24-250, IA
19 cases on aircraft the registry lists as Piper PA-24-250. 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 | 3 |
| 1968 | 2 |
| 1970 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 4 |
| 1977 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1997 | 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 ('7102404'))
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 ('7102404'))
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 CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB MKC81DCD12Accident · No injuriesClosedPiper PA-24 · Charles City, IANTSB MKC77DCD39Accident · No injuriesClosedPiper PA-24 · Council Bluffs, IANTSB MKC75FCD21Accident · No injuriesClosedPiper PA-24 · Elkader, IANTSB MKC75FCD02Accident · No injuriesClosedPiper PA-24 · Hillsboro, IANTSB MKC74DCD38Accident · No injuriesClosedPiper PA-24 · Urbandale, IANTSB MKC74DCD24Accident · Minor injuriesClosedPiper PA-24 · Dubuque, IANTSB MKC74AK013Accident · 1 fatalClosedPiper PA-24 · Council Bluf, IANTSB MKC72DCD16Accident · No injuriesClosedPiper PA-24 · Estherville, IANTSB MKC71DCD50Accident · No injuriesClosedPiper PA-24 · Iowa City, IANTSB MKC70DCD17Accident · No injuriesClosedPiper PA-24 · Monticello, IANTSB MKC70DCD03Accident · No injuriesClosedPiper PA-24 · West Union, IANTSB MKC69F0302Accident · No injuriesClosedPiper PA-24 · Paullina, IANTSB MKC69F0187Accident · No injuriesClosedPiper PA-24 · Newton, IANTSB MKC66F0351Accident · No injuriesClosedPiper PA-24 · Jefferson, IANTSB MKC66D0298Accident · No injuriesClosedPiper PA-24 · Guthrie Cntr, IANTSB MKC66D0076Accident · No injuriesClosedPiper PA-24 · Waterloo, IANTSB UNK64X3342Accident · No injuriesClosedPiper PA24 · Kalona, IA