NTSB investigations: Lycoming TI0-540 series, 1983
4 cases on aircraft whose registry engine model is Lycoming TI0-540 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 4 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 1 |
Where
Open the mapLatest 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 ('41533')
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\" = 130))
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 ('41533')
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" = 130))
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 ATL84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Columbia, SCWhile en route, the acft's ammeter went to a zero reading, and subsequently, a complete electrical failure occurred. Prior to landing, the plt attempted to lower the landing gear by letting it freefall, in accordance with recommended procedures. The gear…NTSB ATL84LA035Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greer, SCDuring the flt, hydraulic failure of the landing sys occurred & the aircrew were unable to get the gear locked in the down position. After orbiting for over an hour, a landing was made. During touchdown, the gear collapsed. An exam revealed that an aileron…NTSB FTW83FA415Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Huffman, TXThe acft collided with the ground in a high speed dive and totally disintegrated. Impact created a 7' crater and material blew out for 100 yards. The engines were recovered at the 14 ft level in the crater. The acft took off at 2215 from baytown TX. At 2334…NTSB CHI83FA324Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Youngstown, OHDuring an IFR flt, the acft was leveled at 13,000 ft & the power was set at 18 inches manifold pressure & 2300 RPM. Aprx 5 min later, the right eng began to surge to 3000 RPM & almost 'pegged.' The plt attempted to control the right propeller. Finally, the…