NTSB investigations: Lycoming IO-540 series, AK
10 cases on aircraft whose registry engine model is Lycoming IO-540 series, where the first occurrence was “In flight encounter with weather”. 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
| 1988 | 1 |
|---|---|
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 2 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585')
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\" = 240))
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 c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585')
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" = 240))
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 ANC06LA025Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ilimana, AKThe pilot's continued flight into adverse weather conditions, and his spatial disorientation and loss of control during a subsequent landing attempt. Factors associated with the accident are flat light and whiteout conditions, fog, and snow-covered terrain.NTSB ANC01FA106Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Kotzebue, AKThe pilot's failure to maintain adequate clearance from an obstruction (antenna tower), and his continued flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, and low visibility.NTSB ANC01FA093Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Haines, AKThe pilot's continued flight into known adverse weather conditions, and his poor in-flight decision making. Factors associated with the accident were clouds and mountainous terrain. A finding is the pilot's use of FAA prohibited drugs.NTSB ANC00LA013Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Palmer, AKThe pilot's intentional takeoff into known adverse weather. Factors associated with this accident are crosswinds, gusts, and downdrafts.NTSB ANC00LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Russian Mission, AKThe pilot's continued flight into adverse weather, and an inadvertent stall. Factors in the accident were adverse weather consisting of icing conditions, and airframe icing.NTSB ANC98LA165Accident · Serious injuriesLimited investigationFinal reportMaule ML-7 · Wasilla, AKThe pilot's inadequate compensation for the wind conditions, resulting in an inadvertent stall. Contributing factors were the gusty and turbulent weather conditions.NTSB ANC96FA137Accident · Serious injuriesField investigationFinal reportPiper PA-32 · Haines, AKthe pilot's inadvertent flight into instrument meteorological conditions (IMC) failure to maintain adequate altitude/clearance from terrain, while maneuvering to reverse the direction of flight. Factors associated with the accident were: the pilot's…NTSB ANC96LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Nome, AKthe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.NTSB ANC95LA172Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Aniak, AKThe pilot's inadequate weather evaluation. Factors associated with the accident were: the box canyon, rising terrain, wind gusts, and downdrafts.NTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.