NTSB investigations: Lycoming TI0-540 series, TX
4 cases on aircraft whose registry engine model is Lycoming TI0-540 series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1984 | 2 |
|---|---|
| 1987 | 1 |
| 1988 | 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\" = 'TX' 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\" = 230))
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" = 'TX' 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" = 230))
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 FTW88LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Edna, TXA delay in initiation of the go-around during the pilot's second attempt to land in the dark night conditions. Contributing to the accident was the runway closure due to construction, which resulted in no runway lights illuminated, and the fact that the pilot…NTSB FTW87FA184Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Imperial, TXAfter takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he ' . . . Checked power, all ok, plane just seemed to lose all lift . . .' Subsequently, the acft…NTSB FTW85FA054Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Allen, TXThe acft collided with the ground as the plt, who was not current for night/instrument flt, tried to maneuver beneath a low overcast on a dark night. Although seriously injured during the accident sequence, the plt was able to tell rescue workers that he 'was…NTSB FTW84LA210Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Rocksprings, TXThe plt stated that the cabin door opened in-flight. While making a landing at Rocksprings in order to shut the door, the plt failed to use the checklist and landed the acft with the gear up. The acft was equipped with an auto gear extender, but because of…