Skip to content

NTSB investigations: Piper PA-18A 150, TX

33 cases on aircraft the registry lists as Piper PA-18A 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" = 'TX' 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 ('7101837')) 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\" = 'TX' 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 ('7101837'))
  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" = 'TX' 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 ('7101837'))
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 GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.Jun 21, 2018 · N9496D · Substantial damage NTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.Oct 15, 2016 · N9473D · Substantial damage NTSB FTW03LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Roanoke, TXThe flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.May 3, 2003 · N9789D · Substantial damage NTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.Apr 28, 1993 · N2880Z · Substantial damage NTSB FTW82FQD09Accident · 1 fatalFinal reportPiper PA-18A-150 · Sanderson, TXThe pilot was the owner and operator of the aircraft. A search of the FAA airman and medical records revealed no indication of a previous rating. During takeoff, the plane was observed to climb to about 200 to 300 ft AGL, then nose down and crash. There was…Feb 8, 1982 · N2887Z · Substantial damage NTSB FTW81FPA23Accident · Minor injuriesClosedPiper PA-18 · Waxahachie, TXSep 14, 1981 · N8799D · Substantial damage NTSB FTW77FA040Accident · 2 fatalClosedPiper PA-18 · Uvalde, TXMar 9, 1977 · N8973D · Destroyed NTSB FTW76DQG76Accident · No injuriesClosedPiper PA-18 · Idalou, TXJun 6, 1976 · N7683D · Substantial damage NTSB FTW75ARG80Accident · Minor injuriesClosedPiper PA-18A · New Braunfels, TXMay 13, 1975 · N2887Z · Destroyed NTSB FTW75DRG11Accident · No injuriesClosedPiper PA-18A · Floresville, TXAug 13, 1974 · N2887Z · Substantial damage NTSB FTW74AF091Accident · 2 fatalClosedPiper PA-18 · Palacios, TXJun 22, 1974 · N3492Z · Destroyed NTSB FTW74FQG01Accident · Serious injuriesClosedPiper PA-18A · Plainview, TXJul 20, 1973 · N7478D · Destroyed NTSB FTW73AF073Accident · 2 fatalClosedPiper PA-18 · Quemado, TXJun 13, 1973 · N9786D · Destroyed NTSB FTW72DRG79Accident · Serious injuriesClosedPiper PA-18 · Pleasanton, TXApr 30, 1972 · N9266D · Substantial damage NTSB FTW72DQD05Accident · Minor injuriesClosedPiper PA-18A · Fabens, TXAug 12, 1971 · N3971P · Substantial damage NTSB FTW70FQD06Accident · No injuriesClosedPiper PA-18A · El Paso, TXFeb 25, 1970 · N7669D · Substantial damage NTSB FTW70D0201Accident · No injuriesClosedPiper PA-18A · Dimmitt, TXAug 21, 1969 · N9292D · Substantial damage NTSB FTW70D0164Accident · No injuriesClosedPiper PA-18A · Abernathy, TXAug 16, 1969 · N7174D · Destroyed NTSB FTW69D0539Accident · No injuriesClosedPiper PA-18A · Sonora, TXMay 19, 1969 · N6983B · Substantial damage NTSB FTW69D0379Accident · No injuriesClosedPiper PA-18 · Lubbock, TXFeb 3, 1969 · N2688P · Substantial damage NTSB FTW69D0140Accident · No injuriesClosedPiper PA-18 · Fabens, TXAug 7, 1968 · N3971P · Substantial damage NTSB FTW69F0345Accident · 1 fatalClosedPiper PA-18A · Breckenridge, TXJun 24, 1968 · N9121D · Destroyed NTSB FTW68F0568Accident · 1 fatalClosedPiper PA-18A · Batesville, TXMay 1, 1968 · N9465D · Destroyed NTSB FTW68D0605Accident · Minor injuriesClosedPiper PA-18 · Charlotte, TXApr 28, 1968 · N7669D · Substantial damage NTSB FTW68A0081Accident · 1 fatalClosedPiper PA-18A · Uvalde, TXMar 23, 1968 · N3911Z · Destroyed NTSB FTW68D0500Accident · No injuriesClosedPiper PA-18 · San Angelo, TXMar 17, 1968 · N7382D · Substantial damage NTSB FTW68D0118Accident · No injuriesClosedPiper PA-18 · Presidio, TXJul 22, 1967 · N8095D · Substantial damage NTSB FTW68F0252Accident · No injuriesClosedPiper PA-18 · Etter, TXJun 16, 1967 · N6978D · Substantial damage NTSB FTW66F0148Accident · Minor injuriesClosedPiper PA-18A · Friona, TXJul 8, 1965 · N9909D · Substantial damage NTSB FTW66F0080Accident · Serious injuriesClosedPiper PA18A · Pearsall, TXMay 23, 1965 · N7366D · Destroyed NTSB UNK64X3522Accident · No injuriesClosedPiper PA18A · Pecos, TXAug 21, 1964 · N8892D · Destroyed NTSB UNK64X2572Accident · No injuriesClosedPiper PA18A · Rio Honda, TXJun 29, 1964 · N1876P · Substantial damage NTSB UNK64X1708Accident · Minor injuriesClosedPiper PA18 · Valley View, TXMay 10, 1964 · N9790D · Substantial damage