NTSB investigations: Piper PA-18-150, 2018

11 cases on aircraft the registry lists as Piper PA-18-150, where the sequence of events included Loss of control on ground. 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

20082026
NTSB investigations: Piper PA-18-150, 2018 per year, 2008–2026: 110 cases
20084
20096
20108
20118
20127
20137
20148
20156
20165
20173
201811
20199
20206
20217
20222
20234
20242
20255
20262

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\") = 2018
    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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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 GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.Oct 27, 2018 · N4500W · Substantial damageNTSB GAA18CA558Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent loss of directional control on an unimproved airstrip.Sep 13, 2018 · N7184B · Substantial damageNTSB GAA18CA525Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff.Sep 1, 2018 · N5373Y · Substantial damageNTSB ANC18CA068Accident · Minor injuriesData collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll when the left main landing gear wheel got caught in a ditch, which resulted in a subsequent nose-over.Aug 25, 2018 · N5392Y · Substantial damageNTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.Aug 20, 2018 · N6727A · Substantial damageNTSB GAA18CA497Accident · No injuriesData collectionFinal reportPiper PA18 · Stony RIver, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Aug 18, 2018 · N3872Z · Substantial damageNTSB GAA18CA520Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s failure to maintain directional control during landing in gusting wind conditions.Aug 15, 2018 · N4165Z · Substantial damageNTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.Jun 15, 2018 · N3764Z · Substantial damageNTSB GAA18CA303Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with a tailwind.May 27, 2018 · N4018E · Substantial damageNTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.May 7, 2018 · N2432H · Substantial damageNTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.Mar 30, 2018 · N101EB · Substantial damage