NTSB investigations: Piper PA-18-150, 2020

6 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, 2020 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\") = 2020
    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 ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.Oct 8, 2020 · N8788D · Substantial damageNTSB ANC20CA096Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chitina, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Sep 12, 2020 · N416RK · Substantial damageNTSB ANC20CA076Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a runway excursion and collision with trees.Aug 4, 2020 · N82566 · Substantial damageNTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.Jul 29, 2020 · N1049P · Substantial damageNTSB ANC20CA048Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Skwentna, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.May 16, 2020 · N323DH · Substantial damageNTSB WPR20CA134Accident · Minor injuriesData collectionFinal reportPiper PA18 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a roll-over.Apr 25, 2020 · N707VB · Substantial damage