NTSB investigations: Piper PA-18-135
11 cases on aircraft the registry lists as Piper PA-18-135, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1985 | 3 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2005 | 1 |
Where
Open the mapLatest 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 ('7101820')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101820')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.NTSB ANC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature liftoff and subsequent inadvertent stall.NTSB LAX94FA360Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Winslow, AZthe pilot's inadvertent stall and uncontrolled descent into the ground from a low altitude while scouting for game.NTSB BFO93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boonville, NYThe pilot failed to compensate for wind conditions and encountered a stall. The windshear was a factor.NTSB ANC92LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot misjudged the weather conditions for float plane operations and failed to maintain control of the airplane during the takeoff run. Factors contributing to the accident were: high gusty winds, the pilot in command's lack of recent experience, and…NTSB NYC89FA007Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Akron, NYThe Piper PA-18-135 stalled on takeoff and crashed. Witnesses said they observed the aircraft nose high, not climbing, and at a slow airspeed. They reported that the aircraft banked left and struck trees. The aircraft descended through the trees to the ground…NTSB MKC85FA191Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · New Madrid, MOA witness said N267CD made a low pass down the farm airstrip and as the acft neared the end of the strip, it began a climb, banked to the left and descended to the ground. The acft impacted in a nose low, left wing low attitude.NTSB MKC85FA169Accident · 2 fatalField investigationFinal reportPiper PA-18 · North Loup, NEThe acft was observed flying low over the ground in the vicinity of where it eventually crashed. A witness aprx 1/2 mi from the crash site noticed the plane flying low over a corn field as though the student plt was practicing ag-acft type swath runs. (The…NTSB DEN85LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Cut Bank, MTThe purpose of the flt was to clean the acft spray sys. The plt reported that he initiated a downhill/donwind takeoff in winds that were light, but gusting. At lift-off, the plt lost directional control & the acft mushed & crashed. The plt believed the…NTSB ANC83LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Squaw Lake, AKThe acft ground-looped during landing on a 2000 foot gravel runway. The pilot stated that as he approached runway 8 his airspeed was too high and he also was drifting to the right. During touchdown he lost directional control and allowed the acft to continue…