NTSB investigations: Piper PA-28-151, IA
9 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1998 | 2 |
| 2010 | 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 ('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" = '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 ('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 CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.NTSB CHI98LA252Accident · Serious injuriesLimited investigationFinal reportPiper PA28-151 · Anthon, IAThe pilot-in-command's improper preflight planning, preparation and fuel management resulting in an unscheduled landing and impact with a pole.NTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.NTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.NTSB MKC89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Rapids, IAWhile conducting a part 135 air taxi operation, the pilot said his engine began running rough about 7 miles from his destination apt. Emergency procedures were initiated and a call to the control tower declaring an emergency was made. Unable to reach the apt,…NTSB MKC87FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Maquoketa, IAAfter departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft…NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…NTSB MKC76FCD51Accident · Serious injuriesClosedPiper PA-28 · Cedar Falls, IANTSB MKC76DCD09Accident · No injuriesClosedPiper PA-28 · Riceville, IA