Fatal NTSB investigations: Piper J5A

15 cases on aircraft the registry lists as Piper J5A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Fatal NTSB investigations: Piper J5A per year, 1964–2026: 15 cases
1964	1
1966	1
1967	1
1969	1
1972	1
1975	1
1976	1
1981	1
1985	1
1991	2
1992	1
1994	1
2000	1
2023	1

Where

Open the map

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN23FA369Accident · 1 fatalClass 3 · FieldFinal reportPiper J5A · Iola, WIThe pilot’s failure to maintain control of the airplane after landing on a grass taxiway with a tailwind, which resulted in a nose over.Aug 19, 2023 · N35417 · Substantial damage NTSB CHI00FA237Accident · 1 fatalField investigationFinal reportPiper J-5A · Belton, MOThe student pilot not maintaining directional control during the takeoff roll resulting in the inadvertent ground loop.Aug 3, 2000 · N600F · Destroyed NTSB ATL94LA170Accident · 1 fatalLimited investigationFinal reportPiper J-5A · Raeford, NCThe pilot's ostentatious display which resulted in a loss of control of the airplane.Sep 8, 1994 · N31172 · Destroyed NTSB BFO93FA001Accident · 1 fatalField investigationFinal reportPiper J5A · Lumberton, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and an uncontrolled descent at an altitude not possible for recovery.Nov 2, 1992 · N37958 · Destroyed NTSB BFO91FA060Accident · 1 fatalField investigationFinal reportPiper J5 · Berlin, MDThe pilot's failure to maintain adeqate airspeed which caused the airplane to stall.Jun 29, 1991 · N763WM · Destroyed NTSB NYC91FA120Accident · 1 fatalField investigationFinal reportPiper J5A · Newbury, MAThe loss of inflight control, which was the result of a jammed right aileron bellcrank assembly. Factors related to the accident were; the improper maintenance of the flight control system, and the incomplete preflight by the pilot.Apr 23, 1991 · N35826 · Destroyed NTSB ANC85FA163Accident · 6 fatalField investigationFinal reportCessna 180H · Mt. Palmer, AKAircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact.Aug 25, 1985 · N417GP · 2 aircraft · Destroyed NTSB MIA81FA107Accident · 2 fatalClosedPiper J5A · Carrabelle, FLAug 22, 1981 · N41220 · Destroyed NTSB CHI76FEI28Accident · 1 fatalClosedPiper J5A · Lyons, OHApr 9, 1976 · N38241 · Destroyed NTSB MIA76AM027Accident · 1 fatalClosedPiper J5 · Immokale, FLSep 20, 1975 · N38866 · Destroyed NTSB SEA72AS049Accident · 1 fatalClosedPiper J5A · Spanaway, WAMay 5, 1972 · N38289 · Destroyed NTSB NYC70A0026Accident · 1 fatalClosedPiper J-5A · Kittanning, PAAug 23, 1969 · N38649 · Destroyed NTSB SEA68A0002Accident · 2 fatalClosedPiper J5A · Redmond, ORJul 1, 1967 · N35774 · Destroyed NTSB LAX66A0066Accident · 2 fatalClosedPiper J5A · Mc Farland, CAMar 6, 1966 · N54460 · Destroyed NTSB UNK64X1534Accident · 1 fatalClosedPiper J-5A · Paulina, ORApr 30, 1964 · N28260 · Destroyed