NTSB investigations: Piper PA-18-150, 2010

8 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, 2010 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\") = 2010
    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 ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.Sep 17, 2010 · N9764P · Substantial damageNTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.Sep 6, 2010 · N9128D · Substantial damageNTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.Aug 27, 2010 · N9730P · Substantial damageNTSB CEN10CA473Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Watkins, COThe pilot's failure to maintain aircraft control during the landing, resulting in a ground-loop.Aug 5, 2010 · N8576Y · Substantial damageNTSB WPR10TA335Accident · No injuriesFinal reportPiper PA-18-150 · Dillon, MTThe pilot's failure to maintain directional control during landing.Jul 5, 2010 · N6110A · Substantial damageNTSB WPR10CA203Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Taft, CAThe pilot's loss of control during takeoff upon encountering a strong wind gust.Apr 11, 2010 · N2887P · Substantial damageNTSB ANC10TA028Accident · No injuriesFinal reportPiper PA-18-150 · Stony River, AKThe pilot's failure to maintain directional control of the airplane during taxi from landing, which resulted in the airplane sliding into trees.Apr 3, 2010 · N82732 · Substantial damageNTSB ANC10TA017Accident · No injuriesFinal reportPiper PA-18-150 · King Cove, AKA total loss of engine power due to the pilot's failure to use carburetor heat in conditions conducive to carburetor ice.Feb 11, 2010 · N278Z · Substantial damage