NTSB investigations: Lycoming 0-145B series, AK
6 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
| 1972 | 1 |
|---|---|
| 1978 | 1 |
| 1998 | 1 |
| 2013 | 1 |
| 2023 | 1 |
| 2026 | 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\" = 'AK' 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" = 'AK' 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 ANC26LA104Accident · No injuriesClass 4 · LimitedInvestigation openTaylorcraft BL-65 · Ninilchik, AKNTSB ANC23LA013Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL-65 · Wasilla, AKThe pilot's failure to remove all water from the fuel tank, which resulted in fuel contamination and a subsequent partial loss of engine power.NTSB ANC13LA102Accident · No injuriesLimited investigationFinal reportPiper J3L-65 · Nondalton, AKThe fracture and subsequent failure of the No. 4 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.NTSB ANC98FA043Accident · 1 fatalField investigationFinal reportTaylorcraft BL12 · Sitka, AKThe pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were clouds, the pilot's lack of instrument flight experience, obscuration and mountainous terrain.NTSB ANC78DAH06Accident · No injuriesClosedPiper PA-18 · Farewell, AKNTSB ANC73FAA12Accident · No injuriesClosedChampion 7ECA · Fairbanks, AK