Skip to content

NTSB investigations: Piper PA-18-150, NE

28 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

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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 GAA19CA160Accident · No injuriesData collectionFinal reportPiper PA18 · Rushville, NEThe partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.Mar 8, 2019 · N8566D · Substantial damage NTSB CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.May 24, 2016 · N4234Z · Substantial damage NTSB CEN14CA137Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Gordon, NEA loss of engine power due to the pilot's improper planning and miscalculation of the fuel supply, which resulted in fuel exhaustion.Feb 12, 2014 · N83325 · Substantial damage NTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.Oct 9, 2009 · N54750 · Substantial damage NTSB CHI04CA247Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grant, NEDirectional control not attained and the control interference encountered by the pilot during landing roll. The ditch was a contributing factor.Sep 4, 2004 · N91042 · Substantial damage NTSB CHI03LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gordon, NEThe pilots failure to maintain adequate airspeed which resulted in a stall. Contributing factors to this accident were the rain, hail, and wind gusts.May 4, 2003 · N9682P · Substantial damage NTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.Mar 16, 2001 · N3947Z · Substantial damage NTSB CHI97LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Alliance, NEthe instructor-pilot's inadequate supervision by not taking timely action after the student started losing directional control. A factor was the loss of directional control by the student pilot.Oct 23, 1996 · N3939Z · Substantial damage NTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.Jan 24, 1995 · N8825Z · Substantial damage NTSB MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…May 7, 1982 · N4339Z · Substantial damage NTSB MKC79DCJ14Accident · No injuriesClosedPiper PA-18 · North Platte, NEApr 21, 1979 · N57753 · Substantial damage NTSB MKC77DCJ35Accident · No injuriesClosedPiper PA-18 · Cody, NEJul 30, 1977 · N83332 · Substantial damage NTSB MKC77DCJ18Accident · No injuriesClosedPiper PA-18 · Bassett, NEApr 25, 1977 · N9396D · Substantial damage NTSB MKC76DCJ18Accident · No injuriesClosedPiper PA-18 · Merriman, NENov 22, 1975 · N3820Z · Substantial damage NTSB MKC76FCJ04Accident · No injuriesClosedPiper PA-18 · Hebron, NEJul 20, 1975 · N3985Z · Substantial damage NTSB MKC75DCJ16Accident · No injuriesClosedPiper PA-18 · Dunning, NEAug 4, 1974 · N14159 · Substantial damage NTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NESep 25, 1973 · N8519Y · Substantial damage NTSB MKC73DCJ12Accident · No injuriesClosedPiper PA-18 · Hyannis, NEJul 22, 1972 · N4077Z · Substantial damage NTSB MKC71FCJ43Accident · No injuriesClosedPiper PA-18 · Hyannis, NEJan 27, 1971 · N4297Z · Substantial damage NTSB MKC70DCJ24Accident · No injuriesClosedPiper PA-18 · Clay Center, NEMay 23, 1970 · N4252Z · Substantial damage NTSB MKC70F0019Accident · 1 fatalClosedPiper PA-18 · Carleton, NEJun 4, 1969 · N3846Z · Destroyed NTSB MKC69D0347Accident · No injuriesClosedPiper PA-18 · Mullen, NEMar 1, 1969 · N5830Y · Substantial damage NTSB MKC68D0338Accident · No injuriesClosedPiper PA-18 · Whitman, NENov 12, 1967 · N5830Y · Substantial damage NTSB MKC67F0270Accident · Minor injuriesClosedPiper PA-18 · Eli, NEOct 26, 1966 · N3236P · Substantial damage NTSB MKC67F0095Accident · Serious injuriesClosedPiper PA-18 · Shelton Webr, NEJul 27, 1966 · N2987P · Substantial damage NTSB UNK65X0823Accident · No injuriesClosedPiper PA18 · Valentine, NENov 25, 1964 · N3236P · Substantial damage NTSB UNK64X2156Accident · Minor injuriesClosedPiper PA-18 · North Platte, NEJun 6, 1964 · N9061D · Destroyed NTSB UNK64X0456Accident · No injuriesClosedPiper PA18 · Columbus, NEFeb 4, 1964 · N3952Z · Substantial damage