NTSB investigations: Lycoming 0-320 series, 1992
18 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\") = 1992
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") = 1992
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 LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.NTSB BFO93LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, NJInadequate supervision by the instructor, and his delay in initiating a go around.NTSB SEA93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vancouver, WAThe pilot's inability to see birds due to darkness.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).NTSB ANC92LA160Accident · No injuriesLimited investigationFinal reportDale Conover Tundra PUP · Beluga, AKThe inadequate preflight planning/preparation by the pilot. A factor was the pilot misjudged his clearance from the trees.NTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.NTSB FTW92LA194Accident · No injuriesLimited investigationFinal reportCessna 172L · Ozona, TXThe pilot's failure to maintain obstacle clearance.NTSB LAX92LA306Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Kernville, CAThe pilot's selection of the wrong runway; poorly planned approach; failure to attain the proper touch down point; and delay in executing the go-around. Contributing to this accident was the existing tailwind and crosswind.NTSB DEN92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Glade Park, COThe pilot delayed initiation of the go around. A factor was: high density altitude.NTSB MIA92LA136Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Live Oak, FLImproper planning/decision by the pilot, and his improper use of the mixture control, which resulted in his failure to attain sufficient altitude to clear trees near the departure end of the runway. The proximity of trees was a related factor.NTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.NTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.NTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…NTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.