NTSB investigations: Lycoming 0-540 series
24 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the defining event was Landing gear not configured. 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
| 2008 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '095'))
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 ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Eau Claire, WIThe pilot’s failure to ensure that the landing gear was properly extended before landing. Contributing to the accident was the pilot’s unfamiliarity with the landing gear warning horn and failure to verify the gear was extended with the cockpit position…NTSB WPR25LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Thermal, CAThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB CEN25LA290Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Lansing, ILThe pilot's failure to extend the landing gear before landing due to his distraction of other traffic and failure to follow his landing procedures.NTSB ERA24LA288Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Medina, OHThe pilot’s failure to extend the landing gear and the flight instructor’s lack of remedial action, which resulted in a landing with the landing gear not correctly configured.NTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.NTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.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 WPR19LA239Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Wendover, UTFailure of the landing gear solenoid, which resulted in failure of the landing gear position switch, and the pilot's subsequent inability to extend the gear using the manual emergency extension system for undetermined reasons.NTSB GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.NTSB GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.NTSB WPR14CA093Accident · Minor injuriesData collectionFinal reportMaule M 7-235 · Lake Havasu, AZThe pilots' failure to verify the landing gear position prior to the water landing and the pilot/examiner's failure to adequately monitor the pilot.NTSB CEN13CA319Accident · No injuriesData collectionFinal reportCessna TR182 · Emporia, KSThe pilot's failure to lower the landing gear prior to landing.NTSB WPR12CA435Accident · No injuriesData collectionFinal reportPiper PA24 · Madera, CAThe student's and flight instructor’s failure to ensure that the landing gear was extended prior to landing.NTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.NTSB CEN11CA561Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to extend the landing gear prior to landing.NTSB WPR11CA141Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Aurora, ORThe pilot's failure to lower the landing gear prior to landing.NTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.NTSB CEN10CA341Accident · No injuriesData collectionFinal reportCessna R182RG · Albuquerque, NMThe pilot's failure to lower the landing gear. Contributing to the accident was the pilot's distraction with an erroneous airspeed indicator.NTSB CEN10FA164Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Lewisville, TXThe pilot did not retract the landing gear before a water landing. Contributing to the accident was the pilot did not use a checklist.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.