NTSB investigations: Lycoming 0-320 series, 2007
13 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
Latest 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\") = 2007
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") = 2007
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 NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.NTSB ANC08CA011Accident · No injuriesData collectionFinal reportRobinson R-22 · Nikolski, AKThe pilot's inadequate compensation for wind gusts while maneuvering, which resulted in the tail rotor striking an undetermined object, and an emergency descent and landing. Factors contributing to the accident were the wind gusts, and the failure of the tail…NTSB LAX08CA020Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Fresno, CAThe pilot's failure to maintain the proper glide path to clear objects during approach for landing.NTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.NTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.NTSB LAX07CA279Accident · No injuriesData collectionFinal reportCessna 172L · Helena, MTunexpected collision with birds on short final that damaged the airplane wing structure.NTSB ANC07LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe pilot's selection of an unsuitable takeoff area and failure to maintain clearance from trees during takeoff. Contributing to the accident were soft, muddy terrain conditions.NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB ANC07CA042Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's delay in aborting the landing, which resulted in an in-flight collision with trees.NTSB ANC07CA039Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain altitude/clearance while maneuvering, which resulted in a collision with trees. A factor contributing to the accident was dusk lighting conditions.