NTSB investigations: Lycoming 0-540 series, VT
11 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
| 1968 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2014 | 1 |
| 2021 | 1 |
| 2025 | 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\" = 'VT' 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" = 'VT' 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 ERA25LA130Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Manchester, VTThe pilot’s improper decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall/spin.NTSB ERA21LA211Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Burlington, VTA fire that originated in the right main landing gear brake assembly for reasons that could not be determined based on the available information.NTSB ERA15LA022Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warren, VTThe glider pilot’s failure to avoid the tow plane after the aborted takeoff due to both pilots’ failure to review the aborted takeoff procedure before the flight, which led to both pilots turning right after the aborted takeoff.NTSB NYC01LA222Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Warren, VTThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.NTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.NTSB NYC80FNC32Accident · No injuriesClosedCessna 182 · South Hero, VTNTSB NYC78FNC21Accident · No injuriesClosedPiper PA-32 · Rutland, VTNTSB NYC76DNC57Accident · No injuriesClosedPiper PA-25 · Middlebury, VTNTSB NYC7LDNC03Accident · No injuriesClosedPiper PA-24 · Warren, VTNTSB NYC68D0468Accident · No injuriesClosedPiper PA-24 · Warren, VT