NTSB investigations: Piper PA-28-235, OK
11 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 |
|---|---|
| 1966 | 1 |
| 1972 | 1 |
| 1979 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2011 | 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\" = 'OK' 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" = 'OK' 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 GAA18CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Pocasset, OKThe pilot’s improper approach path, which resulted in the airplane landing short of the runway.NTSB CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…NTSB FTW96LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Tulsa, OKlow fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.NTSB FTW95LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hobart, OKThe pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.NTSB FTW82DA106Accident · Minor injuriesFinal reportPiper PA-28-235 · Tulsa, OKThe aircraft experienced a partial power loss during takeoff at an altitude of about 150 AGL. The pilot turned left with the intention of landing on a perpendicular taxiway. During the turn the aircraft developed a high sink-rate and struck the taxiway in a…NTSB FTW81FPM13Accident · Minor injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW81FPJ09Accident · No injuriesClosedPiper PA-28 · Enid, OKNTSB FTW79FPJ12Accident · 1 fatalClosedPiper PA-28 · Purcell, OKNTSB FTW73DPJ05Accident · No injuriesClosedPiper PA-28 · Yukon, OKNTSB FTW66F0615Accident · No injuriesClosedPiper PA-28 · Stilwell, OKNTSB UNK64X3773Accident · No injuriesClosedPiper PA28 · Kingston, OK