NTSB investigations: Piper PA-18-150, AR

14 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

NTSB investigations: Piper PA-18-150, AR per year, 1964–2026: 14 cases
1964	2
1965	2
1968	1
1974	1
1975	1
1977	1
1980	1
1982	1
1984	1
1989	1
2007	1
2022	1

Where

Open the map

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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN22LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rogers, ARThe pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.Jul 9, 2022 · N83552 · Substantial damage NTSB CHI08CA005Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Hot Springs, ARThe total loss of engine power due to inadequate fuel consumption calculations by the pilot resulting in fuel starvation while maneuvering over a lake at too low altitude for a safe landing. An additional cause was the unsuitable terrain encountered during…Oct 4, 2007 · N4157R · Substantial damage NTSB MKC89FA063Accident · 2 fatalField investigationFinal reportPiper PA-18 · Jacksonville, ARSevere corrosion of the left forward wing lift strut which resulted in the in-flight separation of the left wing. A contributing factor was inadequacy of the applicable service bulletin.Feb 25, 1989 · N7580D · Destroyed NTSB MKC84FA197Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wright, ARDuring aerial application, the plt was making a left turn over high voltage power lines when the acft hit the cables, crashed & burned in a rice field. An exam revealed 2 wire marks & 2 electrical arc marks on the left wing along with wire marks on one of the…Jul 3, 1984 · N4025 · Destroyed NTSB FTW82DA328Accident · No injuriesFinal reportPiper PA-18-150 · Devalls Bluff, ARThe pilot was flying over his farm and decided to land in a freshly plowed field. During the rollout, the main gear settled in the loose dirt and the plane nosed over.Aug 12, 1982 · N2601S · Substantial damage NTSB FTW80DPG42Accident · Minor injuriesClosedPiper PA-18 · Hazen, ARJul 3, 1980 · N9735P · Destroyed NTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNov 21, 1977 · N83441 · Destroyed NTSB FTW76DPG13Accident · No injuriesClosedPiper PA-18A · Hazen, ARAug 5, 1975 · N3864Z · Substantial damage NTSB FTW74DPG43Accident · No injuriesClosedPiper PA-18 · Wilmot, ARFeb 9, 1974 · N13895 · Substantial damage NTSB FTW68D0527Accident · No injuriesClosedPiper PA-18 · Bismarck, ARApr 5, 1968 · N7580D · Substantial damage NTSB FTW66F0197Accident · Serious injuriesClosedPiper PA-18 · Keo, ARAug 9, 1965 · N3894Z · Destroyed NTSB FTW66D0076Accident · Minor injuriesClosedPiper PA-18A · Dewitt, ARMay 21, 1965 · N8173D · Destroyed NTSB UNK64X2953Accident · Serious injuriesClosedPiper PA18A · Pettus, ARJul 21, 1964 · N4899A · Destroyed NTSB UNK64X1713Accident · 1 fatalClosedPiper PA18A · W Memphis, ARMay 10, 1964 · N7868D · Destroyed