NTSB investigations: Lycoming O&VO-360 series, 2002
7 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Hard landing”. 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 | 10 |
|---|---|
| 1983 | 5 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 7 |
| 2003 | 3 |
| 2004 | 8 |
| 2005 | 8 |
| 2006 | 6 |
| 2007 | 4 |
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 ('41514')
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\" = 200))
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 ('41514')
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" = 200))
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 LAX03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Corona, CAThe pilot's misjudged landing flare. Also causal were the pilot's improper bounced landing recovery procedures and inadvertent swerve, resulting in the landing gear collapsing from overload.NTSB MIA02LA138Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Trenton, GAThe failure of the pilot to clear the engine during a prolonged approach at idle power resulting in the engine hesitating during application of power to arrest the descent for landing touchdown resulting in a hard landing and separation of the left main…NTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.NTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.NTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…NTSB FTW02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARthe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the sunglare.NTSB CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.