NTSB investigations: Lycoming 0-290 series, 1982
6 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 6 |
|---|---|
| 1983 | 6 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 1982
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')
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\" = 353))
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 year(c."eventDate") = 1982
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')
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" = 353))
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 ANC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cordova, AKThe plt stated as he approached Cordova he smelled & observed smoke in the cockpit. He reduced power & commenced a modified approach to rwy 9 which was nearest his position. When he elected to add power the engine did not respond. The plt turned & landed on a…NTSB SEA83LA017Accident · No injuriesLimited investigationFinal reportFroehlich M-II · Everett, WAPilot acting as safety pilot for a friend in formation under the hood in another aircraft. He noticed his fuel was low, called his friend and headed for home. When his engine quit 2 miles from paine field he ditched. The aircraft sank and was not recovered.NTSB ANC82DA093Accident · No injuriesFinal reportPiper PA-20 · Near Mcgrath, AKPrior to departure, the pilot serviced the aircraft with fuel and verified the right wing tank was full. The pilot did not switch the fuel selector from the left fuel tank prior to departing. During a low pass over a wooded area, the engine quit. Due to the…NTSB ANC82DAG43Accident · No injuriesFinal reportPiper PA-20 · Eagle River, AKThe eng lost power about 750 ft after a water takeoff. There was insufficient landing room on the lake & the acft hit a dike. The pilot stated he fuels the acft from 5 gallon cans due to nonavaiability of aviation fuel at fire lake. Approximately 2 cups of…NTSB DEN82DA140Accident · Minor injuriesFinal reportPiper PA-22 · Glenburn, NDThe pilot reported that the engine lost power at about 100 AGL during a night takeoff. The aircraft was examined after the crash and the fuel selector was found positioned on the right tank. The aircraft had remained upright during and after the crash and the…NTSB ATL82DA063Accident · Minor injuriesFinal reportSmith Mini · Brownsboro, ALThe pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.…