NTSB investigations: Piper PA-28-235, MO
16 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
| 1965 | 4 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1971 | 1 |
| 1972 | 2 |
| 1982 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2017 | 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\" = 'MO' 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" = 'MO' 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 CEN17LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-235 · Harrisonville, MOThe pilot's failure to maintain a safe distance between the airplane and a person on the ground, which resulted in serious injuries to the person.NTSB CEN16FA378Accident · 2 fatalField investigationFinal reportPiper PA 28-235 · Lee's Summit, MOThe pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.NTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.NTSB MKC82DA144Accident · No injuriesFinal reportPiper PA-28-235 · Springfield, MOAfter passing over an imaginary obstacle during a short field landing, the student flared high without adding sufficientpower causing the acft to increase the descent rate. The CFI took control but was too late resulting in a hard landing.NTSB MKC73FCA08Accident · No injuriesClosedPiper PA-28 · Berkeley, MONTSB MKC72FCG36Accident · Minor injuriesClosedPiper PA-28 · Columbia, MONTSB MKC72FCG07Accident · Serious injuriesClosedPiper PA-28 · Stockton, MONTSB MKC68F0403Accident · Serious injuriesClosedPiper PA-28 · Gower, MONTSB MKC68F0255Accident · No injuriesClosedPiper PA-28 · Rolla, MONTSB MKC67F0591Accident · No injuriesClosedPiper PA-28 · St Joseph, MONTSB MKC67F0218Accident · No injuriesClosedPiper PA-28 · Webb City, MONTSB MKC66F0413Accident · Minor injuriesClosedPiper PA-28 · Joplin, MONTSB MKC66A0329Accident · Serious injuriesClosedPiper PA-28 · Gravois Mills, MONTSB MKC66D0256Accident · No injuriesClosedPiper PA-28 · Sedalia, MONTSB MKC66D0138Accident · No injuriesClosedPiper PA-28 · Branson, MONTSB MKC65F0153Accident · No injuriesClosedPiper PA-28 · Webb City, MO