NTSB investigations: Lycoming I0360 series, 1985
4 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of engine power”. 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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 5 |
| 1988 | 3 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 3 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
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\") = 1985
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\" = 350))
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") = 1985
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" = 350))
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 NYC86LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bristol, CTThe acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the…NTSB ATL86FKG04Accident · Serious injuriesFinal reportMooney M20J · Americus, GAThe acft contacted a tree and came to rest inverted during a forced landing following a loss of pwr. The loss of pwr occurred aprx 5 miles west of the destination arpt. Post accident inspection of the airframe and powerplant failed to disclose any mechanical…NTSB NYC85LA208Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Groton, CTEnstrom F28F, N8623X was performing auto rotation at Groton-new london, Connecticut when a loss of power was experienced, the student pilot was at the controls and entered auto rotation with the understanding that it would terminate in a power recovery. After…NTSB NYC85LA077Accident · No injuriesLimited investigationFinal reportRockwell 112A · Waynesburg, PAThe acft was landed gear-up in a fld following a loss of pwr during an initial takeoff climb. Purpose of the flt was to check the eng as it had been disassembled because of metal contamination from the center main bearing. Post accident inspection of the eng…