NTSB investigations: Piper PA-18-150, 2003

6 cases on aircraft the registry lists as Piper PA-18-150, where the first occurrence was “On ground/water encounter with terrain/water”. 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

19842026
NTSB investigations: Piper PA-18-150, 2003 per year, 1984–2026: 32 cases
19841
19881
19892
19931
19941
19953
19962
19982
19992
20002
20022
20036
20043
20052
20072

Latest 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\") = 2003
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101828', '7104221', '7102835')
      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\" = 320))
  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.

NTSB ANC03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a nose over. A factor contributing to the accident was the soft sand of the sandbar.Aug 10, 2003 · N3695P · Substantial damageNTSB ANC03CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over.Jul 17, 2003 · N83582 · Substantial damageNTSB ANC03TA072Accident · No injuriesFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with high brush.Jul 9, 2003 · N7051 · Substantial damageNTSB ANC03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Kenai, AKThe pilot's failure to compensate for gusting wind conditions during the landing flare, which resulted in the airplane encountering brush, and nosing over. Factors contributing to the accident were high brush, and gusting winds.May 17, 2003 · N814JM · Substantial damageNTSB ANC03LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with soft snow, and subsequent nose over during the landing roll. A factor contributing to the accident was the soft, snow-covered terrain.Mar 28, 2003 · N4448Z · Substantial damageNTSB ANC03LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain aircraft control which resulted in a nose over. A factor contributing to the accident was standing puddles of water on the frozen lake.Feb 11, 2003 · N4492A · Substantial damage