Skip to content

NTSB investigations: Lycoming 0-540 series, MS

38 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

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 ERA12LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Amory, MSThe pilot's inadequate preflight and in-flight planning and decision-making, including his inadequate weather evaluation and his delayed diversion to a closer airport, which resulted in a total loss of engine power due to fuel exhaustion.Feb 14, 2012 · N3688W · Substantial damage NTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.Mar 20, 2008 · N3304W · Substantial damage NTSB DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to landing.Jun 10, 2007 · N987MD · Substantial damage NTSB DFW06LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Newton, MSThe total loss of engine power due to fuel contamination. A factor was the pilot's inadequate preflight inspection.Sep 7, 2006 · N330PL · Destroyed NTSB MIA05CA047Accident · No injuriesData collectionFinal reportCessna TR182 · Vicksburg, MSThe pilot's failure to extend the landing gear which resulted in a wheels up landing. A contributing factor is the pilot's failure to complete the checklist.Nov 18, 2004 · N756KQ · Substantial damage NTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.Sep 11, 2002 · N5724P · Substantial damage NTSB MIA02LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hernando, MSThe pilot's operation of the airplane with known deficiencies ( contaminated fuel system) which resulted in fuel starvation, a forced landing to a cotton field, and damage to the airplane during the landing.Aug 27, 2002 · N120S · Substantial damage NTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.Jun 7, 2002 · N697MA · Substantial damage NTSB ATL98FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Clinton, MSThe pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an…Feb 22, 1998 · N9166W · Destroyed NTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.Feb 6, 1993 · N852DH · Destroyed NTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.May 28, 1989 · N2739C · Substantial damage NTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…Mar 14, 1987 · N6290P · Substantial damage NTSB ATL81FKQ24Accident · 1 fatalClosedPiper PA-25 · Bentonia, MSJul 30, 1981 · N4883Y · Destroyed NTSB MIA78FKQ28Accident · No injuriesClosedPiper PA-25 · Raymond, MSAug 3, 1978 · N4801Y · Substantial damage NTSB MIA78FKQ17Accident · No injuriesClosedPiper PA-25 · Schlater, MSJun 29, 1978 · N7141Z · No damage NTSB MIA75DKQ12Accident · No injuriesClosedPiper PA-25 · Beulah, MSAug 28, 1974 · N6581Z · Substantial damage NTSB MIA74DKQ09Accident · No injuriesClosedPiper PA-25 · Rosedale, MSSep 8, 1973 · N7498Z · Substantial damage NTSB MIA72DKQ32Accident · No injuriesClosedCallair A-9 · Avon, MSMar 18, 1972 · N7601V · Substantial damage NTSB MIA71FKQ07Accident · Minor injuriesClosedPiper PA-25 · Bolton, MSAug 13, 1970 · N4383Y · Destroyed NTSB MIA71FKQ06Accident · No injuriesClosedPiper PA-25 · Ruleville, MSAug 8, 1970 · N4835Y · Substantial damage NTSB MIA70F0044Accident · No injuriesClosedPiper PA-25 · Cleveland, MSJul 8, 1969 · N6737Z · Substantial damage NTSB MIA69A0093Accident · No injuriesClosedPiper PA-18 · Flora, MSJun 27, 1969 · N4032Z · 2 aircraft · Destroyed NTSB MIA69D0187Accident · Serious injuriesClosedPiper PA-25 · Batesville, MSSep 28, 1968 · N7331Z · Destroyed NTSB MIA69F0134Accident · No injuriesClosedPiper PA-25 · Ruleville, MSAug 26, 1968 · N7633Z · Substantial damage NTSB MIA69F0126Accident · Minor injuriesClosedPiper PA-24 · Jackson, MSAug 23, 1968 · N5371P · Substantial damage NTSB MIA69F0120Accident · No injuriesClosedPiper PA-25 · Eupora, MSAug 21, 1968 · N7008Z · Destroyed NTSB MIA69F0117Accident · 1 fatalClosedPiper PA-25 · Cadarette, MSAug 21, 1968 · N7254Z · Destroyed NTSB MIA68D0158Accident · No injuriesClosedPiper PA-25 · Rosedale, MSMay 22, 1968 · N7222Z · Substantial damage NTSB MIA68F0449Accident · No injuriesClosedPiper PA-25 · Eupora, MSMar 14, 1968 · N7367Z · Substantial damage NTSB MIA68D0135Accident · No injuriesClosedPiper PA-25 · Silver City, MSSep 10, 1967 · N6717Z · Destroyed NTSB MIA68F0013Accident · No injuriesClosedPiper PA-24 · Gulfport, MSJun 13, 1967 · N6138P · Substantial damage NTSB MIA67F0129Accident · No injuriesClosedPiper PA-24 · Jackson, MSAug 26, 1966 · N7937P · Substantial damage NTSB MIA67F0004Accident · No injuriesClosedPiper PA-25 · Brookhaven, MSJul 4, 1966 · N7503Z · Substantial damage NTSB MIA66F0596Accident · No injuriesClosedSpiper PA24 · Nsilver Creek, MSMay 26, 1966 · N8251P · Substantial damage NTSB MIA66D0583Accident · No injuriesClosedPiper PA24 · Laurel, MSMay 26, 1966 · N7323P · Substantial damage NTSB MIA66D0492Accident · No injuriesClosedPiper PA-24 · Nitta Yuma, MSApr 1, 1966 · N6438P · Substantial damage NTSB MIA65F0047Accident · No injuriesClosedPiper PA-24 · Columbia, MSApr 10, 1965 · N6225P · Substantial damage NTSB UNK64X3821Accident · Minor injuriesClosedPiper PA25 · Lambert, MSSep 6, 1964 · N6842Z · Destroyed