NTSB investigations: Lycoming 0-320 series, 1997
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with terrain/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 | 24 |
|---|---|
| 1983 | 9 |
| 1984 | 11 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 13 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 7 |
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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
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\" = 230))
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") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
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" = 230))
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 LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.NTSB MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.NTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).NTSB ATL97LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, SCthe pilot's improper use of the elevator control and delayed liftoff during takeoff, which resulted in an inadvertent porpoise, collision with the runway, and collapse of the nose gear as he aborted the takeoff.NTSB IAD97LA108Accident · 1 fatalLimited investigationFinal reportRiekkenen Ryelong LE · Wurtsboro, NYThe pilot performed an aerobatic maneuver and misjudged the altitude.NTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.NTSB SEA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB FTW97TA115Accident · Minor injuriesFinal reportPiper PA-18-150 · Laredo, TXthe pilot allowed the airplane to get into an excessive rate of descent, during approach for an off-airport landing.NTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.