NTSB investigations: Lycoming TI0-540 series, WY
12 cases on aircraft whose registry engine model is Lycoming TI0-540 series. 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
| 1968 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2011 | 1 |
| 2023 | 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\" = 'WY' 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'))
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" = 'WY' 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'))
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 WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB WPR11CA299Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Casper, WYAn in-flight collision with a bird at low altitude.NTSB DEN84FA039Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Moose, WYThe acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake…NTSB DEN82DA028Accident · Serious injuriesFinal reportPiper PA-32 · Rock Springs, WYThe aircraft departed vernal,ut at 1810 MST after refueling. During the VFR flight the pilot reported to Rock Springs fss that he was 20 miles south and was given current weather and runway in use. No other transmissions were received. The aircraft struck a…NTSB DEN81FA030Accident · 1 fatalClosedPiper PA-32 · Gillette, WYNTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYNTSB DEN78FTC04Accident · No injuriesClosedBellanca 17-31 · Lander, WYNTSB DEN74DTC17Accident · No injuriesClosedPiper PA-24 · Wheatland, WYNTSB DEN73AD046Accident · 3 fatalClosedPiper PA-24 · Laramie, WYNTSB DEN72FTC05Accident · No injuriesClosedPiper PA-23 · Cody, WYNTSB DEN70FXA04Accident · Minor injuriesClosedPiper PA-24 · Casper, WYNTSB DEN69D0164Accident · No injuriesClosedPiper PA-24 · Alpine, WY