NTSB investigations: Lycoming I0360 series, 1983
6 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 | 3 |
|---|---|
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 4 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 4 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 3 |
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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515')
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\" = 351))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515')
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" = 351))
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 DCA83IA040Incident · No injuriesIncident investigationFinal reportBeech B-24R · Potomac, MDThe acft made a forced landing in a field of rye grass after the engine lost power. Investigation revealed that a connecting rod had failed. An FAA inspection revealed that the connecting rod retaining bolts were not properly torqued during a recent major…NTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…NTSB CHI83LA349Accident · No injuriesLimited investigationFinal reportBeech A24R · Verona, WIThe acft lost power during cruise and was damaged in an off arpt forced landing. During the landing roll in a field, acft contacted a fence and collapsed the nose gear. Examination of the bendix fuel injector SN30479, model RSA-5AD1 revealed that the fuel…NTSB CHI83LA308Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Chandlerville, ILThe acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.…NTSB FTW83LA291Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Leggett, TXThe acft was damaged in a forced landing after the engine failed while cruising at 2500 ft. the acft was landed in an open field. Post accident investigation disclosed a missing oil drain plug. 2 pistons failed from lack of oil. The acft had a 100 hour…NTSB FTW83FA101Accident · No injuriesField investigationFinal reportMooney M20E · Roanoke, TXPower loss occurred about 7 min after takeoff. The plt turned back toward the arpt but was unable to reach the arpt due to a 15-20 kt headwind. The acft landed hard collapsing the landing gear after the plt mushed the acft to clear wires. Examination & flow…