NTSB investigations: Piper PA-18-150

8 cases on aircraft the registry lists as Piper PA-18-150, where NTSB found Landing flare. 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

20092026
NTSB investigations: Piper PA-18-150 per year, 2009–2026: 8 cases
20091
20141
20151
20171
20191
20212
20241

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 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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062041')))
  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 ANC24LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Koliganek, AKThe pilot's improper landing flare and an improper recovery from a bounced landing, resulting in a loss of directional control, and a subsequent nose over.Jul 9, 2024 · N243AK · Substantial damageNTSB ANC21LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Glennallen, AKThe pilot’s improper landing flare while landing off-airport with a tailwind.Sep 1, 2021 · N8987Y · Substantial damageNTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.Mar 17, 2021 · N82479 · Substantial damageNTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.Aug 27, 2019 · N7184B · Substantial damageNTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.Aug 18, 2017 · N82912 · Substantial damageNTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.Mar 16, 2015 · N4785F · Substantial damageNTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.Feb 24, 2014 · N9563P · Substantial damageNTSB CEN10CA038Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Three Lakes, WIThe pilot's improper flare and touchdown during the water landing.Nov 1, 2009 · N4070Z · Substantial damage