NTSB investigations: Lycoming 0-290 series
11 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the defining event was Nose over/nose down. 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
| 2010 | 1 |
|---|---|
| 2014 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2023 | 2 |
| 2026 | 3 |
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.\"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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '096'))
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."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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '096'))
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 WPR26LA350Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Salem, ORNTSB ANC26LA093Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Beluga, AKNTSB ANC26LA064Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 105 · Chena, AKNTSB ANC23LA055Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe student pilot’s inadvertent application of the brakes, which resulted in the airplane nosing over.NTSB WPR23LA250Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · McCall, IDThe pilot’s application of wheel brakes during landing roll out, resulting in a nose over.NTSB GAA17CA565Accident · No injuriesData collectionFinal reportPiper PA18 · Holy Cross, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA16CA252Accident · No injuriesData collectionFinal reportPiper PA 20 · Nikolai Creek, AKThe pilot's selection of an unsuitable takeoff area resulting in an airplane nose over during the takeoff roll.NTSB ANC14CA075Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Homer, AKThe pilot's failure to maintain aircraft control during the landing roll.NTSB WPR14CA326Accident · No injuriesData collectionFinal reportPiper PA20 - Undesignat · Dayton, ORThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.