NTSB investigations: Lycoming 0-540 series, LA
54 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 4 |
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 4 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 3 |
| 1976 | 4 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2020 | 2 |
| 2024 | 1 |
Where
Latest cases
Query with SQL
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\" = 'LA' 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" = 'LA' 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" DESCRun 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 CEN25LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Crowley, LAThe pilot’s un-stabilized landing approach and high airspeed during the approach, that resulted in touchdown with insufficient runway remaining to stop the airplane.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.NTSB CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB FTW89DRD02Accident · Minor injuriesFinal reportPiper PA-25-235 · Bogalusa, LAThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB FTW85LA326Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Farmerville, LAThe plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…NTSB FTW84LA350Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Minden, LADuring a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.NTSB FTW83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Franklinton, LAThe acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…NTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…NTSB FTW81DRJ20Accident · No injuriesClosedPiper PA-24 · Many, LANTSB FTW81DRD07Accident · Minor injuriesClosedPiper PA-32 · Loreauville, LANTSB FTW79DRD51Accident · Minor injuriesClosedPiper PA-25 · White Castle, LANTSB FTW77DRJ18Accident · No injuriesClosedPiper PA-25 · Jonesville, LANTSB FTW76FRD66Accident · No injuriesClosedPiper PA-25 · Port Barre, LANTSB FTW76DRJ36Accident · No injuriesClosedCallair A-9 · Plain Dealing, LANTSB FTW76FRJ21Accident · No injuriesClosedPiper PA-25 · Crowville, LANTSB FTW76FRD31Accident · No injuriesClosedPiper PA-32 · Convent, LANTSB FTW76FRD14Accident · No injuriesClosedPiper PA-25 · Opelousas, LANTSB FTW75FRD57Accident · No injuriesClosedPiper PA-25 · Basile, LANTSB FTW75FRD46Accident · Minor injuriesClosedPiper PA-25 · Leroy, LANTSB FTW75DRJ09Accident · No injuriesClosedPiper PA-25 · Simmesport, LANTSB FTW75FRD05Accident · No injuriesClosedPiper PA-32 · Port Barre, LANTSB FTW75DRJ01Accident · Serious injuriesClosedPiper PA-25 · Winnsboro, LANTSB FTW74DRJ37Accident · No injuriesClosedPiper PA-25 · Collinston, LANTSB FTW74FRJ04Accident · No injuriesClosedPiper PA-32 · Minden, LANTSB FTW73DRJ32Accident · No injuriesClosedPiper PA-25 · Mer Rouge, LANTSB FTW73DRJ14Accident · Minor injuriesClosedPiper PA-24 · West Monroe, LANTSB FTW73AF001Accident · 5 fatalClosedPiper PA-28 · Intrcoastl Cty, LANTSB FTW72DRJ21Incident · No injuriesClosedPiper PA-28 · Jonesville, LANTSB FTW72DRD11Accident · No injuriesClosedPiper PA-25 · Belle Rose, LANTSB FTW71DRF29Accident · No injuriesClosedPiper PA-32 · Georgetown, LANTSB FTW71FRJ28Accident · No injuriesClosedPiper PA-25 · Bossier City, LANTSB FTW71DRJ13Accident · Serious injuriesClosedPiper PA-25 · Shaw, LANTSB FTW71DRJ07Accident · No injuriesClosedPiper PA-24 · Cottonport, LANTSB FTW69D0544Accident · Serious injuriesClosedPiper PA-25 · Morganza, LANTSB FTW69F0412Accident · No injuriesClosedPiper PA-32 · Sarepta, LANTSB FTW69D0288Accident · No injuriesClosedPiper PA-25 · Wisner, LANTSB FTW69D0181Accident · No injuriesClosedPiper PA-25 · Pioneer, LANTSB FTW69F0061Accident · No injuriesClosedPiper PA-25 · Cheneyville, LANTSB FTW69F0045Accident · No injuriesClosedPiper PA-25 · Newellton, LANTSB FTW68F0103Accident · No injuriesClosedPiper PA-25 · Belle Rose, LANTSB FTW67D0597Accident · No injuriesClosedPiper PA-32 · Baton Rouge, LANTSB FTW67D0248Accident · No injuriesClosedPiper PA-32 · Freemason Isl., LANTSB FTW66D0654Accident · No injuriesClosedPiper PA-25 · Crowley, LANTSB FTW66F0466Accident · Serious injuriesClosedPiper PA-32 · Alexandria, LANTSB FTW66A0006Accident · 4 fatalClosedPiper PA-24 · Lake Charles, LANTSB FTW66F0130Accident · No injuriesClosedPiper PA-25 · Newellton, LA