NTSB investigations: Lycoming 0-290 series, ME
16 cases on aircraft whose registry engine model is Lycoming 0-290 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 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1970 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1983 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 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\" = 'ME' 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 ('41506'))
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" = 'ME' 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 ('41506'))
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 ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.NTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.NTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.NTSB NYC97LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clayton Lake, MEthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall, and uncontrolled descent to the frozen lake surface.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…NTSB NYC81DNC12Accident · No injuriesClosedPiper PA-18 · Allagash River, MENTSB NYC80DNC02Accident · No injuriesClosedPiper PA-20 · Lakeville, MENTSB NYC79DNC79Accident · No injuriesClosedPiper PA-22 · Alexander, MENTSB NYC78FNC01Accident · No injuriesClosedPiper PA-20 · Norridgewock, MENTSB NYC74DNC44Accident · No injuriesClosedPiper PA-18 · Winslow, MENTSB NYC70FFG08Accident · Serious injuriesClosedDart GK-19 · Berwick, MENTSB NYC68F0124Accident · No injuriesClosedPiper PA-20S · Bucksport, MENTSB NYC68D0129Accident · No injuriesClosedPiper PA-20 · Waterville, MENTSB NYC67F0400Accident · No injuriesClosedPiper PA-18 · Augusta, MENTSB UNK65X0442Accident · 1 fatalClosedPiper PA-18S · Kokadjo, ME