NTSB investigations: Lycoming 0-290 series, 2000
14 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 | 92 |
|---|---|
| 1965 | 75 |
| 1966 | 71 |
| 1967 | 70 |
| 1968 | 47 |
| 1969 | 49 |
| 1970 | 51 |
| 1971 | 45 |
| 1972 | 49 |
| 1973 | 35 |
| 1974 | 43 |
| 1975 | 28 |
| 1976 | 38 |
| 1977 | 39 |
| 1978 | 45 |
| 1979 | 30 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 29 |
| 1983 | 29 |
| 1984 | 24 |
| 1985 | 27 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 19 |
| 1989 | 15 |
| 1990 | 15 |
| 1991 | 22 |
| 1992 | 17 |
| 1993 | 15 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 31 |
| 1997 | 6 |
| 1998 | 21 |
| 1999 | 18 |
| 2000 | 14 |
| 2001 | 19 |
| 2002 | 24 |
| 2003 | 18 |
| 2004 | 12 |
| 2005 | 19 |
| 2006 | 11 |
| 2007 | 14 |
| 2008 | 18 |
| 2009 | 17 |
| 2010 | 11 |
| 2011 | 14 |
| 2012 | 17 |
| 2013 | 10 |
| 2014 | 11 |
| 2015 | 13 |
| 2016 | 6 |
| 2017 | 12 |
| 2018 | 10 |
| 2019 | 10 |
| 2020 | 14 |
| 2021 | 14 |
| 2022 | 8 |
| 2023 | 14 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 9 |
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 year(c.\"eventDate\") = 2000
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 year(c."eventDate") = 2000
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 SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB ANC00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.NTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB SEA00LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quinault, WAFuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…NTSB ANC00LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor in the accident was a sudden wind shift.NTSB ANC00LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mccarthy, AKThe pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the wind gusts.NTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.NTSB LAX00LA150Accident · Minor injuriesLimited investigationFinal reportTaylor Smith Witman W-10 · Riverside, CAfailure of the pilot to recover from a bounced landing resulting in a loss of directional control and collision with a fence.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…