NTSB investigations: Lycoming 0-540 series
83 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 4 |
| 1985 | 5 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 6 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 2 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 5 |
| 2007 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC08FA026Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Jamestown, TNThe pilot’s failure to maintain clearance from a known wire hazard during takeoff.NTSB CHI06LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Underwood, NDThe pilot's failure to maintain clearance with the power line during the aerial application flight.NTSB ATL06FA102Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Suches, GAThe pilot's failure to retract the wing flaps and his decision to make a turn while performing a go-around.NTSB LAX06CA184Accident · Minor injuriesData collectionFinal reportRobinson R44 · Wailuku, HIthe pilot's inadequate compensation for the existing gusty wind conditions that resulted in his failure to maintain proper alignment with the landing area.NTSB DFW06CA116Accident · Minor injuriesData collectionFinal reportHeliotech H-250 · Woodville, TXThe pilot's failure to maintain clearance with obstructions at the departure end of the airstrip during an aborted landing. A contributing factor was dusk light conditions.NTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.NTSB CHI04LA212Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Chesterfield, MOThe pilot's inadequate preflight planning due to his selection of an unsuitable takeoff area and his failure to maintain clearance from the open hangar door. A contributing factor was the open hangar door.NTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB NYC04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Collegeville, PAThe pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.NTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…NTSB NYC02LA157Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Atlantic City, NJThe pilot's improper flare during approach.NTSB CHI02FA049Accident · 1 fatalField investigationFinal reportRobinson R44 · Waukesha, WIThe pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.NTSB LAX02LA001Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Petaluma, CAThe pilot's inadvertent (dark, nighttime) VFR flight into instrument meteorological conditions and subsequent loss of altitude control. A factor in the accident was the pilot's inadequate preflight weather evaluation.NTSB SEA01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Thompson Falls, MTThe pilot's inadequate compensation in gusting wind conditions during the landing flare. A tree was a factor.NTSB CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.NTSB CHI01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Manhattan, KSthe inadequate soft field takeoff procedure by the pilot and his failure to abort the takeoff. Factors were the high grass on the runway, the pilots disregard for the runway conditions, his lack of total experience in the aircraft, the trees, and the pilots…NTSB NYC00LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Chester, CTThe CFI's delayed remedial action.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.NTSB FTW98LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mineola, TXThe flight instructor's failure to maintain clearance from the fence post. A factor was the flight instructor's delay in taking remedial action to remedy the student's improper glidepath.NTSB CHI98LA239Accident · Minor injuriesLimited investigationFinal reportRobinson R-44 · Cassville, MOThe pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB FTW97LA131Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Donna, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight. A factor was the power lines.NTSB NYC97LA034Accident · No injuriesLimited investigationFinal reportMaule M-5 · Levant, MEthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance from tree(s) during an attempted go-around. The crosswind and proximity of tree(s) were related factors.NTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.NTSB FTW95LA387Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cibolo, TXThe pilot's improper planning/decision and failure to abort the takeoff, while there was sufficient runway remaining.NTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.NTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.NTSB FTW95LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Catoosa, OKThe pilot's failure to maintain terrain and obstacle clearance.NTSB MIA94LA161Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's failure to maintain a visual outlook and a safe altitude while making a low pass over a boat, resulting in an in-flight collision with the boat mast.NTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.NTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.NTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.NTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.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.NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.NTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.NTSB CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.NTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…NTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.NTSB DEN90LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Hazelton, NDThe failure of the pilot in command to maintain adequate visual lookout during aerial application maneuvering.NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.NTSB NYC90LA018Accident · No injuriesLimited investigationFinal reportMaule M-5 · Plattsburgh, NYThe pilot's inadequate preflight planning to assure clearance from the surrounding brush.NTSB ATL88DKG17Accident · No injuriesFinal reportIntermountain Mfg. Callair A-9 · Redbud, GA