Skip to content

NTSB investigations: Piper PA-18-150, AZ

30 cases on aircraft the registry lists as Piper PA-18-150. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' 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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    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'))
  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.

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."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
  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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.Jul 21, 2014 · N3997Z · Substantial damage NTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.Jul 11, 2014 · N83447 · Substantial damage NTSB WPR14CA109Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Willcox, AZThe pilot's decision to land off airport on unsuitable terrain that resulted in a collision with hidden objects.Jan 26, 2014 · N9683P · Substantial damage NTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.Apr 27, 2011 · N9683P · Substantial damage NTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damage NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.Jan 29, 2006 · N62712 · Substantial damage NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.Mar 22, 2005 · N4101E · Substantial damage NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.Nov 6, 2004 · N6854P · Destroyed NTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.May 19, 2004 · N62712 · Substantial damage NTSB LAX03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZthe CFI's inadequate supervision and delayed decision to abort the takeoff resulted in the runway overrun.Mar 1, 2003 · N62712 · Substantial damage NTSB LAX01LA180Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Tucson, AZThe pilot's inadequate preflight inspection, which included verifying the position of the fuel selector handle, which subsequently led to fuel starvation and a forced landing.May 18, 2001 · N8524Y · Substantial damage NTSB LAX00LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Scottsdale, AZFailure of the pilot to maintain directional control on the landing rollout. Also causal to the accident was his failure to retract flaps during the aborted landing attempt, which lead to a loss of lift and a hard landing followed by a ground loop.Aug 21, 2000 · N91003 · Substantial damage NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.May 9, 2000 · N7345Z · Substantial damage NTSB LAX98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sedona, AZThe pilot's failure to maintain directional control during the landing rollout. A factor was the gusty wind.May 23, 1998 · N4101E · Substantial damage NTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.Aug 18, 1997 · N57528 · Substantial damage NTSB LAX97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZfailure of the student pilot to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight. The student's diverted attention was a related factor.Jan 15, 1997 · N4101E · Substantial damage NTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…Dec 4, 1993 · N4417Z · Destroyed NTSB LAX90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bumble Bee, AZThe failure of the student pilot to apply carburetor heat in a timely manner. Contributing to the accident were the carburetor icing conditions and the desert terrain.Dec 19, 1989 · N4101E · Substantial damage NTSB LAX88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casa Grande, AZDuring an instructional flt, the student was performing climbs, descents and turns when the engine sputtered and lost power. The flight instructor took control of the aircraft but was unable to restart the engine. The aircraft was landed on a dirt road where…Oct 28, 1987 · N4101E · Substantial damage NTSB LAX87LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZAt the end of a local pleasure flight, the pilot attempted a downwind landing by following other traffic in the pattern. During touchdown, the left wing lifted. The pilot corrected by moving the control stick to the left. At that time, the aircraft became…Nov 17, 1986 · N4101E · Substantial damage NTSB LAX83LA376Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Flagstaff, AZThe plt reported that during a pleasure flt, when he was flying over rising terrain north of Flagstaff, AZ, he realized a need for more altitude. He turned toward a downhill direction, but the acft crashed into the tree tops when he was unable to maintain…Aug 6, 1983 · N7699Y · Substantial damage NTSB LAX82DA157Accident · No injuriesFinal reportPiper PA-18-150 · Chandler, AZDuring landing roll the pilot stated that a gust of wind or a dust devil picked up the left wing and turned the aircraft to the right. The aircraft departed the runway and went into a small plowed field coming to rest in the opposite direction of the runway.May 1, 1982 · N82016 · Substantial damage NTSB LAX80FUJ90Accident · No injuriesClosedPiper PA-18 · Mesa, AZAug 6, 1980 · N82016 · Substantial damage NTSB LAX79DUJ20Accident · No injuriesClosedPiper PA-18 · Eloy, AZNov 27, 1978 · N4090E · Substantial damage NTSB LAX77DUJ14Accident · No injuriesClosedPiper PA-18 · Phoenix, AZDec 5, 1976 · N83480 · Substantial damage NTSB LAX74AL026Accident · 2 fatalClosedPiper PA-18 · Tacna, AZOct 4, 1973 · N4265Z · Substantial damage NTSB LAX69D0192Accident · No injuriesClosedPiper PA-18 · Benson, AZNov 6, 1968 · N4129Z · Substantial damage NTSB LAX69A0022Accident · 2 fatalClosedPiper PA-18 · Tucson, AZOct 5, 1968 · N4365Z · Destroyed NTSB LAX69F0016Accident · 1 fatalClosedPiper PA-18 · Seligman, AZMay 30, 1968 · N5656Y · Destroyed NTSB UNK64X3270Accident · Minor injuriesClosedPiper PA-18 · Fairbank, AZAug 8, 1964 · N3995Z · Destroyed