NTSB investigations: Lycoming 0-145B series, NY
8 cases on aircraft whose registry engine model is Lycoming 0-145B 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
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1975 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1994 | 1 |
| 2018 | 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\" = 'NY' 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 ('41502'))
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" = 'NY' 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 ('41502'))
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 GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.NTSB NYC94LA047Accident · No injuriesLimited investigationFinal reportAeronca 65-TL · Findley Lake, NYthe failure of a weld at the base of the landing gear which resulted in the failure of the left snow-ski assembly.NTSB NYC86LA020Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Lee Center, NYThe acft experienced a loss of control during an apch to the plt's pvt airstrip. After a pleasure flt of one-half hour, with no reported problems the acft returned to the arpt. On about a one-half mile final, the acft entered a steep left turn at about a 60…NTSB NYC83LA139Accident · Minor injuriesLimited investigationFinal reportAeronca 65-LB · Auburn, NYAccording to the plt, he was en route when the eng lost power. He maneuvered for a forced landing in a nearby hay/corn field. During the flare, the eng regained power momentarily & lifted about 50 ft. at about the same time, the acft encountered wind gusts,…NTSB NYC75FFA37Accident · Minor injuriesClosedPiper J3C-65 · Marlboro, NYNTSB NYC71DFJ17Accident · No injuriesClosedMooney M18LA · Kirkville, NYNTSB NYC68D0206Accident · No injuriesClosedPiper PA 15 · Sodus, NYNTSB UNK64X3945Accident · No injuriesClosedPiper PA15 · Forestville, NY