NTSB investigations: Piper PA-25, 1983
6 cases on aircraft the registry lists as Piper PA-25. 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 | 26 |
|---|---|
| 1965 | 13 |
| 1966 | 22 |
| 1967 | 26 |
| 1968 | 26 |
| 1969 | 10 |
| 1970 | 15 |
| 1971 | 13 |
| 1972 | 12 |
| 1973 | 14 |
| 1974 | 12 |
| 1975 | 15 |
| 1976 | 12 |
| 1977 | 7 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 6 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2009 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102502'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102502'))
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 NYC84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-25 · West Mifflin, PAThe pilot said that prior to departure he visually checked the tanks, found fuel in the tanks and the fuel indicator working properly. On final aprch at destination, the engine stopped and the acft landed in trees aprx 2 miles short of the rwy. During post…NTSB CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.NTSB DEN83LA178Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Fowler, COThe plt & the owner thought there was enough fuel remaining for about 1 hr of aerial application. During a procedure turn, aprx 45 min after takeoff, the eng lost power. The plt reported he tried to start the eng, but the acft was so low that he didn't have…NTSB CHI83LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Morgan, MNThe acft collided with trees while turning during aerial application. The pilot reported that the acft controls felt soft. Thinking he was stalling he reduced bank, lowered the nose and at 85 mph indicated with full power continued levelflt until a wing hit a…NTSB FTW83LA284Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Abilene, TXThe agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…NTSB LAX83LA278Accident · No injuriesLimited investigationFinal reportPiper PA-25 · New River, AZThe pilot stated that he refueled his aircraft and secured the gas cap after which he made four fifteen minutes aero tow flights. During the fifth aero tow, as the aircraft was climbing, the pilot heard an object strike the wind shield and he saw that the gas…