NTSB investigations: Piper J5A

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

19832026

NTSB investigations: Piper J5A per year, 1983–2026: 6 cases
1983	1
1984	1
1992	1
2002	1
2003	1
2006	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" = 353)) 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\" = 353))
  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" = 353))
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 ANC06LA129Accident · No injuriesLimited investigationFinal reportPiper J5A · North Pole, AKThe pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.Aug 30, 2006 · N35395 · Substantial damage NTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.Sep 10, 2003 · N33063 · Substantial damage NTSB ANC03LA016Accident · No injuriesLimited investigationFinal reportPiper J5A · Soldotna, AKThe pilot's failure to remove all water from the airplane's fuel supply during the preflight inspection, which resulted in a loss of engine power and subsequent hard landing.Dec 1, 2002 · N270JS · Substantial damage NTSB SEA92LA081Accident · No injuriesLimited investigationFinal reportPiper J-5A · Broadus, MTFuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.Apr 17, 1992 · N35931 · Substantial damage NTSB MKC85FA022Accident · No injuriesField investigationFinal reportPiper J5A · Stuttgart, ARThe acft was being ferried x-country in legs of approximately 2 hrs flt duration. The acft was refueled for the next legand it needed 18 gallons of fuel. The plt was predicting a burn of 5-6 gallons of fuel per hour. After a flt of 2 hrs and 17 minutes with…Nov 19, 1984 · N35786 · Substantial damage NTSB ATL84LA027Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Arlington, TNAccording to both occupants, the eng lost power during takeoff at night. Subsequently, the acft was damaged when it hit a fence & metal pole during an emergency landing. No preimpact part failure or malfunction was found. The rear seat occupant, a female plt,…Oct 22, 1983 · N35280 · Substantial damage