NTSB investigations: Lycoming TI0-540 series, FL
9 cases on aircraft whose registry engine model is Lycoming TI0-540 series, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 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 ('41533')
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\" = 220))
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 ('41533')
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" = 220))
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 ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.NTSB MIA90LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLThe pilots decision to depart for his destination airport in the path of approaching thunderstorms resulting in the encounter with wind gusts during landing which exceeded his limitations.NTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…NTSB MIA88FA083Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Pembroke Park, FLThe non-instrument rated private pilot obtained a weather briefing that indicated the weather would be deteriorating to IMC, but he attempted a flight anyway. During the flight, he became disoriented and penetrated 2 control zones and then struck an antenna…NTSB MIA87LA206Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hastings, FLThe plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in…NTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…NTSB MIA86FA012Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Pensacola, FLAfter takeoff acft headed to destination arpt located 4 miles south. When aprx two miles out, the plt turned back to the departure arpt. Witnesses reported the acft was in a shallow descent, low and fast when it collided with trees and exploded about 1400 ft…NTSB MIA85FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Homestead, FLWhile cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…NTSB MIA83FA006Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Placid, FLAircraft was transporting marijuana and during an attempted road landing at Lake Placid collided with wires which damagethe landing assembly. Aircraft continued on to north about 4 miles and ditched in a lake. The aircraft sank with both occupants and cargo.