Skip to content

NTSB investigations: Lycoming 0-540 series, SD

28 cases on aircraft whose registry engine model is Lycoming 0-540 series. 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

19652026

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" = 'SD' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')) 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\" = 'SD' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
  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" = 'SD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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 GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.Feb 12, 2016 · N6691P · Substantial damage NTSB CEN15CA001Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Yankton, SDThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Oct 1, 2014 · N6659Z · Substantial damage NTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.Aug 20, 2011 · N7051Z · Substantial damage NTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.Jun 18, 2011 · N7018Z · Substantial damage NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.Apr 18, 2008 · N32394 · Substantial damage NTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.Sep 9, 2005 · N8523W · Destroyed NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.Jul 27, 2003 · N512EA · Destroyed NTSB CHI94FA155Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Mcintosh, SDVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) from rising terrain. Factors related to the accident were: failure of the pilot to update his weather…May 2, 1994 · N525GS · Destroyed NTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · Destroyed NTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.May 18, 1992 · N4427Y · Destroyed NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.Jun 9, 1990 · N7136Z · Destroyed NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…Aug 7, 1986 · N7121Z · Destroyed NTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…Jul 22, 1986 · N8629L · Substantial damage NTSB DEN83LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Brandt, SDThe acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…Jul 1, 1983 · N7121Z · Substantial damage NTSB DEN81FTK24Accident · No injuriesClosedPiper PA-28 · Custer, SDSep 28, 1981 · N15358 · Substantial damage NTSB MKC79FTK20Accident · No injuriesClosedPiper PA-25 · Belvidere, SDJul 15, 1979 · N8628L · Substantial damage NTSB MKC78FTK25Accident · No injuriesClosedPiper PA-25 · Sisseston, SDJul 9, 1978 · N9882P · Substantial damage NTSB MKC76FTK28Accident · Minor injuriesClosedPiper PA-25 · Sturgis, SDJun 11, 1976 · N7500Z · Destroyed NTSB MKC72FTK02Accident · No injuriesClosedPiper PA-25 · Dixon, SDAug 9, 1971 · N7579Z · Substantial damage NTSB MKC71AK031Accident · Minor injuriesClosedPiper PA-28 · Rapid City, SDDec 1, 1970 · N8569W · Substantial damage NTSB MKC70FDQ09Accident · 1 fatalClosedCallair A-9 · Madison, SDJun 11, 1970 · N9653Z · Destroyed NTSB MKC70D0102Accident · No injuriesClosedPiper PA-25 · Doland, SDAug 4, 1969 · N4897Y · Substantial damage NTSB MKC69F0446Accident · No injuriesClosedCallair A-9 · Kadoka, SDMay 5, 1969 · N9653Z · Substantial damage NTSB MKC69D0034Accident · No injuriesClosedPiper PA-25 · Platte, SDMay 29, 1968 · N6568Z · Substantial damage NTSB MKC68F0446Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDFeb 1, 1968 · N6968P · Substantial damage NTSB MKC68A0010Accident · 3 fatalClosedPiper PA-24 · Belle Forch, SDAug 3, 1967 · N8064P · Destroyed NTSB MKC67F0136Accident · No injuriesClosedHelio H-250 · Hot Springs, SDJul 22, 1966 · N6318V · Substantial damage NTSB MKC66F0270Accident · No injuriesClosedPiper PA-24 · Wagner, SDOct 16, 1965 · N7440P · Substantial damage