NTSB investigations: Piper PA-28-235
7 cases on aircraft the registry lists as Piper PA-28-235, where the first occurrence was “Hard landing”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1999 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.NTSB LAX94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lovelock, NVThat the pilot's failure to maintain adequate airspeed while on final approach which resulted in an inadvertent stall during the flare.NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.NTSB DEN89FA192Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Bullfrog, UTImproper flare by the pilot, his failure to maintain runway alignment, and the improper remedial action which resulted in a loss of control. The high density altitude and objects (runway light and smudge pot) were considered to be contributing factors.NTSB NYC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Toms River, NJThe flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings.NTSB FTW84LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Odessa, TXDuring the takeoff ground roll the plt noticed the inop airspeed indicator but continued the takeoff. The acft bounced during the long fast landing and traveled off the right side of the rwy. The plt corrected back to the left and the acft touchdown hard off…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.