NTSB investigations: Lycoming 0-290 series, 1983
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\") = 1983
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") = 1983
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 ANC83LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKAccording to the pilot the engine started running intemittently after he was over trees at the departure end of the runway. The engine stopped and the pilot set up for and accomplished a forced landing. After the accident the pilot and a mechanic found water…NTSB SEA83LA159Accident · Minor injuriesLimited investigationFinal reportVangrunsven RV-3 · Twin Falls, IDThe home built plane was one of a flt of four acft that were being flown on a cross-country flt. While en route from hillsboro, or to Twin Falls, ID, the pilots had to divert around weather. As they were approaching Twin Falls, N17RV lost power from fuel…NTSB SEA83LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Fort Hall, IDThe acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed…NTSB CHI83LA268Accident · No injuriesLimited investigationFinal reportHomebuilt Baby Great Lakes · Lebanon, INThe acft landing gear collapsed and the acft nosed over after the engine quit due to fuel starvation. The engine lost power in a steep climb of at least a 45 deg angle and could not be restarted. The fuel flows to the engine by gravity. In a steep climb the…NTSB FTW83LA236Accident · No injuriesLimited investigationFinal reportPiper J3 · Sherrill, ARThe acft nosed over on an emergency downwind landing in a wet rice field after an eng failure. The plt stated that the eng failed as a result of water in the fuel. The operator services his acft from a private underground fuel storage tank. As a result of…NTSB FTW83LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Martinsville, TXReportedly, the plt took off with 36 gallons of fuel on board, of which, 10 gals was automobile low lead fuel. The automobile fuel had been purchased from an off airport gasoline station, was transported to the acft in 5 gal cans, then added to the fuel tanks…