NTSB investigations: Lycoming 0-540 series, 1984
5 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 8 |
|---|---|
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 10 |
| 1988 | 6 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 5 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 4 |
| 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
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\" = 353))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
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" = 353))
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 LAX85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Essex, CAThe plt reported that he visually checked the quantity of fuel in the acft's fuel tanks prior to departure & that he apparently overestimated the amount in the tanks. Following the accident the plt reported that he opened the fuel caps to both tanks & they…NTSB DEN84LA249Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ogden, UTAfter discharging sky divers, plt was concentrating on max rate of descent, eng pwr at idle, when fuel tank in use ran day. Pwr loss not noted until throttle applied for level off. Switch to usable fuel tank and restart attempt initiated with insufficient…NTSB DEN84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Webster, NDPlt stated the engine began to sputter during an ag flt. A forced landing was made in a wheat field during which the left main gear collapsed and the left wing contacted the ground. Investigation revealed the acft was fueled from an unfiltered 5 gallon can…NTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…NTSB CHI84LA265Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kankakee, ILThe eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.