NTSB investigations: Lycoming 0-540 series, FL
12 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2004 | 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 ('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\" = 353))
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 ('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" = 353))
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 ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…NTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…NTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…NTSB MIA98LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City Bch, FLThe pilot's inadequate inflight planning, which resulted in fuel exhaustion and the loss of engine power.NTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.NTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.NTSB MIA87LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Ft.Lauderdale, FLThe plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed…NTSB MIA85LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fellsmere, FLThe acft made a forced landing due to fuel exhaustion in an open field. On the landing roll, the nosewheel struck a ditch causing it to fold and the acft came to a stop resting on it's nose. The plt had determined the amount of fuel on board prior to takeoff…NTSB MIA85FA089Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Key Largo, FLThe aircraft crashed into the waters of the atlantic ocean and sank nose first into 15 feet of water. On impact the 25 bales of marijuana located in the cabin of the aircraft shifted forward and pinned the pilot and passenger in the aircraft. No usable fuel…NTSB MIA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Jupiter, FLThe plt reported that he was returning from the Bahamas when he experienced a loss of eng power & landed in a vacant field. The power loss occurred following fuel starvation. The plt stated that the acft was recently purchased & the fuel gauges were…NTSB MIA82DA161Accident · No injuriesFinal reportCessna R182 · Plymouth, FLThe pilot had a flight of over 4 hours total with one enroute stop. At this stop the pilot did not refuel. After 2 hoursand 9 minutes of return flight the eng lost power & the plt made a wheels up landing on a highway.