NTSB investigations: Piper PA-25, 1987
5 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\") = 1987
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") = 1987
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 ATL87LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCAfter about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage…NTSB FTW87DQG02Accident · No injuriesFinal reportPiper PA-25 · Lubbock, TXThe toe of the pilots left boot was rubbing on the dispensing hopper which restricted application of rudder and brake. This resulted in a loss of control when exiting the runway and the resultant collision with a sign. The fiberglass hopper had deep abrasions…NTSB DEN87LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Portales, NMThe plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…NTSB FTW87LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Jackson, LAEngine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.NTSB CHI87DER05Accident · Minor injuriesFinal reportPiper PA-25 · Henning, MNAfter experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…