NTSB investigations: Lycoming AEIO-540 series, FL
11 cases on aircraft whose registry engine model is Lycoming AEIO-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
| 1991 | 1 |
|---|---|
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2009 | 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.\"eventStateOrRegion\" = 'FL' 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 ('41568'))
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" = 'FL' 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 ('41568'))
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 ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.NTSB MIA04CA055Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Parkland, FLThe pilot's inadequate preflight planning which resulted in an off-airport precautionary landing to preclude fuel exhaustion, which resulted in damage to the airplane during the landing.NTSB MIA03FA050Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA300/L · Golden Gate, FLThe airplane's entry into a near vertical descent for undetermined reasons, which resulted in a collision with terrain during the resultant descent.NTSB ATL02FA076Accident · No injuriesField investigationFinal reportFlugzeugbau EA-300L · Lakeland, FLThe Extra 300L pilot's failure to maintain a visual lookout resulting in a midair collision while landing. Contributing to the accident was the Extra 300L pilot's failure to follow written instructions contained in the NOTAM, and ATC instructions resulting in…NTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…NTSB MIA01FA041Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · Weston, FLAn inflight loss of control by both pilots while maneuvering, which resulted in an inverted flat spin, an uncontrolled descent, and an impact with terrain/water. A factor contributing to the accident was the failure of both pilots to ensure that the…NTSB ATL98LA022Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Fort Lauderdale, FLThe undetermined malfunction of the right brake and the pilot's failure to maintain directional control during the landing rollout. A factor was the quartering tailwind.NTSB MIA95LA129Accident · No injuriesLimited investigationFinal reportPitts S-2B · Naples, FLThe failure of the tail wheel landing gear system for undetermined reasons. This resulted in an on-ground loss of control on landing rollout, ground loop, and collapse of the right main landing gear.NTSB MIA94LA171Accident · No injuriesLimited investigationFinal reportPitts S2B · Fort Lauderdale, FLThe poor welding quality of the manufacturer, resulting in the fatigue failure of the aileron attachment bracket.NTSB MIA94LA154Accident · No injuriesLimited investigationFinal reportPitts S2B · Keystone Height, FLThe pilot-in-command's exceeding of the design limitations of the airplane.NTSB MIA92LA013Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Sebring, FLFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and collision with tall grass beside the runway. The tall grass was a related factor.