NTSB investigations: Lycoming 0-320 series, 1995
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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 | 32 |
|---|---|
| 1983 | 12 |
| 1984 | 17 |
| 1985 | 19 |
| 1986 | 20 |
| 1987 | 12 |
| 1988 | 14 |
| 1989 | 15 |
| 1990 | 13 |
| 1991 | 14 |
| 1992 | 18 |
| 1993 | 15 |
| 1994 | 17 |
| 1995 | 11 |
| 1996 | 14 |
| 1997 | 15 |
| 1998 | 15 |
| 1999 | 16 |
| 2000 | 9 |
| 2001 | 15 |
| 2002 | 13 |
| 2003 | 11 |
| 2004 | 15 |
| 2005 | 12 |
| 2006 | 16 |
| 2007 | 13 |
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\") = 1995
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\" = 220))
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") = 1995
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" = 220))
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 SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.NTSB FTW96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Waller, TXthe pilot's failure to maintain obstacle clearance.NTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.NTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…NTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.NTSB LAX95FA198Accident · 4 fatalField investigationFinal reportCessna 172N · Lovelock, NVthe pilot's intentional flight at low altitude and subsequent collision with transmission wires during dusk light conditions.NTSB ANC95LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Hope, AKThe pilot's failure to adequately compensate for wind conditions. Factors associated with the accident are the trees bordering the runway, and a downdraft.NTSB LAX95LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Redding, CAthe pilot's improper use of the flight controls. The downward-sloping terrain and the intermittent gusty wind conditions were factors in this accident.NTSB MIA95FA070Accident · 2 fatalField investigationFinal reportCessna 172N · Mintonville, KYThe flightcrew's intentional VFR flight into known instrument meteorological conditions. A factor was the inadequate altitude to prevent an inadvertent collision with an obstruction.NTSB SEA95FA037Accident · 3 fatalField investigationFinal reportCessna 172N · Blyn, WAThe pilot's VFR flight into instrument meteorological conditions. Factors in the accident were the weather conditions and the dark night.