NTSB investigations: Lycoming IO-540 series, FL
8 cases on aircraft whose registry engine model is Lycoming IO-540 series, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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 ('41530', '41585')
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\" = 250))
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 ('41530', '41585')
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" = 250))
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 MIA05FA085Accident · 2 fatalField investigationFinal reportCommander 114-B · Venice, FLThe pilot's in-flight loss of control during takeoff/initial climb over the water at night due to spatial disorientation. A related factor was the night conditions.NTSB MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.NTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…NTSB MIA92LA096Accident · 2 fatalLimited investigationFinal reportAnkerman, Donald L. SX300 · Okeechobee, FLFailure of the pilot-in-command to maintain airspeed (vs) resulting in inadvertent stall/mush.NTSB MIA91LA221Accident · 2 fatalLimited investigationFinal reportJohn H. Logan Loganair I · Gainesville, FLThe non-instrument rated pilot in command's decision to depart under special visual flight rule clearance in instrument flight rules conditions during darkness with a failed vacuum pump and resulting inoperative flight instruments which resulted in an…NTSB MIA90FA033Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Orlando, FLLoss of aircraft control during takeoff for an unknown reason which resulted in a collision with the ground.NTSB MIA89FA015Accident · Serious injuriesField investigationFinal reportLake LA-4-250 · Key West, FLThe plt reduced engine power during initial climb from a touch and go landing on the gulf of Mexico. The acft stalled and descended uncontrolled back to the water, striking the water hard. The acft then bounced and again hit the water in a nose low right wing…NTSB MIA83LA111Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Tampa, FLThe aircraft departed runway 18L at Tampa intl airport. Shortly after takeoff the pilot reported to the control tower that the main cabin door was open and requested landing instructions. The pilot stated he was holding the door and trying to fly the aircraft…