NTSB investigations: Piper J5A

7 cases on aircraft the registry lists as Piper J5A, where the first occurrence was “Loss of engine power”. 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

19822026

NTSB investigations: Piper J5A per year, 1982–2026: 7 cases
1982	1
1997	1
1998	1
1999	1
2001	2
2002	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100702')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.May 26, 2002 · N38399 · Substantial damage NTSB CHI01LA125Accident · No injuriesLimited investigationFinal reportPiper J5A · Brussels, ILthe partial loss of engine power for undetermined reasons and the high vegitation encountered during the precautionary landing.May 17, 2001 · N38646 · Substantial damage NTSB MIA01LA083Accident · No injuriesLimited investigationFinal reportPiper J5A · Hollywood, FLthe pilot's improper inflight planning/decision and inadequate fuel consumption calculations that resulted in fuel exhaustion and substantial damage to the aircraft as a result of a hard landing during the emergency descent/landing.Feb 15, 2001 · N35288 · Substantial damage NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.Mar 15, 1999 · N40888 · Substantial damage NTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.Jan 20, 1998 · N38645 · Substantial damage NTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.May 29, 1997 · N31164 · Substantial damage NTSB MIA82DA106Accident · No injuriesFinal reportPiper J5A · Tampa, FLThe pilot reported that the engine malfunctioned while he was on a VFR flight. He stated that he applied carburetor heat as well as other measures to restore power. The malfunction persisted, and the plane was substantially damaged during a forced landing…Apr 22, 1982 · N41141 · Substantial damage