NTSB investigations: Piper PA-25-235, TN
17 cases on aircraft the registry lists as Piper PA-25-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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 3 |
| 1981 | 1 |
| 1984 | 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\" = 'TN' 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 ('7102504'))
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" = 'TN' 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 ('7102504'))
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 ATL85LA024Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lincoln, TNThe acft was making a swath run spraying crops when the engine suddenly lost power with 200 yards of level field remaining for an emergency landing. After touchdown the plt turned the acft to avoid a collision with trees. During the turn the nose of the acft…NTSB ATL81FLT07Accident · No injuriesClosedPiper PA-25 · Pickwick Dam, TNNTSB IAD79DLT05Accident · No injuriesClosedPiper PA-25 · Covington, TNNTSB IAD79FLT02Accident · No injuriesClosedPiper PA-25 · Ridgely, TNNTSB IAD79FKW07Accident · No injuriesClosedPiper PA-25 · Sparta, TNNTSB IAD77DLT05Accident · No injuriesClosedPiper PA-25 · Trimble, TNNTSB IAD76FKW28Accident · No injuriesClosedPiper PA-25 · Springfield, TNNTSB IAD75DLT10Accident · No injuriesClosedPiper PA-25 · Montezuma, TNNTSB IAD75FLT03Accident · Serious injuriesClosedPiper PA-25 · Germantown, TNNTSB IAD75FLT01Accident · No injuriesClosedPiper PA-25 · Selmer, TNNTSB IAD74DLT02Accident · Serious injuriesClosedPiper PA-25 · Brownsville, TNNTSB IAD73FLT22Accident · No injuriesClosedPiper PA-25 · Silerton, TNNTSB MIA73DLT04Accident · No injuriesClosedPiper PA-25 · Jackson, TNNTSB MIA72DLT16Accident · Minor injuriesClosedPiper PA-25 · Trimble, TNNTSB MIA72FKW27Accident · No injuriesClosedPiper PA-25 · Athens, TNNTSB MIA72FKW04Accident · No injuriesClosedPiper PA-25 · Murfreesboro, TNNTSB MIA69F0090Accident · Serious injuriesClosedPiper PA-25 · Selmer, TN