NTSB investigations: Piper PA-18-150, NM
19 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1970 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 2 |
| 1983 | 2 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2004 | 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.\"eventStateOrRegion\" = 'NM' 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" = 'NM' 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" 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 DEN05TA033Accident · No injuriesFinal reportPiper PA-18-150 · Jal, NMthe pilot's failure to maintain clearance from the power lines. Contributing factors include the power lines, the sun glare, the pilot's reduced visual lookout, the pilot’s improper in-flight planning and decision making and the pilot's failure to perform a…NTSB DEN00LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Belen, NMA loss of engine power due to low cylinder compression from an open exhaust valve, and the pilot's failure to lean the fuel mixture.NTSB FTW98LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Folsum, NMthe pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.NTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB DEN90TL#01Accident · Serious injuriesClass 3Final reportPiper PA-18-150 · Alamagordo, NMNTSB DEN87LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Las Vegas, NMThe plt reported that he experienced a departure stall after take off. A witness reported that the plt attempted a steep turn immediately after takeoff and that the acft appeared to stall. The left wing went down and the acft began an uncontrolled descent…NTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.NTSB FTW83LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roswell, NMThe CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear…NTSB FTW83LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMDuring the landing roll, the plt lost directional control of the acft & it went off the right side of the rwy & hit an irrigation ditch. Reportedly, there was no acft malfunction or failure prior to the mishap.NTSB FTW81DQD09Accident · No injuriesClosedPiper PA-18 · Artesia, NMNTSB FTW80DQA37Accident · No injuriesClosedPiper PA-18 · Roswell, NMNTSB DEN79FA054Accident · 2 fatalClosedPiper PA-18 · Artesia, NMNTSB DEN78FQA51Accident · No injuriesClosedPiper PA-18 · Albuquerque, NMNTSB DEN70DQA06Accident · No injuriesClosedPiper PA-18 · Vaughn, NMNTSB DEN67F0099Accident · Serious injuriesClosedPiper PA-18 · Albuquerque, NMNTSB DEN67A0002Accident · 2 fatalClosedPiper PA-18 · Quemado, NMNTSB DEN66F0276Accident · No injuriesClosedPiper PA-18 · Albuquerque, NMNTSB DEN66D0184Accident · No injuriesClosedPiper PA-18 · Ruidoso, NMNTSB UNK65X0946Accident · No injuriesClosedPiper PA18 · Parkview, NM