NTSB investigations: Lycoming 0-290 series, 2002
8 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 8 |
|---|---|
| 1983 | 7 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 6 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 10 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 9 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 8 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 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 year(c.\"eventDate\") = 2002
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\" = 260))
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") = 2002
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" = 260))
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 DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB SEA02LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Newberg, ORA warped right brake disc resulting in a veer to the right during the landing roll, and the aircraft's subsequent collision with a fence. A contributing factor was the fence.NTSB MIA02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Jacksonville, FLThe failure of the solo student/owner to maintain directional control of the airplane during takeoff in a crosswind, which resulted in the airplane veering off the runway, a collision with a runway light, and a ground loop.NTSB CHI02LA168Accident · Minor injuriesLimited investigationFinal reportBumgarner CA65 Sky Fly · Warrensburg, MOThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the overload failure of the right main landing gear.NTSB SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.NTSB LAX02LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Reno, NVFailure of the pilot to maintain directional control. A factor was the hump in the runway.NTSB ATL02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe failure of the pilot to use proper wind correction technique, resulting in a loss of directional control of the aircraft.NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.