Skip to content

NTSB investigations: Piper PA-18, TX

24 cases on aircraft the registry lists as Piper PA-18. 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 ('7101802')) 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 ('7101802'))
  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 ('7101802'))
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 CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…May 26, 2025 · N7175D · Substantial damage NTSB CEN20LA150Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Bowie, TXThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions, which resulted in an uncontrolled turn and descent into terrain.Apr 19, 2020 · N3670P · Substantial damage NTSB FTW03LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moran, TXLanding short of the runway due to the pilot's failure to maintain a proper glide path, which resulted in the airplane impacting a tree. A contributing factor was the short runway.Apr 7, 2003 · N18141 · Substantial damage NTSB FTW00LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · New Ulm, TXThe pilot's failure to maintain clearance with a fence during the aborted landing.Feb 26, 2000 · N8967C · Substantial damage NTSB FTW96LA379Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Palestine, TXThe pilot's selection of unsuitable terrain for takeoff.Sep 8, 1996 · N7467D · Substantial damage NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.Jun 24, 1995 · N5424H · No damage NTSB FTW81DRA54Accident · No injuriesClosedPiper PA-18 · Nome, TXAug 19, 1981 · N1175A · Substantial damage NTSB FTW76DRG64Accident · No injuriesClosedPiper PA-18 · New Berlin, TXJun 29, 1976 · N21AA · Substantial damage NTSB FTW76DRG22Accident · No injuriesClosedPiper PA-18 · New Braunfels, TXSep 21, 1975 · N8293C · Substantial damage NTSB FTW75FRG20Accident · Minor injuriesClosedPiper PA-18 · La Vernia, TXSep 26, 1974 · N1152A · Substantial damage NTSB FTW72DRG87Accident · No injuriesClosedPiper PA-18 · Long Mott, TXMay 20, 1972 · N1562P · Substantial damage NTSB FTW70DRG50Incident · No injuriesClosedPiper PA-18A · Sinton, TXJun 2, 1970 · N3479Z · Minor damage NTSB FTW70DRG37Accident · No injuriesClosedPiper PA-18 · Norias, TXApr 21, 1970 · N21AA · Substantial damage NTSB FTW69F0550Accident · No injuriesClosedPiper PA-18 · Abilene, TXMay 31, 1969 · N2870P · Substantial damage NTSB FTW69D0255Accident · No injuriesClosedPiper PA-18 · El Paso, TXOct 24, 1968 · N9690D · Substantial damage NTSB FTW69F0251Accident · Serious injuriesClosedPiper PA-18 · Anahuac, TXOct 12, 1968 · N2893Z · Substantial damage NTSB FTW68F0557Accident · Serious injuriesClosedPiper PA-18 · Lubbock, TXApr 21, 1968 · N7264D · Destroyed NTSB FTW68D0296Accident · Serious injuriesClosedPiper PA-18 · Fabens, TXOct 16, 1967 · N4088Z · Destroyed NTSB FTW67F0232Accident · No injuriesClosedPiper PA-18 · San Antonio, TXAug 24, 1966 · N9579D · Substantial damage NTSB FTW66F0228Accident · Minor injuriesClosedPiper PA-18 · Booker, TXAug 21, 1965 · N256T · Substantial damage NTSB FTW66D0035Accident · No injuriesClosedPiper PA-18 · Sierra Blanca, TXMay 4, 1965 · N4088Z · Substantial damage NTSB UNK65X0289Accident · Minor injuriesClosedPiper PA18 · Lubbock, TXOct 16, 1964 · N1375A · Destroyed NTSB UNK65X0264Accident · No injuriesClosedPiper PA18A · Lubbock, TXOct 13, 1964 · N1375A · Substantial damage NTSB UNK64X2240Accident · No injuriesClosedPiper PA18 · Peacock, TXJun 12, 1964 · N1073A · Destroyed