Final NTSB investigations: Lycoming O-290-D2
12 cases on aircraft whose registry engine model is Lycoming O-290-D2. 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2020 | 1 |
| 2022 | 2 |
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42090'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42090'))
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 ERA22LA372Accident · Minor injuriesClass 3 · LimitedFinal reportThomas Wayne L THOMAS' Flyer · Searsmont, MEA total loss of engine power during the initial climb for reasons that could not be determined.NTSB WPR22LA170Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22/135 · Mesa, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB CEN20CA254Accident · Minor injuriesClass 4 · Data collectionFinal reportVolmer VJ22 · Erie, MIThe pilot's failure to ensure that the amphibious airplane’s wheels were retracted before attempting a water landing, resulting in a nose over during touch down. Contributing to the accident was the lack of a checklist available to the pilot.NTSB GAA15CA084Accident · No injuriesData collectionFinal reportFaunce PA-11 · Morrisville, VTThe pilot's failure to maintain directional control during the landing roll and his deliberate application of excessive braking pressure.NTSB WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB CHI08CA261Accident · Minor injuriesData collectionFinal reportNtbk Wag Aero Sport · Oxford, IAThe pilot misjudged his approach path which resulted in insufficient altitude and the subsequent failure to maintain clearance with the trees. Contributing to the accident were the trees and the dusk lighting conditions.NTSB LAX03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Chandler, AZThe student pilot's improper flare and his failure to maintain directional control. A contributing factor is the student pilot's improper recovery from a bounced landing.NTSB NYC88DFA01Accident · No injuriesFinal reportLloyd Feary VJ-22 · Kingston, NYThe aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted…NTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…NTSB ANC85LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mulchatna River, AKPlt reported that left wheel axle broke during aborted takeoff from gravel bar, causing acft to ground loop. Plt failed to provide complete info & broken axle for analysis.NTSB ANC83LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe plt reported that while he was flying in a canyon, up cub creek, he encountered unanticipated turbulence. He decided to make a 180 deg turn & leave the canyon. However, while making a left turn, the right wing of the acft struck a tree. Subsequently, the…