NTSB investigations: Lycoming AEIO-540 series, TX
8 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
| 1985 | 1 |
|---|---|
| 1993 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2018 | 1 |
| 2020 | 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\" = 'TX' 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" = 'TX' 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 CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA127Accident · Minor injuriesLimited investigationFinal reportMX MXS · Fulton, TXA total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway.NTSB CEN10LA295Accident · Minor injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Amarillo, TXThe fracture of the fuel pump housing for undetermined reasons.NTSB FTW04FA054Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Beaumont, TXThe flight instructor's failure to maintain clearance with a static line. Contributing factors were the low cloud ceiling weather conditions and night light conditions.NTSB FTW01LA102Accident · No injuriesLimited investigationFinal reportCap 232 · Laporte, TXFailure of the brake system during taxi. A contributing factor was the pilot's decision to continue taxiing after discovering the brakes were not functioning normally.NTSB FTW98LA317Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXThe inadequate visual lookout by the pilots of both airplanes.NTSB FTW93LA265Accident · No injuriesLimited investigationFinal reportPitts S1-T · Sherman, TXFailure to maintain visual lookout by the pilots in command of both aircraft.NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…